Scenario Analysis
Overview
A scenario analysis is shown below. This shows how the payback period changes from changing multiple input variables at a time.
Info: Worksheet (and page JavaScript) may take time to load
Tip: Double click a cell to view its formula
Worksheet Elements
The worksheet has various elements. These are described further below:
Graph
The graph near the top just illustrates the fact that a scenario analysis is usually for seeing how an ouput might vary to varying several input(s) at a time, rather than just one.
Scenario Table
This is basically a table where you can record what the Payback period and Net Contributions are to different configurations of input variables. The input variables can be changed by varying the Baseline input variables highlighted in “yellow” on the front sheet.
Feedback
Submit and view feedback