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.

Before we begin ... Download the free Excel template

Download the free Excel template

Submitting ...

(Click here for part 2)

Comments
guest
13 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
Rishika
Rishika
January 12, 2016 8:09 am

It was really helpful!
Good job.

Gisella Perez
Gisella Perez
February 2, 2015 1:36 am

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

David Kamau Kangethe
David Kamau Kangethe
July 16, 2020 12:56 am

Pretty cool. Much appreciated.

Roy Muthamia
Roy Muthamia
July 15, 2020 9:47 am

Very helpful. Thank you.

Julia Andrews
Julia Andrews
December 7, 2019 11:43 am

Thanks for posting this. Great lesson.

Jessica Veroba
Jessica Veroba
February 27, 2018 8:05 pm

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

Thank you.

Caira
Caira
January 27, 2017 11:26 pm

Thank you.

Baron
Baron
August 9, 2016 11:13 am

Great resource, thanks for sharing your expertise 😉

Anthony
Anthony
April 27, 2016 2:37 am

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

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.