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 = 9.5%, BOY5 = 11%.

Compute the payments, loan balances, and yields for the ARM for the five-year period.

****Please in Excel as I need to learn how to use the formulas and learn which ones to use*** Thank you!

Expert Solution

Solution:

ekkarill92 answered 2 years ago

Excel work, please Assume that a lender offers a 30-year, $150,000 adjustable rate mortgage (ARM) with...

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

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.

Consider a 30-year adjustable rate mortgage (ARM), which requires the borrower to make monthly payments at...

Consider a 30-year adjustable rate mortgage (ARM), which requires the borrower to make monthly payments at the end of each month. The mortgage amount is $432,000 and the APR on the mortgage is 3.65% for the first 10 years and then 3.87% for the next 20 years. Prepare a loan amortization schedule for this mortgage. Assume that the mortgage closing date is October 1, 2018. Among other things, the following columns should be included. (50) (i) Date (ii) Beginning Balance...

The table shows the specifications of an adjustable rate mortgage (ARM). Assume no caps apply. Find...

The table shows the specifications of an adjustable rate mortgage (ARM). Assume no caps apply. Find a) the initial monthly payment; b) the monthly payment for the second adjustment; and c) the change in monthly payment at the first adjustment. *The principal balance at the time of the first rate adjustment. Beginning Balance $75000 Term 20 years Initial index rate 5.4% Margin 2.6 % Adjustment period 1 year Adjusted index rate 6.9% *Adjusted balance $73,414.75 What is the initial monthly...

which mortgage is riskier for lender? fixed rate mortgage to adjustable rate mortgage? And why does...

which mortgage is riskier for lender? fixed rate mortgage to adjustable rate mortgage? And why does the adjustable rate mortgage have lower expected yield?

Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 5.50% for...

Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 5.50% for 30 years, monthly payments. The lender will charge you two discount points and the loan has a 4% prepayment penalty. A. (1 pt) What is the annual percentage rate (APR) of the loan? B. (1 pt) How many points are required to yield an APR of 5.75%?

Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 4.75% for...

Your local lender offers you a fixed-rate mortgage with the following terms: $220,000 at 4.75% for 30 years, monthly payments. The lender will charge you two discount points and the loan has a 3% prepayment penalty. A. (1 pt) What is the annual percentage rate (APR) of the loan? Answer: _______ B. (1 pt) How many points are required to yield an APR of 5.25%? Answer: _______

Your local lender offers you a fixed-rate mortgage with the following terms: $200,000 at 5.50% for...

Your local lender offers you a fixed-rate mortgage with the following terms: $200,000 at 5.50% for 30 years, monthly payments. The lender will charge you two discount points and the loan has a 4% prepayment penalty. A. (1 pt) What is the annual percentage rate (APR) of the loan? B. (1 pt) How many points are required to yield an APR of 5.75%? Suppose you take a fixed-rate mortgage for $175,000 at 4.50% for 30 years, monthly payments. A. (1...

Your lender now offers you a 30-year fixed-rate mortgage with 3.6% interest rate per year. If...

Your lender now offers you a 30-year fixed-rate mortgage with 3.6% interest rate per year. If you can afford a monthly payment of $1725, what is the maximum loan you can get? (round to nearest dollar.)

2.Assume the following for a one-year rate adjustable rate mortgage loan that is tied to the...

2.Assume the following for a one-year rate adjustable rate mortgage loan that is tied to the one-year Treasury rate: Loan amount: $200,000 Annual rate cap: 1% Life-of-loan cap: 4% Margin : 2.50% First-year teaser rate: 5.50% One-year Treasury rate at end of year 1: 5.25% One-year Treasury rate at end of year 2: 5.50% Loan term in years: 15 Given these assumptions, calculate the following: a.Initial monthly payment b.Loan balance end of year 1 c.Year 2 contract rate d.Year 2...

Question