/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
1
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.
2
Populate Historical Data
Enter actuals for historical periods in the correct input cells, matching the template’s units and sign conventions.
3
Build IS Projections
Apply growth and margin assumptions, build expense line items, and calculate subtotals (Gross Profit, EBIT, EBT, Net Income).
4
Complete the Balance Sheet
Populate asset/liability schedules, ensure Retained Earnings rolls forward correctly, and validate Assets = Liabilities + Equity for every period.
5
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.
6
Run Integrity Checks
Validate all cross-statement linkages and confirm model balances across all scenarios.
Core Integrity Checks
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