Debt-to-Income Ratio Calculator

Lenders use DTI to judge how much debt you can handle. Lower is better; under ~36% is generally considered healthy.

How the Debt-to-Income Ratio Calculator works

Your debt-to-income (DTI) ratio is your total monthly debt payments divided by your gross monthly income, multiplied by 100 - and this tool computes two versions of it at once: front-end (housing only) and back-end (all debt). DTI is a lending-approval number, not a payoff timeline. It tells a lender how much of your pre-tax paycheck is already promised to debt before they hand you a new loan.

The core formula is:

DTI % = (total monthly debt payments / gross monthly income) x 100

• Gross monthly income = your income before any taxes or deductions. If you are paid annually, divide salary by 12 (e.g. $90,000 / 12 = $7,500).
• Total monthly debt payments = the minimum required payments on recurring debt obligations, not the balances you owe.

Here is exactly what the calculator does internally:

1. Converts any annual income you enter into a gross monthly figure.
2. Sums your housing payment (rent, or mortgage principal + interest + taxes + insurance + HOA) into a separate bucket.
3. Sums every other required debt payment (car, student, credit-card minimums, personal loans, child support) into a second bucket.
4. Divides housing by gross income for your front-end DTI.
5. Divides housing + all other debt by gross income for your back-end DTI.
6. Compares both against the 28/36 rule, the 43% Qualified-Mortgage line, and the ~50% lender-flex ceiling.

Edge cases it handles: zero income returns no result instead of dividing by zero; it ignores items lenders do not count (utilities, groceries, insurance premiums, streaming); and because lenders use gross, not take-home, it never asks for your net pay. The output is a percentage you can take straight to a loan officer to gauge approval odds - not a schedule of how long your debt takes to clear.

Example calculation

Three borrowers with identical-looking math but very different approval odds show how front-end and back-end DTI diverge.

Example 1 - Renter applying for a car loan. Gross monthly income $5,000. Housing (rent) $1,200, car $350, student loan $200, credit-card minimum $100. Front-end DTI = $1,200 / $5,000 x 100 = 24.0%. Back-end DTI = ($1,200 + $350 + $200 + $100) / $5,000 x 100 = $1,850 / $5,000 = 37.0%. Comfortably approvable - but note that adding a new $400 car payment would push back-end to $2,250 / $5,000 = 45.0%, into flex territory.

Example 2 - Dual-income couple buying a home. Gross monthly income $8,000. Proposed housing (PITI) $2,100, car $550, student loans $400, card minimums $250, personal loan $150. Front-end = $2,100 / $8,000 = 26.25%. Back-end = $3,450 / $8,000 = 43.13%. That nudges just past the 43% QM line - paying down $570 of monthly debt brings back-end to $2,880 / $8,000 = 36.0%, or earning just $24 more per month gross ($3,450 / $8,024 = 42.996%) tips them back under 43%.

Example 3 - Paying off a card to qualify. Gross $6,000, housing $1,500, car $450, card minimum $300. Back-end = ($1,500 + $450 + $300) / $6,000 = $2,250 / $6,000 = 37.5%. Pay off the card and back-end drops to $1,950 / $6,000 = 32.5% - a 5-point improvement from one move, with no change to front-end (housing is untouched).

Scenario	Gross/mo	Housing	Other debt	Front-end	Back-end
1. Renter + car loan	$5,000	$1,200	$650	24.0%	37.0%
2. Couple + mortgage	$8,000	$2,100	$1,350	26.25%	43.13%
3. After card payoff	$6,000	$1,500	$450	25.0%	32.5%

Notice Example 2 has the lowest front-end yet the highest back-end - housing alone looks great, but stacked consumer debt is what threatens approval. That gap between the two ratios is exactly why lenders run both, and why a payoff timeline tells you nothing about whether the loan clears underwriting today.

Tips for using the Debt-to-Income Ratio Calculator

