Wall Street Prep

Quick Lesson: Cash Flow Statement, Part 1

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
avatar
newest oldest most voted
Julia Andrews
Julia Andrews

Thanks for posting this. Great lesson.

Jessica Veroba
Jessica Veroba

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

Thank you.

Caira
Caira

Thank you.

Baron
Baron

Great resource, thanks for sharing your expertise 😉

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?

Rishika
Rishika

It was really helpful!
Good job.

Gisella Perez
Gisella Perez

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

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.