ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
2
3
Financial Projections Model
4
5
This spreadsheet has been developed by Equidam, using both the expertise from experience as well as from academia. The purpose of this document is to create a projection of a company's financial performance given certain inputs and assumptions. It must be appreciated that there is no one fits all, and any financial model requires adjustment and fine-tuning to the specificities of each company or project. Equidam holds no responsibility for the soundness of this template and does not guarentee it is without error in calculation or approach.
6
7
8
How to use this template
The name of my company is:
9
This spreadsheet walks you through the process of developing an integrated set of financial projections.
Please enter the name of your business in the box below:
10
Please note that the "$" sign is purely a place holder to show values that are currency - it has no other effect.
Unicorn Inc.
11
12
1 -
All cells where your input is required are highlighted in light green as shown below.
CONTENT: Overview of the sheets in this model template and their function.
13
How-to: Fill in boxes with a light green shading:
-
14
Sheet #Sheet Name
Description of Sheet function
15
2 -
Certain cells are required inputs where an assumption has been made and that require your review (optional).
1 IntroductionThis introduction page explaining the Model Template.
16
How-to: Check assumptions in boxes with a grey shading and edit where necessary:
 -
17
2 Summary FinancialsA Summary sheet in which you can find an overview of the five year projection on a yearly basis after all inputs have been filled in.
18
3 -
All information found in black text and without shading is automatically calculated for you.
19
Please refrain from editing the formulas in these cells as this can alter the model's functionality.
20
3 Equidam Financials InputThe Equidam Financials Input sheet conveniently gathers all the required information from the model necessary to perform a valuation using Equidam.
21
4 -
The sheets with a light green shading on the right require your input.
22
The Summary Financials, Equidam Financials Input and Overview of Inputs are calculated automatically for you.
23
4 Overview of InputsThe Overview of Inputs sheet is a convenient way to review and check all the inputs provided for all the years; use it to verify you haven't made any typos.
24
5 -
Once you complete this model template, you will be one step away from discovering your company valuation.
25
Understand your valuation, transparently discuss it and close fair deals on:
equidam.com
26
If you need advanced help with the financial projections, please reach out to our team of financial modelling and valuation consultants to discuss how we can assist you. You can do this either through sending an e-mail or arranging a call through the links below.5 Financing ScheduleThe Investment Schedule sheet is where you should input any desired or expected investments or new debt. There is a built in red flag identifier that notifies you if the company goes cash negative.
27
28
Send an e-mailArrange a call
29
6 Year 1Five sheets each with 12 periods in each and representing a forecast year. This is where you need to input base assumptions and inputs which will determine the forecast. There are 4 primary types of revenue, each with its particular mechanics and corresponding costs etc. Should an input in this model not be applicable, simply set it to 0 (zero) and it will not have any effect.
30
7 Year 2
31
Powered by:8 Year 3
32
9 Year 4
33
This model has been developed by Equidam BV (www.equidam.com) for non-commercial purposes.
10 Year 5
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100