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
| +142 | What’s “the path” now? | 56 | 1d |
| +105 | Is Everyone Too Bearish on PE? | 34 | 6h |
| +48 | Why would anyone do PE in long term in 2026? | 13 | 1d |
| +37 | 3rd Year IB Analyst, Top Bucket, Still No PE Offer. What Would You Do? | 19 | 1d |
| +25 | Is This Normal in LLM PE | 10 | 5d |
| +24 | Q&A: What It’s Actually Like Working at an Independent (Fundless) Sponsor | 4 | 2d |
| +21 | UMM PE or High Paying Strat Finance? | 13 | 21h |
| +21 | Striking out in last rounds | 2 | 4d |
| +15 | Overwhelmed by amount of data / granularity | 3 | 2d |
| +15 | DELETE | 1 | 1d |
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.
Omnis consequatur omnis et omnis aut accusamus sit. Alias quia reprehenderit incidunt voluptatem. Consequatur ea nam voluptatem deserunt.
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...