Account Retention and LTV Calculator

P23-EDUby TWENTY3 IntelligenceAccount Retention Value LTV
Library
v1.0
Sales Tool 31
Account
LTV & Retention
What is a wholesale account actually worth over 3 years? Model LTV at different retention rates, quantify the cost of churn, and build the business case for account retention investment.
1Account Profile
Expected annual growth on retained accounts
2Retention & Churn
% of churned accounts eventually return
3Account Investment
Samples, service, visits, co-op
Account 3-Year LTV 
LTV
3 Years
Churn
Cost
Retention
ROI
3-Year LTV Model
Year 1 Revenue
Year 2 Revenue (if retained)
Year 3 Revenue (if retained)
Gross Revenue (3yr, if retained)
× Gross margin
− Retention investment (3yr)
Net LTV (3 years)
Churn Economics
Lost revenue (churn in Yr2)
Replacement CAC
Total churn cost per account
Retention Rate Sensitivity
Ret. RateYr-2 Rev3yr LTVvs 100%
P23-EDU · TWENTY3 IntelligenceSales Tool 31·Account LTV & Retention·3-Year Revenue + Margin Model·Churn Cost vs Retention Investment·P23-EDU · TWENTY3 IntelligenceSales Tool 31·Account LTV & Retention·3-Year Revenue + Margin Model·Churn Cost vs Retention Investment·