SaaS Financial Forecast Template
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions
2
This template is meant to be a simplified starting point for building a forecast for a new or early-stage SaaS company, and requires customization based on the structure of your business. Blue cells are inputs, meant to be filled in or adjusted. White cells are calculated. Make a copy for yourself and edit as needed.
3
4
Employees Tab:
Start with this tab first, by filling in your hiring plan
5
This tab also includes inputs around your sales rep quotas and ramp schedules, which drive new ARR
6
P&L Tab:You may want to override the new ARR calculations in the first few months based on reasonable expectations, especially if you don't plan to hire sales reps until several months out
7
Make estimates for the assumptions in the blue cells in column B
8
Make monthly estimates for the discretionary spending in the remaining blue cells
9
Balance Sheet:Most cells here are filled in. Only fill in blue cells as they apply (i.e. if company purchases any fixed assets not on the P&L)
10
Fill in Common Stock or Long-Term Debt with any cash invested in the company
11
12
Key Assumptions in this Model:
13
Employees Tab: The salary calculation is taking a full month of salary expense for the month in which an employee starts. Note that if you enter a date other than the first of the month, the formula will calculate zero for that month
14
P&L Tab:
Revenue is recognized beginning the month after the ARR is first booked
15
ARR is all annual, up-front contracts
16
Commission is expensed in the month the ARR is booked and assumes a percentage based on new ARR
17
Balance Sheet:
New bookings are invoiced the month after booked, and collected the month after invoiced
18
Accounts Receivable and Deferred Revenue forecasts do not take into account invoicing and collecting for renewal ARR - adjust this model in year two by adding in cash collections on renewals
19
This template takes a very simplified approach to forecasting prepaid expenses and accounts payable, basing them off of a percentage of that month's expenses
20
This template doesn't model any delays in paying out commissions, or other accrued liabilities
21
22
Note on Gross Margins: This model does not include a calculation of Cost of Sales and Gross Margin. Items on the included P&L that should likely be allocated to Cost of Sales are Hosting expense and some of the Salaries expense. These allocation depend on the nature of your business, and are difficult to model in a template format.
23
24
25
26
27
28
29
30
31
32
33
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
Loading...
Main menu