skip to Main Content

Mobile App Financial Model

4.56 (9 reviews)

Comprehensive Mobile App Financial Model Template. Easy to use feasibility study for startups. Professional design, intuitive reporting. All in Excel!


Learn more about License Types

Someka 30 days refund icon


Someka one time payment Icon


Someka direct download icon


Payments are processed by our partner company


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.

Mobile App Financial Model Excel Template - Someka TextSS01

No new software, no installation. Everything in Excel. Just open this Mobile App Financial Model and start building your feasibility study!


Basically this financial plan consists of 3 main sections:

  1. Revenue Model Inputs
  2. Cost Inputs
  3. 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.


Dashboard - Someka TextSS02

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.

Settings - Someka TextSS03

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.



Download Projections - Someka TextSS04

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-ActiveUsers Calculation - Someka TextSS05

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.

Mobile App Financial Model Excel Template - Someka TextSS06

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)


ADS Income Model - Someka TextSS07

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.


In App Purchases - Someka TextSS08

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.


Subscriptions - Someka TextSS09

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.



Mobile App Financial Model Excel Template - Someka TextSS10

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.

Mobile App Financial Model Excel Template - Someka TextSS11

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)


Mobile App Financial Model Excel Template - Someka TextSS12

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.

Mobile App Financial Model Excel Template - Someka TextSS13


Mobile App Financial Model Excel Template - Someka TextSS14

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)



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)

Mobile App Financial Model Excel Template - Someka TextSS15

Mobile App Financial Model Excel Template - Someka TextSS16

Mobile App Financial Model Excel Template - Someka TextSS17


Mobile App Financial Model Excel Template - Someka TextSS01

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 easy to see the situation from different aspects:



Mobile App Financial Model Excel Template - Someka TextSS18

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.


  • 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 2007 and later versions

This excel template is ready-to-use and provided as is. If you need customization on your reports or more complex templates, please refer to our custom services.


9 reviews for Mobile App Financial Model

  1. Johann Mushi


  2. Josh Harrison

    Too complicate to customize, takes too long.

  3. a.barrie

    I am engineer alum and need to develop financial model because retention model needs some re-working but this one clarify every piece of work.

  4. A Saher

    It is amazing. wish it had “10 years forecast”

    • Someka

      Thanks for your comment! You can only choose from 1 to 5. Industry standard for financial forecasting is 2 years and max 5 for long term plans. 10 years is too long and nearly impossible to guess slightest parameter.

  5. sakkuralma

    Good source of data for mobile app uptake curves building out a financial model.

  6. Denise juma

    flipping awesome what i have been looking for. tha k u so much

  7. Ryan Clines

    Simply WOW! marvellous detailed info and wonderful features are given in this template. Very well done.

  8. Giu R.

    Well, usefull definately. ( I would have found it more esay and logical to give the expected total downloads goals per year, and the template would calcluate the increase inbetween, instead of me giving evey month manually in a projection of 3 or 4 years) But I am super happy I found it

    • Someka

      Thanks a lot for your comments Giu!
      As we also discussed with you, both methodology has pros and cons. We have chosen this for being a more generic approach for most people.
      Thanks again and glat that was useful for you.

  9. Nick Anderson

    Very powerful. Good option for a forecasting.

Leave a customer review

Your email address will not be published. Required fields are marked *

Microsoft Excel® is registered trademark of Microsoft Corporation. Someka Excel Solutions is an active member of Microsoft Partner Network (MPN).

Someka SSL Certificate Icon

Someka Excel Solutions Ltd. Co.
© 2015-2019 All rights reserved.

Someka Bilişim Teknolojileri Ltd. Şti.   |   Address: Mansuroğlu Mah. 286/3 Sk. No:14B Bayraklı Tower 35030 BAYRAKLI / İZMİR   |   Tel: +90 (0232) 700 1883   |