Debt to Income Ratio Calculator

  • Version
  • 22'925 Downloads
  • 18 KB File Size
  • January 4, 2022 Updated
  • 0 Number of comments
  • Rating
table of content

While waiting for an approval from my bank for new house loan mortgage application, I have been informed that the bank has checked my loan history and status and they said that my debt-to-income ratio is slightly above their ratio number. But, since I am already being their customer for more than 10 years with good payment track record, it looks like that my loan mortgage will be approved.

What is debt-to-income ratio? If you are a financial people, you will understand this term. Debt-to-income ratio is a personal finance measure that compares the amount of money that you earn to the amount of money that you owe to your creditors. This number is arisen when they plan to finance their new house, new car, or others. Any financial institutions or banks usually calculate it to determine your mortgage affordability.

Calculating your debt-to-income ratio is easy, open up an excel spreadsheet, put and sum up all of your bank or financial institution debts in one column, then put and sum up all of your income in other column, and divide the sum of your debt to the sum of your income. That's it. That is your debt-to-income ratio. If you are still confused to run it using excel you can download this simple debt-to-income ratio calculator to help you find out your ratio. Replace item name in the template with your income and loan item.

Inside this tool, there is a ratio classification which I quoted from Gerri Detweiler, author of The Ultimate Credit Handbook. And there are some other classification from other experts that probably more suitable for you. There are many factors that affect the ratio, because it will depend on other expenses. For example, family with children will have different expenses compare with single people. Your living neighborhood also will affect your monthly expenses. So, be wise with your expenses, and read many references in internet if you have problem on managing your monthly expenses.

This tool will be more suitable if you plan to apply for a loan mortgage and you want to calculate whether your ratio is below your bank requirement where maximum ratio of 36% or 37% is the most common parameter used by banks to give you loan.

How useful was this template?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 83

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

Cash Flow Statement

3.4 Mb / 13312 downloads
Present Value Calculator

21 KB / 5068 downloads
Profit and Loss Statement

1.7 Mb / 10057 downloads
Compound Interest Calculator

16 KB / 5029 downloads
Savings Calculator

16 KB / 6106 downloads
Credit Card Payoff Calculator

1.1 Mb / 17985 downloads
Simple Personal Budget

27 KB / 22750 downloads
Debt Reduction Calculator

27 KB / 13114 downloads
Bill Payment Calendar

6.6 Mb / 105469 downloads
View Comments
There are currently no comments.