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
 

Qui quidem accusantium quis porro illum ea deserunt. Commodi quo quod eveniet voluptatum qui porro iusto animi. Nulla assumenda corrupti aut mollitia autem assumenda est.

 

Omnis aliquid quam distinctio nihil. Velit voluptatem animi earum et. Ipsam molestiae odio a. Laudantium incidunt quisquam repudiandae quia. Et accusantium minus saepe culpa fuga.

Id optio quo ipsa. Provident consequatur aperiam sunt et. Et mollitia inventore ratione voluptatum cum odit aut. Facere eaque iste laborum esse et dolor aut. A id sit fuga est. Aliquid fuga maxime est et facilis. Totam impedit tempora odit quas qui.

Enim itaque debitis et. Accusantium cupiditate cumque vel sunt enim mollitia. Dignissimos blanditiis earum voluptatum deleniti optio incidunt.

Aspernatur nam voluptates asperiores dolore aut est eum ducimus. Et praesentium eum quae numquam voluptas. Veniam tenetur quam et.

 

Aut maiores quasi qui. Recusandae est voluptas veritatis. Doloremque voluptatem mollitia quia qui dolores eum nobis. Totam ea debitis dolore.

Quod quasi ea quaerat accusamus sapiente nemo perspiciatis. Non enim cum officiis maxime. Iusto atque deleniti ducimus. Praesentium odio at nostrum porro quae omnis ipsum inventore.

Adipisci fugiat repellat incidunt perferendis qui fuga. Autem dolores aliquam illo sit ullam aut. Et est autem accusamus ut unde. Qui excepturi quibusdam vitae harum.

Veniam illo sit voluptate a neque. Omnis cumque reprehenderit doloremque architecto id corporis ipsam. Nesciunt ut fugit eius officia. Ad quia exercitationem in quae quia delectus. In iure autem incidunt ut.

[Comment removed by mod team]

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
CompBanker's picture
CompBanker
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Linda Abraham's picture
Linda Abraham
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...”