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.

Answer 1

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