Debt

An annual debt cost sheet: interest and fees on all loans and cards

Build an annual debt cost sheet with one row per loan or card, add up interest, fees and late charges, and see the total as a share of your income.

Editorial illustration for An annual debt cost sheet: interest and fees on all loans and cards

An annual debt cost sheet has one row per loan or card and columns for interest, fees and late charges for the year. Add the columns, total the rows, then divide the grand total by your yearly income. It shows what borrowing cost you in rupees, which an EMI amount alone never does.

What should the sheet contain?

Set up five columns in Excel or Google Sheets, with a header row in row 1 and your debts from row 2 down.

  • Column A: the loan or card, such as car loan or card one.
  • Column B: interest paid during the financial year.
  • Column C: fees, such as processing fees or an annual card fee.
  • Column D: late charges and penal charges.
  • Column E: the row total.

In E2 write =SUM(B2:D2) and copy it down. Under the last debt, write =SUM(B2:B5) in B6, and copy that across to C6, D6 and E6 for the column totals.

A worked example with made-up figures

These are hypothetical numbers for a year from April to March. Replace them with the figures from your own statements.

DebtInterestFeesLate chargesTotal
Car loan₹38,400₹1,200₹0₹39,600
Personal loan₹14,900₹2,000₹600₹17,500
Credit card₹9,300₹1,000₹500₹10,800
Phone EMI₹1,800₹0₹0₹1,800
Total₹64,400₹4,200₹1,100₹69,700

Check it two ways. Across the bottom row, 64,400 plus 4,200 plus 1,100 is ₹69,700. Down the last column, 39,600 plus 17,500 plus 10,800 plus 1,800 is also ₹69,700. If the two answers differ, there is a typing mistake in a row.

How much of your income does it use?

Put your yearly income in a cell, say B8, then in B9 write =E6/B8 and format the cell as a percentage. If the yearly income is ₹9,00,000, then ₹69,700 divided by ₹9,00,000 is about 0.0774, or 7.7 percent. Do not read that number as good or bad; it is a measure to track year on year.

Where do you find each figure?

  1. Loans: ask your lender for the year's statement and look for the interest portion of each EMI.
  2. Cards: read the monthly statements for interest, annual fee and late payment lines, and add each up.
  3. Fees: look at the loan documents and statements for processing or other fees charged during the year.
  4. If a figure is unclear, ask the lender in writing to confirm it.

Check each lender's own year summary for the interest figure, because the split between interest and principal changes every month.

Should you include money owed to family or friends?

Only if they charge interest or fees. An interest-free loan from a relative has no cost in this sheet, though you may want a separate list of balances you owe. Keep this sheet for the money that leaves your pocket as a price for borrowing, so that the year-on-year comparison is clean.

What do you do with the answer?

Sort the rows by total and look at the biggest, but also at the smallest: a late charge of ₹600 is a cost you could have avoided entirely. List the one or two debts that cost the most relative to what you owe and ask the lender about your options. Before taking any step, such as prepaying or switching, check the terms with the lender and, where needed, a qualified adviser.

When the sheet stops being enough

A sheet is enough for a handful of debts. When statement lines are many, SpendixAI can import the PDF, CSV or Excel statements, let you review the rows, and categorise charges in a category you create, such as interest and fees. Reports and a CSV download then give you the yearly totals to paste into your sheet.

Next step

  • Fill in last year's figures from your statements.
  • Calculate the share of income.
  • Set a reminder to update the sheet each quarter.
  • Compare this year's total with next year's.
SPENDIXAI JOURNAL

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

Explore your reports