Answered

Discover the answers you need at Westonci.ca, a dynamic Q&A platform where knowledge is shared freely by a community of experts. Join our Q&A platform to get precise answers from experts in diverse fields and enhance your understanding. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform.

You plan to purchase a $340,000 house using either a 25-year mortgage obtained from your local savings bank with a rate of 8.10 percent, or a 10-year mortgage with a rate of 7.10 percent. You will make a down payment of 20 percent of the purchase price.
a. Calculate the amount of interest and, separately, principal paid on each mortgage. What is the difference in interest paid?
b. Calculate your monthly payments on the two mortgages. What is the difference in the monthly payment on the two mortgages?

Sagot :

Tundexi

Answer:

a. Interest under 10 year mortgage = CUMIPMT(7.1%/12, 10*12, 340000*80%, 1, 10*12, 0)

Interest under 10 year mortgage = 108662.44

Interest under 25 year mortgage = CUMIPMT(8.1%/12, 10*12, 340000*80%, 1, 25*12, 0)

Interest under 25 year mortgage = 363217.16

Difference in interest = 363217.16 - 108662.44

Difference in interest = 254554.72

b. Monthly payment under 10 year = PMT(7.1%/12, 10*12, 340000*80%)

Monthly payment under 10 year = 3172.19

Monthly payment under 25 year = PMT(8.1%/12, 25*12, 340000*80%)

Monthly payment under 25 year = 2117.39

Difference in the monthly payment = 3172.19 - 2117.39

Difference in the monthly payment = 1054.80

We appreciate your time. Please come back anytime for the latest information and answers to your questions. Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. Your questions are important to us at Westonci.ca. Visit again for expert answers and reliable information.