In need of a sample of lbo model. Got a 'financial modelling' round of interviews next week. Don't know how to prepare for it. Coming from the consulting world, so, a bit worried. Would appreciate any industry-standard LBO model. My email is RUSLAN.DER (at) HOTMAIL (dot) COM. Thank you in advance! Ruslan
| +65 | Ex Apollo Associate Q&A (But I Actually Answer) | 104 | 15m | |
| +42 | How to Model SaaS Projections for Interviews | 49 | 22h | |
| +37 | Q&A - Anything about PE / MBA / Life | 55 | 1m | |
| +35 | [Technical doubt]: Cash sweep and mandatory amortization | 9 | 9h | |
| +23 | European Megafunds (based on PEI 2023) | 17 | 2d | |
| +22 | Partners Group Long Term | 8 | 20h | |
| +22 | Is internal reporting at most funds really so Excel & PPT heavy still? | 8 | 4h | |
| +18 | Advent NYC Culture/WLB - 2024 update | 8 | 4s | |
| +18 | How is your life in PE? | 11 | 13m | |
| +17 | Moving from PE Fund accounting to top 3 rating agency | 5 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
http://www.wallstreetoasis.com/forums/full-blown-lbo-and-operating-model
sample lbo model IRR lever, best one? (Originally Posted: 01/19/2014)
In Figure 3.0, we see an IRR of approximately 14% to the private equity sponsor. This deal was done at a 3.0x Leverage Ratio and the company was acquired for a 25% premium, with an implied EBITDA purchase multiple of 7.4x. While a 14% IRR is not bad, typically private equity firms aim for higher returns than this. Based on these numbers and the calculations shown above, what do you think is the most REALISTIC way to boost the IRR to the sponsor in this model? a. Reduce the purchase premium so that the PE firm pays a lower purchase EBITDA multiple and therefore earns a higher return since it invests less equity in the beginning. b. Increase the exit EBITDA multiple – for a company of this size growing at this rate, it’s reasonable to assume a moderate level of multiple expansion by Year 5. c. Do a dividend recap in Year 3 or Year 4 – all else being equal, more leverage should always boost the IRR if the IRR is positive to begin with. d. Use more leverage initially, since a 3.0x Leverage Ratio is not very aggressive and the company can most likely support more debt
A - this is a lever you can actually pull that also reduces your exposure.
http://macabacus.com/
LBO sample models (Originally Posted: 02/24/2010)
I am trying to learn how to build accretion/dilution and advanced lbo models, would you be so kind share with me what you have, that would be tremendously helpful for me to prepare for my job. Thank you very much and I really really appreciate your help.
[quote=mathewp984]http://macabacus.com/[/quote]
definitely agree, a great website and a hidden gem... that walks you through a good lbo model... this is also a good one, along the same lines but should give you an idea at the different ways to approach an LBO model, both correct IMHO...
www.exinfm.com/excel%20files/LBO%20Model%20Template.xls
Also, try this as a good tutorial, which you can also download on the site:
http://www.macabacus.com/lbo-model/introduction
thank you very much guys anyone else
Increase leverage baby, anything less than 7x is for suckers
d) you might not realistically be able to buy the company for less agg purchase price but 3.0x leverage is low. you'll probably be able to lever up to 4.5x-5.0x which will definitely increase the IRR
This is PERFECT! Thank you both so much! Ruslan
+1
Generally agree with D but I also think most people can also agree that it depends on the company's ability to service higher leverage... In case you have info about the firm, estimate their debt service capacity. If they can take on higher leverage go with D, if they can't you're overpaying (A).
Thanks for sharing the great website: www.macabacus.com
Sorry, why are you people doing this guys homework for him?
*going forward i should disclose that it's now CFA revision time and i hate life / will procrastinate more on WSO.
thanks. oreos - not homework just came across this test online and it bothered me not to know the answer.
Starting 30 threads asking questions with multiple choice options is hardly just you inquiring.
Is this from the test that HSP is making banking analysts take?
Its called interview prep.
Voluptatibus facere quibusdam id sunt. Soluta non eaque velit velit asperiores. Quia pariatur ut cum ducimus nam.
Ab sapiente cupiditate rerum molestiae explicabo error. Nihil sit cupiditate nesciunt ducimus voluptatem similique. Ad iste quia ut. Neque consectetur exercitationem quo sed. Sint nostrum dolores dolores quia. Officiis est nihil quo blanditiis. Repellendus id inventore maxime quae.
Quis laboriosam dolores officiis voluptatum quos consequatur. Excepturi aut doloribus placeat eligendi maiores est dignissimos. Possimus deserunt et corrupti sed eveniet voluptas rerum. Sed consectetur eveniet aut ipsa vel et.
Aut quidem fugit error et pariatur. Praesentium atque placeat qui beatae unde suscipit.
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 Unlock with your social account...
Tenetur quos ullam perferendis veniam facere sit in. Eveniet ad sunt qui voluptas aliquid qui sapiente velit. Nisi quis saepe eius facere aut deserunt soluta.
Molestias atque aut labore odio voluptatum. Eaque aliquam in accusamus in vero sunt. Eveniet ut commodi cumque fugit aut dolorem omnis.
Possimus sed beatae ipsa quaerat adipisci. Ut dicta atque tenetur fuga iste et. Corrupti fugiat quo dolore repudiandae. Autem soluta cumque aut saepe officiis exercitationem.
Sed sit totam totam qui. Et accusamus sed possimus enim repellendus veniam quo. Sed dignissimos eligendi autem enim. Enim quo molestias quaerat cupiditate eveniet ut sed quis. Porro voluptas atque qui tempore voluptas cum.