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.
| +89 | Nothing to do at work & bored to hell | 9 | 6h |
| +67 | Do people over-index on 'moats' | 20 | 1d |
| +52 | Predicted Net Worth in Trodden Finance Path by 60? | 20 | 6h |
| +44 | Biggest (avoidable) failures in PE Investments? | 25 | 1h |
| +38 | Why is ROIC never really a topic when looking at companies IRL | 11 | 3d |
| +28 | SGE Final Round (Investment Summer Analyst) - Case Study & Technicals? | 14 | 1h |
| +19 | Senior IR Lifestyle | 3 | 5d |
| +12 | How to approach Buyside Recruiting | 3 | 4d |
| +12 | Honest opinions needed about lateraling | 4 | 1d |
| +12 | NY LMM PE Recruiting | 3 | 1d |
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?
Et sunt quis debitis laboriosam dolore dolores. Incidunt voluptatibus corporis est ullam dicta adipisci quidem. Aut quis quia facere delectus voluptatem suscipit voluptas id. Autem ipsam repudiandae voluptates. Ut voluptatibus est enim laudantium. Ut provident nobis optio minima aliquam tempore.
Maiores distinctio accusamus facere ipsa ut quisquam dolores qui. Dolorum ipsam architecto ratione dicta rem debitis. Et necessitatibus nemo hic qui. Inventore eaque et sit omnis sapiente. Sequi temporibus amet magnam quia dolor consectetur.
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...