3-Statement Model: 90-Minute Case Study from a Blank Excel Sheet

Learn more: https://breakingintowallstreet.com/co... For all the files and resources, go to: https://mergersandinquisitions.com/3-... Table of Contents: 0:00 Introduction 2:35 What is a 3-Statement Modeling Test? 5:54 Part 1: Inputting the Historical Financial Statements 15:31 Balance Sheet Entry 24:14 Cash Flow Statement Entry 35:11 Part 2: Income Statement Projections 50:12 Part 3: Balance Sheet Projections 57:51 Part 4: Cash Flow Statement Projections 1:07:12 Part 5: Linking the Statements 1:10:59 Part 6: Debt and Stock Repurchases 1:19:16 Part 7: Model Checks, Review, and Final Comments 1:22:35 Recap and Summary

Join Today
The Debt Schedule in 3-Statement Models, LBO Models, and Credit Models
▶︎

The Debt Schedule in 3-Statement Models, LBO Models, and Credit Models

LBO Modeling Test: Full Walkthrough of a 60-Minute Test (Blank Sheet)
▶︎

LBO Modeling Test: Full Walkthrough of a 60-Minute Test (Blank Sheet)

Data Analytics for Beginners | Data Analytics Training | Data Analytics Course | Intellipaat
▶︎

Data Analytics for Beginners | Data Analytics Training | Data Analytics Course | Intellipaat

RL for Agents Workshop - Deep Dive on Training Agents with RL and Open Source
▶︎

RL for Agents Workshop - Deep Dive on Training Agents with RL and Open Source

Financial Modeling Best Practices: How to Give Your Excel Files a “Makeover”
▶︎

Financial Modeling Best Practices: How to Give Your Excel Files a “Makeover”

AI Is Creating A Rare Opportunity For Investors. How Jim Roppel Is Playing It. | Investing With IBD
▶︎

AI Is Creating A Rare Opportunity For Investors. How Jim Roppel Is Playing It. | Investing With IBD

The DCF Model: The Complete Guide… to a Historical Relic?
▶︎

The DCF Model: The Complete Guide… to a Historical Relic?

Oil & Gas Modeling 101: The Upstream, Midstream, and Downstream Crash Course
▶︎

Oil & Gas Modeling 101: The Upstream, Midstream, and Downstream Crash Course

How to Build an LBO Model from Scratch: Full PE Modeling Bootcamp
▶︎

How to Build an LBO Model from Scratch: Full PE Modeling Bootcamp

Excel for Finance and Accounting Full Course Tutorial (3+ Hours)
▶︎

Excel for Finance and Accounting Full Course Tutorial (3+ Hours)

The Flow of Funds: How to Make Cap Tables Flow Like Water
▶︎

The Flow of Funds: How to Make Cap Tables Flow Like Water

The Debt Service Reserve Account (DSRA) in Project Finance: Save the Lenders, Save the World
▶︎

The Debt Service Reserve Account (DSRA) in Project Finance: Save the Lenders, Save the World

How to Recognize, Reconcile, and Forecast Revenue Without Breaking Your Close Every Month
▶︎

How to Recognize, Reconcile, and Forecast Revenue Without Breaking Your Close Every Month

NVIDIA DCF Valuation Model Built From Scratch | FREE EXCEL INCLUDED (2023)
▶︎

NVIDIA DCF Valuation Model Built From Scratch | FREE EXCEL INCLUDED (2023)

Investment Banking Analyst Mock Interview at J.P. Morgan
▶︎

Investment Banking Analyst Mock Interview at J.P. Morgan

Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond
▶︎

Financial Modeling Tutorial | Build a Three-Statement Model in 30 Minutes with CFI CEO Tim Vipond

Cash Flow from Operations: Real Life vs. Investopedia
▶︎

Cash Flow from Operations: Real Life vs. Investopedia

Inside Excel: Beginner to Advanced in One 5-Hour Course
▶︎

Inside Excel: Beginner to Advanced in One 5-Hour Course

Build a 3-Statement Financial Model [Free Course]
▶︎

Build a 3-Statement Financial Model [Free Course]

Private Equity: Leveraged Buyouts Explained (Analyze Deals Like a Pro)
▶︎

Private Equity: Leveraged Buyouts Explained (Analyze Deals Like a Pro)