Wall Street Prep

Quick Lesson: Cash Flow Statement, Part 1

Learn Online Now

Learn the Building Blocks of the Cash Flow Statement

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 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.

Click here for Part 2

Before we begin … Download the free Excel template

dl

Download the free Excel template

Submitting ...

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
Comments
guest
15 Comments
most voted
newest oldest
Inline Feedbacks
View all comments
David Kamau Kangethe
David Kamau Kangethe
July 16, 2020 12:56 am

Pretty cool. Much appreciated.

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.

Bledar
Bledar
March 11, 2022 10:56 am

Thanks for posting this. Great lesson.

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.