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

Rouillie Wilkerson
Rouillie Wilkerson
10,419 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%?

I passed the quiz, but missed this one. What is the answer? The formula that's not "flawed"? What am I missing! Please walk me through this as follows:

"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): $_____"

3 Answers

Sean King
Sean King
5,144 Points

Your attrition rate is 12% and you have a profit percentage of 90% (keep in mind we want net here). In a simple sense, you should be able to reduce this to (1/MCR)*(1-COGS)*ARPU.

Reality isn't as simple, but that can get you close.

Last night I just substituted values into the spreadsheet from the teacher's notes here and the value wasn't accepted. However after reading Sean's answer I tried again this morning and it worked. Who knows? But here is a link to the sheet

Rouillie Wilkerson
Rouillie Wilkerson
10,419 Points

Thanks, I'm going to go back in and run both methods. I just have to get this!