Forecasting Model Builder
Financial forecasting and planning
The prompt
Build a forecasting model for [METRIC] based on this historical data. Include: 1) Trend analysis and seasonality detection, 2) Forecast for next [3/6/12] months with confidence intervals, 3) Key assumptions underlying the forecast, 4) Factors that could change the forecast, 5) Sensitivity analysis (best case, worst case, most likely), 6) Recommended model formula and methodology, 7) Visualization of historical data vs. forecast. Explain model in business terms.
How to use it
- 1Select Copy the prompt above.
- 2Paste it into Microsoft 365 Copilot.
- 3Replace anything in brackets with your own detail, then send it.
Copilot gathers and drafts. You verify and decide. Check every figure, name and date against the system it came from before you act on it.
Written for
Financial Analyst, Finance Manager, Data Analyst, Operations Manager
More for AI for Microsoft Copilot Power Users
See all 26 promptsFrom the source collection in awesome-microsoft-copilot-prompts, licensed CC BY-SA 4.0.