The Subscription Model Template contains the following Excel sheets and sections:
- Subscription Cash Flow Model: The spreadsheet forecasts Customer Growth, Revenue and Costs. It contains monthly estimates of Churn, Retention and Cost per Acquisition.
- Basic and Premium Users: The model splits users into two subscription plans with separate revenue, cost and churn assumptions.
- Customer Lifetime Value Calculator: The template estimates the Customer Lifetime Value using Retention, Churn, Monthly Revenue and Cost assumptions.
- The Return on Investment: Estimates of the Exit / Terminal Value and Analysis of Equity Returns.
Click on product images for screenshots of the template.