LTV Spreedsheet Example

	A	B	C	D	E	F	G	H	I	J	L	M	O	P	Q	R	T	U
1											Retention Function Calc (y=a*x^b)		Integral on Retention Function				180 Day LTV Calculation
2	Day	Retention D1 (%)	Retention D7 (%)	Retention D30 (%)	DAU	Revenue IAP (Proceed) (USD)	Revenue Ad (USD)	Revenue Ad CN (USD)	Revenue (USD)	ARPDAU (USD)	a	b	Days	Retention func.	Integral to date	180d Integral	User days (to 180d)	2.303024073

3	1	25.69	8.17	1.82	943	4.04	8.95	0.65	13.64	0.0145	28.52027602	-0.7679738206	0			2.303024073	Avg. ARPDAU	$0.010
4	2	21.79	8.91	0.82	707	0.00	5.91	0.14	6.05	0.0086	28.7806795	-0.9367566396	1	34.50	34.50		LTV	$0.022
5	3	39.34	4.48	2.27	734	0.00	7.43	0.13	7.56	0.0103	33.75344958	-0.8538454012	2	19.47299161	53.97
6	4	39.67	10.36	1.59	761	0.00	5.92	0.02	5.94	0.0078	45.677948	-0.9318244327	3	13.11031024	67.08
7	5	34.66	6.19	0.33	807	0.00	7.47	0.00	7.47	0.0093	45.2372074	-1.342015468	4	9.901590153	76.98
8	6	41.95	7.58	1.71	852	0.00	8.47	0.25	8.72	0.0102	43.39843769	-0.9374760646	5	7.964265643	84.95
9	7	37.22	7.99	0.61	1003	0.21	10.53	0.29	11.03	0.0110	46.86538968	-1.185893047	6	6.666305894	91.61
10	8	32.03	7.50	0.58	907	0.11	9.02	0.33	9.46	0.0104	40.67256686	-1.155730019	7	5.735382896	97.35
11	9	26.09	5.46	1.62	748	0.00	7.54	0.12	7.66	0.0102	26.2821598	-0.8163748456	8	5.034741939	102.38
12	10	36.07	5.43	0.00	732	0.00	5.80	0.00	5.80	0.0079	167.8260463	-3.609750439	9	4.488131057	106.87
13	11	40.13	5.68	1.03	731	0.00	5.02	0.02	5.04	0.0069	41.75675599	-1.072907085	10	4.049654816	110.92
14	12	32.75	9.74	1.98	752	0.00	6.68	0.03	6.71	0.0089	36.60275627	-0.813922235	11	3.690025849	114.61
15	13	42.93	5.38	0.81	845	0.28	6.78	0.10	7.16	0.0085	45.36333027	-1.161856941	12	3.389670684	118.00
16	14	33.63	8.50	2.05	955	0.00	8.74	0.20	8.94	0.0094	35.84549365	-0.8162037269	13	3.135007948	121.14
17	15	29.24	6.32	1.40	921	0.00	7.11	0.36	7.47	0.0081	31.00508716	-0.8877182237	14	2.916316708	124.05
18	16	24.92	4.92	0.33	690	0.64	8.70	0.01	9.35	0.0135	31.71988641	-1.247499664	15	2.726454777	126.78
19	17	31.21	7.64	1.59	723	0.00	7.13	0.09	7.22	0.0100	33.93871324	-0.8669731881	16	2.560056112	129.34
20	18	38.02	8.77	0.90	756	0.00	8.62	0.06	8.68	0.0115	46.0311419	-1.081681233	17	2.41301056	131.75
21	19	35.14	10.61	1.55	769	0.00	8.81	0.00	9.33	0.0121	41.51032804	-0.9011292181	18	2.282116439	134.04
22	20	45.23	8.52	0.00	900	0.00	8.29	0.52	8.54	0.0095	232.6210483	-3.666355224	19	2.164842466	136.20
23	21	36.59	7.64	0.00	958	0.00	6.23	0.25	6.29	0.0066	187.2110597	-3.604542756	20	2.059160865	138.26
24	22	32.56	6.23	0.70	940	0.11	7.00	0.06	7.23	0.0077	37.97548171	-1.113693008	21	1.963427991	140.22
25	23	30.79	6.37	1.58	761	0.00	6.38	0.12	6.43	0.0084	31.88615289	-0.8696853776	22	1.876297404	142.10
26	24	37.06	7.29	2.33	725	0.10	5.60	0.05	5.77	0.0080	36.60970844	-0.8146517215	23	1.796655533	143.90
27	25	35.80	5.38	0.99	700	0.00	7.53	0.07	7.56	0.0108	37.43372802	-1.05049887	24	1.723573374	145.62
28	26	37.08	8.04	1.98	756	0.10	6.99	0.00	7.66	0.0101	38.66402306	-0.8573092831	25	1.656269738	147.28
29	27	39.00	8.94	1.80	857	0.00	7.20	0.03	7.35	0.0086	42.29970002	-0.896270751	26	1.594082946	148.87
30	28	36.96	5.65	2.38	972	0.28	9.62	0.57	9.90	0.0102	33.86232881	-0.815079396	27	1.536448796	150.41
31	29	33.23	7.30	1.42	914	0.11	10.27	0.15	10.38	0.0114	36.05696569	-0.9188735917	28	1.482883235	151.89
32	30	28.20	8.63	0.00	702	0.12	5.54	0.00	5.66	0.0081	154.141455	-3.521415259	29	1.432968599	153.32
33													30	1.386342597	154.71
34	Ave	34.50	7.32	1.21	817	0.00	8.00	0.00	7.87	0.0096	38.29661666	-0.9757424011	31	1.342689422	156.05
35	Sum					6.10	225.28	4.62	236.00				32	1.301732517	157.35
36													33	1.263228658	158.62
37													34	1.226963072	159.84
38													35	1.192745389	161.04
39													36	1.160406275	162.20
40													37	1.129794593	163.33
41													38	1.100775026	164.43
42													39	1.073226055	165.50
43													40	1.047038244	166.55
44													41	1.022112771	167.57
45													42	0.9983601723	168.57
46													43	0.9756992577	169.54
47													44	0.9540561752	170.50
48													45	0.9333635997	171.43
49													46	0.9135600264	172.34
50													47	0.8945891546	173.24
51													48	0.8763993479	174.12
52													49	0.8589431609	174.97
53													50	0.8421769215	175.82
54													51	0.826060363	176.64
55													52	0.8105562982	177.45
56													53	0.79563033	178.25
57													54	0.7812505942	179.03
58													55	0.7673875308	179.80
59													56	0.7540136786	180.55
60													57	0.7411034923	181.29
61													58	0.7286331783	182.02
62													59	0.7165805462	182.74
63													60	0.7049248766	183.44
64													61	0.6936468008	184.14
65													62	0.6827281921	184.82
66													63	0.6721520684	185.49
67													64	0.6619025022	186.15
68													65	0.6519645409	186.80
69													66	0.6423241324	187.45
70													67	0.6329680588	188.08
71													68	0.6238838751	188.70
72													69	0.6150598535	189.32
73													70	0.6064849325	189.93
74													71	0.5981486698	190.52
75													72	0.5900412003	191.11
76													73	0.5821531959	191.70
77													74	0.5744758298	192.27
78													75	0.5670007432	192.84
79													76	0.5597200148	193.40
80													77	0.5526261322	193.95
81													78	0.545711966	194.50
82													79	0.5389707456	195.03
83													80	0.5323960371	195.57
84													81	0.5259817222	196.09
85													82	0.5197219795	196.61
86													83	0.5136112665	197.13
87													84	0.5076443028	197.63
88													85	0.5018160553	198.14
89													86	0.4961217235	198.63
90													87	0.4905567264	199.12
91													88	0.4851166897	199.61
92													89	0.4797974348	200.09
93													90	0.4745949678	200.56
94													91	0.469505469	201.03
95													92	0.4645252841	201.50
96													93	0.4596509148	201.96
97													94	0.4548790109	202.41
98													95	0.4502063623	202.86
99													96	0.4456298922	203.31
100													97	0.4411466495	203.75