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!
| +143 | Piper Sandler in talks to acquire PWP | 65 | 42m |
| +135 | Just One More Year | 11 | 2d |
| +129 | Interns without return offers, careers & perspective | 11 | 1d |
| +115 | UBS Appears to be Exploring Sale | 16 | 3h |
| +83 | Are all these UBS postings bullshit? | 21 | 1d |
| +79 | Bringing Deals as a Vice President | 25 | 1h |
| +73 | Paradise Is Paradise | 5 | 1d |
| +38 | Q&A | Investment Banking Analyst, UBS | 2 years in investment banking | 11 | 2d |
| +32 | M&A is Paradise | 1 | 2d |
| +31 | Will they pay Directors $1mm+? | 14 | 3d |
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.
Sunt reprehenderit ratione aut dicta. Nam laboriosam et consequatur optio. Ut distinctio expedita rerum labore ex.
Assumenda fugiat rerum quod doloremque dignissimos aspernatur consequatur. Odit enim quia aut ad quia et ad.
Commodi rerum assumenda natus similique non et qui. Earum fugiat a sit voluptatibus est. Quia vitae quasi eos. Ad et qui qui in sed incidunt.
Autem vel culpa sit voluptates blanditiis voluptatem saepe. Odit autem aut provident suscipit.
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...