Apr 1, 2015
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.
Private Equity Interview Course
- 2,447 questions across 203 private equity funds. Crowdsourced from over 500,000 mem.
- 9 Detailed LBO Modeling Tests and 15+ hours of video solutions.
- Trusted by over 1,000 aspiring private equity professionals just like you.
Wall Street Oasis Notifications
Please tell us a little bit more about yourself to send you the most relevant notifications
Get Notified?
Popular Content See all
- How was Investment Banking modeling done back in the day?Have always wondered this. Investment banks have been around long before excel - even back to the 80s and 90s - so how would investment banks and private equity firms create IPO pricing, valuations, LBOs, etc?
- Advice on HF RecruitingI figured that I'd give back/pay it forward in one form or another after being in the industry for a while. Frankly, the most relevant thing I could think of was advice on people searching for new opportunities. My advice is more tailored towards fundamental investing hedge fund recruiting...
- I work in event driven / arbitrage. Here are some career advice for youIt’s been a while since I’ve visited WSO. Yet in my early 20s, this was the place that I would often come to for information and guidance. In the spirit of giving back, I’ll share my story and a few nuggets of wisdom that I believe may help others who are also trying to strive in their...
- Parents [including celebs and various hot shots] indicted in college admissions test scamOuch... prestige attempts done the wrong way AND caught no less! Prosecutors filed charges against 33 parents, accused of paying between $200,000 and $6.5 million to get their children into elite universities. Those indicted include actresses Lori Loughlin and Felicity Huffman [actress and...
- Net debt: The definite listSince this topic comes up on WSO every now and then, I thought that it might help to collect everything in one list. The underlying definition is all "interest bearing liabilities". I will split it up into “positive items” and “negative items” which are subtracted. For some I...
- SA and Full Time Recruiting 2020 threadWanted to better organize the 2020 recruiting here instead of my previous post. @AndyLouis" Current 2020 SA Info: [quote="champagnepaki"] Not really. Sure the WSJ article from this past Fall brought awareness and the process will probably be a little slower this year, but...
- Bulge Bracket ER AMAI've been on buy side, currently bulge bracket ER. I've got a liberal arts undergrad in classics and non target MBA. Ask me anything, would like to help those in need. Best, nerd
- Anyone actually like their corporate development job? (Post -IB)I know most people exit to PE/HF (coming from my firm) and maybe 1-2 in each analyst class exit to corporate development. I myself also plan on exiting to PE but I've always been curious about corporate dev I know the positive to corporate development is actually getting your life back...
- AMA: 2.5 years @ MBB post PhDI appreciated the info I got from this forum when I was applying so figured I’d pay it forward. **** Briefly about me: * I am a PhD at an MBB in N Europe * Joined ~2.5 years ago as entry level (think BA/A/AC) * Now am an Associate/Consultant level * I have worked through...
- Financial & Valuation Modeling Boot-CampFinancial modeling is a skill that any investment banking analyst will have to master. Although the majority of investment banks and other financial firms now have formal training programs, many students and prospective finance professionals are choosing to enroll in self-study financial...
Leaderboard See all
| 1 |   | 97.4 |
| 2 | | 97.2 |
| 3 | | 97.1 |
| 4 | | 96.8 |
| 5 | | 96.8 |
| 6 | | 96.7 |
| 7 | | 96.6 |
| 8 | | 96.5 |
| 9 | | 96.5 |
| 10 | | 96.5 |
Upcoming EventsSee all
- Mar21
Comments (52)
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
Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.
Hey...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.agrad[at]gmail .com
Many thanks in advance
Hi! Could you also send me the templates, please?
jonesmansur[at]gmail[dot]com
Thanks a lot!
Hi,
Could you send me the Templates and Completed Models, would be greatly appreciate.
shajithebraveheart[at]gmail[dot]com
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
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-ba...
Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.
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-ba...
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
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
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)
Want to sign in with your social account?
Want to Vote on this Content?! No WSO Credits?
Join Us
Already a member? Login
Related Content
Popular Content
See all