ABCDEFGHIJKLMNOPQRSTUVWX
1
Variable Values (change these to try different scenarios)Calculated Values (do not change these)
2
Product InputsUA InputsRevenue (60)$200,848.58
3
ARPDAU$0.50CPI (LOW)$5.00Installs (60)69,501
4
D1 Retention30.00%CPI (HIGH)$7.00ARPU (60)$2.89
5
D3 Retention20.00%eCPI (LOW)$1.25LTV (60)$4.53
6
D7 Retention17.00%eCPI (HIGH)$3.50
7
D30 Retention10.00%Organic:paid (HIGH)3.00Revenue (180)$1,006,876.88
8
D90 Retention9.00%Organic:paid (LOW)1.00Installs (180)165,095
9
D180 Retention6.00%Monthly Ad SpendARPU (180)$6.10
10
D360 Retention2.00%1$50,000.00LTV (180)$9.29
11
2$50,000.00
12
3$50,000.00Revenue (1yr)$2,544,106.79
13
4$50,000.00Installs (1yr)261,696
14
5$50,000.00ARPU (1yr)$9.72
15
6$50,000.00LTV (1yr)$12.93
16
7$50,000.00
17
8$50,000.00Platform Fees (15/30%)$613,232
18
9$50,000.00Total UA Spend (1yr)$600,000
19
10$50,000.00Net Profit (1yr)$1,330,874.75
20
11$50,000.00
21
12$50,000.00
22
23
24
INSTRUCTIONS
25
Make a copy of this sheet and populate the yellow boxes with estimates for your game project
26
This worksheet is provided as is with no warranties. Use at your own risk
27
Provided by Beamable for educational purposes only
28
Google sheets can be extremely slow calculating some of the data. Keep an eye on the bar in the top right after you change numbers
29
30
Definitions
31
ARPDAUAverage Revenue Per Daily Active User
32
D1-D360How many of your players come back at each of those day windows
33
CPICost per install to acquire a use via paid advertising
34
Organic:paidThe ratio of free/organic sign ups to paid signups
35
Monthly SpendHow much your team is spending on user acquisition per month
36
eCPIThe effective cost per install when you add the free players acquires to the paid players
37
Revenue (60,180, 1yr) Gross revenue of the game before any expenses subtracted
38
InstallsHow many players install your game
39
ARPUAverage Revenue Per User (how much the average player spends)
40
LTV The Life Time Value of a player over the defined period (avg amount a player will spend the entire time they play your game). LTV usually refers to *all* the revenue you'll ever collect from a player, but here we've bracketed it inside a number of days to help you understand progression to the utlimate value.
41
Platform FeesApp stores take 15% of your first $1M in revenue and then 30% on everything over that, taken out before they send you your earnings
42
Total UA SpendThe total user acquisition spend over 12 months
43
Net profit The amount of revenue you keep to pay expenses for the game and reinvest in your product after subtracting out the UA and Platform fees
44
45
1/1/2021Organic:paid (HIGH)3.00
46
3/1/2021Organic:paid (60 day)2.00
47
7/1/2021Organic:paid (180 day)1.50
48
12/31/2021Organic:paid (LOW)1.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