Skip to content

Maximum Affordable Loan

Maximum Affordable Loan

The largest loan whose payment fits within a debt-to-income limit: income times the allowed DTI ratio per period, less existing debt payments, is the payment capacity; the loan is that capacity converted to a principal at the rate and term.

When to use: Use to see how much house or car a given income supports under a lender's DTI rule (commonly 36% to 43% for mortgages), and how existing car or student payments shrink it.

Calculator

Formula

Loan=(Income×DTImOther)×1(1+k/m)nmk/m\text{Loan} = \left(\frac{\text{Income} \times \text{DTI}}{m} - \text{Other}\right) \times \frac{1 - (1 + k/m)^{-nm}}{k/m}

Variables

SymbolNameDescriptionUnit
MaxLoanMaximum LoanLargest principal the payment capacity supports$
AnnualIncomeAnnual Gross IncomeHousehold income before tax$
DTIDebt-to-Income LimitMaximum share of income allowed for all debt payments, as a decimal%
OtherDebtOther Debt PaymentsExisting debt payments per period (car, student, cards)$
kInterest RateAnnual interest rate on the new loan%
nLoan TermTerm in yearsyears
mPayments per YearNumber of payments per yearinteger

Real-Life Examples

Example 1: Mortgage at 36% DTI

$120,000 income, 36% DTI limit, $600 a month of other debt, 6.5% over 30 years.

Given

AnnualIncome = $120,000.00DTI = 36.0000%OtherDebt = $600.00k = 6.5000%n = 30.00 yearsm = 12.00

Step-by-Step

1.Payment capacity = 120,000 × 0.36 / 12 − 600 = $3,000 a month
2.Loan = 3,000 × [1 − (1 + 0.065/12)⁻³⁶⁰] / (0.065/12)
3.Maximum loan = $474,632.46
Result:$474,632.46

About $475,000 of mortgage. Without the $600 car payment the capacity would be $3,600 and the loan about $570,000: existing debt costs nearly $95,000 of house.

Example 2: Stretching to 43%

$75,000 income, 43% DTI, $900 a month of other debt, 7% over 30 years.

Given

AnnualIncome = $75,000.00DTI = 43.0000%OtherDebt = $900.00k = 7.0000%n = 30.00 yearsm = 12.00

Step-by-Step

1.Payment capacity = 75,000 × 0.43 / 12 − 900 = $1,787.50 a month
2.Loan = 1,787.50 × [1 − (1 + 0.07/12)⁻³⁶⁰] / (0.07/12)
3.Maximum loan = $268,674.78
Result:$268,674.78

Even at the more permissive 43% limit, $900 of existing payments and a 7% rate hold the maximum to about $269,000.

Frequently Asked Questions

Rules vary by lender and loan program. Conventional mortgages often use 36% (sometimes 43% or more with strong credit); the DTI here counts all debt payments, including the new loan, as a share of gross income.

Not unless you fold them in. Lenders usually count property tax, insurance and HOA dues as part of the housing payment, which reduces the loan this formula shows.