Description
Track MRR, ARR, churn, NRR, LTV, CAC, payback and cohort retention from a customer list. Monthly MRR bridge, channel scorecard and charts.
Who it’s for
SaaS founders, indie hackers and finance leads who need investor-ready numbers without paying for an analytics tool.
What’s inside
- Dashboard: MRR, ARR, customers, ARPA, growth, NRR, churn, LTV, CAC, LTV:CAC, payback, 3 charts, plan mix and channel scorecard
- Customers: Subscription list with MRR after discount, status and months active
- MRR Changes: Upgrades (expansion) and downgrades (contraction)
- Spend: Sales & marketing spend by channel and month
- Monthly Metrics: 12-month MRR bridge, customer counts, churn %, revenue churn %, NRR, ARPA, CAC, LTV, LTV:CAC, CAC payback
- Cohorts: Retention triangle: % of each signup month still active after 0–11 months, heat-mapped
- Settings: Currency, first month, gross margin, plans & prices, channels, churn reasons
What you get
- The .xlsx workbook with sample data that’s easy to clear
- Setup Guide PDF, with every tab explained
- A video walkthrough
FAQ
Does it work in Google Sheets?
Yes. Upload it to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.
Which Excel version do I need?
Excel 2019 or newer, Microsoft 365 or Excel for Mac.
Is this a subscription?
No. You pay once and keep the file. No macros, no add-ons.
Sample numbers are example data, not benchmarks.
This is a digital product. No physical item will be shipped.
Also on Gumroad: SaaS Metrics Dashboard: MRR, Churn, LTV & CAC on Gumroad
Build your own store: Hostinger WordPress hosting (affiliate link: I may earn a commission at no extra cost to you)
