Simon recently received a credit card with an 13% nominal interest rate. With th

Question

Simon recently received a credit card with an 13% nominal interest rate. With the card, he purchased an Apple iPhone 5 for $480. The minimum payment on the card is only $10 per month.

a. If Simon makes the minimum monthly payment and makes no other charges, how many months will it be before he pays off the card? Do not round intermediate calculations. Round your answer to the nearest month.

b. If Simon makes monthly payments of $30, how many months will it be before he pays off the debt? Do not round intermediate calculations. Round your answer to the nearest month.

c. How much more in total payments will Simon make under the $10-a-month plan than under the $30-a-month plan. Do not round intermediate calculations. Round your answer to the nearest cent.

Explanation / Answer

a Nominal interest rate per month 1.08% 13%/12 Present Value $480 PMT $10 FV 0 Using the NPER function in excel we get, no of months as follows NPER(1.08%,-10,480) N = 68.11732632 N = 68 months Rounding to the nearest month b Nominal interest rate per month 1.08% Present Value $480 PMT $30 FV 0 Using the NPER function in excel we get, no of months as follows NPER(1.08%,-30,480) 17.66611934 N = 18 months Rounding to the nearest month c Total Payments @ $10 per month 68.11732632*$10 681.1732632 Total Payments @ $30 per month 17.66611934*$30 529.9835802 Extra payment or interest $ 151.19

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.