Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down at purchase time and taking a $20,000, 5-year, 6% per year, compounded monthly loan with 60 monthly payments of $386.66 each. She is examining her loan situation and would like to have some specific information. Help her obtain the following: (a) Verification of the current monthly payment amount. (b) Total amount she will pay over the 5 years. (c) Total interest she will pay over the 5 years and the percentage this represents of the original loan amount of $20,000. (d) After she missed payment #36 at the very end of the third year, according to the loan agreement, the interest rate increased from 6% to 10% per year, compounded monthly. Based on the remaining principal immediately after the late payment, determine the new monthly payment. Verify that this increased amount is necessary to pay off the loan at the increased rate. (e) Penny is now in her fourth year, has paid the increased payment for 12 payments, and wants to get rid of this loan completely. She wishes to know the remaining principal amount when payment #48 is due. There is no penalty for early repayment of principal.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
ChapterMB: Model-building Problems
Section: Chapter Questions
Problem 27M
icon
Related questions
Question

Some years ago, Penny purchased the car of her
dreams for $25,000 by paying 20% down at purchase
time and taking a $20,000, 5-year, 6% per
year, compounded monthly loan with 60 monthly
payments of $386.66 each. She is examining her
loan situation and would like to have some specific
information. Help her obtain the following:
(a) Verification of the current monthly payment
amount.
(b) Total amount she will pay over the 5 years.
(c) Total interest she will pay over the 5 years
and the percentage this represents of the
original loan amount of $20,000.
(d) After she missed payment #36 at the very
end of the third year, according to the loan
agreement, the interest rate increased from
6% to 10% per year, compounded monthly.
Based on the remaining principal immediately
after the late payment, determine the
new monthly payment. Verify that this increased
amount is necessary to pay off the
loan at the increased rate.
(e) Penny is now in her fourth year, has paid
the increased payment for 12 payments,
and wants to get rid of this loan completely.
She wishes to know the remaining principal
amount when payment #48 is due.
There is no penalty for early repayment of
principal.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 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.
Similar questions
  • SEE MORE QUESTIONS
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