ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
 Get Started
3
Key model assumptions and summaries. Detailed inputs on Forecast sheet.
4
5
 Setup and Timescale
6
 What is the name of your company? Company
This is used in the Legal Disclaimer sheet, which is purely optional, but something many people choose to include in their projections when they provide them to potential investors
7
 What is your currency? $
Model works for any currency, as there are no currency-specific calculations in the model. This label is used in some presentation areas.
8
 What is the first date you want to forecast?Sep-21
First month in the model; if this model is entirely a forecast of the future, input the first month you want to forecast from.
9
What is the fiscal year end of the first year modeled?
Dec-21
Define the month that is the fiscal year end of the first year in the model. This allows you to set the fiscal years in the model, and thus the # of months in the first year forecasted in the model. The default setting uses a formula to return the year end (in December) from the first month in the forecast. Feel free to overwrite this to set a different fiscal year end, just overwrite the formula with a date.
10
11
Revenue and Marketing Assumptions
12
Average Revenue per Subscriber, per month $ 30 average revenue per month
13
Gross Margin % %88%as a % of revenues
14
Customer Acquisition Cost (CAC) $ 25 Customer acquisition cost, per new subscriber
15
Retention Cost per renewed subscriber $ 5
retention cost per subscriber, per renew cycle. Intention is to include cost to market to existing subscribers to increase retention
16
Deferred Revenues, beginning of first month $ - optional: deferred revenue at the beginning of the first month in model
17
18
 Growth and Churn Assumptions
19
 Date to start growth and revenuesSep-21date to start growth of revenues, used on Forecast sheet in Growth section
20
 Subscribers # 25
use the input to change the label, the number input refers to the # new in the first month, as defined above
21
 Subscribers, beginning of first month # - at the beginning of the first period in model
22
 Baseline growth rate in New Subscribers %10%this assumes the growth rate in the first month after growth starts, as defined above
23
 … where the growth rate declines % per month %-5%
this changes the growth rate over time: you can assume a growth rate that increases over time, stays the same, or decreases (most common)
24
 Churn rate, per period %5%Churn per month, as a % at the beginning of the period
25
 Reactivation Rate, per period %0%
optional: for previously churned subscribers that reactive. calculated as % of churn in previous period.
26
 Contract Cycle # 12
Assume the length of the contract, in months, to calculate churn cycles. E.g. input 12 for an annual contract, 1 for a month-to-month contract
27
 Billing Cycle # 12
Assume the length of the billing cycle, in months. e.g. an annual contract billed all up front is 12, an annual contract billed month to month is 1, a month-to-month contract is 1
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