Advanced Customer Lifetime Value B2B Calculator

Model account value with recurring revenue, churn, margin, CAC, and growth. Stress test assumptions easily. Reveal profitable segments and longer retention opportunities for teams.

Calculator Inputs

Name the customer group you want to evaluate.
Examples: $, €, £, Rs.
Use the number of accounts in the cohort.
Enter average contract amount for the chosen billing cycle.
The calculator converts this amount into monthly revenue.
Use gross margin after direct delivery costs.
Account-level churn applied monthly.
Growth from upsell, cross-sell, or seat expansion.
Revenue loss without full account churn.
Used to discount future cash flows into present value.
Include sales and marketing acquisition cost.
Include implementation, training, and setup effort.
Ongoing service cost deducted from gross profit.
Applied in month one for onboarding add-ons or initial expansion.
Use for launch discounts or negotiated first-period concessions.
Maximum projection window for the model.
Leave blank to estimate lifetime from churn.

Example Data Table

Use this sample data to understand how different B2B segments can produce very different lifetime value patterns.

Segment Accounts Contract Value Billing Cycle Gross Margin Logo Churn CAC Illustrative Net CLV
Mid-Market SaaS 25 $12,000 Annual 78% 2.2% monthly $2,600 $113,420
Enterprise Support 8 $48,000 Annual 68% 1.1% monthly $8,500 $171,900
Agency Retainer 15 $3,000 Monthly 61% 4.5% monthly $900 $42,360
Data Platform 12 $18,000 Quarterly 82% 1.8% monthly $4,200 $129,780

Formula Used

This calculator combines recurring revenue, gross margin, logo churn, expansion, contraction, acquisition cost, and discounting into a B2B CLV model.

1. Monthly revenue per account
Monthly Revenue per Account = Contract Value ÷ Months in Billing Cycle
2. Active accounts by month
Active Accountst = Starting Accounts × (1 − Logo Churn)t−1
3. Revenue per surviving account
Revenue per Accountt = Base Monthly Revenue × (1 + Expansion − Contraction)t−1
4. Gross profit by month
Gross Profitt = (Revenuet + One-Time Revenuet) × Gross Margin − Support Costt
5. Discounted gross profit
Discounted Profitt = Gross Profitt ÷ (1 + Monthly Discount Rate)t
6. Net discounted CLV
Net Discounted CLV = Sum of Discounted Gross Profit − CAC − Onboarding Cost

How to Use This Calculator

  1. Enter a cohort name so your exports stay easy to identify.
  2. Set the number of acquired accounts and the average contract value.
  3. Choose the correct billing cycle so the calculator normalizes revenue monthly.
  4. Add gross margin, logo churn, expansion, and contraction assumptions.
  5. Enter CAC, onboarding cost, monthly support cost, and any one-time expansion revenue.
  6. Use initial concession if the first bill includes discounts or negotiated credits.
  7. Set the analysis horizon, or provide a manual lifetime override.
  8. Submit the form and review CLV, payback, ratio quality, the monthly table, and the projection graph.
  9. Use the CSV and PDF buttons to save the full output.

Frequently Asked Questions

1. What is B2B customer lifetime value?

B2B CLV estimates the total gross profit expected from a customer or account over its relationship, after applying churn, margin, costs, and discounting assumptions.

2. Why does this version use gross profit instead of revenue?

Gross profit gives a better decision metric because it removes direct delivery costs. Revenue alone can overstate customer value, especially for service-heavy accounts.

3. What does logo churn mean here?

Logo churn represents the percentage of accounts lost each month. It reduces the active customer base over time and directly affects projected lifetime value.

4. Why include expansion and contraction separately?

B2B accounts often grow through seat increases or shrink through lower usage. Separate inputs make the model more realistic than a simple flat revenue assumption.

5. What does the discount rate do?

The discount rate converts future profit into present value. It helps compare long-term customer returns using a more finance-friendly view of value.

6. How should I interpret the CLV to CAC ratio?

A higher ratio usually suggests stronger acquisition efficiency. Many teams want a ratio above 3x, but targets vary by margin, payback speed, and growth strategy.

7. What if my business has annual contracts?

Choose annual billing. The calculator converts annual contract value into monthly revenue so the model can apply churn, expansion, and discounting consistently.

8. When should I use the manual lifetime override?

Use it when you have observed retention limits, contractual caps, or board-approved assumptions that should override churn-based lifetime estimation.

Related Calculators

account based marketing roi

Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.