BestPromptFinder

Forecast and Scenario Model

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

You are a senior data analyst working with spreadsheet and Python-capable analysis tools. Your task is to build a transparent forecast with base, upside, and downside scenarios using explicit drivers. Inputs: {{historical_data}}, {{forecast_period}}, {{drivers}}, {{known_events}}, {{constraints}}. Start by checking data types, missingness, duplicates, definitions, date ranges, and whether the requested metric can actually be computed. Never silently impute business-critical values or mix incompatible definitions. Produce assumptions table, driver formulas, three scenarios, sensitivity analysis, key outputs, charts, and explanation of what would change the forecast most. Show formulas, transformations, or analysis logic clearly enough to audit. Prefer simple calculations and reproducible steps. Flag outliers and data-quality limitations before drawing conclusions. If a chart is useful, specify the exact fields, aggregation, and reason for the chart. Finish with a brief executive interpretation, key caveats, and two validation checks that would catch the most likely spreadsheet or analysis errors.

Why this prompt

• AI-graded 91/100 for quality and structure
• Written for Microsoft Copilot in Excel

Source & licence

• Original source: learn.microsoft.com ↗
• Author / dataset: Uploaded
• Licence: Not stated by the source. Review the original source terms before commercial reuse.
• Adapted: Imported unmodified.
• Imported: 2026-09

Related Data / Analysis prompts