Debt

How to chart your debt payoff progress month by month

Chart your debt payoff progress month by month with a stacked area or line chart of each loan's balance, using six months of invented figures.

Editorial illustration for How to chart your debt payoff progress month by month

To chart debt payoff progress, make a table with one row per month and one column per loan's remaining balance, then insert a stacked area chart. The height of the stack is your total debt, and each band is one loan, so you can watch the whole pile shrink and see each loan disappear.

Build the table

  1. Column A: month, starting with month 0 for today's balances.
  2. Columns B, C and D: the remaining balance of each loan, taken from the lender's statement.
  3. Column E: =SUM(B2:D2) for the total owed, filled down.
  4. Add one new row after each statement.

Six months of invented data

Say Loan A is ₹24,000 at 24 percent with a ₹2,500 payment, Loan B is ₹70,000 at 13 percent with ₹3,000, and Loan C is ₹1,50,000 at 10 percent with ₹4,000. The rates are assumptions and the payments never change.

MonthLoan ALoan BLoan CTotal
0₹24,000₹70,000₹1,50,000₹2,44,000
1₹21,980₹67,758₹1,47,250₹2,36,988
2₹19,920₹65,492₹1,44,477₹2,29,889
3₹17,818₹63,201₹1,41,681₹2,22,700
4₹15,674₹60,886₹1,38,862₹2,15,422
5₹13,487₹58,546₹1,36,019₹2,08,052
6₹11,257₹56,180₹1,33,152₹2,00,589

How do I draw the chart?

Select the month column and the three loan columns, leaving out the total. In Excel, use the Insert menu, then Area, then Stacked Area. In Google Sheets, use Insert, then Chart, then choose the stacked area type. If the months appear as a data series, change the horizontal axis to the month column. For a line chart instead, choose the line type, which shows each loan's own path without stacking.

How do I read it?

  • The total height falls from ₹2,44,000 to ₹2,00,589 in six months, which is ₹43,411, or about 17.8 percent.
  • Loan A's band shrinks the most in proportion: from ₹24,000 to ₹11,257, a fall of about 53.1 percent.
  • Loan B has fallen about 19.7 percent and Loan C about 11.2 percent.
  • A band that narrows to nothing is a loan that has closed, and the stack gets lower for good.

Over six months you paid 6 times ₹9,500, which is ₹57,000, and ₹13,589 of it was interest, so the debt fell by ₹43,411. Loan C has the largest balance and the slowest percentage fall, since its ₹4,000 payment includes ₹1,250 of interest in month 1.

What is the stacked area good for, and the line chart?

Use the stacked area for the big picture and the line chart when you want to see whether one loan has stopped moving. A flat stretch on a line is a loan where the payment barely exceeds the interest, which is worth investigating.

What can go wrong with the chart?

  • Using balances from different dates in the same month, which makes some months look quicker than others.
  • Including new card spending in a card loan's balance, so the band rises when you buy something. Chart only the old balance, or keep new spending separate.
  • Leaving a closed loan's cell blank instead of zero, which can break the stack.
  • Forgetting to extend the chart range after adding a row.

A monthly routine

  1. After each statement, read each loan's balance.
  2. Add the row, check the total, and look at the chart.
  3. Compare the actual balance with the plan, and note any difference.
  4. When a loan closes, leave its column at zero so the band disappears cleanly.

SpendixAI's Report builder can filter and group your records, and its CSV download lets you pull a month's loan payments into the sheet, so the chart rests on what left your account and not on what you remember.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports