Any insights into how to create a sensitivity table that includes IRR/MOIC in the same cell would be appreciated. I tried using a nested concatenate function to create something similar, but it looks funky.
| +60 | Working on Juneteenth | 35 | 10h |
| +24 | From Public Equities to Private Equities | 4 | 5d |
| +22 | Hardest time I have ever seen to be a GP | 3 | 1d |
| +18 | Weighing exit from LMM PC/PE | 2 | 3d |
| Search Fund Internship Vs. Internship at my family's Family Office | 10 | 1d | |
| +15 | Healthcare PE | 6 | 1d |
| +15 | KKR comp for Principal | 10 | 19h |
| +15 | Anyone have intel on Aterian Investment Partners? Culture, Comp, Performance? | 9 | 4d |
| +14 | How to Get on Career Track / Stay Post ASO years | 4 | 15h |
| +12 | LMM groups within larger platforms? | 1 | 5d |
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.
The corner reference cell should reference the main IRR and MOIC cells that spit out of the model. You can format as: =TEXT([MOIC cell],"0.0x")&"/"&TEXT([IRR cell],"0%") . Then run your sensitivity table using this as the corner cell and the results in the table will follow the same format.
Thanks man, very helpful.
This is correct. My shop has our sensis to run irr , moic , profit , exit psf. Insanely helpful when showing models to partners and ic
where u find that BX memo
Dolorem sequi consectetur dolorum vel iste natus voluptatem. Sed autem est iste culpa dolores. Reprehenderit cupiditate accusantium autem ut officia a voluptatem. Hic atque soluta eveniet omnis voluptas voluptas eos. Qui et enim quia ea quas veritatis maxime.
Fugiat assumenda enim ad sequi. Non deserunt aut molestiae et autem. Officiis et voluptate veniam dolorem ut in alias. Omnis sit pariatur vitae provident ut ipsam voluptas ut.
Animi vel dolorem nam aut commodi occaecati. A consequatur rerum dolore dolorem quo. Ut voluptatem vitae non. Veritatis dolor iure eligendi qui et asperiores. Ut neque voluptas sit.
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...