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.
Comments (62)
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.
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.
Guys, the DCF model is available from scribd website. The LBO can be downloaded from Docstock. Sorry for not attaching the links, but I'm new here and WSO's policy won't allow me to do that.
Hopefully that helps!
Actually, scribd has all the templates - PM me, I can send it to you. Also, actually creating them by yourself is a great practice for learning excel and the models inside out
Is scribd free? I sent a pm
-

- Learn more
- | Suggested Resource
Learn More300+ 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 moreHey...I will be grateful if you can send me all the models as well.
Thanks in advance.
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!
Hi!
Can you please send me the templates ?
Here is my email: youssef.agradATgmail .com
Many thanks in advance
Hi! Could you also send me the templates, please?
jonesmansurATgmailDotcom
Thanks a lot!
Hi,
Could you send me the Templates and Completed Models, would be greatly appreciate.
shajithebraveheartATgmailDotcom
Hi Therock
Can you please PM me your email Id because I really need those Templates and Completed Models. I have to prepare myself for interview, I will be highly thankful to you
Would you please share the templates with me. Thanks!
could you PM?
hi can you share the templates of version 2 ? I am looking for Merger Consequence Analysis template, thanks a lot
Please, can you also send to me? I sent you PM.
Could you send me the templates? Thanks
Hi! Could you also PM me the templates, please?
Rosenbaum Example Excel Models (Originally Posted: 04/02/2013)
Am I missing something or does Rosenbaum not have a PGM calculation in his example DCF model. Is it typical not to have this calculation in your DCF model?
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
Rosenbaum 2nd Edition Models (Originally Posted: 06/12/2013)
Does anyone have the first or second edition models? I'm imagining there won't be that big of a difference between the two?
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
hello, can you please PM me the models if you have them? Would be greatly appreciated
Could you please PM me with the models as well? Thanks so much!
I just purchased the 2nd edition and expected the models to be included and they are not any chance you could help me out?
Hello, can you please PM me the models if you have them? Would be greatly appreciate
Could you also PM me the templates, please?
Thank you so much!
If you could PM the models to me as well, that would be great.
hey could you pm me the models?, its would be much appreciated!
I'm in the same boat. Would appreciate the models as well.
Would you mind PM me as well? Would be highly appreciated!
would appreciate the models as well. Thanks
Would appreciate the 2nd edition models as well, please! Trying to sharpen the skills before starting.
I too would like to add to the litany of summons for 2nd edition models. I would have actually bought the more expensive option, but doing so after buying the normal book seems excessive.
I'd be immensely grateful if anybody could pm me them!
Would appreciate the models as well please :) would be awesome!
Hi Gerry_Garner
Please send me the First Edition Templates and Completed Models or you can PM me your ID
Thanks in advance
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?
Hey there, I'm also interested in these spreadsheets as well, were you able to get them by any chance?
Do a search, there's a lot of models uploaded to Scribd
could anyone email me the models?
bump
Excel Models from Pearl & Rosenbaum Investment Banking??? (Originally Posted: 12/01/2014)
I am a 1st edition owner, so I am somewhat screwed by not having access to the excel models from Investment Banking anymore. Can any one of you monkeys send them to me?
Cheers
I have the same problem -- if anyone has them readily available, I would appreciate getting the files
You can grab a bb model from investmentbankingmodels[dot]com
Could someone send me the template please too? I would greatly appreciate that.
Could someone send me the template please too? I would greatly appreciate that.
Could someone send me the template please too? I would greatly appreciate that.
same. would greatly appreciate it!
I need them too guys if anyone has a link send it my way please!! Thanks
Hey, could you send me the template as well please? I would really appreciate it!
Have an interview coming up and will really appreciate if someone could send me the completed models. Thanks!
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?
Hey were you able to get the excel files? I'm in the same boat as you and was wondering if you could pass them along. PM'd you
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
These are for the first edition tho :(
Edit: My bad I didn't notice the title was for the first edition
Hey, could anyone share the models for the 2nd edition please? Would be much appreciated, thanks!
Bump
Did you find them? Also interested
bro just open excel and recreate them
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Want to Unlock by signing in with your social account?
No more fortnite
No more fortnite