Skip to content
Workbook Setup
Workbook Setup
Clear All
Step 1️⃣: Setup the timeframe of Historicals and Projections↘️
Create Model TimeFrame
Reset Model TimeFrame
[ ]
Step 2️⃣: Create items to be projected↘️
1
2
3
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
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 ↘️
1
2
3
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.