Sarah is a mortgage underwriter specializing in debt-to-income and qualification rules, ensuring the affordability calculations meet industry standards.
The **Mortgage Affordability Calculator** helps you estimate the maximum loan amount you can qualify for, based on your income, existing debt, and lender-imposed Debt-to-Income (DTI) limits. This versatile four-function solver allows you to determine the **Maximum Loan Amount (L)**, **Maximum Monthly Payment (M)**, **Total Monthly Income (I)**, or **Total Monthly Debt (D)**. Simply enter any three of the four required variables, along with the loan terms, and the tool will solve for the missing one.
Mortgage Affordability Solver
Loan & Limit Inputs
Mortgage Affordability Key Formulas
The calculation relies on two key components: the Debt-to-Income (DTI) ratio, which determines the maximum monthly payment (M), and the Amortization Formula, which converts that maximum payment (M) into a maximum loan amount (L).
Core Identity 1: Maximum Payment (M) from DTI
$$ M_{max} = (I \cdot DTI_{limit}) - D $$
\text{Where DTI}_{limit} \text{ is in decimal form.}
\text{Core Identity 2: Loan Amount (L) from Payment}
$$ L = M \left[ \frac{(1+i)^n - 1}{i(1+i)^n} \right] $$
\text{Where } i = R/12 \text{ and } n = T \times 12
Formula Source: CFPB: Debt-to-Income Ratio
Variables
- L (Max Loan Amount): The largest principal amount the borrower can finance under the given DTI, rate, and term. (In currency).
- M (Max Monthly Payment): The maximum P&I amount the borrower can afford based on DTI rules. (In currency).
- I (Total Monthly Income): The borrower’s gross monthly income used for qualification. (In currency).
- D (Other Monthly Debt): Total minimum monthly payments for non-mortgage debts (e.g., cars, credit cards). (In currency).
- R & T (Rate & Term): The annual interest rate and loan term used for the amortization calculation. (Auxiliary inputs).
Related Mortgage Affordability Calculators
Fine-tune your home buying budget and loan strategy:
What is Mortgage Affordability?
Mortgage affordability refers to a borrower’s capacity to comfortably make their mortgage payments without straining their overall financial health. Lenders primarily use the **Debt-to-Income (DTI) Ratio** to determine this capacity. The DTI ratio is the percentage of a borrower’s gross monthly income that goes toward servicing all monthly debt payments, including the future mortgage payment (PITI).
The affordability calculation is typically performed by setting a maximum allowable DTI (e.g., 43%). The maximum monthly payment (M) is then derived by subtracting existing debts (D) from the DTI-mandated limit. Once the maximum affordable monthly payment (M) is known, the amortization formula is used in reverse to calculate the largest loan amount (L) that results in that payment. It is crucial to remember that this calculated maximum is based purely on debt rules and does not account for property taxes, insurance (PITI), or discretionary spending needs.
How to Calculate Max Loan Amount (Example)
An applicant earns $\$5,000$ (I) per month, has other debts (D) of $\$500$, and the lender’s DTI limit is $45\%$. The loan terms are $30$ years at $6.0\%$.
-
Step 1: Calculate Max Total Debt Payment ($I \times DTI$)
Max Total Payment $= \$5,000 \times 0.45 = \$2,250$.
-
Step 2: Calculate Max Mortgage Payment ($M_{max}$)
$$ M_{max} = \$2,250 (\text{Max Total}) – \$500 (\text{Other Debts}) = \$1,750 $$
-
Step 3: Convert Max Payment to Max Loan Amount (L)
Using the Amortization Formula in reverse with $M_{max} = \$1,750$, $R=6.0\%$, and $T=30$ years, the maximum principal loan amount (L) is determined.
The Max Loan Amount (L) is approximately $\mathbf{\$291,911}$.
Frequently Asked Questions (FAQ)
The standard benchmark DTI ratio is often $43\%$. However, many programs offer flexibility. Fannie Mae (Conventional) may go higher with compensating factors, and FHA loans can sometimes reach $50\%$ or more, though $43\%$ is generally considered the qualifying line for Qualified Mortgages (QM).
The calculated value M represents the maximum affordable **P&I (Principal & Interest)** portion of the payment. The total affordability must account for T&I (Taxes & Insurance), so your final loan amount (L) may need to be lower than the calculated maximum.
Income (I) is typically calculated as **gross** (pre-tax) monthly income. Lenders use verifiable sources like W-2s, tax returns, and recent pay stubs. Only the reliable, documented income is used, excluding inconsistent bonuses or self-employment income without history.
The relationship between the Monthly Payment (M) and the Loan Amount (L) is defined entirely by the amortization schedule, which requires the interest rate (R) and the loan term (T). Without these auxiliary inputs, the calculator cannot convert the affordable payment (M) into the maximum loan principal (L).