• Pay off the smallest-balance revolving account first when qualifying, not the highest-interest one. Eliminating a $300 card minimum removes the entire payment from your back-end DTI even if the balance was tiny - lenders count the required payment, not the interest cost.
• An installment loan with 10 or fewer payments left is usually excluded from DTI by mortgage underwriters. If your car loan has 9 payments remaining, you may not need to pay it off at all - ask the loan officer before draining savings.
• Never confuse gross with take-home. Lenders use pre-tax income, so a $6,667-a-month gross earner with $5,000 net is measured against $6,667. Plugging in net pay overstates your DTI (40% vs 30% on $2,000 of debt) and can scare you off a loan you'd actually get.
• Adding a co-borrower adds their income AND all their debts. If their DTI is worse than yours, a joint application can raise the combined ratio - run both scenarios before deciding whose name goes on the loan.
• Authorized-user and co-signed accounts count against you. If you co-signed your kid's car loan, that payment sits in your back-end DTI even though you never drive it - unless you can document someone else has paid it on time for the last 12 months.
• Pay credit-card balances before the statement closing date, not just the due date. A reported $0 balance means a $0 minimum, instantly shrinking back-end DTI - plan the paydown with the credit-card-payoff-calculator so the lower balance hits your report before you apply.
• Income-driven student-loan payments can be used at their actual (sometimes $120, sometimes $0) amount by many programs, but some loan types impute 0.5% to 1% of the balance instead - on a $40,000 balance that is $200 to $400 a month. Get a servicer statement showing the real payment before applying.
• Don't open or finance anything in the 60 days before applying. A new $400 furniture installment can swing back-end DTI by several points and re-trigger underwriting - see how a payment maps to borrowing room in the loan-affordability-calculator.
• Boosting gross income lowers DTI faster than you'd think near the ceiling. In a $3,450-debt, $8,000-income scenario, just $24 more in monthly gross moves you from 43.13% to under 43% - document any raise, two-year bonus average, or stable side income.
• Front-end DTI is the quiet gatekeeper for mortgages. You can pass back-end at 41% but still get pushed back if housing alone exceeds ~28-31%; price the home so PITI fits the front-end rule using the mortgage-calculator before you fall in love with it.

Front-end vs back-end DTI: the two ratios lenders run

Front-end DTI counts only your housing payment, while back-end DTI counts every required monthly debt payment - and a mortgage lender checks both. Front-end isolates whether the home itself is affordable; back-end measures your total obligation load. You can look great on one and fail the other, which is why this is an approval test, not a budgeting exercise.

	Front-end DTI	Back-end DTI
What's counted	Housing only (PITI + HOA)	Housing + all other debt
Also called	Housing ratio	Total debt ratio
Typical target	28% or less	36% or less
Common max	~31%	43% (QM), ~50% with flex
Used most for	Mortgage sizing	Almost every loan

For non-mortgage loans (auto, personal, credit card), lenders mostly look at back-end DTI - there is no separate housing test. The front-end number matters most when housing is the loan being underwritten. To see how much house a given payment buys, pair this with the mortgage calculator, and to translate a target back-end DTI into a maximum borrowing limit, use the loan affordability calculator.

The 28/36 rule, the 43% ceiling, and where lenders flex to 50%

The 28/36 rule says spend no more than 28% of gross income on housing and no more than 36% on total debt - but the Qualified-Mortgage back-end ceiling is 43%, and many lenders approve up to roughly 50% with compensating factors. These three lines are the heart of an approval decision.

• 28/36 is the conservative comfort zone underwriters prefer. It is a guideline, not a law.
• 43% is the back-end DTI threshold tied to the Qualified-Mortgage standard. Staying at or below it makes a mortgage easiest to approve and to sell on the secondary market.
• ~50% is where flexible automated-underwriting programs go when you have compensating factors: a large down payment, strong cash reserves, a high credit score, or stable long-term income.

So a 45% back-end DTI is not an automatic rejection - it just shifts you from "easy yes" to "yes, if the rest of your file is strong." Where you land between 36% and 50% often decides your interest rate, not only your approval. This is the difference between DTI and a payoff calculator: DTI ranks your approval odds at one moment, while a payoff tool ranks how long debt takes to disappear.

What counts as debt - and what doesn't

DTI counts required monthly debt obligations, not your living expenses - so utilities, groceries, and insurance premiums are excluded even though they cost real money. Getting this list right is what separates an accurate approval ratio from a guess.

Counts toward DTI	Does NOT count
Rent or mortgage (PITI)	Utilities (electric, water, gas)
HOA / condo dues	Phone, internet, streaming
Auto loan / lease	Groceries and gas
Student loan payments	Health / auto / life insurance
Credit-card minimum payments	Childcare and tuition
Personal / installment loans	Taxes withheld from pay
Child support / alimony owed	Savings / 401(k) contributions
Co-signed or co-borrowed loans	Day-to-day discretionary spending

The big surprise for most people: lenders ignore the bills that feel most stressful (utilities, food) and focus only on contractual debt that shows on a credit report. That's why DTI can look healthier than your budget feels. To shrink the items that do count before you apply, the debt payoff calculator shows which balances to clear first.

Common mistakes that wreck your DTI math

The most damaging DTI errors come from using the wrong income figure or the wrong debt figure - both shift your ratio by points that can change an approval.

