/3-statement-model — 3-Statement Financial Model
The 3-statement model is the backbone of financial analysis. It connects a company’s three core financial statements — the Income Statement, Balance Sheet, and Cash Flow Statement — into an integrated framework where changing one assumption (like revenue growth) automatically flows through to every other statement. This integrated structure is what separates a real financial model from a collection of disconnected spreadsheets.
This command populates an existing 3-statement model template with proper linkages, formulas, and scenario analysis. It is designed for completing templates, not building models from scratch.
For a deep dive into the three financial statements and how they link together, see the 3-Statement Model Skill page.
Command Syntax
This command is designed for populating existing templates — not building models from scratch. Provide your firm’s template for best results.
What It Produces
A fully populated 3-statement model with proper cross-statement linkages, validated integrity checks (balance sheet balances, cash tie-out), and scenario analysis support.Workflow
Analyze the Template Structure
Claude reviews all tabs, identifies input vs. formula cells, maps cross-tab dependencies, and confirms the structure before touching any cells.
Populate Historical Data
Enter actuals for historical periods in the correct input cells, matching the template’s units and sign conventions.
Build IS Projections
Apply growth and margin assumptions, build expense line items, and calculate subtotals (Gross Profit, EBIT, EBT, Net Income).
Complete the Balance Sheet
Populate asset/liability schedules, ensure Retained Earnings rolls forward correctly, and validate Assets = Liabilities + Equity for every period.
Complete the Cash Flow Statement
Link CFO to Net Income, add non-cash items, model working capital changes, and validate Ending Cash = Balance Sheet Cash.
Core Integrity Checks
| Check | Formula | Expected Result |
|---|---|---|
| Balance Sheet Balance | Assets - Liabilities - Equity | = 0 |
| Cash Tie-Out | CF Ending Cash - BS Cash | = 0 |
| Net Income Link | IS Net Income - CF Starting Net Income | = 0 |
| Retained Earnings | Prior RE + NI - Dividends - BS Ending RE | = 0 |
How to Customize for Your Firm
skills/3-statement-model/SKILL.md to add your firm’s template conventions, sign conventions, and projection methodology.
Related
- 3-Statement Model Skill — Full Finance 101 explanation of the three financial statements, how they link, and validation methodology
/debug-modelCommand — Audit a completed model for errors