Google Sheets + Excel Template
Spreadsheet Only
You can estimate ad revenue based on the number of active users, and the amount of sessions they start on a monthly basis.
We factor in avg time per session, avg session length and avg ad impressions per session.
Finally, we multiply that by the average CPM (cost per mille).
For in-app purchases, we use an average spend per active user to estimate revenue.
The model also accounts for the App Store and Google Play fees, and the payout delay for the revenue (usually 1-2 months).
Finally, you can also estimate transactions that happen outside of Google and Apple's ecosystems.
Using a conversion rate from active user to subscriber, you can estimate the MRR (subscription revenue) for your mobile app.
You will be able to estimate the percentage of users in monthly subscriptions vs annual subscriptions, as well as the App Store fees for each one of them.
Custom dashboards to track monthly active users and revenue distribution.
Color-coded sheets that cover the basic expense and revenue categories for any financial model.
Estimate equity and convertible note rounds of funding, from Pre-Seed to Series C.
A complete knowledge base, and phone support available from our financial analysts.
