Skip to content
The title slide and first slides of the Debt to Income Calculator template

Debt to Income Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 16, 2026

Every slide (6)

Overview

Before a lender looks at your credit history, it usually divides your monthly debt payments by your gross monthly income. This sheet does that division for you. Income goes on one tab with its source and type, debts go on another with the payment you make each month, and the Ratio tab displays the answer in percent, next to the share that rent or a mortgage takes on its own.

A small Bands table turns the percent into a word such as Low or High. The four starting points are examples, and you can overwrite each one with the limits your lender or loan program publishes. Add the payment you expect on a new car or home loan as an extra row on Debts, and the ratio shows what you would carry after borrowing.

Useful for

  • Check your ratio before you apply for a mortgage or car loan
  • See how paying off a card changes the percent
  • Work out how much new payment you could add before crossing a lender's limit

What's included

  • 5 tabs: Ratio, Income, Debts, Bands, How to use
  • Ratio: a dashboard with 5 summary figures
  • Income: a table
  • Debts: a table
  • Bands: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Income tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do you calculate debt to income?

Add up your monthly debt payments, divide by your gross monthly income and multiply by 100. The Ratio tab does this as soon as both lists are filled in.

Does rent count as debt?

Lenders count a mortgage or the rent you pay today as a housing payment. Enter it with the Housing type and the sheet also shows it as its own percent of income.

What is a good debt to income ratio?

It depends on the lender and the loan type. The Bands tab holds example cutoffs you can replace with the numbers your lender gives you.

  • #financial-calculator
  • #debt-to-income-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More financial calculator templates

See all 29

Also in Finance

All finance templates
Get this template

Preparing your template…