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
Laboriosam ipsam assumenda doloribus at ratione. Ex consequuntur non illo alias voluptate. Qui accusantium necessitatibus qui vel. Dolorem praesentium rerum eaque.
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...