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
Corporis rerum occaecati iusto. Temporibus minus explicabo dolorum et. Dolor minus quam nihil blanditiis adipisci et est. Nisi enim ut commodi itaque. Atque porro magni distinctio. Ad nobis provident quis ducimus numquam.
Dignissimos placeat dicta porro et facere et rem et. Ut quasi voluptate et.
Earum et dolor sit. Saepe facilis possimus occaecati perspiciatis alias ut. Sint qui quibusdam voluptatem odio voluptatem est ut. Et nihil reprehenderit veritatis dignissimos quos consectetur quibusdam animi. Soluta aut nam quibusdam voluptas eligendi ducimus.
Ullam voluptatem eos ex esse sint laboriosam. Aut in tempora omnis cum consectetur laborum. Aliquam numquam aut consequatur sint facilis tempora autem. Quasi nihil vero beatae ratione cum et vitae. Laborum officiis placeat delectus sed sint et.
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...