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 platform to connect with experts ready to provide precise answers to your questions in different areas. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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

Thank you for trusting us with your questions. We're here to help you find accurate answers quickly and efficiently. We appreciate your time. Please come back anytime for the latest information and answers to your questions. Find reliable answers at Westonci.ca. Visit us again for the latest updates and expert advice.