Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for September 2024 for September 2024
Private EquityReal Estate Investing
Hedge Fund InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Statement of Cash Flows (Part 1)

Statement of Cash Flows (Part 1) | Excel Tutorial

Last Updated March 13, 2024

Learn Online Now

Statement of Cash Flows – Excel Tutorial (Part 1)

In this video, we’ll build a cash flow statement model given an income statement and balance sheet in Excel.

The accounting here is a simplified presentation of how the three major financial statements are interrelated and lays the foundation of financial statement models built on the job in the field of corporate finance.

Many accounting questions that we see time and again in finance interviews are designed to test the understanding explained in this exercise.

Statement of Cash Flows – Excel Template


Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.


Cash Flow Statement (Part 1)

Quick Lesson: Part 2

Step-by-Step Online Course

Everything You Need To Master Financial Modeling

Enroll in The Premium Package: Learn Financial Statement Modeling, DCF, M&A, LBO and Comps. The same training program used at top investment banks.

Enroll Today
most voted
newest oldest
Inline Feedbacks
View all comments
January 12, 2016 8:09 am

It was really helpful!
Good job.

Haseeb Chowdhry
January 12, 2016 11:27 am
Reply to  Rishika


David Kamau Kangethe
July 16, 2020 12:56 am

Pretty cool. Much appreciated.

Gisella Perez
February 2, 2015 1:36 am

Thanks for sharing, you are a smart and generous professional.

Haseeb Chowdhry
February 2, 2015 10:30 am
Reply to  Gisella Perez

Thanks – please spread the word about WSP!

October 8, 2022 1:29 pm

Good job

Brad Barlow
October 10, 2022 8:58 pm
Reply to  Argynbek

Thank you!

Angela smith
May 24, 2022 5:19 am

Really want to thank you for this stuff.

Brad Barlow
May 25, 2022 1:46 pm
Reply to  Angela smith

You’re welcome, Angela!

March 11, 2022 10:56 am

Thanks for posting this. Great lesson.

Brad Barlow
March 11, 2022 12:35 pm
Reply to  Bledar

You’re welcome!

Roy Muthamia
July 15, 2020 9:47 am

Very helpful. Thank you.

Julia Andrews
December 7, 2019 11:43 am

Thanks for posting this. Great lesson.

Jessica Veroba
February 27, 2018 8:05 pm

Please send me the Excel document models you use in your tutorials.

Thank you.

Haseeb Chowdhry
March 14, 2018 5:19 pm
Reply to  Jessica Veroba


At the top of the page there’s a link for your to click and download the relevant Excel files for the video – thanks.

– Haseeb

January 27, 2017 11:26 pm

Thank you.

August 9, 2016 11:13 am

Great resource, thanks for sharing your expertise 😉

April 27, 2016 2:37 am

Does this not double-count Depreciation? Once in the early add-back for D&A and once in accounting for Cash from Investing?

Shannan Wilson
April 28, 2016 1:36 am
Reply to  Anthony

Hi Anthony,
We are only adding back Depreciation once, in the Cash Flow from Operations section, the Cash Flows from Investing section will include spending on Capital Expenditures, Intangible Assets and other Long-term investments.

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.