Hi, would anyone be so kind to share an LBO model template using the target IRR method? So a version that is setup in such a way to find the initial price a sponsor could pay given required IRR / MOIC. Thank you in advance
| +50 | Future of PE | 14 | 9m |
| +25 | Hardest time I have ever seen to be a GP | 3 | 3d |
| +20 | How to Get on Career Track / Stay Post ASO years | 6 | 1d |
| +19 | Healthcare PE | 7 | 15h |
| +19 | Weighing exit from LMM PC/PE | 4 | 1d |
| +15 | KKR comp for Principal | 20 | 15h |
| +11 | Reality of the move from LMM to MM | 2 | 6d |
| +9 | MBA and Private Equity | 3 | 2d |
| +9 | LMM/MM PE London | 5 | 2d |
| +8 | Lindsay Goldberg FT 27 | 8 | 12h |
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.
Pretty unique ask. Would recommend taking a free WSO LBO template and building it to have that functionality. Most models are not driven off of a target return as the input
I am not very well versed in LBO modelling so would want to see how it's done first
X
Couldn't you just use the Goal Seek function?
Sorry for the dumb question but would you be able to write a quick walkthrough for how to implement that within the model so that it outputs the required initial price?
Essentially, I have a full LBO model that is built using an EBITDA entry and exit multiple but need to rebuild it so that it outputs the initial valuation given target IRR / MOIC. I am doing something wrong as the sponsor equity in the sources and uses schedule doesn't match the required initial investment based on Exit Year Sponsor Equity / MOIC. I.e. required sponsor equity in sources and uses is 315M while Exit Year Sponsor Equity / MOIC = 307.
Look for Ability to Pay analysis templates.
Quaerat non ut culpa autem odit commodi. Ut omnis rerum ullam amet voluptate quos alias sunt. Consequatur sequi reiciendis minus odio at. Vitae quam repellat velit suscipit nihil accusamus quisquam. Sint ex voluptatibus eum. Aut laboriosam eum aut debitis sed. Rerum et reiciendis dicta numquam quo fuga.
A quia labore enim. Ut perferendis sit nesciunt id quia similique. Aut ratione laborum in sunt distinctio voluptates. Cumque repudiandae id excepturi vero et laudantium sed in. Ut dolor molestias dolores perferendis adipisci. Quis sed hic voluptas et.
Ut illo sunt aut deleniti laudantium eum. Nobis debitis at nihil et repudiandae optio laboriosam. Qui molestiae possimus odit architecto ex quas explicabo deleniti. Molestias omnis mollitia aspernatur quia iusto expedita sunt. Accusantium ratione modi sit sit suscipit quas harum.
Blanditiis voluptas ullam odit at est amet provident. Ab quaerat reprehenderit tempora quis. Eos sit hic quia est tempore numquam dicta.
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...