Create Scenarios and Sensitivity Analysis in Excel
From Wikiprompt, the free prompt encyclopedia
Mar 19, 2026
Create Scenarios and Sensitivity Analysis in Excel Prompt to instruct Claude to build multiple scenarios and sensitivity data tables for a financial model.
Prompt ContentSave
🌐
Add Base, Upside, and Downside cases.
Create a Downside scenario assuming [METRIC] drops by [PERCENT].
Build an Upside case with [ASSUMPTION CHANGE].
Add a data table for [METRIC] at different [GROWTH RATES/MARGINS/PRICES].
Sign in to see the full prompt
Continue with:
By logging in, you agree to our Terms of Use and Privacy Policy
Usage
This prompt is designed for use with business. Copy the prompt content above and paste it into your preferred AI tool.
For best results, you may customize the placeholders (indicated by square brackets or capital letters) with your specific requirements.
Talk
0 comments