Question

In: Finance

Five years ago, Diane secured a bank loan of $390,000 to help finance the purchase of...

Five years ago, Diane secured a bank loan of $390,000 to help finance the purchase of a loft in the San Francisco Bay area. The term of the mortgage was 30 years, and the interest rate was 8%/year compounded monthly on the unpaid balance. Because the interest rate for a conventional 30-year home mortgage has now dropped to 6.5%/year compounded monthly, Diane is thinking of refinancing her property. (Round your answers to the nearest cent.)

(a) What is Diane's current monthly mortgage payment?
$ ____________

(b) What is Diane's current outstanding principal?
$ _____________

(c) If Diane decides to refinance her property by securing a 30-year home mortgage loan in the amount of the current outstanding principal at the prevailing interest rate of 6.5%/year compounded monthly, what will be her monthly mortgage payment?
$ ______________

(d) How much less will Diane's monthly mortgage payment be if she refinances?
$ ________________

Solutions

Expert Solution

Answer; Part (A)

Current Monthly Installment Amount =

No of Year = 30 Years

No of period = 30 X 12 = 360 monthly payments

Rate = 8% per annum monthly compounded

Effective annual Rate = (1+ 8%/12)12 -1 = 8.3%

Monthly rate = 8.3 % / 12 = .69167%

Principal Amount = $ 390,000

Formula ; Monthly Installment =  = P × r × (1 + r)n/((1 + r)^n - 1)

   = 390,000 x .69167% [ (1.0069167)^360/ (1.0069167)^360 -1]

= 2600 x[11.95832889/(11.95832889-1)]

   = 2697.50 x 1.09125479

   = $2943.66 Per Month

Answer Part B

Ramaining Amount = Formula

Ramaining Amount =

= 390000*(1.0069167)^60 - 2943.66*[(1.006917)^60 - 1]/.006917

= $371769.69

Answer Part (C)

New Monthly Installment Amount =

No of Year = 30 Years

No of period = 30 X 12 = 360 monthly payments

Rate = 6.5% per annum monthly compounded

Effective annual Rate = (1+ 6.5%/12)12 -1 = 6.70%

Monthly rate = 6.7 % / 12 = .558333%

Principal Amount = $ 371769.69

Formula ; Monthly Installment =  = P × r × (1 + r)n/((1 + r)^n - 1)

   = 371769.69 x .558333% [ (1.00558333)^360/ (1.00558333)^360 -1]

= 2075.71 x[7.421701592/(7.421701592-1)]

   = 2075.71 x 1.155721966

= $2398.95

Answer Part D

Monthly mortgage Payment less by =

   = $2943.66 - $2398.95

= $544.71


Related Solutions

The Flemings secured a bank loan of $240,000 to help finance thepurchase of a house....
The Flemings secured a bank loan of $240,000 to help finance the purchase of a house. The bank charges interest at a rate of 4%/year on the unpaid balance, and interest computations are made at the end of each month. The Flemings have agreed to repay the loan in equal monthly installments over 25 years. What should be the size of each repayment if the loan is to be amortized at the end of the term? (Round your answer to...
George secured an adjustable-rate mortgage (ARM) loan to help finance the purchase of his home 5...
George secured an adjustable-rate mortgage (ARM) loan to help finance the purchase of his home 5 years ago. The amount of the loan was $250,000 for a term of 30 years, with interest at the rate of 9%/year compounded monthly. Currently, the interest rate for his ARM is 5.5%/year compounded monthly, and George's monthly payments are due to be reset. What will be the new monthly payment? (Round your answer to the nearest cent.)
Sarah secured a bank loan of $155,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $155,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 5 years. How much will Sarah still owe on her house? (Round your answer to the nearest cent.)
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is...
Sarah secured a bank loan of $185,000 for the purchase of a house. The mortgage is to be amortized through monthly payments for a term of 15 years, with an interest rate of 3%/year compounded monthly on the unpaid balance. She plans to sell her house in 10 years. How much will Sarah still owe on her house at that time? (Round your answer to the nearest cent.) $____
Five years ago, Marcus bought a house. He secured a mortgage from his bank for $1,720,000....
Five years ago, Marcus bought a house. He secured a mortgage from his bank for $1,720,000. The mortgage had monthly payments for 20 years with an interest rate of 6.0% compounded monthly. However, after five years, it is time to renegotiate the mortgage. Interest rates have fallen to 4.5% compounded monthly, and Marcus still intends to make monthly payments and to pay back the debt over the remaining 15 years. a) How much were Marcus' initial monthly payments? b) What...
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan...
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan has 4.0% APR with monthly payments of $1,800. How much do you owe on the loan today? The remaining loan balance is $________. (round to the nearest dollar) How much interest did you pay on the loan in the past year? The interest paid in year five was $______. (round to the nearest dollar) Over the entire period of 10 years, how much interest...
Five years ago you borrowed $100,000 to finance the purchase of a $120,000 house. The interest...
Five years ago you borrowed $100,000 to finance the purchase of a $120,000 house. The interest rate on the old mortgage is 10%. Payment terms are being made monthly to amortize the loan over 30 years. You have found another lender who will refinance the current outstanding loan balance at 8% with monthly payments for 30 years. The new lender will charge two discount points on the loan. Other refinancing costs will equal $3,000. There are no prepayment penalties associated...
Five years ago you borrowed $100,000 to finance the purchase of a $120,000 home. The interest...
Five years ago you borrowed $100,000 to finance the purchase of a $120,000 home. The interest rate on the old mortgage loan is 8 percent. Payments are being made monthly to amortize the loan over 30 years. You have found another lender who will refinance the current outstanding loan balance at 5.5 percent with monthly payments for 30 years. The new lender will charge two discount points on the loan. Other refinancing costs will equal $3,500. There are no prepayment...
Five years ago, you had arranged for an eight-year bank loan for $300,000 at an interest...
Five years ago, you had arranged for an eight-year bank loan for $300,000 at an interest rate of 10% p.a. with interest compounded semi-annually. The loan was being repaid in equal semi-annual instalments and the payments were being made at the end of each period. The total amount still owed the bank today is closest to? Could you please show the solution step by step instead of using Excel functions…Thanks a lot!
A farm can finance a tractor purchase with an $90,000 loan at the local bank. The...
A farm can finance a tractor purchase with an $90,000 loan at the local bank. The financing terms include a four-year loan, a 7.5% annual interest rate, and equal quarterly repayments of principal and interest. Given this information, determine the level of the quarterly payments.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT