Simple Financial Projections

Explore

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

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

Cost

Profit

⁠

Step 4️⃣: Set up the drivers Growth Rates ↘️

↗️Create Your Drivers Here

⁠

↗️Connect Drivers to the items projected

⁠

↗️Define Calculated Item relations

Name

Name

Slider

Slider

Growth Rate

Growth Rate

ASP

000

43%

Cost

000

Order Volume

000

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

2016

2017

ASP

Cost

1.5

Order Volume

⁠

Step 6️⃣:You are all set!

⁠

Generate Prrojections

⁠

👉Go to:

Dashboard⁠

⁠

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.