Wall Street Prep

Cash Flow Statement (Part 2)

Learn Online Now

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 1

Before we begin … Download the free Excel template

Download the free Excel template

Submitting ...

most voted
newest oldest
Inline Feedbacks
View all comments
Richard Asafo-Adjei
Richard Asafo-Adjei
August 21, 2022 6:00 am

Great teachings on cash flow

Brad Barlow
Brad Barlow
August 24, 2022 10:41 pm

Thanks, Richard!


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.