Exercises / Finance and business maths · 14 of 14
A scenario switch for a model
CHOOSE(n, option1, option2, option3) returns the nth option. Financial models use it as a switch: one input cell picks the Base, Upside or Downside assumption everywhere at once.
Your taskB1 holds the scenario number (1 Base, 2 Upside, 3 Downside). In F4, use CHOOSE to return the assumption for the chosen scenario from B4:D4. It will be copied down to F6.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Scenario | 1 | ||||
| 2 | ||||||
| 3 | Assumption | Base | Upside | Downside | Live | |
| 4 | Revenue growth | 8% | 15% | 2% | ||
| 5 | Gross margin | 42% | 46% | 37% | ||
| 6 | Churn | 5% | 3% | 8% |