ems+Answers.pdf (162 KB) 143. A pool of mortgages currently valued at $1.5 million is structured as...

Transcribed Image Text:

ems+Answers.pdf (162 KB) 143. A pool of mortgages currently valued at $1.5 million is structured as a three-tranche sequential pay collateralized mortgage obligation (CMO), where the junior tranche C does not receive any principal payments until both the senior tranche B and the super-senior tranche A are fully paid off, the senior tranche B does not receive any principal payments until the super-senior tranche A is fully paid off, and where each tranche is one-third of the size of CMO. The interest rate is 6%, mortgage payments are fixed and paid monthly, and the remaining term to maturity is 12 months. Model cash flows from this mortgage pool for the remaining term for each tranche by creating a table with the following columns: (1) month, (2) interest paid to tranche A (IPA), (3) interest paid to tranche B (IB), (4) interest paid to tranche C (IPC), (5) principal paid to tranche A (PPA), (6) principal paid to tranche B (PPB), (7) principal paid to tranche C (PPC), (8) ending principal for tranche A (EPA), (9) ending principal for tranche B (EPB), (10) ending principal for tranche C (EPC). Assume no servicing fee and no prepayments. 144. A pool of mortgages currently valued at $1 million is structured as a two-tranche sequential pay collateralized mortgage obligation (CMO), where the junior tranche B does not receive any principal payments until the senior tranche A is fully paid off, and where both tranches are of equal size. The interest rate is 12%, mortgage payments are fixed and paid monthly, and the remaining term to maturity is 6 months. Model cash flows from this mortgage pool for the remaining term for each tranche by creating a table with the following columns: (1) month, (2) interest paid to tranche A (IPA), (3) interest paid to tranche B (IPB), (4) total interest paid (IPT), (5) principal paid to tranche ems+Answers.pdf (162 KB) 143. A pool of mortgages currently valued at $1.5 million is structured as a three-tranche sequential pay collateralized mortgage obligation (CMO), where the junior tranche C does not receive any principal payments until both the senior tranche B and the super-senior tranche A are fully paid off, the senior tranche B does not receive any principal payments until the super-senior tranche A is fully paid off, and where each tranche is one-third of the size of CMO. The interest rate is 6%, mortgage payments are fixed and paid monthly, and the remaining term to maturity is 12 months. Model cash flows from this mortgage pool for the remaining term for each tranche by creating a table with the following columns: (1) month, (2) interest paid to tranche A (IPA), (3) interest paid to tranche B (IB), (4) interest paid to tranche C (IPC), (5) principal paid to tranche A (PPA), (6) principal paid to tranche B (PPB), (7) principal paid to tranche C (PPC), (8) ending principal for tranche A (EPA), (9) ending principal for tranche B (EPB), (10) ending principal for tranche C (EPC). Assume no servicing fee and no prepayments. 144. A pool of mortgages currently valued at $1 million is structured as a two-tranche sequential pay collateralized mortgage obligation (CMO), where the junior tranche B does not receive any principal payments until the senior tranche A is fully paid off, and where both tranches are of equal size. The interest rate is 12%, mortgage payments are fixed and paid monthly, and the remaining term to maturity is 6 months. Model cash flows from this mortgage pool for the remaining term for each tranche by creating a table with the following columns: (1) month, (2) interest paid to tranche A (IPA), (3) interest paid to tranche B (IPB), (4) total interest paid (IPT), (5) principal paid to tranche