Partner Logo
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 - 2017, International Finance Corporation. All Rights Reserved.

© International Finance Corporation [Year of First Publication].  All rights reserved.
2121 Pennsylvania Avenue, N.W.
Washington, D.C. 20433
Internet:  www.ifc.org
 
The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law.  IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or  liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon

2121 Pennsylvania Avenue, N.W., Washington, D.C. 20433, www.ifc.org

The material in this work is copyrighted. Copying and/or transmitting portions or all of this work without permission may be a violation of applicable law.  IFC does not guarantee the accuracy, reliability or completeness of the content included in this work, or for the conclusions or judgments described herein, and accepts no responsibility or  liability for any omissions or errors (including, without limitation, typographical errors and technical errors) in the content whatsoever or for reliance thereon.

 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