A debt-to-income (DTI) spreadsheet estimates the share of your gross monthly income used for monthly debt payments. Enter your gross monthly income and the monthly payments counted as debt; the calculator returns your DTI percentage and the income left after those listed payments.
Formula
DTI is the sum of the monthly debt payments entered, divided by gross monthly income, multiplied by 100:
DTI (%) = (M + A + C + O) ÷ I × 100
- I = gross monthly income, in dollars, before taxes and other deductions.
- M = housing payment entered, in dollars per month.
- A = auto loan payment, in dollars per month.
- C = credit card minimum payments, in dollars per month.
- O = other monthly debt payments, in dollars per month.
The calculator also reports the sum of the entered payments and subtracts it from gross income. That subtraction is not take-home pay or a full household budget: it does not account for taxes, food, utilities, insurance, savings, or costs you have not entered.
Worked Example
Using the calculator’s default values:
- Gross monthly income: $6,000.
- Listed monthly payments: $1,500 + $400 + $200 + $300 = $2,400.
- DTI: $2,400 ÷ $6,000 × 100 = 40.00%.
- Gross income after the listed payments: $6,000 − $2,400 = $3,600.00.
The result describes only the amounts entered and the definition used. A spreadsheet can reproduce the calculation with a total-debt cell divided by a gross-income cell, formatted as a percentage. Keep the underlying percentage calculation consistent: use either a decimal format or multiply by 100 and display a number, not both.
What a Debt-to-Income Spreadsheet Measures
DTI is a ratio, not a dollar limit. For example, a 40% result means the listed monthly debt payments equal 40 cents for every dollar of gross monthly income. It does not mean that 40% of take-home pay is committed, because the denominator is income before deductions.
The housing field is labeled broadly because a personal worksheet and an outside calculation may count housing costs differently. Some assessments may include more than a mortgage principal-and-interest payment, such as property-related charges or housing costs. The exact definition depends on the purpose and the organization doing the calculation. Check the applicable instructions rather than assuming that every DTI calculation counts the same items.
Likewise, the credit-card field uses monthly minimum payments rather than the card balances. A balance is the amount owed at a point in time; a monthly payment is a cash obligation over a month. Do not enter a balance where the formula expects a payment.
How to Use the Calculator as a Spreadsheet
- Use monthly figures for both income and payments. Convert weekly or biweekly amounts to monthly amounts consistently; multiplying a biweekly amount by two does not represent a full average calendar month. For an annual amount, divide by 12 if it is genuinely annual income.
- Enter gross income, not the amount deposited after payroll deductions. If income varies, choose a defensible monthly figure and note how you derived it; this calculator does not assess income stability.
- Add the monthly payments that fit the calculation you are trying to reproduce. Place obligations not represented by a named field in “other” only if they belong in that definition.
- Check that all figures use the same currency and period, and that a payment has not been counted twice.
- Read the percentage alongside the listed payment total. Record the date and assumptions if you save the result, since debts and income can change.
A spreadsheet version can use labeled input cells and a formula such as =SUM(B2:B5)/B1, with the result cell formatted as a percentage. In that setup, B1 must contain monthly gross income and B2:B5 the monthly payment amounts. If you instead multiply the formula by 100, format the result as a regular number to avoid displaying a percentage 100 times too large.
Interpreting the Result and Its Limits
A lower calculated DTI means the entered payments make up a smaller share of the entered gross income; a higher result means they make up a larger share. The number alone does not establish whether a person can afford a payment, qualifies for credit, or will receive any particular terms. Organizations may use different definitions, include different obligations, or evaluate other information. This calculator does not set or predict approval criteria.
“Income left” is especially easy to misread. The calculator subtracts listed debt payments from gross income, not from net income. The remaining amount still has to cover taxes and ordinary living expenses, as well as any obligations omitted from the inputs. Use a separate, more complete budget if you need to examine monthly cash flow.
Common Spreadsheet Errors
- Mixing time periods: dividing monthly payments by annual income makes the ratio misleading. Convert both sides to monthly figures first.
- Using net income: that creates a different ratio from the gross-income DTI defined here. Label any alternative clearly.
- Entering balances instead of payments: use monthly obligations in the numerator, not total principal owed.
- Double-counting housing: if the housing figure already includes an item, do not also add it as another payment.
- Misformatting the result: a spreadsheet percentage format already multiplies a decimal by 100 for display. Avoid adding another multiplication in the displayed value.
- Assuming the list is complete: this calculator includes only the four payment categories entered. Follow the definition relevant to your purpose.
Frequently Asked Questions
What does a 40% debt-to-income ratio mean?
It means the monthly payments included in the calculation total 40% of the gross monthly income entered. It does not mean 40% of take-home pay, and it does not by itself determine affordability or approval.
Should I use gross or net income for DTI?
This calculator uses gross income, meaning income before taxes and deductions. A different budgeting measure may use take-home income, but it should not be confused with this DTI formula.
Do credit card balances go into a DTI spreadsheet?
Usually the relevant input for a payment-based DTI calculation is a required monthly payment, not the full balance. Definitions can differ, so check the instructions for the calculation you need.
Does DTI include rent or a mortgage?
The housing field lets you enter a monthly housing payment, but the items counted can vary by calculation. Use the stated definition for the context; do not assume every assessment treats rent, mortgage payments, or related housing costs identically.
Can I use annual income in this calculator?
Not directly. Convert annual gross income to a monthly amount by dividing by 12, and enter monthly payments so the numerator and denominator cover the same period.
Is DTI the same as a budget?
No. DTI compares selected monthly debt payments with gross income. A budget also considers take-home income and other spending such as utilities, food, transportation, and savings.
This result is an estimate for educational purposes; a lender’s disclosure provides the exact figures used in its calculation.
Related
Formula used
in inc | Gross monthly income | $ | 6000 | 0.01 | 100000000 in mort | Housing payment | $ | 1500 | 0 | 100000000 in auto | Auto loan payment | $ | 400 | 0 | 100000000 in card | Credit card minimum payments | $ | 200 | 0 | 100000000 in other | Other monthly debt payments | $ | 300 | 0 | 100000000 out dti | Debt-to-income ratio | % | (mort + auto + card + other) / inc * 100 | 2 out debt | Listed monthly debt payments | $ | mort + auto + card + other | 2 out remain | Gross income after listed debt payments | $ | inc - mort - auto - card - other | 2
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- Debt-to-Income Ratio Calculator and How It Works30.00 %
- Debt-to-Income Ratio Calculator: Meaning and Formula24.00 %
- Debt-to-Income Ratio: Is Yours Too High?36.00 %
- Debt-to-Income Ratio Calculator and Scale24.00 %
- Debt-to-Income Ratio Calculator and Sheet38.33 %
- Debt-to-Income Ratio: Calculate Your DTI Rate30.00 %