Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Adjustable Rate Mortgage [40 points] - Create an amortization spreadsheet and answer the following questions for a $600,000 10-year 3/1 ARM loan that is fully-amortizing

Adjustable Rate Mortgage [40 points] - Create an amortization spreadsheet and answer the following questions for a $600,000 10-year 3/1 ARM loan that is fully-amortizing with monthly payments. The loan terms include a teaser rate of 2.0%. After the initial teaser rate period, the interest rate resets annually to the index rate plus a margin of 1.50%. The loan terms also include an annual interest rate cap of 2.0% and a lifetime interest rate cap of 6.0% over the initial teaser rate. Expectations for the beginning-of-year values for the appropriate index are as follows:

Year Index
1 4.00%
2 4.50%
3 5.00%
4 5.00%
5 5.75%
6 6.25%
7 6.75%
8 4.00%
9 4.50%
10 5.25%

a.) Calculate the appropriate contract rate for years 1 10 and then complete the amortization schedule.

b.) What is the effective interest rate (EIR) for the loan if it is held to maturity (assume no upfront fees/points or prepayment penalties)?

c.) Assuming upfront points of 3.0%, what is the loans EIR if it is held until maturity?

d.) Assuming upfront points of 3.0%, what is the loans EIR if it is prepaid at the end of year 6 (assume no prepayment penalties)?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Finance Transactions Policy And Regulation

Authors: Hal Scott, Anna Gelpern

21st Edition

1634602048, 978-1634602044

More Books

Students also viewed these Finance questions