Question

In: Accounting

Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment...

Fifteen years ago a couple purchased a house for $230,000.00 by paying a 20% down payment and financing the remaining balance with a 30-year mortgage at 4.7% compounded monthly.

(a) Find the monthly payment for this loan.

(b) Find the balance of the loan after 16 years and after 17 years?

(c) Find the total amount of interest paid by the couple during the 17th year.

Solutions

Expert Solution

(a) Monthly payment for this loan $       954.34
Working:
# 1 Present Value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.003917)^-360)/0.003917 i 4.7%/12 = 0.003917
= 192.803846 n 30*12 = 360
# 2 Purchase Price of House a        2,30,000
Less:Down Payment b=a*20%            46,000
Loan Amount        1,84,000
# 3 Monthly payment for this loan = Loan amount / Present Value of annuity of 1
=        1,84,000 / 192.8038
=            954.34
(b) Loan Balance after;
16 Years $ 1,17,307.00
17 Years $ 1,11,239.24
Working:
Loan is the present value of monthly payment.
After 16 Years, Present Value of monthly Payment = $           954.34 *         122.9198 = $ 1,17,307.00
Present Value of annuity of 1 for 14 Years = (1-(1+i)^-n)/i Where,
= (1-(1+0.003917)^-168)/0.003917 i 4.7%/12 = 0.003917
=          122.9198 n 14*12 = 168
After 17 Years, Present Value of monthly Payment = $           954.34 *         116.5617 = $ 1,11,239.24
Present Value of annuity of 1 for 14 Years = (1-(1+i)^-n)/i Where,
= (1-(1+0.003917)^-156)/0.003917 i 4.7%/12 = 0.003917
= 116.561698 n 13*12 = 156
(c) Total Interest paid during year 16 $       5,384.28
Working:
Total Payment during year 17 = $           954.34 * 12 = $    11,452.05
Reduction in Principal = $ 1,17,307.00 - $ 1,11,239.24 = $      6,067.77
Interest paid $      5,384.28

Related Solutions

A person purchased a ​$133,748 home 10 years ago by paying 20​% down and signing a​...
A person purchased a ​$133,748 home 10 years ago by paying 20​% down and signing a​ 30-year mortgage at 10.2​% compounded monthly. Interest rates have dropped and the owner wants to refinance the unpaid balance by signing a new 20​-year mortgage at 6.3 % compounded monthly. How much interest will refinancing​ save? Money​ Saved: ​(Round to the nearest cent as​ needed.)
Jingfei bought a house 6 years ago for $200,000. Her down payment on the house was...
Jingfei bought a house 6 years ago for $200,000. Her down payment on the house was the minimum required 10% at that time she financed the remainder with a 30-year fixed rate mortgage. The annual interest rate was 8% and she was required to make monthly payments, and she has just made her 72th payment. A new bank has offered to refinance the remaining balance on Jingfei's loan and she will have to pay $1,320 per month for the next...
You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion,...
You just purchased a $400,000 house and gave a 20% down payment. For the remaining portion, you obtained a 30-year mortgage at a 6% interest rate. (6 points) What are the monthly payments on this mortgage? If the house appreciates at a 3 percent annually, what will be the value of the house in ten years? In ten years, how much equity will you have on this home? Answer all questions and show work in Excel. SHOW ME IN EXCEL...
In order to accumulate enough money for a down payment on a house, a couple deposits...
In order to accumulate enough money for a down payment on a house, a couple deposits $472 per month into an account paying 6% compounded monthly. If payments are made at the end of each period, how much money will be in the account in 3 years? Round to the nearest dollar
A person purchased a ​$239,127 home 10 years ago by paying 15​% down and signing a​...
A person purchased a ​$239,127 home 10 years ago by paying 15​% down and signing a​ 30-year mortgage at 10.8​% compounded monthly. Interest rates have dropped and the owner wants to refinance the unpaid balance by signing a new 20​-year mortgage at 6 % compounded monthly. How much interest will refinancing​ save?
A person purchased a $1,145,000 home 10 years ago by paying 25% down and signing a...
A person purchased a $1,145,000 home 10 years ago by paying 25% down and signing a 30-year fixed rate mortgage at 7.8% p.a.. Interest rate have dropped and the owner wants to refinance the unpaid balance by signing a new mortgage fixed 4% p.a.. Assume monthly mortgage payment frequency. Determine the amount of monthly payments under the original mortgage contract without refinancing. After how long will the principal outstanding be reduced by a half? How much interest will refinancing save?...
Prudence Corporation purchased a machine for $460,000 on September 1, 2019, by paying 20% down payment...
Prudence Corporation purchased a machine for $460,000 on September 1, 2019, by paying 20% down payment in cash and for the balance amount signed a 6%, 10-month note payable for the balance amount. Interest and principle will be paid back together at the end of the note. Prepare journal entries to record: the purchase of the delivery truck, the adjusting journal entry to record the accrued interest on December 31, and the payment of the note at maturity along with...
A person purchased a ​$219 comma 867 home 10 years ago by paying 10​% down and...
A person purchased a ​$219 comma 867 home 10 years ago by paying 10​% down and signing a​ 30-year mortgage at 8.7​% compounded monthly. Interest rates have dropped and the owner wants to refinance the unpaid balance by signing a new 15​-year mortgage at 5.4 % compounded monthly. How much interest will refinancing​ save? Money​ Saved: ​$ nothing ​(Round to the nearest cent as​ needed.) NOTE: PLEASE WRITE NEATLY AND LABEL THE ANSWERS!!!! EXP: How much interest will financing save?...
A couple has decided to purchase a $240000 house using a down payment of $30000. They...
A couple has decided to purchase a $240000 house using a down payment of $30000. They can amortize the balance at 10% over 20 years. a) What is their monthly payment? Answer = $ b) What is the total interest paid? Answer = $ c) How much of their first payment went toward paying interest? Answer = $ d) How much of their first payment went toward paying the balance of the loan. Answer = $
A couple has decided to purchase a $200000 house using a down payment of $15000. They...
A couple has decided to purchase a $200000 house using a down payment of $15000. They can amortize the balanxe at 10% over 25 years. What is their monthly payment? What is the total interest paid? What is the equity after 5 years? What is the equity after 20 years?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT