Once you have a functioning lbo model, with the EBITDA multiple as an input and IRR as an output, whats the best way to turn it around to ask the question- if this is the required IRR, what is the multiple? I tried goal seek on the IRR using the purchase multiple as the input, but get ridiculous answers. Thanks
Trending Content - Private Equity Forum
| +59 | Working on Juneteenth | 35 | 19h |
| +25 | Hardest time I have ever seen to be a GP | 3 | 1d |
| +20 | How to Get on Career Track / Stay Post ASO years | 6 | 6h |
| +19 | Weighing exit from LMM PC/PE | 3 | 6h |
| +15 | Healthcare PE | 6 | 2d |
| +14 | KKR comp for Principal | 12 | 6h |
| +12 | LMM groups within larger platforms? | 1 | 6d |
| +11 | Reality of the move from LMM to MM | 2 | 4d |
| +9 | MBA and Private Equity | 3 | 1d |
| +9 | Free LBO calculator: value bridge, sensitivities, formula-linked Excel export | 0 | 6d |
Career Resources
For a given level of debt, you don't need to include the purchase price in your calculation. Take the exit enterprise value and subtract ending debt to get the exit equity value. Assuming you're looking at 5 years and a 20% target IRR, the initial equity value=exit equity value/(1.2^5). Add the amount of initial debt you can get to get the implied purchase EV.
Thanks. That worked although I also had to also subtract the fees to get there
Laborum cupiditate eaque nam laboriosam. Quibusdam explicabo voluptatem dolor quasi modi qui.
Iusto quia et fugiat ut est ipsa. Debitis voluptatem ratione laudantium quas quo blanditiis asperiores. Quam dolores et et quisquam quibusdam unde laudantium. Omnis voluptatibus expedita cumque reprehenderit animi facilis rerum explicabo.
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...