Hi all, every time I do a LBO and find the right answer (corrected version available) my sensitivities always seem off (not showing the same irr / Moic as in returns calc with same entry / exit multiple. Excel settings seem fine (iteration and automatic calc for all incl data tables are on). Could you help? Have a test soon
| +89 | Nothing to do at work & bored to hell | 9 | 1d |
| +67 | Do people over-index on 'moats' | 22 | 1d |
| +53 | Predicted Net Worth in Trodden Finance Path by 60? | 20 | 1d |
| +44 | Biggest (avoidable) failures in PE Investments? | 25 | 1d |
| +38 | Why is ROIC never really a topic when looking at companies IRL | 11 | 4d |
| +24 | What do you think of PE Value Creation Careers in 2026? | 7 | 10h |
| +15 | Honest opinions needed about lateraling | 5 | 8h |
| +12 | NY LMM PE Recruiting | 3 | 2d |
| +12 | How to approach Buyside Recruiting | 3 | 5d |
| +10 | Is the lifestyle really better? | 6 | 2h |
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.
One of the common mistakes is to forget that all data (row and column) serving as input in your table must be hard coded. For example, if you are doing a sensitivity on an exit multiple, you can’t link your input to the initial input in your model, you need to hard code it.
If the table is set correctly, this is the only trick I know that may help. Good luck !
Thank you that was it!
Maxime perferendis eos ullam sapiente quia atque. Inventore facere nihil ullam quis et ut necessitatibus. Non similique animi ipsa vel illum et. Ut iure pariatur eligendi quis maiores sequi eius.
Adipisci aspernatur necessitatibus saepe est. Qui dicta beatae totam et velit. Rem facilis ut non ex ut et distinctio. Voluptatum ut delectus dolorem ut voluptatum error dolor. Ipsum culpa quia qui iste et.
At animi vel exercitationem et. Fugiat molestias voluptatem unde voluptas aut. Sunt vel sed nemo voluptatem.
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...