IF ANY INFORMATION IS MISSING PLEASE TELL ME SPECIFIC INFORMATION NEEDED

The $250M Arroyo Fund has completed its ten-year life. Its annual performance details are described in Q1 tab of hw2.xls. a. Compute the value multiple, realized value multiple, unrealized value multiple, and IRR for Arroyo after every year of its life. b. At the end of Arroyo Funds life, what is its final GVM and GP%? Show your calculations.

Q1

year 1 2 3 4 5 6 7 8 9 10 50.0 50.0 109.0 50.0 185.2 30.0 259.6 0.0 0.0 316.4 50.0 0.0 348.7 104.6 104.6 0.0 104.6 104.6 83.7 0.0 0.0 20.0 341.9 51.3 51.3 51.3 0.0 94.9 88.9 0.0 0.0 0.0 Investments portfolio value total returned capital returned capital to LPs cumulative returned capital to LP: carried interest port value after capital returned Management fee 0.0 0.0 292.9 29.3 29.3 185.2 0.0 263.6 5.0 0.0 232.5 116.3 93.0 367.1 23.3 116.3 5.0 0.0 0.0 0.0 0.0 155.9 0.0 50.0 5.0 0.0 109.0 5.0 0.0 185.2 5.0 0.0 259.6 5.0 0.0 290.6 5.0 0.0 244.1 5.0 274.1 6.0 221.5 5.0 450.8 20.9 0.0 5.0 Si year 1 2 3 4 5 6 7 8 9 10 50.0 50.0 109.0 50.0 185.2 30.0 259.6 0.0 0.0 316.4 50.0 0.0 348.7 104.6 104.6 0.0 104.6 104.6 83.7 0.0 0.0 20.0 341.9 51.3 51.3 51.3 0.0 94.9 88.9 0.0 0.0 0.0 Investments portfolio value total returned capital returned capital to LPs cumulative returned capital to LP: carried interest port value after capital returned Management fee 0.0 0.0 292.9 29.3 29.3 185.2 0.0 263.6 5.0 0.0 232.5 116.3 93.0 367.1 23.3 116.3 5.0 0.0 0.0 0.0 0.0 155.9 0.0 50.0 5.0 0.0 109.0 5.0 0.0 185.2 5.0 0.0 259.6 5.0 0.0 290.6 5.0 0.0 244.1 5.0 274.1 6.0 221.5 5.0 450.8 20.9 0.0 5.0 Si