Prompt Magic
  • Discover
  • ✦ Premium
  • Pricing

© 2025-2026 Prompt Magic. All Rights Reserved.

  1. Home
  2. Prompts
  3. The Financial Scenario Modeler

The Financial Scenario Modeler

Eric Eden
Mar 23, 2026
124 views
The Financial Scenario Modeler
Featured Image
Claude (Opus 4.6)TextAnalysis

Turn Claude into your fractional CFO to stress-test your runway.

Prompt


Act as a strategic CFO. We are considering 

[Specific Financial Decision, e.g., a major software purchase, hiring 5 new reps, expanding to Europe]. 

Our current financial constraints are

 [Briefly list constraints, e.g., 12 months runway, tight cash flow]. 

Model out three scenarios for this decision in Excel: 1) Best case, 2) Base case, and 3) Worst case. For each scenario, detail the potential impact on cash flow, ROI timeline, and overall business risk. Recommend a go/no-go decision based on the base case.

List all assumptions 
1. 
2. 
3. 

Create a model in excel comparing scenarios.

Create relevant charts and graphs comparing the scenarios to visualize the results
5.0•1 review

Instructions

Top Use Case: Evaluating CapEx, hiring freezes, or M&A opportunities....

About the author

Co-founder of Prompt Magic and ThinkingDeeply.ai Career Chief Marketing Officer

Join Thousands of AI Enthusiasts

Discover Thousands of AI Prompts
Completely Free

Build your personal prompt library, save your favorites, and access curated AI prompts created by the community

Thousands of Prompts

Access a vast library of high-quality AI prompts for every use case

Build Your Library

Save prompts to your personal library and organize them your way

Always Free

Get started with full access to our core features at no cost

Sign Up FreeSign In

No credit card required • Free forever • Join 10,000+ users

Prompts You May Love

Financial Scaling Model & Forecast

When to use: You need to understand unit economics and plan for growth.

by Eric Eden

Dynamic Forecasting & Scenario Planning

Builds multi-scenario financial models with sensitivity analysis in minutes

by Eric Eden 3.0

“AI CFO” System Prompt

Use this prompt to take the heavy lift away from CFO tasks.

by Eric Eden

Business Budget Creator

Use this to create a budget, cashflow and cost analysis

by Eric Eden 5.0

Portfolio Power Matrix

Know exactly what to double down on and what to kill. The Framework: BCG Growth-Share Matrix 2.0 Why It Works: Prevents the #1 business killer - spreading yourself too thin across too many initiatives.

by Eric Eden 5.0

Interactive KPI Dashboard Creation

Generates comprehensive KPI dashboards with drill-down capabilities

by Eric Eden