Hi there,

I'm seeking help for problem 3, 4 and 5. Thank you.

D w Help [Compatibility Mode] Qw Search in Document Home + Share A E E = Insert Design Layout References Times New Ro... - 12 -A- A A B I vabe X, X A A Mailings A 5 = Review E = = View 3 = 3 4+ $. AaBbCcDdE Normal AaBbCcDdE No Spacing AaBb CcD Heading 1 AaBbCcDdE AaBb Heading 2 Title AaBb CcDd Ee Subtitle AaBbCcDdee Subtle Emph... AaBbCcDdee Emphasis Paste Styles Pane Problem 1 Consider the following fixed-rate, level-payment mortgage: maturity = 360 months, amount borrowed = $1,000,000, annual mortgage rate = 5%. Construct an amortization schedule for the first 12 months. Problem 2 Using the same fixed rate mortgage as in problem l, answer the following questions: a) What will the mortgage balance be at the end of the 360th month assuming no trepayments? b) Without constructing an amortization schedule, what is the mortgage balance at the end of month 170 assuming no prepayments? c) Without constructing an amortization schedule, what is the scheduled principal payment at the end of month 170 assuming no prepayments? Problem 3 Complete the #llowing table: CPR Assuming Month 50% PSA 175% PSA 4 00% PSA 120 340 Problem 4 Complete the following table: SMM Assuming: Month 50% PSA 175% PSA400% PSA 340 Problem 5 Complete the following table (in dollars) assuming a prepayment rate of 800 PSA: Original balance: $ 50,000,000 WAC: 5% WAM: 360 months No fee Outst. Mortg. Sch. Pre- Total Cash Month Balance SMM Paym. Interest Princ. paym. Princ. Flow Page 1 of 1 193 Words English (US) 1 E E D Focus - - - + 105% D w Help [Compatibility Mode] Qw Search in Document Home + Share A E E = Insert Design Layout References Times New Ro... - 12 -A- A A B I vabe X, X A A Mailings A 5 = Review E = = View 3 = 3 4+ $. AaBbCcDdE Normal AaBbCcDdE No Spacing AaBb CcD Heading 1 AaBbCcDdE AaBb Heading 2 Title AaBb CcDd Ee Subtitle AaBbCcDdee Subtle Emph... AaBbCcDdee Emphasis Paste Styles Pane Problem 1 Consider the following fixed-rate, level-payment mortgage: maturity = 360 months, amount borrowed = $1,000,000, annual mortgage rate = 5%. Construct an amortization schedule for the first 12 months. Problem 2 Using the same fixed rate mortgage as in problem l, answer the following questions: a) What will the mortgage balance be at the end of the 360th month assuming no trepayments? b) Without constructing an amortization schedule, what is the mortgage balance at the end of month 170 assuming no prepayments? c) Without constructing an amortization schedule, what is the scheduled principal payment at the end of month 170 assuming no prepayments? Problem 3 Complete the #llowing table: CPR Assuming Month 50% PSA 175% PSA 4 00% PSA 120 340 Problem 4 Complete the following table: SMM Assuming: Month 50% PSA 175% PSA400% PSA 340 Problem 5 Complete the following table (in dollars) assuming a prepayment rate of 800 PSA: Original balance: $ 50,000,000 WAC: 5% WAM: 360 months No fee Outst. Mortg. Sch. Pre- Total Cash Month Balance SMM Paym. Interest Princ. paym. Princ. Flow Page 1 of 1 193 Words English (US) 1 E E D Focus - - - + 105%