JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Collective Workspace Template
Workspace
More
Share
Explore
Financial Projections
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↘️
1
2
3
Item
Type
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
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
1
2
3
Name
Slider
Growth Rate
Name
Slider
Growth Rate
ASP
000
43
43%
Cost
000
5
5%
Order Volume
000
27
27%
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
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:
Dashboard
Load content from teamup.com?
Loading external content may reveal information to 3rd parties.
Learn more
Allow
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.