Back to prompts
Business & StrategyPremiumadvanced
4.8

Startup Financial Model Builder

Build a complete 3-year financial model — revenue projections, costs, unit economics, and fundraising metrics.

Copy & Paste this prompt
You are a startup CFO and financial modeling expert. Build a complete financial model for my business.

Business type: [SAAS / E-COMMERCE / MARKETPLACE / SERVICE / OTHER]
Current stage: [PRE-REVENUE / EARLY REVENUE / GROWTH]
Current MRR (if any): [AMOUNT]
Pricing model: [SUBSCRIPTION / ONE-TIME / FREEMIUM / USAGE-BASED]
Price point: [YOUR PRICING]
Current team size: [NUMBER]
Funding situation: [BOOTSTRAPPED / SEED / SERIES A]

Build a 3-year model with:

1. **REVENUE MODEL**
   - Monthly revenue projections (Month 1-36)
   - Customer growth assumptions (with justification)
   - Churn rate assumptions
   - ARPU (Average Revenue Per User) trajectory
   - Revenue breakdown by plan/tier

2. **COST STRUCTURE**
   - Fixed costs (rent, salaries, tools, subscriptions)
   - Variable costs (per-customer costs, COGS)
   - Hiring plan (when to hire what role)
   - Marketing budget allocation

3. **UNIT ECONOMICS**
   - CAC (Customer Acquisition Cost)
   - LTV (Lifetime Value)
   - LTV:CAC ratio
   - Payback period
   - Gross margin

4. **KEY METRICS DASHBOARD**
   - Monthly: MRR, ARR, growth rate, burn rate, runway
   - Quarterly: CAC, LTV, churn, NRR
   - Break-even month

5. **SCENARIOS**
   - Base case (realistic)
   - Bull case (everything goes right)
   - Bear case (things go wrong)
   - What breaks the model (key risks)

6. **FUNDRAISING METRICS**
   - How much to raise and when
   - Key milestones per round
   - Valuation benchmarks for your stage

Present as clean tables I can paste into a spreadsheet.
#financial-model#startup#revenue#fundraising#metrics

Works with

chatgptclaudegemini

💡 Pro Tips

  • •Be conservative on revenue, aggressive on costs — investors appreciate realism
  • •LTV:CAC ratio should be 3:1+ for a healthy business
  • •Update monthly with actuals to validate your assumptions

🧠 Why This Works

This prompt applies bottom-up financial modeling principles, building from unit economics to revenue projections rather than top-down market-share guesses that investors dismiss. It requires explicit assumptions for each variable, making the model auditable and adjustable.

📅 When to Use This Prompt

Use when preparing for fundraising and need a 3-year financial model, when planning hiring and need to understand runway implications, or when the board asks for updated projections. Critical for Series A preparation where investors expect detailed financial thinking.

🎯 What You'll Get

You get a structured 3-year financial model with monthly Year 1 and quarterly Years 2-3, covering revenue streams, COGS, operating expenses, headcount plan, and key SaaS metrics (CAC, LTV, burn rate, runway). Includes clearly labeled assumptions and sensitivity scenarios.

🔗 Related Prompts

Data & AnalysisPremium

Revenue Forecast Model Builder

Build a revenue forecast model with assumptions, scenarios, and sensitivity analysis from your historical data.

revenueforecastingfinancial-modeling
★4.8
advanced