Recent Update: Added key metrics to the monthly detail and annual averages: Average monthly recurring revenue per user, Average one-time revenue per user, Average LTV per user, and Average LTV to CaC ratio as well as visuals for all.
Updates: Changed tax calculation to be a manual input per year and added valuation in year 5 as part of the DCF analysis and executive summary.
*Latest updates: Executive summary added, updates to cash flow, and updates to the per tier sections on the annual summary.
*Latest updates: Added flexibility in picking the start month of each revenue stream and dynamic assumptions about financing as well as adding YoY growth %.
*Latest updates: Changed expenses so they are a dollar amount entry instead of a % and logic for one-time revenue upon sign-up has been added.
Added function for 4 pricing tiers with all separate assumptions on sub growth/churn/revenue per account. Updated charts/visuals.
This is a very clear, cut, and dry way to see recurring revenue and the associated costs you might have to attain such revenue. The usefulness of this model is to help you set targets and also plan out your costs as well as how much revenue you will require in order to make a given profit/cash flow position over time.
Dynamic annual churn rates can be adjusted as well as subscriber growth rates and average revenue per account per month.
A financing schedule has also been implemented to help visualize the impact debt will have as well as the running total of your bank based on operating cash flows.
An annual summary will populate dynamically on a separate tab.
Run rate valuation included.
CAC and CAC months to payback included.
Charts and graphs to highlight key details.