Table of Contents
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
Cash Flow Statement (Part 1)
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
Pretty cool. Much appreciated.
It was really helpful!
Good job.
Thanks!
Thanks for sharing, you are a smart and generous professional.
Thanks – please spread the word about WSP!
Really want to thank you for this stuff.
You’re welcome, Angela!
Good job
Thank you!
Thanks for posting this. Great lesson.
You’re welcome!
Very helpful. Thank you.
Thanks for posting this. Great lesson.
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
Thank you.
Great resource, thanks for sharing your expertise 😉
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