Debt

Debt-to-income by hand: a ten-line worksheet

One ratio shows how much of your monthly income is already spoken for by repayments. You can work it out on paper in a few minutes, and re-run it whenever something changes.

Editorial illustration for Debt-to-income by hand: a ten-line worksheet

Why one ratio helps

Debts are usually discussed one at a time: this loan, that card, a small advance. The ratio of all monthly repayments to monthly income pulls them into a single figure. It answers a blunt question, how much of what I earn is committed before I have bought a single meal, and it does so in a way that can be compared month to month.

There is no universal right answer. Households differ in rent, family size and stability of income. The value of the ratio lies in watching its direction and noticing when it jumps.

The worksheet

  1. Write your take-home income for a typical month. If income varies, use the lower of your last three months.
  2. List every fixed repayment: each loan instalment, the card payment you have committed to, deferred-payment dues, committee contributions that act as obligations.
  3. Add them up.
  4. Divide the total by the income.
  5. Write the result as a percentage, and the date you worked it out.

That is the whole method. Use take-home pay rather than gross for a household view, because take-home is what you can actually spend.

An example with round numbers

LineAmount
Take-home income50,000
Home or personal loan instalment9,000
Vehicle or appliance instalment3,500
Card payment committed2,500
Total repayments15,000
Ratio30 percent

In this invented case, 30 percent of income is committed before any other spending. If a new instalment of 4,000 were added, the ratio would move to 38 percent. Seeing the step makes the effect of a new commitment concrete.

What counts and what does not

  • Include loan instalments, card payments you treat as fixed, and regular dues to family or groups
  • Leave out rent and utilities if you want a pure debt ratio, but also work out a second figure that includes them
  • Do not include voluntary savings, though you may want to see them alongside
  • Include only the interest part for loans where you pay interest alone

Choose one definition and keep it, so that the trend is comparable. Writing the definition at the top of the worksheet prevents drift.

Reading the result

Compare the ratio with your own comfort. If a bad month would push you into borrowing again, the ratio is high for you, whatever the textbook says. If you have a large buffer and steady income, a higher ratio might feel manageable. Official guidance and professional advisers sometimes discuss thresholds, but those depend on the setting, so check current sources before relying on any number.

What matters more is the direction. A ratio that is stable or falling means you are keeping control. A ratio that rises with each passing quarter is the signal to pause new borrowing.

Making it a habit

Re-run the worksheet at every monthly review and whenever you consider a new loan. Before saying yes, add the proposed instalment to the list and see the new ratio. SpendixAI’s reports on loan-repayment categories give you the repayment total quickly, so the worksheet takes only a few minutes.

Keep each result in a note with the date. After a year, you will have twelve data points and a clear picture of how the household’s obligations have moved.

Common mistakes with the ratio

The most frequent error is using gross income for one run and take-home for the next, so the trend jumps for no real reason. A second is forgetting the small items: a deferred payment due next week, a family contribution that is really a fixed arrangement. A third is using a good month’s income when the typical month is lower. Each makes the ratio look kinder than the truth.

If you have a partner whose income and debts are part of the household picture, decide whether to calculate the ratio jointly or for each person. Both views are useful, and the difference between them can start a helpful conversation about who carries what.

SPENDIXAI JOURNAL

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

Explore your reports