Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Introduction to Churn and Lifetime Value (LTV) Analysis LTV Review: LTV

Laura Mora Freeman
Laura Mora Freeman
8,192 Points

What is our net LTV if we have: a monthly ARPU of $10, a gross monthly churn rate of 12%, and COGS of 10%?

What is our net LTV if we have: a monthly ARPU of $10, a gross monthly churn rate of 12%, and COGS of 10%? Round your number to the nearest whole dollar (do not include any cent values):

The formula says LTV = 1/churn*ARPU

When i do it i get an error, could you help me clarify this.

Thank you.

1 Answer

Caleb Kemp
Caleb Kemp
12,755 Points

You're really cranking away through these things :smile:

For the example, we will use the following values. ARPU $20, COGS 10%, and a gross monthly churn rate of 15%. Now to solve with those values

Here is the formula we will need to use to solve this

LTV = NET ARPU/churn rate. (Where churn rate stands for "gross monthly churn rate)

We are not given NET ARPU so we will have to solve for it.

NET ARPU = ARPU - (ARPU * COGS) Now to insert the values from the example

NET ARPU = $20 - ($20 * .10) Note*(10% is the same as written 10/100 or 1/10, which is why we used .10)

NET ARPU = $20 - $18 -> NET ARPU = $18 Now we can plug this into the first formula

LTV = NET ARPU/churn rate Now to plug in our numbers

LTV = $18/.15

LTV = $120 HURRAH!! :smile:

I know this is quite a bit more complicated than the last ones you solved, but I think you got this. Good luck, let me know if it gives you any more trouble.