You can use the following subscription revenue model to create one for your own website. The model is intended to work for any type of subscription revenue-based website, including software-as-a-service (SaaS), premium/freemium/paid content, paid membership, etc. The spreadsheet allows you to input your assumption metrics, including unique visitors, conversion rate, billthrough rate, ARPU (average revenue per user), and retention rate/cancellation rate. If you change an assumption by editing the relevant cell, the model updates instantly. Feel free to download the spreadsheet, edit it, and use it for your own business. (Though note, you may not republish it.)
- Click here to access the model spreadsheet (hosted by Google Docs).
- Right click to download the model spreadsheet in MS Excel (.xslx) format.
More Subscription Revenue Modeling Resources
If you’re interested in subscription revenue modeling, you may also find these resources to be useful:
- Blog Tutorial Category: Membership Sites: Browse this section of the MonetizePros blog archives to access tutorials for paid content, membership sites, SaaS, e-products, etc. The first tutorial in the series is How to Sell Paid Memberships: Building a Product.