MFC Lifetime IRR of a Mobile Game/App_Public

	A	B	C	D	F	G
1		Lifetime IRR of a mobile game/app

2
3
4	🏆 Objective	This calculator analyzes all user acquisition spend and monetization revenue cashflows acrosss the lifetime of a game or app and expresses them as an internal rate of return (IRR)
5
6	🤯 Purpose	Use it to understand the total return on investment of your ad spend over the entire lifecycle of the game or app since launch expressed as an annualized rate
7
8	🤷‍♀️ Who's it for?	CFOs, Founders and UA Leads looking to understand the aggregate effectiveness and financial returns of their UA spend
9
10
11	Date	Cash In	Cash Out	Net Cashflow	Last row for	XIRR - ANNUALIZED RATE
12	(DD/MM/YEAR)	IAP/Ads/Other Revenue	UA Spend	(for calculation)	calculation	65.97%
13	01/01/2024	$2,000.00	$10,000.00	-$8,000.00
14	01/02/2024	$4,000.00	$10,000.00	-$6,000.00	24
15	01/03/2024	$6,000.00	$10,000.00	-$4,000.00	🛠️ How to use: 1. Make a copy of this spreadsheet 📑 2. Input all the Monetization revenues (with dates) from your records in Column B Cash In ✍️ 3. Input all the User Acquisition spend you made for (with dates) in Column C Cash Out ✍️ 4. Indicate the last row to include in the calculation in the Cell F14 🧮 5. If you want to put a Discounted Cash Flow (DCF) valuation of the value of your residual cohorts enter the final repayment amount with today's date in Column B Cash IN 💰 6. XIRR - Annual Rate represents the annualised ROI your UA spend has achieved 💵
16	01/04/2024	$8,000.00	$10,000.00	-$2,000.00
17	01/05/2024	$10,000.00	$10,000.00	$0.00
18	01/06/2024	$11,000.00	$10,000.00	$1,000.00
19	01/07/2024	$12,000.00	$10,000.00	$2,000.00
20	01/08/2024	$13,000.00	$10,000.00	$3,000.00
21	01/09/2024	$14,000.00	$10,000.00	$4,000.00
22	01/10/2024	$15,000.00	$10,000.00	$5,000.00
23	01/11/2024	$16,000.00	$10,000.00	$6,000.00
24	01/12/2024	$17,000.00	$10,000.00	$7,000.00
25				$0.00
26				$0.00
27				$0.00
28				$0.00
29				$0.00
30				$0.00
31				$0.00	📽️ Video tutorial coming soon...
32				$0.00	Read the blog post
33				$0.00	Read the blog post
34
35					If you need more rows simply add them below Row 33 👆
36					(Don't forget to update the sum formula in D34 and the last row for calculation in F14)
37
38
39
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