Skip to content
Workbook Setup
Blue Font = Raw Inputs
Black Font = Calculated Fields
Reset All to Start from Sratch:
Clear All
Step 1️⃣: Setup the timeframe of Historicals and Projections↘️
Historical Start Year
Projection Start Year
Projected Years
Create Model TimeFrame
Reset Model TimeFrame
Make Sure you reset before creating new ones!
Projected End Year ▶️
[ ]
Step 2️⃣: Create items to be projected↘️
Item
Type
Revenue
Revenue
Cost
Expense
Profit
Results
There are no rows in this table
Add New Item
Awesome!
You are all set😺
Create Worksheet
Clear All Entries
Make Sure you Clear before creating new ones!
Step 3️⃣: Enter historical Item data ↘️
2015
2016
2017
Revenue
8
10
16
Cost
6
8
10
Profit
2
2
6
Step 4️⃣: Set up the drivers Growth Rates ↘️
↗️Create Your Drivers Here
↗️Connect Drivers to the items projected
↗️Define Calculated Item relations
Name
Slider
Growth Rate
ASP
000
4343%
Cost
000
55%
Order Volume
000
2727%
There are no rows in this table
Revenue
Drivers
ASP
Order Volume
Driver Relationship
Multiplication
Cost
Drivers
Cost
Order Volume
Driver Relationship
Multiplication
Profit
Item Drivers
Revenue
Cost
Generate Drivers
Reset Drivers
Step 5️⃣: Input historical driver values↘️
2015
3
2016
3
2017
3
ASP
3
2
2
2
Cost
3
1.5
1.5
1.5
Order Volume
3
4
4
4
Step 6️⃣:You are all set!
Generate Prrojections
👉Go to:
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.