Subscription Lifetime Value With Constant Monthly Churn

Reported in interviews at Ampush

Problem statement

You are a data scientist at a subscription software company that launched a little over a year ago. The chief revenue officer wants the average customer lifetime value (LTV), measured as expected revenue per customer. What you know:

  • The product costs USD 100 per month, billed at the start of each month.
  • At the end of every month, 10% of the customers who are still active cancel, and this rate has been stable.
  • Across all customers in the database, the average tenure so far is about 3.5 months.
  1. Write the formula for the average LTV and evaluate it.
  2. The 3.5-month average tenure seems to disagree with the churn rate. Which number should drive the LTV estimate, and why?
Show hint

What distribution describes how many months a customer stays if the same fraction cancels every month?

Relevant roles: Data Scientist and Applied Scientist.

Related free problems