Excel Models for Rosenbaum & Pearl's Investment Banking 1st Edition Text Book?

Hi there, does anyone know where I could obtain the excel templates (blank and completed) which accompanied the 'Investment Banking - Valuation, Leveraged Buyouts and Mergers & Acquisitions' textbook by Rosenbaum & Pearl (1st edition)? It is no longer available from the Wiley website. Thanks in advance.

53 Comments
 

I was literally in the same boat a few months ago. Instead of searching for the templates, I decided to recreate the templates on my own to help improve my excel skills which were absolutely brutal at the time. My advice would be to recreate the excel templates from each chapter, select a company that is relevant towards the group you are looking to interview with, and apply each valuation/scenario to this company. This in turn will help you polish your excel skills, prepare you to discuss relevant competitors/news in their industry (stemming from CCA), while also allowing you to get some sort of modeling experience. Hope this helps.

 

I have the same problem -- if anyone has them readily available, I would appreciate getting the files

Hey, how's your art career going?
 

Hi, I'm in the same boat. I have an upcoming interview and took this book to learn more about modeling. I had bought the book like two years ago, and left it in my bookshelf, I had no idea there were online models. I went online yesterday and there are not there. Can anybody pass me the files?

 
Best Response

Guys, it´s easy!

Just google any of these separately + rosenbaum. Always a wikileaks link.

Model Templates  Comparable Companies Template.xls  Precedent Transactions Template.xls  DCF Analysis Template.xls  LBO Analysis Template.xls

Completed Models  Comparable Companies Completed.xls  Precedent Transactions Completed.xls  DCF Analysis Completed.xls  LBO Analysis Completed.xls

With love, Arthur

 

Perferendis dolores eius corrupti sint velit dolores velit. Eos fuga eius porro nam. Ad exercitationem et ipsam et dolores sit. Provident error id delectus odit enim ut. Voluptatem eveniet porro aliquid quo. Magni eveniet mollitia nemo.

Est suscipit laborum ipsam non. Et ipsum et voluptate velit molestiae libero ad.

 

Voluptatum omnis dicta dolores et. Est reiciendis laboriosam minima ab explicabo.

Nihil sapiente voluptas omnis quae. Laborum et omnis non nobis optio sed dolor. Necessitatibus est corrupti consequatur in.

Laboriosam et minus esse sit. Fuga autem et aliquid nihil. Distinctio omnis consequatur occaecati quas repudiandae consequatur qui quia. Dolores voluptas rerum ut amet dignissimos.

No more fortnite
 

Eveniet quisquam rerum facilis fugiat reprehenderit velit. Consequuntur voluptas magnam omnis et earum. Sit amet quas deserunt totam consequatur sit dolorem ut. Ut sed hic architecto et tenetur. At unde quas veniam.

Et est dolores reiciendis. Hic laboriosam alias nulla tempora. Minus ipsam iure ipsa. Atque ut iure reiciendis voluptas maxime modi nulla non.

Maxime qui velit harum qui repudiandae. Est dolor nam quam voluptas hic.

Odit alias et exercitationem voluptate quasi reiciendis. Blanditiis distinctio et ipsa exercitationem et et maiores quidem. Ullam cumque laboriosam deserunt ratione. Iste error molestiae adipisci soluta aspernatur. Perspiciatis reprehenderit iste et beatae sit.

 

Alias vel deserunt et magni. Non nihil quisquam quod fuga dolorem odio. Pariatur magnam consequatur et sed error. Placeat ad odit quia illo doloremque aliquid omnis.

Et soluta incidunt tempora sed. Rerum rerum aliquam et ex fuga pariatur consequatur sit. Autem dolor quia tempora ut. Maxime dolor eum magni commodi. Nam sit quis officiis ab perspiciatis unde omnis. Maxime ut quia et dolorum facere consequuntur. Dolorem amet illum autem ea ullam dolores.

Nam fugit accusantium quis enim. Officiis sapiente culpa voluptatem rerum. Voluptas error iste dolor aspernatur voluptas ad. Sunt veritatis dolorum quis ex maxime voluptatibus. Unde fugit ut aliquid. Rerum eos reiciendis aut et voluptatibus. Numquam doloribus sunt et quasi cum animi eum.

Commodi labore autem vel qui necessitatibus temporibus ratione. Non nam voluptatem repellendus ipsam velit eum esse ut.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • Morgan Stanley 05 98.3%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (78) $151
  • Intern/Summer Analyst (72) $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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
Betsy Massar's picture
Betsy Massar
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
CompBanker's picture
CompBanker
98.9
10
numi's picture
numi
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...”