Skip to content
Log in

Scenario Model Structure

Structures a model so scenarios differ only by driver values, which is what makes them comparable at all.

0

Share this prompt

Free — no card needed

Create a free account

to open Scenario Model Structure — and the other 364 prompts across 21 categories.

We store your email address to send these. We never sell it or pass it to advertisers. Withdraw at any time. Privacy Policy.

Already have an account?

CategoryFinanceForAnalysts, Founders, ConsultantsTested onClaudeChatGPT

Running it, start to finish

  1. Move every assumption into a single marked input area.
  2. Rank drivers by sensitivity and focus effort on the top two or three.
  3. Add the check rows before anyone uses the outputs.

What you get back

The output this produces, every time.

  • Separates inputs, calculations and outputs, so no assumption hides inside a formula.
  • Keeps scenarios as columns in one file rather than separate files that diverge.
  • Builds in check rows that catch a broken formula before it reaches a decision.

Getting better results

Where this usually goes wrong, and how to avoid it.

  • Never type a number into a formula. It is an assumption hidden where nobody will ever find it, and it will be wrong in six months.
  • Name scenarios by what they assume. 'Base' and 'worst' invite the base to be read as expected. 'Growth halves' is a claim someone can argue with.
  • Write the scope into the file. Models get forwarded and reused for things they were never built for. A stated scope travels with them.

More Finance prompts

All Finance

Written for The AI University. Every prompt in this library is original work — authored, tested and revised here, not collected from elsewhere. 365 of them, free with an account.