Discovery Driven Planning -- CLV Edition

	B	C	E	F	G	H	I	J
1
2
3	Revenue	$1,000.00	month	revenue	profit	% alive	profit \| alive	present value
4	Revenue Growth	2.00%	0	1,000.00	800.00	100%	800.00	800.00
5	Contribution Margin	80.00%	1	1,020.00	816.00	98%	799.68	793.30
6	Churn	2.00%	2	1,040.40	832.32	96%	799.36	786.66
7	Retention	98.00%	3	1,061.21	848.97	94%	799.04	780.08
8	Annual Discount Rate	10.00%	4	1,082.43	865.95	92%	798.72	773.55
9	Monthly Discount Rate	0.80%	5	1,104.08	883.26	90%	798.40	767.07
10	PAV	24,955.07	6	1,126.16	900.93	89%	798.08	760.65
11	Desired CLV / CAC	3.00	7	1,148.69	918.95	87%	797.76	754.28
12	CLV	18,716.31	8	1,171.66	937.33	85%	797.44	747.97
13	"Allowed" CAC	6,238.77	9	1,195.09	956.07	83%	797.12	741.71
14			10	1,218.99	975.20	82%	796.81	735.50
15			11	1,243.37	994.70	80%	796.49	729.34
16			12	1,268.24	1,014.59	78%	796.17	723.24
17			13	1,293.61	1,034.89	77%	795.85	717.18
18			14	1,319.48	1,055.58	75%	795.53	711.18
19			15	1,345.87	1,076.69	74%	795.21	705.23
20			16	1,372.79	1,098.23	72%	794.90	699.32
21			17	1,400.24	1,120.19	71%	794.58	693.47
22			18	1,428.25	1,142.60	70%	794.26	687.66
23			19	1,456.81	1,165.45	68%	793.94	681.91
24			20	1,485.95	1,188.76	67%	793.62	676.20
25			21	1,515.67	1,212.53	65%	793.31	670.54
26			22	1,545.98	1,236.78	64%	792.99	664.93
27			23	1,576.90	1,261.52	63%	792.67	659.36
28			24	1,608.44	1,286.75	62%	792.36	653.84
29			25	1,640.61	1,312.48	60%	792.04	648.37
30			26	1,673.42	1,338.73	59%	791.72	642.94
31			27	1,706.89	1,365.51	58%	791.40	637.56
32			28	1,741.02	1,392.82	57%	791.09	632.22
33			29	1,775.84	1,420.68	56%	790.77	626.93
34			30	1,811.36	1,449.09	55%	790.46	621.68
35			31	1,847.59	1,478.07	53%	790.14	616.48
36			32	1,884.54	1,507.63	52%	789.82	611.32
37			33	1,922.23	1,537.79	51%	789.51	606.20
38			34	1,960.68	1,568.54	50%	789.19	601.12
39			35	1,999.89	1,599.91	49%	788.88	596.09
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