Question

In: Finance

Given a pool of 30 year fully-amortizing FRMs making monthly payments to investors with the following...

Given a pool of 30 year fully-amortizing FRMs making monthly payments to investors with the following characteristics: WAC: 6% Pass-through rate: 5.5% Prepayment assumption: 200 PSA Loans were not seasoned before entering pool This MBS has been active for a few years in collecting payments from borrowers and making payments to investors. It's currently month 26 in the pool.(t=26) Starting pool balance month in month 26: 72,534,232

What is the prepayment amount for month 26, and starting pool balance for month 27?

Solutions

Expert Solution

As the prepayments does not occur at the same rate always, Public Securities Association (PSA) and Conditional Prepayment Rate (CPR) are the two industry conventions adopted as benchmark for prepayment rates.

PSA: A prepayment benchmark which is expressed as a montly series of CPRs.

CPR: Annual Rate at which a Mortgage Pool is assumed to be Pre-paid during the life of the Pool.

Single Monthly Mortality Rate (SMM) = 1 - (1-CPR)1/12

SMM: When CPR is converted into monthly prepayment rate it is called Single Monthly Mortality rate.

For example: 20% SMM rate means, 20% of the Starting pool balance less scheduled payments, will be prepaid during the month.

Now realising the CPR for 100 PSA for a 30-year mortgages which is standard benchmark is as follows:

  • CPR = 0.2% for the first month after origination, increasing by 0.2% per month up to 30 months.
  • CPR = 6% for months 30 to 360

Therefore as in the question given, the CPR for 200 PSA for the month 26 is as follows:

CPR (month 26) = 26 x 0.2%= 0.052 (This is for 100 PSA)

CPR (month 26 for 200 PSA) = 2 x 0.052 = 0.104 or 10.4%

SMM = 1 - (1 - 0.104)1/12 = 1 - (0.896)1/12 = 1 - 0.99089 =0.00911 or 0.911%

Given Starting Pool balance : 72,534,232

Pre-payment for month 26 = 0.00911 x (72,534,232 - Scheduled Prepayment amount)

For Calculating the Scheduled Prepayment amount; we use excel formula with the following formula:

=-PMT(6/100,26, 72,534,232) = 5,578,198

Therefore the Prepayment for month 26 = 0.00911 x (72,534,232 - 5,578,198) = 6,069,969.5

The Starting Pool Balance for Month 27 = (72,534,232 - 5,578,198) - 6,069,969.5 = 60,886,064.5


Related Solutions

Given a pool of 30 year fully-amortizing FRMs making monthly payments to investors with the following...
Given a pool of 30 year fully-amortizing FRMs making monthly payments to investors with the following characteristics: Starting pool balance 250,342,967 WAC: 4% Pass-through rate: 3.45% Prepayment assumption: 75 PSA WAM: 357 (Loans seasoned for 3 months before entering pool) What is the regular payment in month 1, dollar amount of prepayment, total cash flow to the pool, total cash flow to investors, and ending pool balance for the month.
Given a pool of 30 year fully-amortizing FRMs making monthly payments to investors with the following...
Given a pool of 30 year fully-amortizing FRMs making monthly payments to investors with the following characteristics: WAC: 5% Pass-through rate: 4.5% Prepayment assumption: 300 PSA Loans were not seasoned before entering pool This MBS has been active for a few years in collecting payments from borrowers and making payments to investors. It's currently month 32 in the pool. Starting pool balance month in month 32: 54,234,988 What is the dollar amount of prepayment in month 32? CPR is ((300/100)*(0.06*32))/30...
Given a $7,500,000 pool of 10 year FRMs making annual payments with a 10% interest rate...
Given a $7,500,000 pool of 10 year FRMs making annual payments with a 10% interest rate a PO and IO class of securities is formed. What is the present value of the PO class if the market rate is 11%? Assume no prepayment, servicing fees, or defaults. Round to the nearest dollar.
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the the bank the balance, which mortgage has the lowest cost of borrowing (lowest annualized IRR)
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1 for...
Aann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Aann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 30 years, which mortgage has the lowest cost of borrowing
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage A? #2 IRR from mortgage B? I would like to know how to calculate the IRR of this in a BA II
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Assuming Ann makes payments for 30 years, what is Ann’s IRR from mortgage A? Note: IRR is always annualized. If you’ve found a monthly rate, multiply by 12. In this case, two digits for a monthly rate is not enough to avoid rounding errors in the annual rate...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. (A) Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage A? (B) Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage B? (C)...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage B?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT