Financial Projections

Amber Sophia

Workbook Setup

Dashboard

👋Hey there,
`Anonymous User`
⁠
!

⁠

Business, analytics, sucess, startup, Technology _ account, setting, options, preferences.svg

⁠

Welcome to the (Simple) Financial Projections Doc!

This doc is a continuation of

Fundraising OS⁠

, which is all about fundraising stories manifested in questions and answers. The flip side of a story is the evidence of that story told in numbers and logic. This is where this doc comes in. It attempts to simplify the lineup of projections and drivers (for example, your revenue and costs drivers) and model them out into the future with various assumptions of your choosing.

Core Functions

This doc is a simplified version of a typical financial projection model, where a company would have a bunch of items to project, for example Revenues, Cost of goods sold (COGS) and Sales and Admin costs (SG&A) and so on. Usually these items are driven by a set of driver items that represent a certain aspect of the business activity. It could be the number of employees and average wage, as well of number of items and average selling price per item.

In a nutshell, you will be able to：

Define timeframe of historical and projection period

Create as many items to be projected as you like

Create corresponding drivers for each item projected

Further calculation on items projected → items that are results of other items, such as aggregations and margins/rates

⁠

How it works

To start, go to

Workbook Setup⁠

to set the table for the projection model, where you will be given step-by-step instruction as to how to setup the data and core assumptions.

⁠

Ready? Go to:
`Workbook Setup`⁠

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.