I need help on a project in which I need to put together a retention cohort analysis based on historical data. Does anyone have any examples on how to put this together? I've even tried reaching out to tutors on various sites with former finance backgrounds, and nobody seems to know how to do something like this.
| +60 | Working on Juneteenth | 35 | 10h |
| +24 | From Public Equities to Private Equities | 4 | 5d |
| +22 | Hardest time I have ever seen to be a GP | 3 | 1d |
| +18 | Weighing exit from LMM PC/PE | 2 | 3d |
| Search Fund Internship Vs. Internship at my family's Family Office | 10 | 1d | |
| +15 | Healthcare PE | 6 | 1d |
| +15 | KKR comp for Principal | 10 | 19h |
| +15 | Anyone have intel on Aterian Investment Partners? Culture, Comp, Performance? | 9 | 4d |
| +14 | How to Get on Career Track / Stay Post ASO years | 4 | 15h |
| +12 | LMM groups within larger platforms? | 1 | 5d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
This site seems to do a good job exposing user and revenue cohort analysis.
The link doesn’t seem to be coming through but you can search: “Cohort analysis - 4 ways to analyze your product retention rate” on Mobile Spoon.
Conceptually, you want to take the trended data (probably monthly revenue by customer) and tag each customer to a starting cohort based on the year that they launched. Then index each period of actual data based on time since start (e.g., for a 2016 cohort, 2016 revenue = Year 0, 2017 revenue = Year 1, etc.; for a 2017 cohort then 2017 = Year 0, 2018 = Year 1...).
Then use sumifs or a pivot to make a table that traces out revenue for each cohort by period (0, 1, 2, etc.) with cohort year running down column 1 and period running across columns 2+. It should come out as a triangular table. Then beside it, you can add a calc that compares the revenue in each period to time 0 (so Year 0 = 100% (usually), then Year 1 = x%, Year 2 = y%...) and you'll see how much of each cohort gets retained over time.
Aut iusto sequi magnam alias rerum libero atque enim. Deserunt cum magni nobis. Sint error perferendis ut quisquam reiciendis eos a. Iste numquam magnam non qui vel animi consequatur. Sint et dolorem in repudiandae dignissimos.
Nam et est mollitia excepturi. Velit et distinctio reprehenderit optio. Amet voluptatem eveniet molestiae nobis nesciunt quos cumque.
Velit placeat dolor modi quo delectus vero cumque. Mollitia accusantium nesciunt harum occaecati aliquam aut. Possimus ut voluptatibus impedit quae enim tenetur. Incidunt iusto eos atque molestias iste totam architecto. Quis quae tempora placeat dolore mollitia ut tempore voluptatem.
Dolorem repellat blanditiis delectus quibusdam. Dolorem eius optio quia voluptas veniam. Aut dolor ea neque explicabo numquam in error. Non eos hic voluptatem sit eligendi quo ipsam sit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...