Modeling test - contribution analysis

Hi! I am a management consultant interviewing with a large cap fund based in London. My first round is on Friday and will be a modeling test. The headhunter gave me hints about the content and what the sections will be this morning. While most of it seems straightforward / similar to what I have seen in test examples, she mentioned a contribution analysis (details below). Can anyone explain how this works in the model pragmatically? 

Details: 

HH mentioned there will be a contribution analysis that helps bridge from 2022 EBITDA to 2027 EBITDA with the following steps: 2022 EBITDA > change in sales > margin expansion > increased operating expenses > 2027 EBITDA 
 

My understanding is this analysis helps understand how the company is expected to create value during the holding period: 1) increasing topline through volume/price increase, 2) growing gross margin through COGS reduction, 3) growing EBITDA margin through lower sg&a and other operating expenses 
If you have any examples of how this works, it would be super helpful to visualize! 

 

Eum dicta eaque id nisi odit. Necessitatibus voluptatem sequi quis vero. Est sit sequi hic magnam quis. Illo earum error et inventore. Enim nulla vel amet sunt. Aut quo soluta saepe eos voluptatem suscipit.

Voluptatum inventore voluptatem quia velit suscipit odit. Possimus qui molestiae itaque corporis.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

May 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 99.0%
  • Warburg Pincus 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

May 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

May 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

May 2024 Private Equity

  • Principal (9) $653
  • Director/MD (22) $569
  • Vice President (92) $362
  • 3rd+ Year Associate (91) $281
  • 2nd Year Associate (206) $268
  • 1st Year Associate (389) $229
  • 3rd+ Year Analyst (29) $154
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (316) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”