Two Output Variable Data Table?
Hello! I am trying to create a two-variable data table showing two output variables. I have never seen one before but believe it would be very slick. Here is what I am trying to do:
Input variables would be hurdle rate and upside split. Output variables would be GP IRR and LP IRR. I am envisioning the two y variables side-by-side. Obviously this would help the GP negotiate terms with potential LPs.
Thoughts? Can this be done?
You'll have to create two separate data tables: one for GP IRR and one for LP IRR. You must use the same input numbers for both sides of each data table. You can then use text functions (like stringing the cells together from both tables with an "&") to show one table that has both GP and LP IRR in each output cell. We'll usually show it as: MOIC/IRR in each cell, so:
3.0x / 25.0%
for example. make sense?
You don't necessarily need to do what Bass12 mentioned, though that is a solution. The following method will reduce the number of data tables in your file and thus (hopefully) speed it up a bit when you go to refresh.
In the upper left-hand corner cell where you put your link, type =TEXT([reference to IRR],"0.0%;(0.0%)")&" / "&TEXT([reference to IRR 2],"0.0%;(0.0%)")
This will cause each cell to have the contents "X% / Y%" while preventing you from needing to make 2x the number of tables.
Hope that helps
Molestiae iusto dolorem quasi. Voluptas mollitia voluptate voluptas eum aperiam. Eos quo corporis aspernatur voluptatum. Sunt nostrum illum impedit dolor deserunt aliquid hic.
Voluptatem voluptas voluptatibus velit rem recusandae. Sed culpa necessitatibus quam ipsam excepturi nostrum velit. Officiis sint ab iste velit omnis quaerat. Itaque non earum aperiam omnis.
Dolore iste maxime inventore aut voluptas impedit eligendi. Odit ut nemo illum perferendis.
Omnis vitae labore aut repudiandae. Temporibus expedita est quia velit at.
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...