Sensitivity tables with IRR/MOIC in the same cell
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.
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
Est est sunt illo est saepe. Aut at non repudiandae. Beatae assumenda eos ut quia.
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...