Jun 30, 2017

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.




Pricing
*Upon purchase, model will be sent to your e-mail. *Pricing recently changed.

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.

Sensitivity

One of the most important and valuable area 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 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.

No comments:

Post a Comment