• Using net (take-home) income. Lenders use gross. Net pay makes your DTI look worse than the number they will actually run - on $80,000 a year that is the difference between 30% (gross) and 40% (net) on $2,000 of debt.
• Entering full credit-card balances instead of minimum payments. DTI uses the monthly minimum, not the balance you owe.
• Adding living expenses. Tossing in groceries, utilities, or insurance overstates the ratio - those are not debt.
• Forgetting co-signed loans. If you co-signed, that payment counts as yours until you prove someone else has paid it for 12 months.
• Using current rent for a purchase. For a mortgage, front-end DTI uses the proposed new PITI, not today's rent - the rent disappears at closing.
• Ignoring HOA dues. They roll into the housing bucket and can quietly push you past the 28% front-end line.
• Treating DTI as a payoff plan. DTI measures borrowing capacity at a moment in time - it does not tell you how long debt takes to clear. For that, use the credit card payoff calculator.

How to calculate DTI by hand or in Excel

You can reproduce this calculator with one division, or with a single spreadsheet formula. By hand: add up every required monthly debt payment, divide by gross monthly income, then multiply by 100.

In Excel or Google Sheets, put gross monthly income in cell B1 and your debt payments in B2 down to B6, then:

• Back-end DTI: =SUM(B2:B6)/B1*100
• Front-end DTI (housing in B2): =B2/B1*100
• Convert annual salary to gross monthly first: =A1/12 where A1 is annual pay.
• Max housing under the 28% rule: =B1*0.28
• Max total debt under the 36% rule: =B1*0.36
• Room left before the 43% ceiling: =B1*0.43-SUM(B2:B6)

Worked by hand: with $6,000 gross and $2,250 of total debt payments, $2,250 / $6,000 = 0.375, x 100 = 37.5%. The 28% housing cap would be $6,000 x 0.28 = $1,680, and the 43% ceiling allows up to $6,000 x 0.43 = $2,580 in total debt payments - so this borrower has $330 of monthly payment room before hitting the QM line.

Is your DTI good? Benchmark numbers

A back-end DTI of 36% or less is considered healthy, 37-43% is acceptable to most lenders, 44-49% is borderline and rate-sensitive, and 50% or above is hard to approve. Use this as a reality check against your result.

Back-end DTI	How lenders read it
0-20%	Excellent - large borrowing headroom
21-36%	Healthy - the comfort zone
37-43%	Acceptable - within the QM line
44-49%	Borderline - needs compensating factors
50%+	High risk - approval difficult

Front-end DTI has its own scale: at or under 28% is ideal, up to ~31% is common, and above that pressures a mortgage approval on its own. Remember these are approval benchmarks - a 36% DTI says you qualify, not that the payments are comfortable for your actual budget. A lender can clear you at 43% and still leave you stretched.

Concrete ways to lower DTI before you apply

You lower DTI two ways: shrink the numerator (monthly debt payments) or grow the denominator (gross income) - and the fastest wins come from eliminating whole payments.

• Pay off a small revolving balance entirely so the minimum payment disappears from your back-end DTI - clearing a $300 card minimum on $6,000 income drops DTI 5 points.
• Pay a card before its statement closing date so a lower (or $0) balance is reported, cutting the minimum that lands on your credit file.
• Avoid new credit for 60 days before applying - no new car, no "12 months same as cash" furniture, no extra cards.
• Document additional gross income: a raise, a consistent two-year bonus history, or stable side income all expand the denominator.
• Recast or refinance an existing loan to a lower monthly payment, which directly trims the numerator without paying the debt off.
• Time loans you can retire: installment loans with 10 or fewer payments left are often excluded - finishing one early can cost less than draining savings to clear a big balance.

Once you target a lower ratio, confirm how much new borrowing it unlocks using the loan affordability calculator, and check the take-home impact of the new payment with the take-home pay calculator.

DTI approval quick reference: the 28/36 rule and 43% QM ceiling by income

The fastest way to judge borrowing capacity is to apply the limits straight to gross monthly income. Front-end DTI counts housing only (PITI plus HOA), back-end DTI counts every monthly debt, and lenders use gross (pre-tax) income. Below, each cell is income x the stated rate: front-end at 28%, back-end at 36%, the 43% Qualified-Mortgage ceiling, and the ~50% level where automated underwriting may flex with strong credit and reserves.

Gross monthly income	Annual	28% front-end (housing max)	36% back-end (total debt)	43% QM ceiling (total debt)	~50% flex (total debt)
$4,000	$48,000	$1,120	$1,440	$1,720	$2,000
$5,500	$66,000	$1,540	$1,980	$2,365	$2,750
$6,000	$72,000	$1,680	$2,160	$2,580	$3,000
$7,500	$90,000	$2,100	$2,700	$3,225	$3,750
$8,000	$96,000	$2,240	$2,880	$3,440	$4,000
$10,000	$120,000	$2,800	$3,600	$4,300	$5,000

