Solve it by excel Please .. VERY IMPORTANT AND URGENT BEFORE SATURDAY
Michael Hornsby, CFA, is a Senior Investment Officer at Icarus, a UK-based institutional investor in private equity. He is contemplating an investment in Europa Venture Partners III, a new late stage technology venture capital fund, after a thorough due diligence performed on the fund and an updated due diligence on the GP. Icarus has been an investor in Europa Venture Partners' (EVP) previous two funds, EVP I and EVP II. Icarus has been satisfied with the performance of EVP so far and is seeking to further expand its relationship with this GP because Icarus considers it a niche venture capital firm operating in a less crowded segment of the pan- European technology markets. As a result of its success, EVP decided to increase its carried interest for the third fund to 25 percent from 20 percent for the previous two funds. Hornsby has received the information about the fund's financial performance and is seeking assistance in calculating and interpreting financial performance for a number of specific queries as outlined below. Europa Venture Partners (EVP) General Partner Europa Venture Partners (EVP) was established to provide equity financing to later stage technology companies in need of development capital across Europe. The GP seeks to provide strategic support to seasoned entrepreneurial teams and bring proven new technologies to the market. The GP targets investment in portfolio companies between 2 million and 10 million. Established in 1999 Type: Development Capital Actual Fund Size ( Vintage Millions) 2001 125 Capital Mgmt Called Fees (%) (%) 922 Fund EVP Carried Interest (%) 20 Hurdle Rate (%) Report Term Date 2009 31 Dec 2006 2012 31 Dec 2006 EVP 2003 360 48 Financial performance for investments by Icarus in EVP funds Committed Capital ( Millions) Capital Called Down Fund Gross IRR (%) 16.1 1.6 Net IRR (%) 11.3 (0.4) 9.2 DPI RVPI TVPI (X) (X) (X) 1.26 1.29 2.55 0.35 1.13 1.48 EVPI EVP Quartile 1 2 25 12.0 Hornsby also is interested in verifying management fees, carried interest, and the NAV of EVP I. He has the following information about yearly capital calls, operating results, and distributions. Calls, Operating Results, and Distributions ( Million) Called-down Realized results Unrealized results Distributions 2001 2002 2003 2004 50 15 10 25 0 0 10 35 -5 -15 15 10 - - - 25 2005 2006 105 40 80 15 25 45 75 Operating results correspond to the sum of realized results from exits of portfolio companies and of unrealized results from the revaluation of investments held in portfolio companies. In addition to the information available on EVP I, Hornsby also knows from the fund prospectus that the distribution waterfall is calculated according to the total return method following the first alternative, i.e., the GP receives carried interest only after the fund has returned the entire committed capital to LPs. Management fees are calculated on the basis of the paid-in capital. Hornsby also wants to calculate DPI, RVPI, and TVPI of EVP I for 2006 and is interested in understanding how to calculate gross and net IRRs. 1. Interpret and compare the financial performance of EVP I and EVP II. 2. Based on the information given, calculate the management fees, carried interest, and the NAV of EVP I. Also calculate DPI, RVPI, and TVPI of EVP I for 2006. Explain on the basis of EVP I how gross and net IRRs are calculated, and calculate the gross and net IRRs. Michael Hornsby, CFA, is a Senior Investment Officer at Icarus, a UK-based institutional investor in private equity. He is contemplating an investment in Europa Venture Partners III, a new late stage technology venture capital fund, after a thorough due diligence performed on the fund and an updated due diligence on the GP. Icarus has been an investor in Europa Venture Partners' (EVP) previous two funds, EVP I and EVP II. Icarus has been satisfied with the performance of EVP so far and is seeking to further expand its relationship with this GP because Icarus considers it a niche venture capital firm operating in a less crowded segment of the pan- European technology markets. As a result of its success, EVP decided to increase its carried interest for the third fund to 25 percent from 20 percent for the previous two funds. Hornsby has received the information about the fund's financial performance and is seeking assistance in calculating and interpreting financial performance for a number of specific queries as outlined below. Europa Venture Partners (EVP) General Partner Europa Venture Partners (EVP) was established to provide equity financing to later stage technology companies in need of development capital across Europe. The GP seeks to provide strategic support to seasoned entrepreneurial teams and bring proven new technologies to the market. The GP targets investment in portfolio companies between 2 million and 10 million. Established in 1999 Type: Development Capital Actual Fund Size ( Vintage Millions) 2001 125 Capital Mgmt Called Fees (%) (%) 922 Fund EVP Carried Interest (%) 20 Hurdle Rate (%) Report Term Date 2009 31 Dec 2006 2012 31 Dec 2006 EVP 2003 360 48 Financial performance for investments by Icarus in EVP funds Committed Capital ( Millions) Capital Called Down Fund Gross IRR (%) 16.1 1.6 Net IRR (%) 11.3 (0.4) 9.2 DPI RVPI TVPI (X) (X) (X) 1.26 1.29 2.55 0.35 1.13 1.48 EVPI EVP Quartile 1 2 25 12.0 Hornsby also is interested in verifying management fees, carried interest, and the NAV of EVP I. He has the following information about yearly capital calls, operating results, and distributions. Calls, Operating Results, and Distributions ( Million) Called-down Realized results Unrealized results Distributions 2001 2002 2003 2004 50 15 10 25 0 0 10 35 -5 -15 15 10 - - - 25 2005 2006 105 40 80 15 25 45 75 Operating results correspond to the sum of realized results from exits of portfolio companies and of unrealized results from the revaluation of investments held in portfolio companies. In addition to the information available on EVP I, Hornsby also knows from the fund prospectus that the distribution waterfall is calculated according to the total return method following the first alternative, i.e., the GP receives carried interest only after the fund has returned the entire committed capital to LPs. Management fees are calculated on the basis of the paid-in capital. Hornsby also wants to calculate DPI, RVPI, and TVPI of EVP I for 2006 and is interested in understanding how to calculate gross and net IRRs. 1. Interpret and compare the financial performance of EVP I and EVP II. 2. Based on the information given, calculate the management fees, carried interest, and the NAV of EVP I. Also calculate DPI, RVPI, and TVPI of EVP I for 2006. Explain on the basis of EVP I how gross and net IRRs are calculated, and calculate the gross and net IRRs
