Latest / ModeLoop: Financial Modelling in Excel

Scenarios and sensitivities with AI | P3E21
Synthetic annual teaching case: separate a coherent scenario from a sensitivity that holds stated inputs fixed. Base simplified operating result is £50,000; the downside is £3,000. A £47,000 bridge reconciles the changes in volume, price and unit cost.
The sensitivity grid holds unit cost at £30, explaining why its £12,000 corner differs from the £3,000 downside. A hard 10,500-unit capacity limit reduces a proposed £76,000 upside to £65,500. Scenarios are not probabilities, and positive operating result is not proof of sufficient cash.
Designed illustrations and two-voice synthetic narration…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.