Read it as a ceiling, not a target: a $7,500 earner can carry up to $2,700 of total debt at 36%, but every $375 of monthly debt equals 5 percentage points of DTI ($375 / $7,500 = 5%), so trimming payments before you apply directly widens which lenders will approve you - and at what rate.

Related on this site

Loan Affordability Calculator · Debt Payoff Calculator · Mortgage Calculator · Credit Card Payoff Calculator · Take-Home Pay Calculator · Down Payment Calculator

For a related deep dive, see CFPB debt-to-income ratio.

Debt-to-Income Ratio Calculator — frequently asked questions

What DTI do lenders want?

Many mortgages prefer ≤36–43% total DTI, though programs vary.

Gross or net income?

Lenders use gross (pre-tax) monthly income for DTI.

What DTI do mortgage lenders want?

Often 43% or less total, though some programs allow higher with compensating factors.

How do I lower my DTI?

Pay down balances or increase income; avoid taking on new debt before applying.

What is the maximum mortgage payment I can have at the 28% front-end rule on a $7,500 monthly gross income?

Your housing payment can reach about $2,100 per month under the 28% front-end DTI rule. Front-end DTI counts only housing (principal, interest, taxes, insurance, plus HOA): 0.28 x $7,500 = $2,100. The 36% back-end rule then caps ALL debt at 0.36 x $7,500 = $2,700, leaving $600 for car, card, and student-loan payments. Estimate the payment with the <a href="/mortgage-calculator/">mortgage calculator</a>.

How much total monthly debt can I carry at the 43% Qualified-Mortgage limit if I earn $8,000 a month?

About $3,440 in total monthly debt payments. The 43% QM ceiling is a back-end limit: 0.43 x $8,000 = $3,440 for housing plus every other recurring debt combined. If your car, cards, and student loans already total $900, only $2,540 is left for housing (PITI). Many lenders flex above 43% to roughly 50% with strong credit and reserves; see the <a href="/loan-affordability-calculator/">loan affordability calculator</a>.

What is my back-end DTI if I make $6,500 a month and pay $450 car, $200 student loan, $150 credit cards, and a $1,500 mortgage?

Your back-end DTI is about 35.4%. Add every monthly debt: $1,500 + $450 + $200 + $150 = $2,300. Divide by gross income: $2,300 / $6,500 = 0.354, or 35.4%. That sits under the 36% benchmark and well below the 43% QM ceiling, so most lenders would view it favorably. Your front-end (housing-only) DTI is $1,500 / $6,500 = 23.1%.

How much housing payment is left for me at 43% DTI on $6,500 income after $800 of other debt?

About $1,995 per month for housing. First find the back-end room: 0.43 x $6,500 = $2,795 total allowed debt. Subtract existing non-housing debt: $2,795 - $800 = $1,995 available for principal, interest, taxes, and insurance. If that is too tight, lowering the $800 to $500 frees the housing budget to $2,295. Pair this with the <a href="/down-payment-calculator/">down payment calculator</a>.

By how much does paying off a $350 monthly car loan lower my DTI if I earn $7,000 a month?

It drops your back-end DTI by exactly 5 percentage points. The car payment adds $350 / $7,000 = 0.05, or 5%, to your ratio. Eliminate it and that 5% disappears from the back end (front-end housing DTI is unaffected). If your DTI was 41%, it falls to 36% the moment the loan is closed and removed from your credit report, often the fastest single move before applying.

How do I calculate debt-to-income ratio in Excel?

Use =SUM(debt cells)/gross_income formatted as a percentage. Put each monthly payment in cells B2:B6, gross monthly income in C2, then enter =SUM(B2:B6)/C2 and format the result as Percent. For example, $2,200 of debt over $6,000 income gives =2200/6000 = 0.3667, shown as 36.7%. For front-end DTI only, divide just the housing cell by C2. Multiply by 100 if you want the raw number instead of a percent format.

What income do lenders use for DTI, gross or net, and how much difference does it make on $80,000 a year?

Lenders use gross (pre-tax) income, which makes your DTI look much better than net. On an $80,000 salary, gross monthly income is $80,000 / 12 = $6,667. After roughly 25% for taxes and deductions, net might be about $5,000. With $2,000 of debt, gross DTI is $2,000 / $6,667 = 30%, but on net it would be $2,000 / $5,000 = 40%. Lenders qualify you on the 30% figure.

