In the attached Excel spreadsheet, complete the private equity fund cash flows and calculate the following. Assume the cash flows are for a Primary Fund Commitment deal, with a Make-Whole provision for LPs (i.e. LP capital is paid back first before the GP can receive any distributions). The management fee is 2% per year based on the committed capital and the profits are distributed in an 80/20 split to LPs and GP. Calculate the following and show the work in Excel:

Cash flows to LPs

Cash flows to GP

SI-IRR for LPs

Net TVPI to LPs

NPV to LPs (assuming a 15% discount rate)

NPV Income to GPs (assuming a 15% discount rate)