Calculate Player LTV of Your Game/App in a Spreadsheet

You made a great game/app and it has started giving you revenue. You are able to consider buying users, and it is very important that to get the right player lifetime value (LTV) first so you can have an idea on how much cost per install (CPI) you can afford. This article will explain where to get the raw data and how to calculate the LTV in a spreadsheet.

TLDR; Put your numbers and calculate the LTV in this spreadsheet.