a Let an be balance after the nth payment. We are asked to find the balance after the fourth payment, a4. To do this, we will find a for an. Then we will use a spreadsheet.
Recursive Rule
Since the annual interest rate is
11.5%=0.115, the monthly interest rate is
0.115/12. This tells us that the balance increases by a factor of
1+0.115/12 each month, and then the payment of
$173.86 is subtracted.
Balance afterpayment⇓an=(1+0.115/12)⋅=(1+0.115/12)⋅Balance beforepayment⇓an−1−−Payment⇓173.86
You borrow
$10000. This tells us the balance at the beginning of the first month is
$10000. Therefore,
a0=10000. Now, we can use a spreadsheet to find the balance after the fourth payment,
a4.
Spreadsheet
Let's enter
a0=10000 in cell A1 and write
=Round((1+0.115/12)∗(A1)−173.86,2)
in cell A2. When we hit enter, we will get the following.
Next, copy cell A2, highlight cells A3 through A5, and paste.
We get 9683.38 in the fifth row. Therefore a4=9683.38, and this tells us that the balance after the fifth payment is $9683.38.