A student decides to finance their college education using a credit card. They charge one semester's tuition and then make the minimum monthly payment until the credit card balance is zero. How many months will it take to pay off the semester's tuition? How much will the student have spent to pay off the tuition?
We can solve this problem using an m-file script. We define the following variables:
bn - Balance at month n.
Pn - Payment in month n.
fn - Finance charge (interest) in month n.
The finance charge fn is the interest that is paid on the balance each month. The finance charge is computed using the monthly interest rate r:
Credit card interest rates are typically given as an annual percentage rate (APR). To convert the APR to a monthly interest rate, use the following formula:
More information on how to compute monthly rates can be found at the Wikipedia article "Credit card interest" (http://en.wikipedia.org/wiki/Credit_card_interest).
Credit cards usually have a minimum monthly payment. The minimum monthly payment is usually a fixed percentage of the balance; the percentage is required by federal regulations to be at least 1% higher than the monthly interest rate. If this minimum payment would be below a given threshold (usually $10 to $20), the minimum payment is instead set to the threshold. For a threshold of $10, the relationship between the balance and the minimum payment can be shown in an equation as follows:
To compute the balance for one month (month n+1) from the balance for the previous month (month n), we compute the finance charge on the balance in the previous month and add it to the previous balance, then subtract the payment for the previous month:
In the following exercises, we will develop the program to compute the number of months necessary to pay the debt. We will assume that the card APR is 14.9% (the average rate on a student credit card in mid February 2006 according to http://money.cnn.com/pf/informa/index.html) and that the initial balance charged to the card is $2203 (the in-state tuition at Arizona State University at the Polytechnic Campus for Spring 2006 semester according to http://www.asu.edu/sbs/FallUndergradEastWest.htm).
Write code to compute the monthly interest rate r from the APR.
Write code to compute the minimum monthly payment Pn.
Write code to compute the balance at month n+1 in terms of the balance at month n.
Place the code developed for Exercise 7 into a while loop to determine how many months will be required to pay off the card.
Modify your code from Exercise 8 to plot the monthly balance, monthly payment, and total cost-to-date for each month until the card is paid off.