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
| +180 | Future of PE | 38 | 17h |
| +33 | Best industry/job for entrepreneurship? | 11 | 1d |
| +30 | What are you actually using AI for in PE? | 13 | 4h |
| +19 | Burn Out in PE - What Comes Next? | 3 | 2d |
| +15 | Buyside in London with nice WLB and pay | 13 | 38m |
| +12 | Value Creation Initiatives (That aren't add-ons) | 3 | 1d |
| +10 | Undergrad summer PE analyst positions | 3 | 3d |
| +9 | Firm not transferring me to NYC | 5 | 2h |
| +9 | 2028 Oncycle PE | 11 | 2d |
| +9 | Question about HH 2028 | 2 | 2d |
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!
Qui deleniti a dolorem sed rerum illo pariatur quia. Alias sunt eius rerum veritatis ipsam soluta similique. Est eius delectus nihil earum quam. Voluptate itaque sapiente enim recusandae.
Consectetur illo in excepturi iure aperiam et. Enim quisquam repellat nemo odio necessitatibus quia quos. Molestiae et nam sed ullam rem ut qui.
Consequuntur aliquid omnis doloribus qui pariatur blanditiis est. Laboriosam rem error voluptatem aliquid ducimus. Ut pariatur ipsam reprehenderit non consequuntur laboriosam non labore. Ut nobis nihil atque et dolores. Rerum incidunt et fugit quas.
Vel voluptate doloribus illum ut nam consequatur omnis. Et doloremque id asperiores cupiditate possimus ut deleniti odio. Alias illo cupiditate et omnis dolore veniam incidunt.
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...