3-Statement Model
Simplified linked P&L, balance sheet, and cash flow across a few periods.
Measures how earnings, working capital, and CapEx feed ending cash and equity.
Use it as a teaching / sketch model before building a full forecast workbook.
Your numbers stay in this browser. Export only — nothing is uploaded. Illustrative, not financial advice.
3-Statement Model
Simplified linked P&L, balance sheet, and cash flow across a few periods.
Sample figures (5m rev · 8% growth · 3 periods).
Drivers (3 periods)
Simplified linked model: P&L feeds retained earnings; WC and CapEx drive cash. Persist locally · Jump to results
Linked statements
P&L → Net income to equity; Cash flow bridges opening to closing cash.
How this is calculated
- Revenue grows at the stated % each period
- EBIT = Revenue − COGS − OpEx − Depreciation
- NI = EBIT × (1 − tax) when EBIT > 0
- CFO ≈ NI + Dep − ΔNWC
- Cash end = Cash start + CFO − CapEx
Illustrative sketch — not a full three-statement forecast. Not financial advice.
Take it with you
Get the worked example workbook in Excel — type your own numbers into it.
The Excel is the worked example workbook — type your own numbers into it. Stays on your device.