Please show in excel with formulas. A closed-end, commingled opportunity fund is being created with an expected three-year life. It expects to acquire properties that it expects to turnaround and sell at the end of three years for a gain. It also plans a minimum target return of 10 percent to investors, which will be based on cash distributions from operations and from the sale of properties at the end of the life of the fund. The opportunity fund manager expects to receive a promote equal to 25 percent of cash flows remaining after sale of the assets and after equity investors receive their minimum 10 percent target return. Cash flows are expected as follows:

	Equity Investment	Cash Distributions from Operations to Equity Investors (After Management Fees)	Expected Sale Proceeds
Year 0	$ 3,000,000
Year 1		$ 100,000
Year 2		100,000
Year 3		100,000	$ 4,000,000

Required:

a. What must be the cash flows to equity investors at the end of year 3 in order to achieve their total target 10 percent return on equity investment?

b. How much of the proceeds from property sales must the fund manager receive in order to earn its 25 percent promote?

c. After the equity investors earn their 10 percent target return (IRR) and the fund manager earns the 25 percent promote, how much will be distributed to equity investors?