Revenue Forecast Model

Build a simple forecast based on historical performance

🧪 Tested by a human Advanced 👤 Finance 👤 Analyst 👤 Executive
Using the last [PERIOD — 12 / 24] months of revenue data, create a forecast for the next [PERIOD — 3 / 6 / 12] months. Include: (1) Trend analysis, (2) Seasonal adjustments if patterns exist, (3) Best case, expected, and worst case scenarios, (4) Key assumptions stated clearly, (5) Confidence level for each scenario. Present as a table with a trend chart.

Works on

⭐ M365 Copilot (Best)

Copy & Open in

Prompt is copied to your clipboard when you click

Tips for Best Results

  • State your assumptions clearly — forecasts are only as good as their assumptions
  • Include at least 3 scenarios so leadership can plan for range of outcomes
  • Update forecasts monthly as new actuals come in

📎 More Prompts

Budget Planning Template

●●
Create a budget planning template for [DEPARTMENT] for [FISCAL YEAR]. Include: (1) Revenue categories with line items, (2) Operating expenses by category (personnel, software, travel, training), (3) Capital expenditure section, (4) Monthly and quarterly breakdowns, (5) Variance tracking columns (budget vs actual), (6) Summary dashboard row with key ratios. Add formulas for totals, percentages, and year-over-year comparison.
⭐ M365 🟢 GPT

Cost Reduction Opportunity Analysis

●●●
Analyse our spending data and identify cost reduction opportunities. Review: (1) Subscriptions and recurring costs (look for unused or duplicate tools), (2) Vendor consolidation potential, (3) Process automation savings, (4) Licence right-sizing, (5) Contract renegotiation opportunities. For each opportunity estimate: annual savings, implementation effort, and risk. Rank by ROI.
⭐ M365 🟢 GPT

Expense Variance Analysis

●●
Analyse the expense variance between budget and actual for [PERIOD]. For each line item that varies by more than [THRESHOLD — 5% / 10% / ]: (1) State the variance amount and percentage, (2) Classify as favourable or unfavourable, (3) Explain the likely cause, (4) Recommend whether it is a one-time variance or a trend, (5) Suggest corrective action if needed. Summarise total impact.
⭐ M365
💬