Mobile App / Website - 5 Year Recurring Revenue Excel Model Template

A financial forecasting excel model template for apps or websites that have recurring paid subscribers.

by Jason Varner
Smarthelping.com - Freelancer - I make my living working in Excel and G-sheets.

53 views|Start the discussion!|Bookmark

Description
You can think of this as a bottom up model. A vast amount of assumptions are available so that you can build all kinds of scenarios. On top of that flexibility, you can alter your scenario with sensitivity drop-downs that apply a % change to all traffic, conversion, and pricing variables individually. This allows you to set a base case in the assumptions and then alter that base case up or down for each key revenue driver individually.

The flow of logic is that you forecast a given amount of traffic. You can then forecast a conversion % of that traffic to a free user pool. From the free pool, you then forecast a conversion of that pool to a paid pool. The free/paid pools both have their own growth/churn rates therein.

If you don't have a free pool, you would simply put 100% conversion to paid from free.

You can choose up to 5 pricing tiers and the % of each newly added paid subscriber to falls into each tier. You can also define a date when you want a given pricing tier to activate.

On the expense side, there is logic to start a wide array of expenses in any month and you can adjust those expenses on a yearly basis.

The idea on this financial template was to give the user plenty of variables to play with and test all kinds of structures that they may be looking to visualize.

Many visuals are included as well as high-level summaries, a monthly and annual P&L / cash flow that is granular enough to see how each assumption effects the overall performance of the case.

A video for the Recurring Revenue Excel Model Template is also included.

This business tool includes
1 Excel template and 1 tutorial video