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...
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?
Kari is purchasing a home for $220,000. The down payment is 25% and the balance will...
Kari is purchasing a home for $220,000. The down payment is 25% and the balance will be financed with a year mortgage at 8% and 4 discount points. Kari made a deposit of $30,000 (applied to the doen payment) when the sales contract was signed. Kari also has three expenses: credit report, $70; appraisal fee, $110; title insurance premium, 1% of amount financed; title search, $200; and attorney's fees, $500. Find the closing costs (in $).
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT