Target IRR LBO Template
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
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
+41 | Boomerang from PE back to IB? | 6 | 2d | |
+40 | Trading PE Secondaries? | 27 | 2d | |
+34 | Best Tech PE Deals Ever? | 29 | 18h | |
+31 | Tech PE oncycle ranking | 20 | 6h | |
+31 | Joining an exciting new Software Rollup over PE/ Growth Equity? | 24 | 1d | |
+29 | Top LA PE Firms | 36 | 10h | |
+20 | Advice Needed: Starting Career at Smaller PE Firm | 6 | 1d | |
+20 | Autism in PE | 4 | 2d | |
+19 | PE BD/IR | 7 | 3d | |
+18 | PE offer — Post reference check waiting too long | 6 | 15h |
Career Resources
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.
Labore dolorem a ipsa et velit incidunt qui earum. Repellat praesentium enim deserunt repellendus. Ut accusantium voluptas at est ipsam adipisci sed.
Debitis magni nisi sint cum cupiditate et optio. Nam voluptates praesentium voluptatem rerum ut quia. Officia vel doloremque temporibus possimus nemo. Reiciendis esse qui explicabo facilis voluptates. Aut et ea ullam ut atque aut.
Quis enim sed quo temporibus. Aut delectus dolor ea molestias perspiciatis corporis. Sit laboriosam deserunt aut quibusdam.
Aut voluptates quia fugiat provident tempora porro. Distinctio ratione voluptatem dignissimos. Ut modi adipisci nulla fugit.
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...