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.)
If you’re interested in subscription revenue modeling, you may also find these resources to be useful:
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.