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 trialLaura Mora Freeman
8,192 PointsChurn
In the ChurnAssessment spreadsheet (used in multiple questions in this quiz), what is the Net MRR Churn rate for month 6? Exclude new subscribers from your calculations. Submit your answer in percent format, rounded to the nearest 100th decimal value (example: 10.22):
Can you help me with this calculation , i am not getting right, thank you
3 Answers
Laura Mora Freeman
8,192 PointsThank you Caleb, i was doing it with the $ not subscribers, thank you for clarifying it. Also.
what is the dollar value of the Net MRR Churn in Month 1? Exclude new subscribers from your calculations: $
I am doing this with the same formula but now with $
= ($141,775-$23,400)/$2,561,250 = 0.05
and i get an error, do you know why. Thank you.
Caleb Kemp
12,755 PointsIt's kind of confusing how all the terms sound so similar but are all calculated differently. Here is how you calculate the $ amount of net churn. (What you have above is churn rate percentage)
$ Net MRR = (canceled $) - (expansion $) So, for month 2, here's what that looks like cancelled $ = 65675, expansion $ = 21925
$ 65675 - $ 21925 = $ 43750
I think you should be able to get the correct answer from that, good luck. Let me know if it gives you any further trouble
Laura Mora Freeman
8,192 PointsThank you Caleb!
Caleb Kemp
12,755 PointsGlad I was able to help!
Laura Mora Freeman
8,192 PointsSince you are active can i ask another question. 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):
I tried with the formula given LTV=1/Churn*Arpu but i am not getting results, also i tried to convert the churn rate to the average customer lifetime but is not working, if you happen to know, would love your help. Thank yoou in advance
Caleb Kemp
12,755 PointsSorry, I didn't see this earlier, I put the solution on the separate post you made for this question. Good job plugging away at it, glad to see you making progress.
Caleb Kemp
12,755 PointsCaleb Kemp
12,755 PointsSo, the calculation is pretty straightforward.
Net MRR = (cancelled - expansion) / start of month
So, for month 8, here's what that looks like cancelled = 3012, expansion = 801, start = 107144
(3012 - 801) / 107144 2211 / 107144 = 0.02063 to get the percent, times that by 100 so the net MRR for month 8 is 2.06%
Hopefully that makes sense, let me know if it gives you any further difficulty.