Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMAccounts & CustomersCustomer Lifetime Value and Cohort Retention

SpreadsheetAccounts & CustomersFree

Customer Lifetime Value and Cohort Retention

Calculate LTV, LTV:CAC and payback by plan, and track how many customers each monthly cohort keeps over time.

Shown with sample data

Colour

Customer Lifetime Value and Cohort Retention

Calculate LTV, LTV:CAC and payback by plan, and track how many customers each monthly cohort keeps over time.

Monthly recurring revenue
$197,455
Blended ARPU
$78.39
Blended monthly churn
4.0%
Weighted by customers
Customer-weighted LTV
$3,839
Plans below 3:1
2
Weighted month-1 retention
89%
Weighted month-3 retention
77%
Weighted month-6 retention
65%
Lifetime value by plan
  • Enterprise (custom)$152,250
  • Pro$12,761
  • Annual (monthly equivalent)$4,933
  • Growth$2,543
  • Starter$411
  • Marketplace add-on$111
Month-1 retention by cohort
Jan 2026Sep 2026

Latest: 92.3%

How to use it

  1. 1On the LTV sheet, enter each plan’s active customers, monthly ARPU, gross margin, monthly churn and CAC.
  2. 2Read LTV, LTV:CAC and payback; plans marked Unprofitable or Marginal need pricing, retention or CAC work.
  3. 3On the Cohorts sheet, add a row for each month’s new customers and fill in how many are still active at each checkpoint.
  4. 4Leave checkpoints blank until the cohort reaches them; retention shows only where there is data.
  5. 5Compare recent cohorts with older ones: rising month-3 retention means your changes are working.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Know what a customer is worth before you decide what to spend acquiring one. The LTV sheet takes average revenue per user, gross margin, monthly churn and acquisition cost for each plan and returns expected lifetime, lifetime value (ARPU × gross margin ÷ churn), LTV:CAC and months to pay back CAC, with a health flag. The Cohorts sheet tracks each month’s new customers and how many remain after 1, 2, 3, 6 and 9 months, turning them into retention percentages and a weighted average curve.

Who it’s for

  • Setting marketing budgets and target CAC
  • Investor and board metrics packs
  • Comparing plans or pricing tiers
  • Spotting whether retention is improving for newer cohorts

What’s included

  • LTV by plan sheet: Lifetime value and payback for each plan.
  • Cohorts sheet: Each month’s new customers and how many remain.

How to use it

  1. 1On the LTV sheet, enter each plan’s active customers, monthly ARPU, gross margin, monthly churn and CAC.
  2. 2Read LTV, LTV:CAC and payback; plans marked Unprofitable or Marginal need pricing, retention or CAC work.
  3. 3On the Cohorts sheet, add a row for each month’s new customers and fill in how many are still active at each checkpoint.
  4. 4Leave checkpoints blank until the cohort reaches them; retention shows only where there is data.
  5. 5Compare recent cohorts with older ones: rising month-3 retention means your changes are working.

Tips

  • Use gross margin, not revenue, in LTV. A customer paying $100 a month at 30% margin is worth far less than one at 80%.
  • A healthy subscription business usually targets LTV:CAC of 3 or more and CAC payback under 12 months; early-stage businesses often run below this while they learn.
  • Monthly churn compounds: 5% a month loses about 46% of customers in a year. Small improvements in churn have a large effect on LTV.
  • Simple LTV assumes churn stays constant. If your cohorts flatten after a few months, the real LTV is higher than this estimate.

Questions

How do you calculate customer lifetime value?

A common formula for subscriptions is LTV = ARPU × gross margin ÷ monthly churn rate. For example, $60 a month × 75% margin ÷ 3% churn = $1,500. Average lifetime is 1 ÷ churn, so 3% monthly churn means about 33 months.

What is a good LTV to CAC ratio?

Around 3:1 is the widely used benchmark: each customer is worth three times what it cost to acquire. Much lower means you are overspending on acquisition or losing customers too fast; much higher may mean you are underinvesting in growth.

What is cohort retention analysis?

Grouping customers by the month they joined and tracking what share remain active over time. It shows whether retention is improving for newer customers and when most customers leave, which averages across the whole base can hide.

How do I calculate monthly churn rate?

Customers lost during the month ÷ customers at the start of the month. Use an average over several months for the LTV calculation because single months are noisy.

Related searchescustomer lifetime value calculatorltv calculator excelcohort retention analysisltv to cac ratiochurn rate calculatorsubscription metrics template

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
2
Setup
10 min
Level
Advanced
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts & CustomersFree

Customer Lifetime Value and Cohort Retention

Calculate LTV, LTV:CAC and payback by plan, and track how many customers each monthly cohort keeps over time.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
2
Setup
10 min
Level
Advanced
Price
Free

Your copy is private to you.

More accounts & customers templates

View all
Customer Health Scorecard2 sheets

Accounts

6

At risk

2

Revenue at risk

$134,000

Annual revenue by segment
$204k
$116k
$32k
EnterpriseMid-marketSmall business
SpreadsheetAccounts & Customers

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

10 min setupPreview
RFM Customer Segmentation3 sheets

Customers

14

Champions’ share of revenue

48%

Revenue from at-risk customers

$4,600

ABCD
1CustomerLast orderOrdersTotal spend
2Amelia TurnerNov 914$2,860
3Noah BennettOct 287$1,240
4Isla FraserNov 121$85.00
5Leo HughesApr 211$2,310
Customers
SpreadsheetAccounts & Customers

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

10 min setupPreview
Customer Contact List3 sheets

Customers

9

Lifetime revenue

$187,400

Revenue at risk

$37,100

ABCD
1CustomerContact personCityOwner
2Northwind RetailSara AliSeattleDana
3Blue Harbor CafeHana KimPortlandMia
4Oak & Pine StudioWill GrantDenverLeo
5Delta FoodsBen ColeChicagoLeo
Customers
SpreadsheetAccounts & Customers

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