Back

Generate financial best/base/worst case scenarios

Generate financial best/base/worst case scenarios

Your first prompt to AI

Your first prompt to AI

"Using the attached financial dataset and historic performance data, generate best/base/worst-case financial scenarios; output a forecast table with assumptions."

"Using the attached financial dataset and historic performance data, generate best/base/worst-case financial scenarios; output a forecast table with assumptions."

Enhanced AI workflow

  1. Input via Excel: Upload financial model and define key drivers


  2. AI-Simulation Setup in AI Chat: Define assumptions for each scenario


  3. AI-Model Generation: Recalculate metrics for best, base, and worst cases


  4. AI-Stress Test: Identify which drivers have outsized impact


  5. AI-Visualization: Create comparison charts for each case


  6. Output via Excel and AI Chat: Share updated model and visuals

AI accessing tools and data

AI accessing tools and data

Benefits using AI

Benefits using AI

Freed up human focus

Freed up human focus

Faster execution

Faster execution

Ensured accuracy

Ensured accuracy

Applied in

Applied in

Scenario planning

Scenario planning

Requesting departments

Requesting departments

Investment, Finance

Investment, Finance

Beneficiaries

Beneficiaries

Investment Manager, Finance Manager, FP&A Analyst, Portfolio Analyst

Investment Manager, Finance Manager, FP&A Analyst, Portfolio Analyst