3-Statement Model

Simplified linked P&L, balance sheet, and cash flow across a few periods.

Illustrative sample (5m rev · 8% growth · 3 periods). Not financial advice.

Drivers (3 periods)

Simplified linked model: P&L feeds retained earnings; WC and CapEx drive cash. Persist locally · Jump to results

Balance sheet cash at start

Period 1 revenue

Applied to P2 and P3

Contribution to gross margin

Operating expenses

On EBIT (sketch — no loss carryforward)

Working capital investment

Fixed outflow each period

Non-cash · added back in CF

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

Download a prompt or export the Excel workbook from your current inputs.

Takes your current inputs — stays on your device.