Lab Exercise: Paying Debt off in a YearDue Sept 9, Midnight |
Our goal is to figure out how big our payments need to be to pay off our credit card in exactly one year
Each month, a credit card statement will come with the option for you to pay a minimum amount of your charge, usually 2% of the balance due. However, the credit card company earns money by charging interest on the balance that you don't pay. So even if you pay credit card payments on time, interest is still accruing on the outstanding balance.
Say you've made a $5,000 purchase on a credit card with an 18% annual interest rate and a 2% minimum monthly payment rate. If you only pay the minimum monthly amount for a year, how much is the remaining balance?
You can think about this in the following way.
At the beginning of month 0 (when the credit card statement arrives), assume you owe an amount we will call b_{0} (b for balance; subscript 0 to indicate this is the balance at month 0).
Any payment you make during that month is deducted from the balance. Let's call the payment you make in month 0, p_{0}. Thus, your unpaid balance for month 0, ub_{0}, is equal to b_{0}−p_{0}.
ub_{0}=b_{0}−p_{0}
At the beginning of month 1, the credit card company will charge you interest on your unpaid balance. So if your annual interest rate is r, then at the beginning of month 1, your new balance is your previous unpaid balance ub_{0}, plus the interest on this unpaid balance for the month. In algebra, this new balance would be
In month 1, we will make another payment, p_{1}. That payment has to cover some of the interest costs, so it does not completely go towards paying off the original charge. The balance at the beginning of month 2, b_{2}, can be calculated by first calculating the unpaid balance after paying p_{1}, then by adding the interest accrued:
If you choose just to pay off the minimum monthly payment each month, you will see that the compound interest will dramatically reduce your ability to lower your debt.
Let's look at an example. If you've got a $5,000 balance on a credit card with 18% annual interest rate, and the minimum monthly payment is 2% of the current balance, we would have the following repayment schedule if you only pay the minimum payment each month:
Month | Balance | Minimum Payment | Unpaid Balance | Interest |
---|---|---|---|---|
0 | 5000.00 | 100 (= 5000 * 0.02) | 4900 (= 5000 - 100) | 73.50 (= 0.18/12.0 * 4900) |
1 | 4973.50 (= 4900 + 73.50) | 99.47 (= 4973.50 * 0.02) | 4874.03 (= 4973.50 - 99.47) | 73.11 (= 0.18/12.0 * 4874.03) |
2 | 4947.14 (= 4874.03 + 73.11) | 98.94 (= 4947.14 * 0.02) | 4848.20 (= 4947.14 - 98.94) | 72.72 (= 0.18/12.0 * 4848.20) |
We want write a program to calculate the credit card balance after one year if a person only pays the minimum monthly payment required by the credit card company each month.
The following variables should be input by the user:
balance - the outstanding balance on the credit card
annualInterestRate - annual interest rate as a decimal
monthlyPaymentRate - minimum monthly payment rate as a decimal
Remaining balance: 813.41
instead of
Remaining balance: 813.4141998135
So your program only prints out one thing: the remaining balance at the end of the year in the format:
Remaining balance: 4784.0
A summary of the required math is found below:
Monthly interest rate = (Annual interest rate) / 12.0
Minimum monthly payment = (Minimum monthly payment rate) x (Previous balance)
Monthly unpaid balance = (Previous balance) - (Minimum monthly payment)
Updated balance each month = (Monthly unpaid balance) + (Monthly interest rate x Monthly unpaid balance)
Starting point: repl.it
Now write a program that calculates the minimum fixed monthly payment needed in order pay off a credit card balance within 12 months. By a fixed monthly payment, we mean a single number which does not change each month, but instead is a constant amount that will be paid each month.
In this problem, we will not be dealing with a minimum monthly payment rate.
The following variables contain values as described below:
balance - the outstanding balance on the credit card
annualInterestRate - annual interest rate as a decimal
Lowest Payment: 180
Assume that the interest is compounded monthly according to the balance at the end of the month (after the payment for that month is made). The monthly payment must be a multiple of $10 and is the same for all months. Notice that it is possible for the balance to become negative using this payment scheme, which is okay. A summary of the required math is found below:
Monthly interest rate = (Annual interest rate) / 12.0
Monthly unpaid balance = (Previous balance) - (Minimum fixed monthly payment)
Updated balance each month = (Monthly unpaid balance) + (Monthly interest rate x Monthly unpaid balance)
How might we go about finding the least payment, that is a multiple of $10, which will pay the balence off in a year? Use this new rwpl.it as a starting point: repl.it
You'll notice that in Step 2, your monthly payment had to be a multiple of $10. Why did we make it that way? You can try modifying your code from step 2 so that the payment can be any dollar and cent amount (in other words, the monthly payment is a multiple of $0.01). Does your code still work? It should, but you may notice that your code runs more slowly, especially in cases with very large balances and interest rates. (Try it for a balance of $100,000,000, with 0.05 interest. Why does it run so slow?
Well then, how can we calculate a more accurate fixed monthly payment than we did in Step 3 without running into the problem of slow code? We can make this program run faster using a technique introduced in lecture - bisection search!
The following variables contain values as described below:
balance
- the outstanding balance on the credit card
annualInterestRate
- annual interest rate as a decimal
What is a good upper bound? Imagine that instead of paying monthly, we paid off the entire balance at the end of the year. What we ultimately pay must be greater than what we would've paid in monthly installments, because the interest was compounded on the balance we didn't pay off each month. So a good upper bound for the monthly payment would be one-twelfth of the balance, after having its interest compounded monthly for an entire year.
In short:
Monthly interest rate = (Annual interest rate) / 12.0
Monthly payment lower bound = Balance / 12
Monthly payment upper bound = (Balance x (1 + Monthly interest rate)12) / 12.0
Write a program that uses these bounds and bisection search (for more info check out the Wikipedia page on bisection search) to find the smallest monthly payment to the cent (no more multiples of $10) such that we can pay off the debt within a year. Try it out with large inputs, and notice how fast it is (try the same large inputs in your solution to step 3 to compare!). Produce the same return value as you did in step 3. Note that your goal is NOT is get a negative balance, but rather to get within a few cents of zero.
Turn in link to final problem here: Moodle Link
I | Attachment | History | Action | Size | Date | Who | Comment |
---|---|---|---|---|---|---|---|
png | Screenshot_20180924_212605.png | r1 | manage | 5.1 K | 2018-09-25 - 01:30 | JimSkon | |
png | Screenshot_20180924_212627.png | r1 | manage | 7.5 K | 2018-09-25 - 01:30 | JimSkon | |
jpg | credit-card-debt.jpg | r1 | manage | 57.4 K | 2018-09-24 - 18:02 | JimSkon |