ABCDEFGHIJKLMNOPQRSTUV
1
IF YOU WANT TO PLAY WITH THIS SPREADSHEET DOWNLOAD IT OR MAKE A COPY AND PLAY WITH IT LOCALLY. I'M NOT ALLOWING EDITING ACCESS
2
Average revenueMonth of first purcahse
3
per buyer inMar 2011April 2011May 2011June 2011July 2011Aug 2011Sept 2011Oct 2011Nov 2011Dec 2011Jan 2012Feb 2012March 2012April 2012May 2012Average revenue% of originalCum RevCum LTVPaid back?Mths
4
Month 1$161.60$150.50$156.70$145.60$128.60$146.10$147.00$137.80$141.70$142.70$141.80$131.40$126.80$128.10$133.10$141.30100%$141.30$21.20FALSE1
5
Month 2$30.50$27.30$29.30$27.90$22.00$23.20$24.80$24.90$27.20$23.80$24.40$23.10$26.00$26.40$25.8018.2%$167.09$25.06FALSE2
6
Month 3$27.00$27.90$21.10$24.20$22.00$19.60$26.70$21.60$21.40$21.50$22.90$21.50$21.10$23.0016.2%$190.04$28.51FALSE3
7
Month 4$23.90$23.30$23.60$21.10$20.50$22.40$23.10$20.00$21.40$21.40$19.70$20.10$21.7015.4%$211.75$31.76FALSE4
8
Month 5$22.40$21.60$20.00$18.80$20.30$23.60$21.30$20.30$19.40$23.60$20.40$21.1014.9%$232.83$34.92FALSE5
9
Month 6$18.10$22.80$19.90$21.40$22.50$21.60$19.30$20.30$20.30$20.60$20.7014.6%$253.52$38.03FALSE6
10
Month 7$19.70$20.00$21.00$19.60$21.60$20.00$22.70$19.70$20.00$20.5014.5%$274.02$41.10FALSE7
11
Month 8$21.40$22.90$23.50$22.10$24.80$22.60$20.50$22.00$22.5015.9%$296.48$44.47FALSE8
12
Month 9$20.50$21.40$22.30$20.90$23.20$21.30$21.60$21.6015.3%$318.08$47.71FALSE9
13
Month 10$19.60$22.00$20.00$21.70$21.80$19.90$20.8014.7%$338.91$50.84TRUE10
14
Month 11$21.90$19.50$22.70$19.40$19.10$20.5014.5%$359.44$53.92TRUE11
15
Month 12$20.80$20.70$21.40$20.60$20.9014.8%$380.29$57.04TRUE12
16
Last 6 mth average14.9%
17
18
Month 13$21.0714.9%$401.36$60.20TRUE13
19
Month 14$21.0714.9%$422.43$63.36TRUE14
20
Month 15$21.0714.9%$443.49$66.52TRUE15
21
Month 16$21.0714.9%$464.56$69.68TRUE16
22
Month 17$21.0714.9%$485.63$72.84TRUE17
23
Month 18$21.0714.9%$506.69$76.00TRUE18
24
Month 19$21.0714.9%$527.76$79.16TRUE19
25
Month 20$21.0714.9%$548.82$82.32TRUE20
26
Month 21$21.0714.9%$569.89$85.48TRUE21
27
Month 22$21.0714.9%$590.96$88.64TRUE22
28
Month 23$21.0714.9%$612.02$91.80TRUE23
29
Month 24$21.0714.9%$633.09$94.96TRUE24
30
Month 25$21.0714.9%$654.16$98.12TRUE25
31
Month 26$21.0714.9%$675.22$101.28TRUE26
32
Month 27$21.0714.9%$696.29$104.44TRUE27
33
Month 28$21.0714.9%$717.36$107.60TRUE28
34
Month 29$21.0714.9%$738.42$110.76TRUE29
35
Month 30$21.0714.9%$759.49$113.92TRUE30
36
Month 31$21.0714.9%$780.55$117.08TRUE31
37
Month 32$21.0714.9%$801.62$120.24TRUE32
38
Month 33$21.0714.9%$822.69$123.40TRUE33
39
Month 34$21.0714.9%$843.75$126.56TRUE34
40
Month 35$21.0714.9%$864.82$129.72TRUE35
41
Month 36$21.0714.9%$885.89$132.88TRUE36
42
43
3 year Cumulative Revenue$885.90
44
Contribution Margin$0.15
45
3 year LTV$132.88
46
Customer Acquisiton Cost$50.00
47
LTV/CAC ratio$2.66
48
Payback period$10.00
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