ChatGPT Financial Model Builder Prompt
You are a financial modelling analyst who has built models for VC-backed companies and presented them to institutional i
Category
💼 Business
Difficulty
Advanced
Models
2
Last Updated
2026-06-28
Works with
📄 Example output
⚠️ Common Mistakes
❓ FAQ
⚙️ Fill in your variables
📋 Prompt
You are a financial modelling analyst who has built models for VC-backed companies and presented them to institutional investors.
Business: [business type]
Revenue model: [revenue model — SaaS/ads/marketplace/e-commerce/service]
Monthly costs: [monthly costs]
Growth: [growth assumptions — MoM growth rate, key drivers]
Task: Build a complete financial model framework:
1. UNIT ECONOMICS: CAC, LTV, LTV:CAC ratio, payback period
2. REVENUE MODEL: Revenue per unit × volume, MRR/ARR progression Year 1–3
3. P&L OUTLINE: Revenue → COGS → Gross margin → OpEx → EBITDA → Net income
4. CASH FLOW: Monthly burn rate, runway calculation, break-even point
5. KEY ASSUMPTIONS TABLE: Every assumption that drives the model
6. SENSITIVITY ANALYSIS: What happens if key metrics change ±20%
7. INVESTOR METRICS: What a VC would focus on for this business type
Business: [business type]
Revenue model: [revenue model — SaaS/ads/marketplace/e-commerce/service]
Monthly costs: [monthly costs]
Growth: [growth assumptions — MoM growth rate, key drivers]
Task: Build a complete financial model framework:
1. UNIT ECONOMICS: CAC, LTV, LTV:CAC ratio, payback period
2. REVENUE MODEL: Revenue per unit × volume, MRR/ARR progression Year 1–3
3. P&L OUTLINE: Revenue → COGS → Gross margin → OpEx → EBITDA → Net income
4. CASH FLOW: Monthly burn rate, runway calculation, break-even point
5. KEY ASSUMPTIONS TABLE: Every assumption that drives the model
6. SENSITIVITY ANALYSIS: What happens if key metrics change ±20%
7. INVESTOR METRICS: What a VC would focus on for this business type
FINANCIAL MODEL: ToolsNova (Ad-supported, free tools)
UNIT ECONOMICS:
RPM (Revenue per 1,000 pageviews): $2.50
Target Month 6: 500K PVs → $1,250 MRR
Target Month 12: 2M PVs → $5,000 MRR
Target Month 24: 10M PVs → $25,000 MRR
P&L (Year 1 — Base Case):
Revenue: $18,000
Costs: Hosting $0 (Cloudflare Pages free tier), Domain $15/yr, Tools $600/yr = $615 total
Gross Profit: $17,385 (96.6% margin)
Net Income: $17,385
KEY ASSUMPTIONS:
| Metric | Conservative | Base | Optimistic |
|---|---|---|---|
| MoM traffic growth | 10% | 15% | 25% |
| Average RPM | $2.00 | $2.50 | $4.00 |
| AdSense approval month | 6 | 4 | 3 |
SENSITIVITY: If RPM drops 40% to $1.50 → revenue $10,800/year — still profitable given near-zero costs
BREAK-EVEN: Already passed — near-zero infrastructure cost means every dollar is margin
UNIT ECONOMICS:
RPM (Revenue per 1,000 pageviews): $2.50
Target Month 6: 500K PVs → $1,250 MRR
Target Month 12: 2M PVs → $5,000 MRR
Target Month 24: 10M PVs → $25,000 MRR
P&L (Year 1 — Base Case):
Revenue: $18,000
Costs: Hosting $0 (Cloudflare Pages free tier), Domain $15/yr, Tools $600/yr = $615 total
Gross Profit: $17,385 (96.6% margin)
Net Income: $17,385
KEY ASSUMPTIONS:
| Metric | Conservative | Base | Optimistic |
|---|---|---|---|
| MoM traffic growth | 10% | 15% | 25% |
| Average RPM | $2.00 | $2.50 | $4.00 |
| AdSense approval month | 6 | 4 | 3 |
SENSITIVITY: If RPM drops 40% to $1.50 → revenue $10,800/year — still profitable given near-zero costs
BREAK-EVEN: Already passed — near-zero infrastructure cost means every dollar is margin
🏆
💡 Pro Tips
Best model for this prompt
Claude
Claude (Opus 4 / Sonnet 4)
Separate assumptions from formulas — every input should be a changeable cell, never hardcoded
LTV:CAC of 3:1 is the minimum viable ratio for most investor conversations
Always build conservative, base, and optimistic — investors test which you actually believe
The assumptions are what investors scrutinise — your model is only as credible as your ability to defend each one
Hockey-stick projections with no explanation of the inflection
Forgetting churn in SaaS models — the most common financial modelling error
Not accounting for customer acquisition cost
Overly optimistic gross margins that ignore real operational costs
- Should I use Excel or Google Sheets?Google Sheets for collaboration and easy investor sharing. Excel for complex models with external data connections. For most early-stage startups, Sheets is perfectly adequate.
- How do investors use financial models?Less to believe the numbers, more to test whether you understand your unit economics. They stress-test assumptions — especially CAC, churn, and growth rate.
- What's the difference between MRR and ARR?MRR = monthly subscription revenue. ARR = MRR × 12. ARR is the standard SaaS valuation metric. Net MRR growth = new MRR + expansion MRR − churned MRR.
- How conservative should my projections be?Conservative enough that you'd be comfortable presenting them to a skeptical audience who will ask 'why do you assume 15% MoM growth?' Have a specific, defensible answer for every major assumption.