Sales Forecast Template

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
2	Average Revenue per User	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00
3	Starting Subscribers	0	490	980	1,455	1,925	2,386	2,838	3,280	3,715	4,140	4,557	4,962
4	New Subscribers	500	500	500	500	500	500	500	500	500	500	500	500
5	Cancellations	10	10	25	30	39	48	58	65	75	83	95	100
6	Net Additions	490	490	475	470	461	452	442	435	425	417	405	400
7	Ending Subscribers	490	980	1,455	1,925	2,386	2,838	3,280	3,715	4,140	4,557	4,962	5,362
8	Churn Rate	NA	2.04%	2.55%	2.06%	2.03%	2.01%	2.04%	1.98%	2.02%	2.00%	2.08%	2.02%
9	Projected Lifetime (months)	NA	49.0	39.2	48.5	49.4	49.7	48.9	50.5	49.5	49.9	48.0	49.6
10	Projected Lifetime Value (LTV)	NA	$980.00	$784.00	$970.00	$987.18	$994.17	$978.62	$1,009.23	$990.67	$997.59	$959.37	$992.40
11	Total Monthly Recurring Revenue	$10,000.00	$19,800.00	$29,600.00	$39,100.00	$48,500.00	$57,720.00	$66,760.00	$75,600.00	$84,300.00	$92,800.00	$101,140.00	$109,240.00
12
13
14
15
16
17
18
19
20
21
22
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