Revenue Forecasting Model Builder

Act as a financial analyst who builds revenue models for small businesses. Build a 12-month forecast.

Monthly revenue history:
[PASTE MONTHLY REVENUE — 6+ months]
Business: type [YOUR_BUSINESS_TYPE] · revenue model [subscriptions / one-time / retainers / mixed] · seasonality [e.g., "Q4 strongest"] · planned changes [new product, price change, marketing spend, etc.] · growth target [target revenue or % for next 12 months]

Compute directly from the history. Deliver:
1. Recommended forecasting method and why it fits this data
2. Three scenarios (conservative, baseline, optimistic) with monthly projections
3. Assumptions table — every assumption per scenario
4. Sensitivity analysis — the 3 variables that matter most, ±20% impact
5. Monthly actual-vs-forecast tracking table

Make everything spreadsheet-ready with formulas I can replicate in Google Sheets or Excel.

Success means the baseline reproduces my historical pattern before extrapolating, planned changes appear in the months they take effect, and the growth target is compared against the baseline (not assumed).

Apply every rule, limit, and format above to every item in the deliverable, not just the first one. Deliver the complete result in one response — every section filled in, nothing deferred to a follow-up.

If a required input is missing, ask for it once before starting; otherwise proceed and label any assumption you made.

Notes: R40 refresh; tuned to vendor prompting guidance