Urgent! Please Reply Quickly!

How to recreate this table in excel?

Question 14 Reproduce the following table in Excel. In yellow are the inputs, in blue are the formulas. O Fund Size: Term (years): Management fee: Carry: Deals: 200 // 200/5 = 40 = contribution every year for 5 years 10 0.02 0.015 2% on commitment (200M) during 4 years investment period, 1.5% on (invested capital+realized capital) thereafter 20% 2 per year a $20m with 4y until exit 2 6 7 8 9 10 1 - 40 3 -40 4 -40 -40 Year Invested capital Realized capital Management Fee Carried Interest 5 -40 80 -2.4 1 80 80 -1.8 80 -0.6 -4 -200 400 -20.8 -40 -4 -4 80 0 -16 -4 SUM: SUM: SUM: 0 0 0 -8 -16 Gross return -40 -40 -40 -40 40 80 80 80 80 SUM(GAIN): Mom: IRR: 200 2 18.9% CF to Investor -44 -44 -44 -44 37.6 78.2 71.4 64 64 SUM(GAIN): MOM: IRR: 139.2 1.696 13.5% From the reference book Exhibit 19.3: IMPACT OF COST ON NET RETURNS COMMENTS STRONGLY SIMPLIFIED EXAMPLE! Fund Size 15m): 200 Term (years): 10 Management fee: 2 on commitment during 4y investment period, 1.5% on invested capital thereafter. Carry 20% of European style 'All Capital First structure thurdle rates and catch-up not relevant as fundin example comfortably exceeds hurdle) Deals 2 per year a $20m with 4y until exit 6 7 8 9 YEAR INVESTED REALIZED 1 2 3 4 5 40 40 40 40 40 80 o Equal time distribution of of investment & distributions Early win would impact IRR and timing for carried interest Management fee drops substantially after year 5, building a successful GP franchise requires new fund raised by this time, 80 80 80 80 4 4 MANAGEMENT FEE CARRIED INTEREST -24 0 -18 0 -12 8 -0,6 0 SUM - 16 - 16 SUMO 40 GROSS RETURN 40 40 -40 -40 40 80 80 80 80 200 SUM (GAIN: MOM: IRR 18.9% First carry flows in year 7! Cost to investor about 5.5% p.a. or 0.31x MOM NET OF TO INVESTOR 44 44 44 376 782 708 634 64 SUM (GANO MOM: IRR 138 1.69 13.4%