Website / Mobile App Financial Model with Recurring Revenue (5 Tiers + Free User Pool)

This is a highly robust financial model that will be useful for any business that has traffic and converts that traffic to users. Basically, anyone with an app or a website and a recurring revenue model. Also, check out this SaaS Rolling Revenue Forecast.

The template will be sent to you after purchase via your PayPal/purchasing e-mail. Recently updated with a dynamic start month for monthly traffic. Let me know if you want it sent to a different e-mail (my e-mail is at the top of this site). This is included in the SaaS financial model template bundle.

Updated logic for cash distributions, NPV, investor funding, and added some formatting to the summary tab.

Recent Update:

About the model:

I have tried to lay out everything so the assumptions and summaries are as clear as possible. There is functionality to include an 'investor' side and sponsor/owner side as well as showing scenarios without investors and just financing with a bank.

The model will support up to 5 pricing tiers as well as a pool of free users that all grow/churn per assumptions.

One of the biggest things I have been working to improve in the recent excel templates is how well you can see summaries of the data. My strongest skill is structuring all the data nicely and accurately with a lot of functionality. This is me trying to combine that along with the useful visuals that investors/managers would want to be able to review.


One of the most important and valuable areas in this model is the sensitivity adjustments. Once you build the 'base' assumptions for how much your traffic is planned to grow at per month, the conversion of that traffic, the pricing levels, and churn, you can pick if they are going to be better or excellent compared to the base or bad/worst compared to base just with the click of a drop-down menu.

Each level of change is 15% up or down and obviously churn is the opposite as it gets better the churn % would lower whereas the other metrics would increase when the better/excellent option is chosen.

The usefulness of sensitivity analysis is that you can show what you think will happen and then have an overall control that says ok if things are 30% worse than what you think, how do the numbers play out? or vice versa.

You get a ton of visuals in this. I have done metrics for CaC, CaC payback, LTV, running cash balance, leveraged cash position, revenues, expenses, MRR Vs. Users, and a whole slew of others.

On the 'Distribution' tab you will see a breakout of investor cash flows compared to sponsor cash flows as well as the IRR. Below those, you will also see the cash flow of a leveraged scenario and its IRR.

The distribution tab also shows DCF / NPV of the cash flows for each. A visual is included within this tab.

With the purchase, you will get a blank version and a version with some numbers in it just to see how values flow.

You will be able to pick the month of exit if not in the final month of the 5th year as well as the run rate multiple of the business at that time of exit.

You can pick the month each revenue stream starts as well as each fixed / variable cost.

Also, check out this model that is dedicated just for the mobile app business.

or this freemium financial model:

Screenshots of this template:
website recurring revenue model global assumptions

saas revenue assumptions

saas opex

saas cogs

saas startup costs

saas revenue visual

saas kpi visual

saas DCF Analysis

saas executive summary

saas pro forma 1

saas pro forma 2

saas pro forma 3

saas pro forma 4

saas pro forma 4

saas monthly KPIs