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
There are no rows in this table
Step 5️⃣: Input historical driver values↘️
2015
3
2016
3
2017
3
Step 6️⃣:You are all set!
👉Go to:
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.