← backFinance & LegalFounding · Free forever

Build a financial model from assumptions

Sensitivity analysis > point estimates — models impress when you stress-test them.

by @whitney · recommended tool Claude Co-Work · 0 unlocks

You'll need

CLAUDE SKILLS

xlsx

CONNECTORS

Google Drive

EXAMPLES · WHAT THIS PROMPT PRODUCES

Sample output

**3-Statement SaaS Model — Cohort Coffee Co. (DTC subscription) — 3-year horizon**

**Assumptions tab**
- Starting subscribers: 1,200 | New subs/mo: 350 (Y1), +8% MoM acquisition growth
- Monthly churn: 4.5% | AOV: $32/mo | Gross margin: 62%
- CAC: $38 | Blended ad spend: $14K/mo scaling to $40K/mo

**Revenue tab (summary)**
- Y1 revenue: $612K | Y2: $1.18M | Y3: $1.94M
- Ending subscribers: 3,140 (Y1) → 5,020 (Y3)
- Net revenue retention: 94%

**Costs tab**
- COGS (38% of rev), Marketing (CAC × new subs), Ops/fulfillment ($4.10/order), G&A ($18K/mo fixed)
- Y1 operating loss: ($71K) | Y2 operating profit: $96K | Y3: $402K

**Summary tab + charts**
- Break-even: Month 19 (cumulative)
- Cash-flow positive monthly: Month 14
- Chart 1: subscriber growth vs. churn | Chart 2: revenue vs. operating profit

**Sensitivity analysis (3 key drivers)**
- *Churn:* at 6% monthly, break-even slips to Month 27. At 3%, Month 14.
- *CAC:* a $10 CAC increase pushes Y1 loss to ($131K).
- *AOV:* +$4 AOV adds $186K to Y3 revenue.

All cells formula-driven off the assumptions tab — change one input and the model cascades.

PRICE HISTORY0 cr · current

PROMPT TEMPLATE · v1.0.0

Build a <TYPE> financial model for <BUSINESS>.
Inputs: <ASSUMPTIONS>. Horizon: <N> years.
Deliver: assumptions tab + revenue tab + costs tab + summary tab + charts.
Include: sensitivity analysis on 3 key drivers and a break-even calc.