Back to prompts
Data & AnalysisPremiumadvanced
4.8

Revenue Forecast Model Builder

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

Copy & Paste this prompt
You are a financial analyst specializing in revenue forecasting and financial modeling for startups and SMBs.

Build a revenue forecast model based on:

Business Type: [SAAS / E-COMMERCE / SERVICES / MARKETPLACE]
Current Metrics:
- Monthly Revenue: [CURRENT MRR/REVENUE]
- Growth Rate: [MONTH-OVER-MONTH %]
- Customer Count: [CURRENT CUSTOMERS]
- Average Revenue Per User: [ARPU]
- Churn Rate: [MONTHLY CHURN %]
- Customer Acquisition Cost: [CAC]

Forecast Period: [6 / 12 / 24 MONTHS]

Deliver:

1. **Base Case Forecast** — Month-by-month projection with new/churned/net customers, MRR, cumulative revenue
2. **Three Scenarios:** Optimistic (growth +50%), Base, Pessimistic (growth -50%, churn up)
3. **Sensitivity Analysis** — Impact of churn, ARPU, and CAC changes
4. **Break-even Analysis** — When do you cover costs?
5. **Key Metrics to Track** — Leading indicators for each scenario

Format as a spreadsheet-ready table for Google Sheets/Excel.
#revenue#forecasting#financial-modeling#SaaS#metrics

Works with

chatgptclaudegemini

💡 Pro Tips

  • •Be conservative with growth assumptions — VCs respect realistic models
  • •Update monthly and compare forecast vs actual
  • •Ask for the Google Sheets formula version to build a live model

🧠 Why This Works

This prompt enforces assumption-explicit forecasting by requiring you to state and stress-test every input variable. It builds scenarios (base, optimistic, pessimistic) with sensitivity analysis, producing forecasts that communicate uncertainty rather than false precision.

📅 When to Use This Prompt

Use for annual planning, investor presentations, board decks, or any time you need to project revenue with defensible assumptions. Essential for SaaS companies modeling ARR growth, e-commerce businesses planning inventory, or startups preparing fundraising materials with credible financial projections.

🎯 What You'll Get

You get a complete forecast model with clearly stated assumptions, three scenarios with probability-weighted outcomes, sensitivity analysis showing which variables matter most, and a month-by-month projection table ready for spreadsheet implementation.

🔗 Related Prompts

Business & StrategyPremium

Startup Financial Model Builder

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

financial-modelstartuprevenue
★4.8
advanced