Overview

A typical model consists of several worksheets - Inputs, Revenues, Opex, Capex etc.

Imagine as well your model has three scenarios - Base, Upside and Downside which you can switch from and to on the Inputs sheet.

You set your model to Base scenario and start walking through it. At Capex sheet, you decide you want to look at it under the Upside scenario and wish there was a way to switch between scenarios on every worksheet.

The attached file explains how to do this.

Share
Reviews Add a review
No reviews yet

More From Andrei Okhlopkov

Browse our top rated business templates. See All
Variance Analysis & Portfolio Statistics
32
0
The attached template provides the basis for product portfolio analysis. The template performs the following types of analysis: - key…
financial model templates dashboard Monte Carlo analysis without macros
171
20
The Monte Carlo method tests a large number (several hundreds or thousands) of "scenarios" in which the inputs are random…
Analysing data in Excel
228
28
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
financial model templates dashboard Sensitivity analysis - advanced methods of using data tables (full version)
354
1
This is a full version of my data table publication which explains how to:   - link several data tables…
financial model templates dashboard Sensitivity analysis - advanced methods of using data tables
382
42
A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various…
financial model templates dashboard Guiding Principles of Financial Modelling
366
52
The file explains the general principles of building financial models, gives a comprehensive example of a demo financial model and…