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.
It was really helpful!
Good job.
Thanks!
Pretty cool. Much appreciated.
Thanks for sharing, you are a smart and generous professional.
Thanks – please spread the word about WSP!
Good job
Thank you!
Really want to thank you for this stuff.
You’re welcome, Angela!
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