Does anyone have a good template for when you are given a sales cube on a growth equity case study. The examples online I found weren't great, and I feel like the examples on a case study will be way harder.
Any insights / templates that can be shared are welcomed.
| +74 | PE Bro Accepted to GSB/HBS/Wharton - AMA | 72 | 10h |
| +29 | Private Equity Office wear | 13 | 4d |
| +21 | Use Cases For Claude Cowork / Claude Code | 8 | 1d |
| +18 | GE / LMM PE Comp in Tier 2 City | 1 | 1d |
| +17 | Army Officer Seeking Advise on transition to PE | 5 | 1h |
| +13 | Starting Early as a PE Associate | 4 | 1d |
| +12 | Graduate Positions: Boutique LMM PE/Advisory vs. Big 4? | 1 | 12h |
| +11 | PE vs IB job security | 12 | 23h |
| +10 | How much time are you spending on new deals vs portfolio work? | 3 | 2d |
| +9 | Exiting PE to acquire a business | 1 | 9h |
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.
I don’t have a template but what’s your question / analysis you’re worried you can’t do?
It's unstructured data from an invoice output with lot's of blanks, uneven contract lengths, and examples of expansionary revenue. Need to create an MRR roll forward with that information when not parameters were given. I.e there's no end contract date that signals churn, no trigger that signals expansionary or contractionary revenue streams.
If it’s bad data you can use a series of IF Statement formulas to cut the data. For example a new customer win would be if they don’t have revenue the previous month and they did this month (if data is bad extend it to be if they didn’t have revenue the previous quarter so you eliminate the variability of choppy invoicing). Tough to delineate expansion versus true new product upsell without some sort of revenue by product by customer dataset same applies to Downsell (hard to delineate contraction vs. true Downsell). Churn same formula logic as Wins it is a churn if they had revenue but didn’t in the following month (extend it to didn’t have revenue for three months if the data is choppy). If you have revenue by product level info you can further delineate between seat expansion/contraction versus product upsell/Downsell.
Thank you so much. That’s sort of what I ended up doing, just felt super sloppy doing that.
Churn revenue and new revenue was easy to do, others not so much.
Also, how do you account for renewal? Monthly contract that is $100 each month and company renews each time. Is that “new revenue” in an MRR roll forward?
Fuga id doloribus sit assumenda veniam dolores. Id consequatur modi repellendus maiores corporis. Ut ut quis illum assumenda laboriosam ducimus. Quo et totam aperiam quo sit rerum. Aliquam corrupti assumenda rerum beatae quia sunt.
Eos veniam qui nihil est. Saepe hic possimus est aut ut voluptatum recusandae.
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...