Subscription Revenue (MRR) Calculator
Business & documents · Done in 3 steps
- 1Enter your numbers
- 2
- 3
About
Project MRR and ARR month by month from new customers, growth, churn and expansion, with LTV, LTV:CAC, CAC payback and a chart.
How to use it
- 1Enter customers today, average revenue per customer and new customers per month.
- 2Set acquisition growth, monthly churn and expansion.
- 3Add CAC and gross margin to get LTV, LTV:CAC and payback.
- 4Hover the chart for any month, and download the monthly table as CSV.
- You give
- Starting customers, ARPA, new customers, growth, churn, expansion, CAC, gross margin and horizon.
- You get
- MRR/ARR projection chart, monthly table (CSV) and unit-economics stats.
- Good to know
- A simple cohort-free model: churn and expansion apply evenly to all customers, and there is no seasonality. Use it to compare scenarios, not as an accounting forecast.
- Privacy
- Processed on your device. Nothing is uploaded, stored or logged.
- Last tested
- 2026-10-28
FAQ
How is LTV calculated?
LTV = ARPA × gross margin ÷ monthly churn. With $49 ARPA, 80% margin and 3% churn, LTV ≈ $1,307. It's undefined at 0% churn, which is why the tool warns you.
What is a good LTV:CAC ratio?
Around 3:1 or better is the common rule of thumb for subscription businesses, with CAC paid back in under 12 months. Below 1:1 you lose money on every customer.
Go further with AI
Training deck outline
Design a training session around what learners must be able to do, with timed segments, practice activities and a check for understanding.
ChatGPT · Claude · Gemini
Research-to-slides workflow
Turn a long report or research notes into a short, decision-focused deck with one message per slide and evidence in the notes.
ChatGPT · Claude · Gemini
Presentation redesign checklist
Fix a cluttered deck systematically: story, slide titles, density, visual hierarchy, charts, accessibility and consistency.
ChatGPT · Claude · Gemini
Case study document template
Write a credible customer case study in challenge, solution, results format, using only verified facts and marking every gap for follow-up.
ChatGPT · Claude · Gemini