Answer should be in excel format.

Carlyle successfully completed its purchase of DuPont's DPC division in February 2013, for a purchase price of $5.153 billion. The acquisition was funded with a $1.227 billion equity contribution from Carlyle, with the balance of the purchase funded from debt (\$3.926 billion). In November 2014, DPC (now renamed Axalta) completed an IPO, selling a portion of its shares to the public. The shares not sold in the IPO continued to be owned by Carlyle. The full amount of the net proceeds of $926 million were paid to the pre-IPO shareholder (Carlyle), i.e. no proceeds were retained by Axalta). In December 2015, Carlyle sold an additional portion of the shares it owned on the open market, for proceeds of approximately $1130 million to Carlyle. In July 2016, Carlyle sold its remaining stake for $870 million DPC/Axalta's outstanding debt and estimated total equity value at the following dates were: a. What is the IRR to Carlye's investment in DPC? (you can use the XIRR function in excel, rather than the IRR function, to specify the dates of the cash flow; you can assume Feb 1, Dec 1, etc). b. What is the risk adjusted required rate of return on (levered) equity for each year of Carlyle's investment in DPC/Axalta? You can assume the following: The buyout occurred on Dec 31, 2012 (rather than Feb 2013), the IPO occurred on Dec 31 2014, and Carlyle sold its remaining stake on Dec 31, 2016 The debt and equity values given above are at the calendar year ends