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.
- 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.