Build a Financial Model
Create a SaaS or startup financial model with revenue projections, cost structure, and key metrics.
The Prompt
Build a financial model for the following business. Provide: 1. Revenue model: how revenue is calculated (ARR, MRR, transactional, etc.) 2. Key assumptions with sensitivity ranges 3. Monthly projections for 24 months: revenue, cost of goods, gross margin, opex, EBITDA, cash 4. Unit economics: CAC, LTV, LTV:CAC ratio, payback period 5. Headcount plan 6. Key metrics dashboard: MRR, ARR, Growth Rate, Burn Rate, Runway 7. Break-even analysis Provide as a structured set of tables I can paste into a spreadsheet. Business details: - Business model: [SaaS / MARKETPLACE / E-COMMERCE / SERVICES] - Current metrics: [CURRENT REVENUE, CUSTOMERS, MRR IF APPLICABLE] - Pricing: [YOUR PRICING TIERS] - Growth assumptions: [EXPECTED MONTHLY GROWTH RATE] - Cost structure: [MAJOR COST CATEGORIES]
Example Output
24-month model with Month 1 at $8K MRR growing to $245K MRR by Month 24 (12% monthly growth assumption). Includes headcount plan growing from 3 to 18, CAC of $850 and LTV of $6,200 (LTV:CAC 7.3x), break-even at Month 19, and a sensitivity table showing 6 scenarios at different churn rates.
FAQ
Which AI model is best for Build a Financial Model?
Claude Sonnet 4 — careful and precise with financial calculations and assumptions.
How do I use the Build a Financial Model prompt?
Copy the prompt, replace the [BRACKETED] placeholders with your specific information, and paste into your preferred AI assistant (ChatGPT, Claude, Gemini, etc.). 24-month model with Month 1 at $8K MRR growing to $245K MRR by Month 24 (12% monthly growth assumption). Includes headcount plan growing from 3 to 18, CAC of $850 and LTV of $6,200 (LTV:CAC 7.3x), break-even at Month 19, and a sensitivity table showing 6 scenarios at different churn rates.
Model Recommendation
Claude Sonnet 4 — careful and precise with financial calculations and assumptions.