Mobile App Financial Model
Comprehensive Mobile App Financial Model Template. Professional feasibility study for startups. Nice design, intuitive reporting. All in Excel!
Do you have a startup and planning to launch a new mobile application but you’re not sure whether your business model is feasible or not? Maybe you want to perform some simulations in order to find out the necessary investment amount, number of developers to hire or minimum necessary downloads to achieve the target breakeven point. Whatever your needs, you will need to crunch some numbers and prepare a financial feasibility study to be able to foresee your business results. This Excel Mobile App Financial Model Template has been built to make your life easier!
We have built this Excel Template following the latest industry practices such as different revenue streams, expense types, commissions, retention rate calculations, breakeven analysis and much more.
No new software, no installation. Everything in Excel. Just open this Mobile App Financial Model and start building your feasibility study!
MOBILE APP FINANCIAL MODEL TEMPLATE FEATURES
Basically this financial plan consists of 3 main sections:
- Revenue Model Inputs
- Cost Inputs
- Report Outputs
The flow is: Make inputs for your download projections and different revenue streams > Input your variable and fixed expenses > Analyze results at report outputs. This is a three step cycle and according to the results, you can go back to the input sections and play with your projections until you find a reasonable point for your project.
This is the Navigation Panel. You make your revenue related inputs to blue sections and cost related inputs to red regions.
After completing the inputs, you will see the outcomes in the green reports sections.
This is the main Settings section under Dashboard.
From the Model Config box (on the right side) you can configure your model:
- Projection Years: You can choose to make your projections from 1 to 5 years. This Financial Model will update all reports according to your selection.
- Start Date: Input the month-year for operations to start. The tool will update all reports and input tables accordingly.
- Currency: This setting does not affect the formatting of values but several notes will be updated according to this selection.
- Instructions: Here you can show/hide all instructions boxes in the model.
Left side is the Model Variables section. Here you input the values you will use all through the model:
- There are 4 different variable tables: Apps, Platforms, In-App Items and Subscriptions. You input your names here and they will appear in the dropdown selections at Input Sections.
- This is important to ensure the same texts are used everywhere in the model to prevent data discrepancies
- Attention: If you decide to change values here later on, make sure you update your existing selections.
1. REVENUE MODEL INPUTS
DOWNLOAD PROJECTIONS & PAY PER DOWNLOAD PRICES
Under this section you will input the estimated download units for your apps per platform based:
- You select your Product and Platform from the left side dropdown selectors and input monthly estimations. (If you want to add new items in these dropdowns, you can update the Settings tables at Dashboard)
- Then you input monthly download estimations and prices in the first 2 tables. If you are not planning to charge users for downloads, you can leave the prices table empty. (Pay-Per-Download Revenue will be zero)
- Attention: White areas are where you make your inputs or selections. Gray cells are calculations and you should not change it manually.
- Downloads Revenue is a result of simple multiplication of units and prices per month.
RETENTION & ACTIVE USERS CALCULATION
This is where we calculate the active users according to the download units we inputted in the previous section:
- Retention Rate is the metric that shows the percentage of your users who still use your app 1 month after download. For example, a retention rate of 80% means that if 100 people downloaded your app, 80 people are using your app the next month.
- According to your inputs on the left table, your Cumulative Active Users will be calculated below.
If you want to micro-manage this Retention Rate and Active Users section, you can also change the calculated monthly Engaging User percentages. (You will need to overwrite the formulas)
This is where we calculate our Ads Revenue. If you don’t plan to place ads in your apps, you can skip this section. Like the previous sections, you select your Product and Platform from the left side dropdown selectors and fill Ad Parameters.
How is Ads Revenue Calculated?
- According to your inputs in the Parameters table on the left, monthly add revenue per user is found.
- Sessions per Month for a Typical User: How many times is an active user opening your app?
- Average Minutes per Session: When a user opens your app, for how long do they use it?
- Ad Impressions Per Minute: How often do you plan to show ads in your app?
- Average CPM (Cost per 1000 Impressions): This is how much you are going to earn per thousand impressions. You can use data from platform statistics or from your past info.
- Then, monthly Ad Revenue per User will be multiplied with Monthly Active Users which is calculated in the Userbase section.
- This will give us the Ads Revenue in the currency you input in the Dashboard.
Similar to the Pay-Per-Download inputs, here we sell in-app items. If you are not planning to offer any in-app purchases, you can skip this section:
- You input monthly selling estimations and prices in the first 2 tables.
- In-App Items Revenue will be calculated via simple multiplication of units and prices per month.
If you plan to offer subscriptions, here you can input projected paying subscribers and related revenue streams. If you are not planning to have subscription revenue, you can skip this section.
- You select your Product, Platform and Subscription Name and input monthly paying subscribers and subscription prices in the first 2 tables.
- Subscription Revenue is a result of simple multiplication of subscribers and prices per month.
2. COST INPUTS
COMMISSION RATES & VARIABLE COSTS
Here you define the commission rates for each platform. This is where you lose a certain ratio of all your sales:
- Some platforms do not charge commissions for Ad Revenue, so we separated that field. All other revenue models (Pay-per-download, In-app purchases, Subscriptions and Other Revenue) will be subject to the All Sales Commission rate on the left.
- Commission amounts will be calculated automatically via a simple multiplication of revenue amount and commission percentages.
Variable Costs are a type of costs that changes with the amount of activity of your app(s). Besides commissions, we have included 3 different Variable Cost Tables:
- Costs Per Download: These amounts will be directly multiplied with download units.
- Per Active User: These amounts will be directly multiplied with Cumulative Active Users of that month.
- Per Paying Subscriber: These amounts will be directly multiplied with the Number of Paying Subscribers (which is inputted in the Subscriptions section)
SALARIES & FIXED COSTS
Fixed Costs are a type of costs that does NOT change with the amount of app activities. These are paid regardless of any revenue, downloads, subscribers etc.
We have separated Fixed Costs in two different tables:
- Salaries: Input employees and monthly projected salaries. You can start some of them not from the beginning but later instead.
- Other Fixed Costs: All OPEX goes here. Rent, utility bills, travel expenses, hosting etc.
Startup Costs are the expenses that are prior to the going live date of your startup budget:
- These costs will be recorded at 1 month prior to the Start Date in Output Report.
- Startup Costs are especially important for Breakeven Analysis in order to find out when will you be able to pay-out the initial expenses and start making real-profits.
- For the sake of simplicity, we ignored amortization and depreciation in the Breakeven Analysis. So, if you have a significant amount of fixed assets and want to include depreciation, just put them as revenue in Other Revenue section (or you can deduct them from monthly expenses)
3. REPORT OUTPUTS
In this section three financial statements are set-up:
- Income Statement (P&L)
- Balance Sheet
- Cash Flow Statement
At the Income Statement, most of the fields consists of automatic calculations according to your entries from Input Sections. You will just need to input depreciation, amortization, taxes and interest in order to reach Net Income.
For Balance Sheet and Cash Flow Statements, all formulas are set up and ready to be used. (You will need to fill-out white areas)
Break-even analysis is one of the most critical reports in our model:
- This analysis shows us when we pay back (cover) all startup costs and start making profits.
- Most startups, start with a negative balance. What matters is how quickly you pay this back.
- If the break-even point is too far from what you expected, then you should increase revenues or decrease variable costs (like salaries for example).
- This is a pivot report, so that you can change between Monthly / Quarterly / Yearly analysis by changing pivot fields.
There are several output reports in the model which makes it clear to see the situation from different aspects:
- PROFITS (EBITDA) – TREND REPORT
- APP DOWNLOADS BREAKDOWN
- REVENUE DETAILS REPORT
- PLATFORM COMMISSIONS REPORT
- SALARIES REPORT
DATA SOURCE SECTION
We tried so hard to develop this template with an innovative approach. We thought managing all data and outputs from one place would be perfect so we created a Data Source section:
- In this section, we consolidate all tables from input sections of the model.
- Then, the tool uses it for output reporting.
- Even though we do not recommend manual modification to this table, you can make changes if you want.
All the reports are fed from this data source and you can change the parameters of the pivot reports easily.
EXCEL MOBILE APP FINANCIAL MODEL TEMPLATE – FEATURES SUMMARY
- Unique Excel Template to perform financial projections for mobile app
- Works both on Mac and Windows
- No installation needed, ready to use.
- User friendly and sleek design.
- Different revenue models matching the latest industry standards
- Innovative reporting system
- Financial Statements
- On Sheet Instructions
- Compatible with Excel 2010 and later versions