
Explore the three financial statements—income statement, cash flow statement, and balance sheet—and how a 3-statement model links them to keep assets equal to liabilities plus equity.
Model capital expenditures and depreciation in an asset schedule using Excel, applying straight-line depreciation and a blended tax depreciation over seven years to determine ending balances.
Track common equity and retained earnings on the corkshrew equity schedule by linking starting balances to endings and incorporating net income with a quarterly-to-monthly adjustment and payout ratio for dividends.
Enable iterative calculations to handle circularity in the debt schedule after completing P&L and cash flow statements; enable via file > options > formulas > enable iterative calculation, then okay.
Practice running scenario exercises in a three-statement model by adjusting revenue and capital structure (equity and debt) to see impacts on income statement, cash flow, and balance sheet.
Learn how deferred revenue in SaaS affects the three financial statements, with a step-by-step model of cash, revenue recognition, and working capital flows.
Welcome to 3-statement financial modeling! If you’ve taken our Introduction to 3-Statement Modeling course, much of this will feel familiar – think of this course as the next step. While the fundamentals remain the same, here you’ll learn how to build a detailed, monthly operating model designed for actually running a business.
What sets this course apart from others is its unique approach. Unlike courses that are too basic or require you to watch too many hours of videos, this course provides a comprehensive and practical guide to building a robust operating model that can be applied in real-world business scenarios. We've distilled complex concepts into concise, to-the-point videos, paired with a detailed e-guide that allows you to learn at your own pace.
Three-statement modeling is an essential skill for any finance professional. It integrates the income statement, balance sheet, and cash flow statement into a dynamically linked, comprehensive model. This allows you to thoroughly evaluate a company’s financial health and forecast its future profitability, asset position, and cash outlook. As a key decision-making tool, it serves as the foundation for more advanced models, such as discounted cash flow (DCF) and merger models. Ultimately, everything in business and finance ties back to these three financial statements, as they form the bedrock of performance analysis and strategic decision-making.
Whether you're an FP&A leader, a private equity professional, or a student launching a finance career, this course will teach you the skills and knowledge needed to build effective, real-world three-statement models. Happy modeling!
Course Outline:
Introduction
Getting Started: Building the Model
Model Design & Model Layout | Historical Actuals | Inputs & Headcount Planning
Build the Operational Schedules
Revenues & Costs | Working Capital | Capex & Depreciation | Income Tax
Build the Capital Structure Schedules
Debt Schedule (including revolver and cash sweep) | Equity Schedule
Build the 3 Core Financial Statements
Income Statement | Cash Flow Statement | Balance Sheet
Bring it Home
Circularity | Error Checking | Outputs & Exec Summary
Conclusion