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!
You’re logged in! Form submission not required. Access your file below.
Cash Flow Statement (Part 1)
Continue Reading Below
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.
Thanks for sharing, you are a smart and generous professional.
Thanks – please spread the word about WSP!
It was really helpful!
Good job.
Thanks!
Does this not double-count Depreciation? Once in the early add-back for D&A and once in accounting for Cash from Investing?
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.
Shannan
Great resource, thanks for sharing your expertise 😉
Thank you.
Please send me the Excel document models you use in your tutorials.
Thank you.
Jessica,
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
Thanks for posting this. Great lesson.
Very helpful. Thank you.
Pretty cool. Much appreciated.
Thanks for posting this. Great lesson.
You’re welcome!
Really want to thank you for this stuff.
You’re welcome, Angela!
Good job
Thank you!