Example model / scenarios for blog post on models
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Start by taking a copy (File --> Make a copy...) which will give you editing permissions to change parameters, see how everything is set up, and view cell and range names etc.

To begin with, you can simply modify some assumptions and see how the outputs vary - this will be most easy to see in the chart output. Once you are comfortable with that, there are two areas of exploration that you might find interesting:

1. Dive into the mechanics to understand how the model works, how it was built, and how you could build something similar to achieve your own goals
2. Experiment with building "scenarios" - set up inputs how you want them and then vary assumptions through a sensible range, copying the output each time into the scenario comparison sheet (remember to "paste values" which takes just the numbers, and not the formulae - you can do this by pasting with "CTRL+SHIFT+V" or "CMD+SHIFT+V")

As you explore the model, note that I have left a number of comments around the place which explain how or why the model is built the way it is. You can expose them all by clicking on the number on the tab at the bottom of your screen.

You can read more about the motivations and background to this model in my blog post on the Distilled site.
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Key
17
Typed input
18
Typed assumption
19
Calculated field
20
Chart input
21
Pasted scenario
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
How to use this workbook
Assumptions & inputs
Example model
Scenario outputs
Scenario chart
 
 
Main menu