Question

In: Finance

Consider the following tables: a. CPR Assuming month 100% PSA 70% PSA 320% PSA 1 4...

Consider the following tables:

a. CPR Assuming

month 100% PSA 70% PSA

320% PSA

1
4
27
40

b. SMM Assuming

Month 100% PSa 70% PSA 320% PSA
1
4
27
40

Complete the tables.

Solutions

Expert Solution

Conditional Prepayment Rate (CPR)

CPR is the annualized percentage of the existing mortgage pool that is expected to be prepaid in a year.

Single Monthly Mortality rate (SMM)

CPR is an annual rate. However, since the mortgage payments happen monthly we need to calculate the monthly prepayment rate. SMM is a measure of monthly mortgage prepayment rate of the security's mortgage pool

CPR assuming

Month 100% PSA 70% PSA 320% PSA
1 0.2% 0.14% 0.64%
4 0.8% 0.56% 2.56%
27 5.4% 3.78% 17.28%
40 6% 4.20% 19.20%

The PSA benchmark assumes the following CPR's for 30-year mortgages

a CPR of 0.2% for the first month, increased by0.2% per year per month for the next 390 months when it reaches 6%

and a 6% CPR for remaining years. This benchmark is called 100% PSA

If t less than or equal 30: CPR = 6%(t/30)

If t greater than 30 CPR = 6% where t is the number of months

For ex 75 PSA means .75 times of the PSA benchmark prepayment rate

320 PSA means 3.2 times of the CPR of the PS benchmark prepayment rate

With 100 PSA, we get below CPR values

Month1 : CPR = 6%(1/30) = 0.2%; 100 PSA = 1.00(0.2%) = 0.2%

Month4 : CPR = 6%(4/30) = 0.8% ; 100 PSA = 1.00(0.8%) = 0.8%

Month 27 : CPR = 6%(27/30) = 5.4% ; 100 PSA = 1.00(5.4%) = 5.4%

Month 40 : CPR = 6% ; 100 PSA = 1.00(6%) = 6.0%

With 70 PSA

Month1 : CPR = 6%(1/30) = 0.2%; 70 PSA = .70(0.2%) = 0.14%

Month4 : CPR = 6%(4/30) = 0.8% ; 70 PSA = .70(0.8%) = 0.56%

Month 27 : CPR = 6%(27/30) = 5.4% ; 70 PSA = .70(5.4%) = 3.78%

Month 40 : CPR = 6% ; 70 PSA = .70(6%) = 4.20%

With 320 PSA

Month1 : CPR = 6%(1/30) = 0.2%; 320PSA = 3.2(0.2%) = 0.64%

Month4 : CPR = 6%(4/30) = 0.8% ; 320 PSA = 3.2(0.8%) = 2.56%

Month 27 : CPR = 6%(27/30) = 5.4% ; 320 PSA = 3.2(5.4%) = 17.28%

Month 40 : CPR = 6% ; 320 PSA = 3.2(6%) = 19.20%

With 100% PS we get the below SMM values

SMM = 1 - (1-CPR)1/12

Month1 : CPR = 6%(1/30) = 0.2%; 100 PSA = 1.00(0.002%) = 0.002%

SMM = 1 - (1 - 0.002)1/12 = 1 - (0.998)0.83333 = 0.01668%

Month4 : CPR = 6%(4/30) = 0.8% ; 100 PSA = 1.00(0.008%) = 0.008%

SMM = 1 - (1 - 0.008)1/12 = 1 - (0.992)0.83333 = 0.06691%

Month 27 : CPR = 6%(27/30) = 5.4% ; 100 PSA = 1.00(.054%) = .054%

SMM = 1 - (1 - 0.054)1/12 = 1 - (0.946)0.83333 = 0.46154%

Month 40 : CPR = 6% ; 100 PSA = 1.00(.06%) = .06%

SMM = 1 - (1 - 0.06)1/12 = 1 - (0.94)0.83333 = 0.51430%

With 70 PSA

Month1 : CPR = 6%(1/30) = 0.2%; 70 PSA = .70(0.002%) = 0.0014%

SMM = 1 - (1 - 0.0014)1/12 = 1 - (0.9986)0.83333 = 0.01667%

Month4 : CPR = 6%(4/30) = 0.8% ; 70 PSA = .70(0.008%) = 0.056%

SMM = 1 - (1 - 0.0056)1/12 = 1 - (0.9944)0.83333 = 0.04679%

Month 27 : CPR = 6%(27/30) = 5.4% ; 70 PSA = .70(.054%) = .0378%

SMM = 1 - (1 - 0.0378)1/12 = 1 - (0.9622)0.83333 = 0.32059%

Month 40 : CPR = 6% ; 70 PSA = .70(.06%) = .0420%

SMM = 1 - (1 - 0.042)1/12 = 1 - (0.958)0.83333 = 0.35692%

With 320 PSA

