Question

In: Finance

The price of a home is ​$240 000. The bank requires a​ 15% down payment. The...

The price of a home is ​$240 000. The bank requires a​ 15% down payment. The buyer is offered two mortgage​ options: 15-year fixed at 8.5​% or​ 30-year fixed at 8.5​%. Calculate the amount of interest paid for each option. How much does the buyer save in interest with the​ 15-year option? Use the following formula to determine the regular payment amount. Find the monthly payment for the​ 15-year option. ​$ nothing ​(Round to the nearest dollar as​ needed.) Find the monthly payment for the​ 30-year option. ​$ nothing ​(Round to the nearest dollar as​ needed.) Calculate the total cost of interest for both mortgage options. How much does the buyer save in interest with the​ 15-year option? ​$ nothing ​(Use the answers from parts 1 and 2 to find this​ answer.)

Solutions

Expert Solution

1)

Formula for EMI is:

EMI = P × r × (1 + r) n / {(1 + r) n - 1}

Where,

P = Principal of loan = $ 240,000 – (1- 0.15) = $ 240,000 x 0.85 = $ 204,000

r = rate of interest = 8.5 % p.a. or 0.08/12 or 0.007083333 monthly

n = No. of periods = 15 years x 12 months = 180 periods

EMI = $ 204,000 x 0.007083333 x (1 + 0.007083333)180 / {(1 + 0.007083333) 180 -1}

        = $ 204,000 x 0.007083333 x (1.007083333)180 / {(1.007083333) 180 -1}

        = $ 204,000 x 0.007083333 x 3.562653123 / (3.562653123-1)

        = $ 204,000 x 0.007083333 x 3.562653123 / 2.562653123

        = $ 204,000 x 0.007083333 x 1.390220585

        = $ 2,008.868651 or $ 2,009

Monthly payment for 15 years loan is $ 2,009

2)

Let’s compute EMI for 30 year loan

n = 30 years x 12 months = 360 periods

EMI = $ 204,000 x 0.007083333 x (1 + 0.007083333)360 / {(1 + 0.007083333) 360 -1}

        = $ 204,000 x 0.007083333 x (1.007083333)360 / {(1.007083333) 360 -1}

        = $ 204,000 x 0.007083333 x 12.6924972747/ (12.6924972747-1)

        = $ 204,000 x 0.007083333 x 12.6924972747/ 11.6924972747

        = $ 204,000 x 0.007083333 x 1.0855249291

        = $ 1,568.5834486818 or $ 1,569

Monthly payment for 30 years loan is $ 2,009

3)

Total payment for 15 year loan = 180 x $ 2,009 = $ 361,620

Interest amount = Total payment – Principal = $ 361,620 - $ 204,000 = $ 157,620

Total payment for 30 year loan = 360 x $ 1,569 = $ 564,840

Interest amount = Total payment – Principal = $ 564,840 - $ 204,000 = $ 360,840

Difference in interest = $ 360,840 - $ 157,620 = $ 203,220

The buyer can save $ 203,220 in interest with the​15-year option.


Related Solutions

The price of a home is ​$120,000. The bank requires a​ 20% down payment and three...
The price of a home is ​$120,000. The bank requires a​ 20% down payment and three points at the time of closing. The cost of the home is financed with a​ 30-year fixed-rate mortgage at 7​%. a.  Find the required down payment. ​$ b.  Find the amount of the mortgage. ​$ c.  How much must be paid for the three points at​ closing? ​$ ​(Round to the nearest dollar as​ needed.) d.  Find the monthly payment​ (excluding escrowed taxes and​...
You put 20% down on a home with a purchase price of $250,000. The down payment...
You put 20% down on a home with a purchase price of $250,000. The down payment is thus $50,000, leaving a balance owed of $200,000. A bank will loan you this remaining balance at 3.91% APR. You will make monthly end-of-the-period payments with a 30-year payment schedule. What is the monthly annuity payment under this schedule?
A house is sold for $300 000 and appraised for $285 000. What down payment will...
A house is sold for $300 000 and appraised for $285 000. What down payment will be needed to qualify for a conventional mortgage?
You purchase a $1,250,000 home by providing a down payment equal to 20% of the purchase price.
You purchase a $1,250,000 home by providing a down payment equal to 20% of the purchase price. You take out a loan for the remaining balance that requires equal end-of -month payments over the next 30 years with an EAR of 3.8%. How interest will be paid with the first two payments?
A home has price $260,000. After a down payment of $40,000, the rest is financed over...
A home has price $260,000. After a down payment of $40,000, the rest is financed over 25 years at an annual interest rate of 6% compounded monthl y. a) Use the appropriate table in your book to find the monthly payment to the bank. (Do NOT use annuity formulas). b) Suppose that annual taxes are $3120 and homeowner’s insurance has an annual premium of $720. Lenders often collect these amounts in equal monthly installments along with the mortgage payment and...
How much of the third mortgage payment will go to pay down the principle? Home Price:...
How much of the third mortgage payment will go to pay down the principle? Home Price: $339,000 USD 15% down payment of selling price 25 year term loan with a 3% annual interest rate
The price of a small cabin is ​$55 comma 00055,000. The bank requires a​ 5% down...
The price of a small cabin is ​$55 comma 00055,000. The bank requires a​ 5% down payment. The buyer is offered two mortgage​ options: 20-year fixed at 9.59.5​% or​ 30-year fixed at 9.59.5​%. Calculate the amount of interest paid for each option. How much does the buyer save in interest with the​ 20-year option?
1. Amortize a $125,000 (Sale Price) house with 20% down payment on a 15 year loan...
1. Amortize a $125,000 (Sale Price) house with 20% down payment on a 15 year loan at 3.0% annual interest rate (1) What is the monthly payment? (2) What month will the debt be less than $50,000? (Assume that you just took out the loan) (3) How much will you pay in interest over the life of the loan?
Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment....
Create an Amortization Schedule for a home that cost $259,000 with 20% down for a down-payment. Do not use an online amortization schedule. Note the textbook amortization schedule is using an annual payment. Please complete a schedule for both 180 months (15 years) and 360 months (30 years). The interest rate for the year is 2.75% according to Bankrate for the area the home is in. Remember to divide your interest by 12 to get a monthly rate. How much...
Sandeep wants to retire in 15 years and he needs to have $60,000 for a down payment on his retirement home.
Sandeep wants to retire in 15 years and he needs to have $60,000 for a down payment on his retirement home. If he makes quarterly payments into an account paying 7% annual interest compounded quarterly, how much should he deposit each quarter to obtain the desired down payment?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT