Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for September 2024 for September 2024
Private EquityReal Estate Investing
Hedge Fund InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for September 2024 is Open
Wall Street Prep

Statement of Cash Flows (Part 2)

Statement of Cash Flows (Part 2) | Excel Tutorial

Last Updated March 13, 2024

Learn Online Now

Statement of Cash Flows – Excel Tutorial (Part 2)

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 to understanding the connection between each.

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

Quick Lesson: Part 1

Statement of Cash Flows – Excel Template


Get the Excel Template!

By submitting this form, you consent to receive email from Wall Street Prep and agree to our terms of use and privacy policy.


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
most voted
newest oldest
Inline Feedbacks
View all comments
Richard Asafo-Adjei
August 21, 2022 6:00 am

Great teachings on cash flow

Brad Barlow
August 24, 2022 10:41 pm

Thanks, Richard!

Learn Financial Modeling Online

Everything you need to master financial and valuation modeling: 3-Statement Modeling, DCF, Comps, M&A and LBO.

Learn More

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.