As a bootstrapped SaaS founder, you probably have a free tier. But do you know your freemium conversion rate? Your free user churn? Your projected MRR in 6 months?
Most founders guess. But you can model it in Google Sheets in under 30 minutes.
Here's a simple 3-tab model:
Tab 1: Inputs
- Monthly free users, conversion rate, churn rates, average paid MRR
Tab 2: Forecast Dashboard
- Month-by-month MRR projection with free user churn and upgrade funnel
Tab 3: Scenario Analysis
- Best / Base / Worst case — see how changes affect your business
I built a detailed template for this exact purpose. You can grab it on Gumroad (search 'Freemium Subscription Revenue Model Google Sheets').
The key formulas:
- Free users next month = Current free users + new signups - churn - conversions to paid
- Paid customers next month = Current paid customers + conversions - churn
- MRR = Paid customers * $29 (or your price)
Try it with your own numbers. You'll quickly see which levers matter most.
