ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
2
3
4
5
6
7
y = .05 x
8
9
10
11
12
13
Day1234567
14
ARPDAU$0.05$0.05$0.05$0.05$0.05$0.05$0.05
15
Cumulative ARPDAU$0.05$0.10$0.15$0.20$0.25$0.30$0.35
16
Cohort1$0.05$0.05$0.05$0.05$0.05$0.05$0.05
17
2$0.05$0.05$0.05$0.05$0.05$0.05
18
3$0.05$0.05$0.05$0.05$0.05
19
4$0.05$0.05$0.05$0.05
20
5$0.05$0.05$0.05
21
6$0.05$0.05
22
7$0.05
23
24
Total$0.35$0.30$0.25$0.20$0.15$0.10$0.05
25
Blended Return$1.40
26
27
Daily New Users (Installs)5000500050005000500050005000
28
Average CPI$3$3$3$3$3$3$3
29
30
Cohort Recoup (Absolute $)$250.00$500.00$750.00$1,000.00$1,250.00$1,500.00$1,750.00
31
Cohort Expense (CPI * Installs)$15,000.00$15,000.00$15,000.00$15,000.00$15,000.00$15,000.00$15,000.00
32
33
Total Recoup ($)$7,000.00
Blended Return * DNU:
$7,000.00
34
Total Expense$105,000.00
(this is $4.40 x 5000. Note that DNU would need to be weighted per cohort if
35
Timeline Recoup Percentage6.67%
every cohort wasn't the same size)
36
37
38
39
40
41
42
43
44
45
46
y = .5 ln(x) + .02
47
48
49
50
51
52
Day1234567
53
ARPDAU$0.02$0.35$0.20$0.14$0.11$0.09$0.08
54
Cumulative ARPDAU$0.02$0.37$0.57$0.71$0.82$0.92$0.99
55
Cohort1$0.02$0.35$0.20$0.14$0.11$0.09$0.08
56
2$0.02$0.35$0.20$0.14$0.11$0.09
57
3$0.02$0.35$0.20$0.14$0.11
58
4$0.02$0.35$0.20$0.14
59
5$0.02$0.35$0.20
60
6$0.02$0.35
61
7$0.02
62
63
Total$0.14$2.08$1.01$0.58$0.33$0.18$0.08
64
Blended Return$4.40
65
66
Daily New Users (Installs)5000500050005000500050005000
67
Average CPI$3
68
69
Cohort Recoup (Absolute $)$100.00$1,832.87$2,846.53$3,565.74$4,123.59$4,579.40$4,964.78
70
Cohort Expense (CPI * Installs)$15,000.00$15,000.00$15,000.00$15,000.00$15,000.00$15,000.00$15,000.00
71
72
Total Recoup ($)$22,012.90
Blended Return * DNU:
$22,012.90
73
Total Expense$105,000.00
(this is $4.40 x 5000. Note that DNU would need to be weighted per cohort if
74
Timeline Recoup Percentage20.96%
every cohort wasn't the same size)
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