Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Private Equity Certificate: Now Accepting Enrollment for January 29 - March 25, 2024 →
Wall Street Prep

Statement of Cash Flows (Part 2)

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

Statement of Cash Flows – Excel Template


Download the free Excel template


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.