The MZ Mortgage Company is issuing a CMO with three tranche

The MZ Mortgage Company is issuing a CMO with three tranches. The A tranche will consist of $40.5 million with a coupon of 8.25%. The B tranche will be issued with a coupon of 9% and a principal of $22.5 million. The Z tranche will carry a coupon of 10% with a principal of $45 million. The mortgages backing the security issue were originated at a fixed rate of 10% with a maturity of 10 years (annual payments). The issue will be over collarteralized by $4.5 million, and the issuer will receive all net cash flows after priority payments are made to each class of securities. Priority payments will made to the class A tranche and will include the promised coupon, all amortization from the mortgage pool, and interest that will be accrued to the Z class until the principal of $40.5 million due tot he A tranche is repaid. The B class securities will receive interest only payments until the A class is repaid, and then will receive priority payments of amortization and accrued interest. The Z class will accrue interest at 10% untill both A and B classes are repaid. It will receive current interest and principal payments at that time.a. What will be the weighted average coupon on the CMO when issued?b. What will be the maturity of each tranche assuming no prepayment of mortgages in the pool?c. What will be the WAC at the end of year 3? Year 4? Year 8?d. If class A, B, and Z investors demand an 8.5%, 9.5%, and 9.75% yield to maturity, respectively, at the time of issue, what price should MZ Mortgage Company ask for each security? How much will the company receive as proceeds from the CMO issue?e. What are the residual cash flows to MZ? What rate of return will be earned on the equity over collateralization?*Please show all work. If calculated in Excel, please show how you arrived at all answers (formulas included, not just spreadsheet with answers)