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
| +88 | Nothing to do at work & bored to hell | 10 | 3h |
| +67 | Do people over-index on 'moats' | 22 | 2d |
| +54 | Predicted Net Worth in Trodden Finance Path by 60? | 20 | 2d |
| +44 | Biggest (avoidable) failures in PE Investments? | 25 | 2d |
| +25 | What do you think of PE Value Creation Careers in 2026? | 7 | 1d |
| +19 | LT Career Path after MF PE Associate Program? | 5 | 1d |
| +17 | Is the lifestyle really better? | 15 | 1h |
| +12 | Reference checks after final round | 1 | 2h |
| +12 | Those who left PE for Corporate, why? | 5 | 2h |
| +12 | NY LMM PE Recruiting | 3 | 3d |
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.
Vel voluptatem officiis itaque exercitationem. Temporibus ipsam numquam voluptates aut expedita maxime architecto. Quod eos sequi qui nostrum.
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...