A debt-to-income (DTI) ratio sheet totals your monthly debt payments, divides them by your gross monthly income, and expresses the result as a percentage. Use the calculator below to enter income and debt payments; it returns your DTI and the remaining income after those listed payments, before taxes and other living expenses.
Formula
DTI (%) = monthly debt payments ÷ gross monthly income × 100. In this sheet, inc is gross monthly income in dollars; mort, auto, student, and other are monthly debt or housing payments in dollars. The first output, dti, is the ratio as a percentage. debt is the sum of the entered monthly payments in dollars, and left is gross income minus those payments, also in dollars. The “left” figure is not take-home pay or a full budget balance: it does not subtract taxes, groceries, utilities, insurance, savings, or expenses not entered.
Worked Example
Using the default inputs:
- Gross monthly income: $6,000
- Housing payment: $1,500
- Auto loan payments: $400
- Student loan payments: $250
- Other monthly debt payments: $150
First add the entered monthly payments: $1,500 + $400 + $250 + $150 = $2,300. Divide that total by gross monthly income and multiply by 100: $2,300 ÷ $6,000 × 100 = 38.333…, which rounds to 38.33%. The total listed monthly debt payments are $2,300.00. Subtracting those payments from gross income gives $6,000 − $2,300 = $3,700.00 before taxes and all other costs.
Assumptions
- Income and payments are monthly amounts, entered in dollars; convert weekly, biweekly, or annual figures to monthly amounts before using the sheet.
- Gross income means income before taxes and payroll deductions.
- The calculation uses the payment amounts entered and does not apply an interest-rate or loan-amortization formula.
- It excludes taxes, utilities, insurance, groceries, and other costs unless you include them in an input. It does not assess loan fees, taxes, insurance, PMI, or escrow separately.
- The result is arithmetic for educational purposes, not financial advice or a prediction of approval.
What a DTI Sheet Includes
A debt-to-income sheet is a simple worksheet for comparing recurring monthly debt obligations with gross monthly income. The word “sheet” may mean a spreadsheet, a paper form, or a calculator like this one. The basic method stays the same: use monthly amounts, add the debts relevant to the calculation, then divide by gross monthly income.
For a more complete personal record, a sheet might list each obligation on its own row: housing payment, auto loan, student loan, minimum credit-card payment, and other recurring debt payments. A separate income section can show each income source and its monthly equivalent. Keeping the components visible makes it easier to spot an omitted payment or a number entered in the wrong period. The calculator combines the amounts into a single result, so retain your own itemized list if you need to review the entries.
How to Enter Income and Payments
- Choose the income amount that matches the calculation you want. This calculator uses gross income before tax, not the amount deposited into a bank account.
- Convert income to a monthly figure. For annual gross income, divide by 12. For a weekly amount, multiply by 52 and divide by 12; for a biweekly amount, multiply by 26 and divide by 12.
- Enter monthly payment amounts, not balances owed. A $10,000 loan balance is not a $10,000 monthly payment.
- Decide which obligations belong in the calculation you are making. Include applicable recurring debt payments and housing costs consistently; a lender or form may define its own categories.
- Check the result and keep the source and date of each amount with your sheet. Payments and income can change.
For instance, someone paid $1,500 every two weeks has approximate gross monthly income of $1,500 × 26 ÷ 12 = $3,250. Dividing by two would incorrectly produce $3,000 because a year has 26 biweekly pay periods, not 24. Use exact figures from pay records when available rather than relying on a rough conversion.
How to Interpret the Percentage
A DTI of 38.33% means that the listed monthly payments equal about 38 cents for each dollar of gross monthly income. It does not mean that 38.33% of take-home pay is spent on debt, because the denominator is pre-tax income. Nor does one calculated percentage establish whether a household can manage its full expenses: essential costs and irregular expenses may not be represented.
Definitions can differ between worksheets and financial institutions. Some calculations distinguish housing costs from other recurring debts, while some forms ask for particular categories or use specified payment amounts. Follow the instructions for the form or calculation you are completing, and do not assume this sheet duplicates an institution’s method. It simply calculates the ratio from the values entered.
Common Errors and Limits
- Using net income: This sheet’s formula requires gross income. Mixing gross income with take-home income changes the meaning of the result.
- Mixing time periods: Monthly debt payments divided by annual income produces a meaningless percentage. Convert both sides to monthly amounts first.
- Entering balances instead of payments: Enter the monthly obligation, not the total remaining loan or card balance.
- Leaving out relevant payments: An omitted obligation lowers the calculated DTI. Review each category and the instructions for the intended use.
- Counting an expense inconsistently: Whether a particular housing or other cost is included depends on the calculation’s definition. Apply one consistent rule and label the sheet.
- Reading the remainder as disposable income: The displayed remainder is gross income minus only the payments entered. It is not a spending allowance or affordability assessment.
The result is also sensitive to rounding and changing circumstances. The calculator rounds the displayed DTI to two decimal places, while the underlying division can produce more digits. For a formal application or assessment, use the figures and categories requested by the relevant institution rather than treating a rounded estimate as its official result.
Frequently Asked Questions
What is a debt-to-income ratio sheet?
A DTI sheet is a worksheet that records gross monthly income and relevant monthly debt payments, then calculates the payments as a percentage of income.
How do I calculate DTI by hand?
Add the monthly payments included in your calculation, divide their total by gross monthly income, and multiply by 100. Keep both the payments and income on the same monthly basis.
Should I use gross or net income?
This calculator uses gross income before taxes and deductions. Check the instructions for any other worksheet, since its stated definition controls how to fill it out.
Do I enter a loan balance or its monthly payment?
Enter the monthly payment. A balance is the amount still owed, not the amount paid each month.
Does a DTI result tell me whether I will be approved?
No. This arithmetic only reports a ratio from your inputs. It does not predict an institution’s decision or reproduce its criteria, definitions, or full review.
The result is an estimate, and the lender’s disclosure gives the exact figures.
Related
Formula used
in inc | Gross monthly income | $ | 6000 | 0.01 | 100000000 in mort | Housing payment | $ | 1500 | 0 | 100000000 in auto | Auto loan payments | $ | 400 | 0 | 100000000 in student | Student loan payments | $ | 250 | 0 | 100000000 in other | Other monthly debt payments | $ | 150 | 0 | 100000000 out dti | Debt-to-income ratio | % | (mort + auto + student + other) / inc * 100 | 2 out debt | Total listed monthly debt payments | $ | mort + auto + student + other | 2 out left | Income after listed debt payments | $ | inc - mort - auto - student - 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 Calculator and Spreadsheet Formula40.00 %
- 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: Calculate Your DTI Rate30.00 %