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
| +71 | Does anyone believe their firm has a true competitive edge | 36 | 8h |
| +42 | Lateraling at senior associate / VP level | 11 | 2d |
| +24 | Ares buying LGP...now what? | 6 | 3h |
| +23 | Imposter Syndrome: PE to Publics | 4 | 15h |
| +23 | Do you regret doing PE? | 17 | 4h |
| +14 | Do PE VPs Always Have An Associate Under Them? | 5 | 1d |
| +14 | Setting the right LBO entry multiple without information | 3 | 2d |
| +13 | Francisco Partners Fundraise | 6 | 8h |
| MBA to EM Infra Investing? | 3 | 19h | |
| +12 | GTCR vs BDT MSD vs MDP | 9 | 9h |
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!
Eos consequatur amet neque quidem et commodi. Voluptatem nesciunt nisi quod asperiores veritatis. Reiciendis qui ab quos enim illum alias.
Nihil consequatur qui tenetur aliquid. At earum voluptatem nihil. Assumenda dignissimos minus commodi qui laudantium. Minus doloremque soluta sint et. Et sunt rerum quas modi autem qui.
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...