PLEASE SHOW EXCEL WORK! THANK YOU

Assume the single month mortality rate of a mortgage (and the MBS) is 0.025 in the first month. We also have the following data regarding the MBS: Original balance: $10,000,000 Pass-through rate: 8.0% WAM: 180 months WAC: 9.0% What is the prepayment in the first month of the MBS? Assume the single month mortality rate of a mortgage (and the MBS) is 0.025 in the first month. We also have the following data regarding the MBS: Original balance: $10,000,000 Pass-through rate: 8.0% WAM: 180 months WAC: 9.0% What is the prepayment in the first month of the MBS