Interactive LTV Calculator
Try Change Monthly Churn (%) and LTV Period (months) to compare customer lifetime value. Then press Calculate lifetime value.
Observe After pressing Calculate lifetime value, watch total LTV and average customer lifetime as Monthly Churn (%) changes.
Explain Describe how Gross Margin (%) changes monthly profit and total LTV after you press Calculate lifetime value.
Technical boundaries. Monthly ARPU, gross margin, and monthly churn remain constant. Total LTV sums retained monthly profit over the selected period.
Interactive LTV Calculator
Calculate customer lifetime value with different churn scenarios:
viewof arpu = Inputs.range([10, 1000], {
label: "Monthly ARPU ($)",
step: 10,
value: 20
})
viewof grossMargin = Inputs.range([0, 100], {
label: "Gross Margin (%)",
step: 1,
value: 70
})
viewof monthlyChurn = Inputs.range([0.5, 10], {
label: "Monthly Churn (%)",
step: 0.5,
value: 5
})
viewof ltvMonths = Inputs.range([12, 60], {
label: "LTV Period (months)",
step: 12,
value: 36
})
ltvRetentionRate = 1 - (monthlyChurn / 100)
ltvMarginRate = grossMargin / 100
ltvValueTotal = d3.sum(
d3.range(1, ltvMonths + 1).map(month =>
arpu * ltvMarginRate * Math.pow(ltvRetentionRate, month - 1)
)
)
ltvAverageLifetime = 1 / (monthlyChurn / 100)
html`
<div style="background: linear-gradient(135deg, #1F2937 0%, #0F766E 100%); padding: 20px; border-radius: 8px; color: white; margin: 15px 0;">
<h3 class="fm-panel-title">Lifetime Value Results</h3>
<div class="fm-kpi-grid">
<div class="fm-card" style="background: rgba(255,255,255,0.1); padding: 15px; border-radius: 6px;">
<div style="font-size: 14px; opacity: 0.9;">Total LTV (${ltvMonths} months)</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;">${"$"}${ltvValueTotal.toFixed(2)}</div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.1); padding: 15px; border-radius: 6px;">
<div style="font-size: 14px; opacity: 0.9;">Avg Customer Lifetime</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;">${ltvAverageLifetime.toFixed(1)} months</div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.1); padding: 15px; border-radius: 6px;">
<div style="font-size: 14px; opacity: 0.9;">Monthly Profit</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;">${"$"}${(arpu * ltvMarginRate).toFixed(2)}</div>
</div>
<div class="fm-card" style="background: rgba(255,255,255,0.1); padding: 15px; border-radius: 6px;">
<div style="font-size: 14px; opacity: 0.9;">Retention Rate</div>
<div class="fm-medium-number" style="font-weight: bold; margin-top: 5px;">${(ltvRetentionRate * 100).toFixed(1)}%</div>
</div>
</div>
<div style="margin-top: 15px; font-size: 13px; opacity: 0.8; font-style: italic;">
LTV = Σ(ARPU × Margin × Retention^(month - 1)) from month 1 to ${ltvMonths}
</div>
</div>
`
Back to the chapter