Debt to Income Ratio Calculator

  • Version
  • 23'484 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?

Debt Reduction Calculator

27 KB / 13725 downloads
Bill Payment Calendar

6.6 Mb / 106336 downloads
Depreciation Calculator

20 KB / 6052 downloads
Fuel Consumption Calculator

14 KB / 24991 downloads
Electricity Consumption Calculator

44 KB / 24274 downloads
Grocery List Cost Estimator

38 KB / 6009 downloads
Event Budget

29 KB / 4572 downloads
Grocery Price Comparison Spreadsheet

38 KB / 27807 downloads
Extra Payment Calculator

248 KB / 11824 downloads
View Comments
There are currently no comments.