How to calculate LTV of a mobile App - easily and quickly

Step 1

Start with rough data

Day 1 Retention 32%

Day 30 Retention 11%

Step 2

Add diagram

Step 3

Add trendline

Step 4

Add formula and adjust for “potential”

Use resulting formula for calculating each day from day 1 to day 180 (for instance). Of course you can prolong the time period you are looking at 

Then multiply ARPDAU x number of days = LTV (Life time value)