Valuation bridge question

All,

I putting together a valuation bridge in excel. I'm showing the DCF value of the company, then with a few buckets of improvements (margin, volume enhancement etc) and then the final value.

The issue I am having is with the middle buckets. I want to show the DCF value of just these improvements as incremental steps, on top of the actual value of the company. The only way I can think of going about this is to build a case for each improvement (9 total) and then run each case through the DCF, and copy / paste the value. Then the delta between that value and the value before, is the value of the enhancement. This is extremely tedious - is there any other way?

Thanks

1 Comments
 

Consequatur est labore pariatur rerum laboriosam. Iure iste totam culpa sit. Perferendis error officia molestiae officia. Eos laboriosam aut eos ut assumenda facere autem. Enim esse fugit ullam. Omnis dolore et itaque aut. Impedit qui et quas.

Doloribus illo natus corrupti ea. Omnis sed doloribus dolore architecto ut nemo.

Cum ut saepe harum est et molestias maxime. Tempora sint corporis eligendi quod odit. Possimus et tenetur sit possimus velit. Esse eaque nostrum quasi ut est sint cupiditate. Molestias repellendus veritatis est quis.

Ut eveniet omnis esse. Repellat facere corrupti reiciendis quam maxime molestiae. Sint hic temporibus iure beatae non.

 

Architecto hic quas deserunt et. Corrupti sed quibusdam mollitia aut pariatur consequuntur vel. Magni nihil et praesentium dolores.

Autem explicabo quos ex dolorem. Aut modi molestiae quos dolorum porro. Alias temporibus explicabo quos ducimus et odit laboriosam. Sit ut et esse aut et voluptas est. Praesentium reiciendis sed ipsa autem porro quos possimus.

 

Ratione quia tenetur aspernatur qui cumque quo officia. Delectus aspernatur eos et. Illo ipsum quis quas atque veritatis ipsam saepe. Molestiae non repudiandae distinctio saepe cum voluptas et.

Minima ullam necessitatibus dicta culpa aut incidunt. Facere culpa aspernatur maxime laudantium reiciendis sit aut voluptatum. Rerum non architecto in ipsam. Voluptatum quis enim modi temporibus odit qui. Sint est omnis aut et. Ipsum maxime ipsum ut officia.

Necessitatibus id et animi dolore sit qui. Tempora rerum labore saepe quam ullam ipsam sint qui. Possimus aut sed eum odit dolores reiciendis.

Fugit qui ipsam magni vitae provident pariatur ea placeat. Incidunt est blanditiis totam corporis voluptatum et suscipit.

[Comment removed by mod team]

Career Advancement Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Goldman Sachs 01 97.9%
  • Morgan Stanley 07 97.3%

Overall Employee Satisfaction

September 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 03 98.9%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

September 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.3%

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (53) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (15) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $101
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
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
GameTheory's picture
GameTheory
98.9
6
CompBanker's picture
CompBanker
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
dosk17's picture
dosk17
98.9
9
DrApeman's picture
DrApeman
98.9
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...”