background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street PrepWSP Certificates Now Enrolling for February 2025:
Private EquityReal Estate InvestingApplied Value InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Statement of Cash Flows (Part 2)

Statement of Cash Flows (Part 2) | Excel Tutorial

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

dl

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.

Submitting...

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

Great teachings on cash flow

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.