Skip to content
Gallery
ccicon
Collaborative Workspace Template
Share
Explore
Financial Projections

icon picker
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:


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 (
CtrlP
) instead.