Can you help me solve a case study in Buyout investing: Performance & Investor return: The VFF case

VFF (Very First Fund) is a fund launched in Jan 2009 which managed to raise 320 million $ in fund committed that has implemented its last exit in Jan 2018.

It had a straight forward fee structure: -1.5% yearly management fee on capital committed -0.5% transaction fee borne by acquired companies -20% carried interest rate applied to capital gains with a hurdle rate of 7% compounded yearly average -A Claw back provision so carried fees do not exceed 20% of total capital gain (taking into account the hurdle rate.) . Such provision would be taken into account when closing the fund

Use the data below for VFF and:

1. Compute the theoretical IRR for each Company
2. compute the after fee performance of VFF fund using the most common matrix (IRR, DPI, DCC)
3. Compute the MIRR for a limited partner that would have invested all non committed funds at an average rate of 5%. This rate will also apply to all distributed CF
4. What is your opinion on the fund performance?

Company	invested	acquisition date	Y1	Y2	Y3	Y4	Y5	Y6
A	30	2009	0	2	4	52
B	24	2009	0	0	3	5	49
C	68	2010	0	0	0	3	4	84
D	21	2011	0	0	2	2.5	3.5	55
E	13	2012	0	0	37
F	23	2012	0	0	2	3	35
G	28	2013	0	3	41
H	29	2013	0	0	0	2	36
I	34	2014	0	2	5	29