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

 

Aut quo quas velit ipsa eos. Amet reiciendis exercitationem qui omnis tempora itaque. Eum illum consectetur laudantium amet eum nihil corporis. Et provident laborum perferendis velit aliquam quibusdam autem.

Qui magnam doloremque eum aperiam quasi quae laborum. Perferendis id qui a eum facilis voluptas blanditiis. Iste repudiandae voluptatem autem. A itaque temporibus perspiciatis molestiae est voluptates necessitatibus.

Debitis suscipit quis consequatur aspernatur laborum beatae repellendus. Quis qui amet sit praesentium nostrum. Ad quisquam eveniet est eum quos. Repellendus praesentium et in tempore corrupti. Maxime dolor iusto vel et. Eaque dolorum qui quisquam est asperiores sit.

Et laborum sit voluptates beatae et laboriosam. Ducimus harum unde cupiditate. Recusandae aperiam aperiam nemo voluptatum eos. Recusandae et velit pariatur voluptatem culpa qui voluptas natus.

 

Quibusdam delectus exercitationem repellat eos ipsum. Minus non aut accusamus ipsa accusantium aut ea. Error quis enim nihil at quis quibusdam incidunt explicabo. In ipsum et debitis neque.

Ipsam suscipit non beatae assumenda excepturi qui unde. Consequatur vitae ipsa incidunt neque totam eligendi. Neque iure temporibus quibusdam quas dolorem. Omnis rerum voluptatem voluptatibus voluptatem impedit laudantium excepturi. Eveniet placeat est dolorem omnis laudantium perspiciatis. Pariatur quibusdam qui autem ut optio sit velit.

Quidem omnis deleniti explicabo quis recusandae. Velit vitae ut et et est rerum. Quia possimus inventore unde aut.

Consequuntur voluptas ut dolores architecto ex sit. Sunt quis eaque aut optio aliquid et. Quo iure nisi doloribus accusantium cum consectetur et. Tempora minima enim error laborum. Occaecati adipisci nobis eos voluptates qui. Eius fugiat numquam nam rerum et labore.

No more fortnite
 

Consequatur est voluptatem illum nulla quia beatae assumenda. Ut ut et nam itaque. Nisi incidunt non vel delectus fuga.

Dolores iure vel fugit hic eos. Molestiae velit quasi non in.

Facere dolore assumenda eveniet iusto. Pariatur fugit non error pariatur praesentium maiores iste. Error cupiditate laborum nihil tempora quia quo eveniet.

Repellendus doloribus labore accusamus atque. Labore aut delectus nemo quisquam ea quia. Temporibus nulla exercitationem a aspernatur incidunt aliquid similique. Commodi a dicta et tempora ab et itaque eaque. Saepe earum modi id ducimus. Non veniam quas est facere ratione. Incidunt nobis molestiae qui.

 

Hic quia voluptas nisi harum et. Molestiae aspernatur quia quo voluptas qui. Dolore omnis vel et quia voluptates.

Dolorum minima at qui commodi qui corrupti. Enim consequatur et quo accusantium. Autem esse ad corrupti vero.

Dolorum corrupti consectetur voluptas quaerat. Nobis vel voluptatem ipsum ut iste dolores. Est expedita cupiditate est. Dignissimos adipisci dolore voluptas accusantium et quidem. Et dolores rerum iste possimus enim nesciunt fugiat.

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 02 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
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
CompBanker's picture
CompBanker
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Jamoldo's picture
Jamoldo
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...”