How can I create a sensitivity table which output should be the exit multiple and the inputs ideally IRR and share price premium or entry multiple? I do not find a way to do so given even fixing IRR the NPV formula depends on entry and exit, so I do not know how to back solve the exit proceeds. Any insight would be much appreciated, thanks!
| +130 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 25 | 5h |
| +102 | Americas M&A League Table Q2 Updated | 49 | 6m |
| +73 | Wealthy Parents / Jaded | 24 | 1d |
| +58 | How are hours rn for SA (interns) | 31 | 20h |
| +54 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 11 | 19h |
| +49 | Venezuela Debt Restructuring - LAZ vs CVP | 22 | 1d |
| +42 | Boutique firm wants access to my LinkedIn? | 34 | 17h |
| +33 | Investment Banking in Mexico | 9 | 21h |
| +28 | MM bottom bucket bonus | 9 | 4d |
| +26 | Investment Banking is Hard | 11 | 15m |
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.
Eligendi optio sit id ut. Distinctio reiciendis ratione illo id. Ullam voluptatem soluta tenetur reprehenderit illo non corporis natus.
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...