Home  > Debt: Calculate Your Monthly Debt Percentage
 Share  Print Version  Email

Debt: Calculate Your Monthly Debt Percentage

Provided by the International Finance Corporation

Benefits:  This worksheet is set up to be used to calculate your level of debt. Fill in the worksheet by listing all your debts (money borrowed that is being repaid). Examples may include: car payment; mortgage; student loans; and personal loans. Then add in your monthly payments. Most of these amounts are fixed and do not fluctuate. However, if the amount is not fixed, include an average amount by looking at your payment pattern over several months.

Only include credit cards if you are paying off a balance. If you use your credit cards for convenience only and pay the bill in full, it is not considered a debt. 

You need to also know your household gross income (income before taxes and other deductions). Enter this amount and the spreadsheet will automatically compute your percentage. Compare this number with the percentages in the "answer key" tab.

File Description: The file is a Microsoft Excel spreadsheet template.

Special Features:

  • Download this spreadsheet template just once, and be able to use it over and over again.
  • The spreadsheet contains the formatting for calculating your monthly debt level.
  • The spreadsheet can be completely customized — you can quickly add or delete items or revise the format to meet your needs.
  • The spreadsheet is easy to use. Just plug in your monthly debt expenses and your gross income and it will automatically give you your debt percentage.

Attachments: Debt Level Worksheet

Copyright © 2000 - 2016, International Finance Corporation. All Rights Reserved.

 Share  Print Version  Email
Comments &Ratings (0)
If you are a human, do not fill in this field.
Click stars to rate.
   Comments are truncated at 1000 characters