A couple take a 30-year home mortgage of $120,000 at 7.8% compounded monthly. They make their regular monthly payments for 5 years, then decide to pay $1000 per month.                                                   a. Find their regular monthly payment.   b. Findtheunpaidbalancewhentheybeginpayingthe$1000. c. How many payments of $1000 will it take to pay off the loan? Give the answer correct to one decimal place. d. Use your answer to part(c)to find how much interest they save by paying the loan this way.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 5E
icon
Related questions
Question

A couple take a 30-year home mortgage of $120,000 at 7.8% compounded monthly. They make their regular monthly payments for 5 years, then decide to pay $1000 per month.                                                   a. Find their regular monthly payment.

  b. Findtheunpaidbalancewhentheybeginpayingthe$1000.

c. How many payments of $1000 will it take to pay off the loan? Give the answer correct to one decimal place.

d. Use your answer to part(c)to find how much interest they save by paying the loan this way.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 6 images

Blurred answer
Knowledge Booster
Credit Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage