The company develops a mobile application through in-app purchase monetization. Using the data from the table (there are two sheets there), calculate the following indicators:
- [ ] How much does the company earn per user in 3 months from the moment of app installation?
- [ ] How much does the company earn per user in 1 year from the moment of app installation?
- [ ] How much should a company pay on average to attract a new user? Taking into account the payback period of 1 year.
- [ ] How much does the company earn per year from users who started using the app between weeks 17 and 20?
Important: data forecasting is necessary for accurate results.
Please describe step-by-step the logic of calculations and provide all calculations using the Google Sheets link.
- Data explainer
- Weeks Since Install represents the weeks of user engagement with the product.
- 0 denotes the week of installation.
- 1 signifies the first week of the user's engagement after the installation week.