Month1 : CPR = 6%(1/30) = 0.2%; 320PSA = 3.2(0.002%) = 0.0064%

SMM = 1 - (1 - 0.0056)1/12 = 1 - (0.9936)0.83333 = 0.05349%

Month4 : CPR = 6%(4/30) = 0.8% ; 320 PSA = 3.2(0.008%) = 0.0256%

SMM = 1 - (1 - 0.0256)1/12 = 1 - (0.9744)0.83333 = 0.21588%

Month 27 : CPR = 6%(27/30) = 5.4% ; 320 PSA = 3.2(.054%) = .01728%

SMM = 1 - (1 - 0.01728)1/12 = 1 - (0.8272)0.83333 = 1.56848%

Month 40 : CPR = 6% ; 320 PSA = 3.2(.06%) = .1920%

SMM = 1 - (1 - 0.1920)1/12 = 1 - (0.8080)0.83333 = 1.76092%

SMM assuming

Month 100% PSA 70% PSA 320% PSA
1 0.01668% 0.01167% 0.05349%
4 0.06691% 0.04679% 0.21588%
27 0.46154% 0.32059% 1.56848%
40 0.51430% 0.35692 1.76092

Related Solutions

For EACH of these tables, do the following, assuming that both countries are initially in autarky....
For EACH of these tables, do the following, assuming that both countries are initially in autarky. Note: Show ALL of your work! a. For each good, identify which country has an absolute advantage. b. For each country, calculate the opportunity cost of producing one more unit of cars. c. For each good, identify which country has a comparative advantage. d. EXPLAIN how international economic forces will influence the different businesses in each country when trade is allowed, stating clearly what...
Consider the following two demand segments: 120−4Q = P and 100−4Q = P assuming there’s a...
Consider the following two demand segments: 120−4Q = P and 100−4Q = P assuming there’s a constant marginal cost to serving either group, C(Q) = 60Q. 1. Find the optimal price, quantity and profits when the firm is able to practice third degree price discrimination. 2. Find the optimal price, quantity and profits when the firm is unable to practice third degree price discrimination. 3. Compute the price elasticity of demand associated with each optimal monopoly output in each segment....
Complete the following conversions using dimensional analysis 1. 320 pennies to number of nickels 2. 320...
Complete the following conversions using dimensional analysis 1. 320 pennies to number of nickels 2. 320 nickels to number of American dollars 3. 750cm to feet 4. 750cm to miles 5. 316nm to yards 6. 12 meters/seconds to miles/hour 7. $9.50/hour to pennies/day 8. 3.5 millimeters/min to liters/hour 9. 35 centimeters/day to meters/second 10. 35 meters/seconds to miles/year Please explain every step to help me better understand. Also, please, type out your responses so I can legibly read. Thank you...
Q.4  The following relationships hold in economy of Matata Island: ? = 320 + 0.4(? − ?)...
Q.4  The following relationships hold in economy of Matata Island: ? = 320 + 0.4(? − ?) ? = 150 ? = 275 ? = 200 a) Explain the concepts of marginal propensity to consume (MPC) and marginal propensity to save (MPS). b) What is the MPC for this economy? c) Explain the concepts of the autonomous spending and tax multipliers. d) What is the autonomous spending multiplier for this economy? e) What is the equilibrium level of income for this...
Consider the following hypothesis test. H0: μ ≥ 70 Ha: μ < 70
   You may need to use the appropriate technology to answer this question. Consider the following hypothesis test. H0: μ ≥ 70 Ha: μ < 70 A sample of 100 is used and the population standard deviation is 12. Compute the p-value and state your conclusion for each of the following sample results. Use α = 0.01. (a) x = 68.5 Find the value of the test statistic. Find the p-value. (Round your answer to four decimal places.) p-value = State...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 22 13 18 11 19 22 14 Round your answers to two decimal places. a. Compute MSE using the most recent value as the forecast for the next period. Mean squared error is What is the forecast for month ? b. Compute MSE using the average of all data available as the forecast for the next period. Mean squared error is What is the forecast...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 15 20 12 18 22 15 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Graph (i)Graph (ii)Graph (iii)Graph (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend patternHorizontal patternVertical patternNegative trend patternItem 2 (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 25...
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16 (a) Construct a time series plot. What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a cyclical pattern.     The data appear to follow a trend pattern. The data appear to follow a horizontal pattern. (b) Develop the three-month moving average forecasts for this time series. Month...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 14 19 13 19 24 14 (a) Compute MSE using the most recent value as the forecast for the next period. If required, round your answer to one decimal place. What is the forecast for month 8? If required, round your answer to one decimal place. Do not round intermediate calculation. (b) Compute MSE using the average of all the data available as the...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24...
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 12 20 13 18 24 14 (a) Compute MSE using the most recent value as the forecast for the next period. If required, round your answer to one decimal place. What is the forecast for month 8? If required, round your answer to one decimal place. Do not round intermediate calculation. (b) Compute MSE using the average of all the data available as the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT