JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
Collaborative 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↘️
Table that this table is a view of has been deleted. Click to delete the table.
Add New Item
Create Worksheet
Clear All Entries
Make Sure
you Clear before creating new ones!
Step 3️⃣: Enter historical Item data ↘️
Table that this table is a view of has been deleted. Click to delete the table.
Step 4️⃣: Set up the drivers Growth Rates ↘️
↗️Create Your Drivers Here
↗️Connect Drivers to the items projected
↗️Define Calculated Item relations
Table that this table is a view of has been deleted. Click to delete the table.
Table that this table is a view of has been deleted. Click to delete the table.
Table that this table is a view of has been deleted. Click to delete the table.
Generate Drivers
Reset Drivers
Step 5️⃣: Input historical driver values↘️
Table that this table is a view of has been deleted. Click to delete the table.
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.