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.

WSO Elite Modeling Package

  • 6 courses to mastery: Excel, Financial Statement, LBO, M&A, Valuation and DCF
  • Elite instructors from top BB investment banks and private equity megafunds
  • Includes Company DB + Video Library Access (1 year)

Comments (62)

Apr 2, 2015 - 5:54pm

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.

Apr 3, 2015 - 9:18am

Thanks @bromilian, sounds like a smart way to go about about it. I've got an LBO case study coming up for Financial Sponsors Group IBD next week so I plan to jump straight to chapter 5 in the book. I was hoping to save time by getting the model templates, but building from scratch might actually be a more beneficial exercise. Cheers.

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Nov 12, 2016 - 8:59am

hello, I have been looking for these excel models for quiet a while. could you send a copy to my email '' pwt2016 at gmail dot com '' , I'm really grateful for your kindness!

Aug 21, 2016 - 11:05am

Hello fellow Monkeys! As with many of us, I am using the Rosenbaum text to expand my knowledge. I thought it would be a good idea to create a group for this where we can exchange information.

Here is the link: http://www.wallstreetoasis.com/group/investment-banking-valuation-leveraged-buyouts-and-mergers-acquisitions

Aug 21, 2016 - 11:07am

Hello fellow Monkeys! As with many of us, I am using the Rosenbaum text to expand my knowledge. I thought it would be a good idea to create a group for this where we can exchange information.

Here is the link: http://www.wallstreetoasis.com/group/investment-banking-valuation-leveraged-buyouts-and-mergers-acquisitions

Aug 21, 2016 - 11:18am

Rosenbaum excel models (Originally Posted: 06/19/2014)

Hi!

Just bought a used copy of Investment Banking by Rosenbaum & Pearl.
However the excel spreadsheet's aren't available on wiley anymore for 1st edition.

I want to use it to build a base model for valuation, and as I get better add more layers and simulation tools to the model.

Would anyone be so kind as to send me the files?

Aug 21, 2016 - 11:24am

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

Hey, how's your art career going?
Jul 9, 2017 - 7:08pm

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?

Mar 9, 2018 - 7:44am

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

Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (34) $348
  • Associates (183) $233
  • 2nd Year Analyst (105) $150
  • Intern/Summer Associate (95) $145
  • 3rd+ Year Analyst (26) $145
  • 1st Year Analyst (390) $132
  • Intern/Summer Analyst (317) $82