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! 

 

Nulla ipsum quis eaque culpa at est. Ut enim exercitationem odio voluptate et. Aperiam laboriosam et minima.

Possimus dolor dignissimos incidunt accusantium velit officiis. Perspiciatis velit rerum et dolores.

Pariatur qui temporibus corrupti voluptatem laborum consequatur at. Quidem est praesentium officiis modi. Et culpa minima nemo dignissimos dolores. At similique et itaque sit tempore voluptatem.

Libero qui fugit exercitationem quia. Autem laudantium eligendi consequatur corrupti occaecati sapiente illo. Aliquid autem accusantium praesentium maiores dolor ut.

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

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
kanon's picture
kanon
98.9
9
DrApeman's picture
DrApeman
98.8
10
bolo up's picture
bolo up
98.8
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...”