Wall Street Prep

Quick Lesson: Cash Flow Statement, Part 1

Financial Modeling (47)Tutorials (30)Accounting & Finance (27)Excel (22)Templates & Documents (19)Three Statement Modeling (7)

Learn the building blocks of a financial model. In this video, we'll build a cash flow statement given an income statement and balance sheet in Excel. The accounting here is a simplified presentation of how the three major financial statements are inter-related and lays the foundation of financial statement models in investment banking.

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

To download the Excel template that goes with this video, click here

(Click here for part 2)

Comments

10
Leave a Reply

avatar
newest oldest most voted
Jessica Veroba
Jessica Veroba

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

Thank you.

Vote Up0Vote Down  Reply
February 27, 2018 8:05 pm
Haseeb Chowdhry
Haseeb Chowdhry

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

Vote Up0Vote Down  Reply
March 14, 2018 5:19 pm
Caira
Caira

Thank you.

Vote Up0Vote Down  Reply
January 27, 2017 11:26 pm
Baron
Baron

Great resource, thanks for sharing your expertise 😉

Vote Up0Vote Down  Reply
August 9, 2016 11:13 am
Anthony
Anthony

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

Vote Up0Vote Down  Reply
April 27, 2016 2:37 am
Shannan Wilson
Shannan Wilson

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

Vote Up0Vote Down  Reply
April 28, 2016 1:36 am
Rishika
Rishika

It was really helpful!
Good job.

Vote Up0Vote Down  Reply
January 12, 2016 8:09 am
Haseeb Chowdhry
Haseeb Chowdhry

Thanks!

Vote Up0Vote Down  Reply
January 12, 2016 11:27 am
Gisella Perez
Gisella Perez

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

Vote Up0Vote Down  Reply
February 2, 2015 1:36 am
Haseeb Chowdhry
Haseeb Chowdhry

Thanks - please spread the word about WSP!

Vote Up0Vote Down  Reply
February 2, 2015 10:30 am
X

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.

We are currently experiencing intermittent outages. If you are on the site when an outage occurs, please check back in 10-15 minutes. We greatly appreciate your patience as we work to resolve this issue.