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