Does my rent count toward DTI when I apply for a mortgage?

No, your current rent is excluded from DTI because it is replaced by the new mortgage payment. Lenders count the proposed housing payment (PITI plus HOA), not the rent you are leaving. So if you pay $1,600 rent now but the new mortgage PITI is $2,000, only the $2,000 enters the calculation. This is why DTI for a purchase or refinance reflects the future loan, not your current housing cost.

What counts as monthly debt for DTI and what does not?

DTI counts required minimum payments on credit accounts, not your living expenses. Included: mortgage or rent (proposed), auto loans, student loans, minimum credit-card payments, personal loans, and court-ordered alimony or child support. Excluded: utilities, groceries, insurance premiums, phone, streaming, gas, and taxes withheld from pay. A $300 cable-and-grocery bill never affects DTI, but a $300 minimum card payment fully counts.

Is a 45% debt-to-income ratio too high to get approved for a loan?

A 45% DTI is above the 43% Qualified-Mortgage line but often still approvable with compensating factors. Conventional loans run through automated underwriting frequently allow up to about 50% with a strong credit score, cash reserves, or a large down payment. At 45% on $6,000 income, your debt is 0.45 x $6,000 = $2,700. Trimming it to $2,580 reaches 43% ($2,580 / $6,000), widening your lender options and usually lowering your rate.

How much do I need to earn to qualify for a $2,500 mortgage payment under the 28% rule?

About $8,929 per month, or roughly $107,000 a year. The 28% front-end rule means housing should be no more than 28% of gross income, so required income = $2,500 / 0.28 = $8,929 per month. Multiply by 12 for $107,143 annually. If you also carry $700 of other debt, the 36% back-end rule requires ($2,500 + $700) / 0.36 = $8,889, so the front-end rule is the binding (higher) constraint here.

How do student loans on income-driven repayment affect my DTI for a mortgage?

Lenders usually count your actual IDR payment, even if it is far below the standard amount. If your income-driven payment is $120 a month on a $40,000 balance, many programs use that $120, not a hypothetical $400. On $7,000 income, $120 adds only 1.7% to DTI ($120 / $7,000). Some loan types instead impute about 0.5% to 1% of the balance ($200 to $400 here), so confirm which rule your lender applies before you shop.

How does adding a $35,000 car loan at $600 a month change my DTI on a $90,000 salary?

It raises your DTI by about 8 percentage points and can blow past the 43% line. Gross monthly income on $90,000 is $7,500. A new $600 payment adds $600 / $7,500 = 0.08, or 8%. If your DTI was 36% ($2,700 of debt), it jumps to 44% ($3,300 / $7,500). That is why lenders warn against financing a car right before a mortgage. Model the payment with the <a href="/auto-loan-calculator/">auto loan calculator</a>.

Should I pay down debt or increase my down payment to improve mortgage approval odds?

Pay down monthly-payment debt first, because DTI is the harder approval gate than down payment for most borrowers. Eliminating a $400 monthly payment on $6,000 income cuts DTI by 6.7 points, often moving you from declined to approved. A bigger down payment lowers the loan amount but barely changes DTI unless it also shrinks the monthly payment. Compare both effects using the <a href="/down-payment-calculator/">down payment</a> and <a href="/debt-payoff-calculator/">debt payoff</a> tools.

Does paying off a credit card help DTI even if I keep the card open?

Yes, paying the balance to zero removes its minimum payment from DTI while keeping the available credit. DTI counts the required minimum, not the limit, so a $5,000 balance with a $150 minimum adds $150 / $6,500 = 2.3% on $6,500 income; pay it off and that 2.3% disappears. Keeping the account open also helps your credit utilization and history, so do not close it. See the <a href="/credit-card-minimum-payment-calculator/">minimum payment calculator</a>.

What is the difference between front-end and back-end DTI on $5,500 monthly income with a $1,400 rent-equivalent and $700 other debt?

Front-end DTI is 25.5% and back-end DTI is 38.2%. Front-end counts housing only: $1,400 / $5,500 = 0.255, or 25.5%. Back-end adds all other debt: ($1,400 + $700) / $5,500 = $2,100 / $5,500 = 0.382, or 38.2%. Lenders apply the 28/36 rule to these two figures separately, so you can pass the front-end test yet fail the back-end if other debts are high.

Guides & articles

• What DTI Do You Need to Get Approved for a Mortgage?
• How to Lower Your DTI Before You Apply for a Loan

Related calculators

Debt Payoff Calculator · Credit Card Payoff Calculator · Credit Card Minimum Payment Calculator · Mortgage Calculator · Loan Calculator · Auto Loan Calculator