An ARM is made for $200,000 for 30 years with the following terms: Initial interest rate...

An ARM is made for $200,000 for 30 years with the following terms:

Initial interest rate = 3%
Index = 1-year Treasuries
Payments reset each year
Margin = 2 percent
Fully amortizing

Estimated forward rates:
BOY 2	4.50%
BOY 3	5.25%
BOY 4	6%
BOY 5	6.50%

Compute payments and balances for each of the years 1-5.

Solutions

Expert Solution

Given,

Initial rate= 3%

Index= 1 year Treasury rate . Margin =2%. Reset frequency= yearly

Interest cap is not specified.

Index for Year 2= 4.5%. Therefore, interest rate= 4.5%+2% = 6.5%

Index for Year 3= 5.25%. Therefore, interest rate= 5.25%+2% = 7.25%

Index for Year 4= 6%. Therefore, interest rate= 6%+2% = 8%

Index for Year 5= 6.5%. Therefore, interest rate= 6.5%+2% = 8.5%

Year 1: Monthly payments= $843.21 Balance at the end= $195,824.40

Year 2: Monthly payments= $1,251.73 Balance at the end= $193,462.64

Year 3: Monthly payments= $1,346.80 Balance at the end= $191,254.62

Year 4: Monthly payments= $1,442.60 Balance at the end= $189,168.46

Year 5: Monthly payments= $1,506.50 Balance at the end= $187,090.05

Calculations as below:

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

An ARM is made for $50,000 for 30 years with the following terms: Initial interest rate...

An ARM is made for $50,000 for 30 years with the following terms: Initial interest rate = 1 percent Index = 1-year Treasuries Payments reset each year Margin = 200 basis points Interest rate cap = none Payment cap = none Discount points = 1 point Negative amortization is not allowed Based on estimated forward rates, the 1-year Treasury yields to which the ARM is tied is forecasted as follows: Beginning of year (BOY) 2 = one percent (1%); (BOY)...

An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate...

An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate = 3% Index = 1-year Treasuries Payments reset each year Margin = 2 percent Fully amortizing Interest rate cap = 1 percent annually; 3 percent lifetime Estimated forward rates: BOY 2 4.00% BOY 3 5.25% BOY 4 6% BOY 5 6.50% Compute payments and balances for each of the years 1-5.

An Adjustable Rate Mortgage (ARM) is made for $300,000 at an initial interest rate of 2...

An Adjustable Rate Mortgage (ARM) is made for $300,000 at an initial interest rate of 2 percent for 30 years. The ARM will be adjusted annually. The borrower believes that the interest rate at the beginning of the year (BOY) 2 will increase to three percent (3%). a. Assuming that the ARM is fully amortizing, what will monthly payments be during year 1? b. Based on (a) what will the loan balance be at the end of year (EOY) 1?...

A basic ARM is made for $250, 000 at an initial interest rate of 6% for...

A basic ARM is made for $250, 000 at an initial interest rate of 6% for 30 years with an annual reset date. The borrower believes that the interest rate at the beginning of year 2 will increase to 8 percent. a. Assuming that a fully amortizing loan is made. What is the monthly payment during year 2? b. What would be the monthly payments in year 2 if it is an interest-only ARM loan for the first two years?...

A basic arm is made for $200000 at an initial interest rate of 6 percent for...

A basic arm is made for $200000 at an initial interest rate of 6 percent for 30 years with an annual reset date. The borrower believes that the interest rate at the beginning of year 2 will increase to 7 percent. (a) Assuming that a fully amortizing loan is made, what will the monthly payments be during year 1? (b) Based on (a), what will the loan balance be at the end of year 1? (c) Given that the interest...

A basic ARM is made for $250, 000 at an initial interest rate of 6% for...

A basic ARM is made for $250, 000 at an initial interest rate of 6% for 30 years with an annual reset date. The borrower believes that the interest rate at the beginning of year 2 will increase to 8 percent. Assuming that fulling amortizing is made and negative amortization is allowed if payment cap reached. If the ARM loan has a maximum 5% annual increase payment cap, what is the monthly payment during year 2?

A borrower takes out a 5/1 Hybrid ARM for $200,000 with an initial contract interest rate...

A borrower takes out a 5/1 Hybrid ARM for $200,000 with an initial contract interest rate of 3.5%. The interest rate will adjust according to the 1 yr LIBOR rate, plus a margin of 2%. At the first reset date, 1 yr LIBOR is at 1%. What will the borrowers’ monthly payment be immediately after the first reset? (State the payment as a positive number. Unless otherwise stated, you can assume 5/1 ARMs have a term of 30 years. Round...

A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years....

A fully amortizing mortgage loan is made for $200,000 at 6 percent interest for 30 years. Payments are to be made monthly. (Ignore origination fee and other fees). a. Using Excel, construct fully amortizing mortgage loan table including beginning balance, payment, interest, principal, and ending balance. (Please check your ending balance by using PV function in Excel) b. Interest and principal payments during month 1. c. Total Principal and total interest paid over 30 years. d. The outstanding loan balance...

Assume that the lender offers a 30-year, $150,000 adjustable rate mortgage (ARM) with the following terms:...

Assume that the lender offers a 30-year, $150,000 adjustable rate mortgage (ARM) with the following terms: Initial Interest Rate = 7.5% Index = one-year Treasuries Payments reset each year Margin = 2% Interest rate cap = 1% annually; 3% lifetime Discount points = 2% Fully amortizing; however, negative amortization allowed if interest rate caps reached. Based on estimated forward rates, the index to which ARM is tied forecasted as follows: Beginning of year BOY2 = 7%; BOY3 = 8.5%' BOY4...

A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.2%....

A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.2%. After the first year, the interest rate will adjust each year, using 1 yr LIBOR as the index, plus a margin of 175bp. The price of the property is $8,000,000 and the loan will have an initial LTV ratio of 75% At the first reset date, 1 year LIBOR is at 3%. What is the borrower’s payment during the 2nd year of the loan?

Subjects