House Affordability Calculator: 28/36 DTI Rule Formula
Short answer
This house affordability calculator estimates the maximum property purchase price and loan amount you can qualify for using the classic 28/36 debt-to-income (DTI) rule. For example, a household earning $100,000 annually with $500 in monthly debt and a $40,000 down payment at a 6.5% interest rate can afford a home priced up to $341,602.14. It caps your total monthly housing cost at $2,333.33.
Formula
H = min(0.28 × (Gross Annual Income / 12), 0.36 × (Gross Annual Income / 12) - Other Monthly Debts) Price = (H + Down Payment × k) / (k + tm) Loan = Price - Down Payment
H represents the maximum allowable monthly housing payment (including principal, interest, taxes, and insurance). k is the standard monthly mortgage amortization factor per dollar borrowed: [r(1 + r)^n] / [(1 + r)^n - 1], where r is the monthly interest rate (annual mortgage rate / 1200) and n is the total number of monthly payments (loan term in years × 12). tm is the monthly property tax and homeowners insurance rate expressed as a decimal (annual percentage / 1200). Price is the maximum affordable home purchase price, and Loan is the total mortgage balance.
Worked example
- Gross annual income
- 100000
- Other monthly debt payments
- 500
- Down payment
- 40000
- Mortgage rate
- 6.5
- Loan term
- 30
- Property tax + insurance
- 1.5
- Affordable home price: 341,602.14
- Loan amount: 301,602.14
- Max monthly housing cost: 2,333.33
- Principal & interest: 1,906.33
- Tax & insurance per month: 427.00
What the House Affordability Calculator Does
The House Affordability Calculator determines the maximum home purchase price you can target based on standard mortgage underwriting guidelines. Rather than guessing what home price fits your budget, this tool uses the widely established 28/36 debt-to-income (DTI) rule to calculate your borrowing ceiling.
Mortgage underwriters evaluate two specific debt metrics:
- Front-End DTI (Housing Ratio): Your total monthly housing expenses—comprising principal, interest, property taxes, and homeowners insurance (PITI)—should not exceed 28% of your pre-tax gross monthly income.
- Back-End DTI (Total Debt Ratio): Your housing costs combined with all other recurring debt commitments (auto notes, student loans, minimum credit card payments, personal loans) should not exceed 36% of your gross monthly income.
By comparing both thresholds, the calculator identifies your true binding constraint. It then solves backward from your monthly housing limit, interest rate, loan term, and down payment to compute the maximum home purchase price.
Step-by-Step Worked Example
To see how the mathematical formula works in practice, consider the following standard financial profile:
- Gross annual income: $100,000
- Other monthly debt payments: $500
- Down payment: $40,000
- Mortgage rate: 6.5%
- Loan term: 30 years
- Property tax + insurance: 1.5% of home price per year
1. Calculate Monthly Income and DTI Caps
First, convert gross annual income to gross monthly income: $$\text{Monthly Income} = \frac{$100,000}{12} = $8,333.33$$
Next, evaluate both underwriting limits:
- Front-end limit (28%): $0.28 \times $8,333.33 = $2,333.33$
- Back-end limit (36% minus debt): $(0.36 \times $8,333.33) - $500 = $3,000.00 - $500 = $2,500.00$
The binding monthly housing ceiling ($H$) is the lower of the two figures: $$H = \min($2,333.33, $2,500.00) = $2,333.33$$
2. Determine Loan and Tax Factors
For a 30-year loan at 6.5% annual interest:
- Monthly interest rate ($r$): $0.065 / 12 = 0.0054167$
- Total monthly payments ($n$): $30 \times 12 = 360$
- Monthly payment per dollar borrowed ($k$): $$k = \frac{0.0054167(1 + 0.0054167)^{360}}{(1 + 0.0054167)^{360} - 1} \approx 0.00632068$$
For property taxes and insurance totaling 1.5% annually:
- Monthly tax and insurance factor ($tm$): $0.015 / 12 = 0.00125$
3. Solve for Affordable Home Price and Loan Amount
Using the affordability formula: $$\text{Price} = \frac{H + (\text{Down Payment} \times k)}{k + tm}$$ $$\text{Price} = \frac{$2,333.33 + ($40,000 \times 0.00632068)}{0.00632068 + 0.00125} = \frac{$2,333.33 + $252.83}{0.00757068} = $341,602.14$$
Subtracting the down payment gives the total loan amount: $$\text{Loan Amount} = $341,602.14 - $40,000 = $301,602.14$$
4. Breakdown of the Monthly Payment
- Principal & Interest: $$301,602.14 \times 0.00632068 = $1,906.33$
- Taxes & Insurance: $$341,602.14 \times 0.00125 = $427.00$
- Total Monthly Housing Cost: $$1,906.33 + $427.00 = $2,333.33$
How to Interpret the Results
- Affordable Home Price: This is the top purchase price you can target under standard 28/36 underwriting guidelines. Searching for properties at or below this value keeps your mortgage qualification within standard risk thresholds.
- Loan Amount: The actual debt balance you will finance. Compare this against conventional conforming loan limits in your county.
- Max Monthly Housing Cost: The maximum total sum allocated each month toward housing. If your actual mortgage payment, taxes, and insurance come in below this number, your debt ratios improve.
- Income Sensitivity: Notice how income directly shifts the buying threshold. Holding debts and down payment constant, an income of $80,000 lowers the maximum home price to $279,960.82, whereas an income of $120,000 expands purchasing capacity to $403,243.45.
Practical Homebuying Tips
- Maintain an Emergency Buffer: Do not allocate all available cash to your down payment. Lenders prefer to see two to six months of living expenses in reserve after closing.
- Pay Down High-Interest Debt First: Because the back-end ratio subtracts existing non-mortgage obligations dollar-for-dollar, paying off a $300 auto loan or credit card balance directly frees up substantial borrowing room for your mortgage.
- Account for Local Tax Disparities: Real estate property taxes vary significantly across states and counties. A region with a 2.5% tax rate will reduce your maximum purchase price noticeably compared to an area with a 0.75% rate.
When Not to Rely Solely on This Calculator
While the 28/36 rule provides a dependable benchmark, it does not fit every circumstance:
- Specialized Loan Programs: FHA, VA, and USDA mortgages use different qualifying ratios, often allowing higher back-end DTI caps (frequently 43% to 50%).
- High Cost of Living Areas: In major metropolitan markets, jumbo loans and local lender exceptions regularly approve higher front-end ratios for high earners with substantial assets.
- Variable Incomes: Self-employed borrowers, commission-based workers, and freelancers must average two years of tax return income rather than relying on straightforward gross salary inputs.
Comparison
| Scenario | Input | Result |
|---|---|---|
| Lower input | Gross annual income: 80000 | Affordable home price: 279,960.82 |
| Base example | Gross annual income: 100000 | Affordable home price: 341,602.14 |
| Higher input | Gross annual income: 120000 | Affordable home price: 403,243.45 |
Common mistakes
- Entering net take-home pay instead of gross pre-tax income, which drastically understates borrowing capacity.
- Including non-debt living costs like groceries, cellphone bills, or health insurance in the 'other monthly debts' field.
- Forgetting to preserve a separate post-closing cash reserve for emergency funds and routine home maintenance.
- Overlooking closing costs (typically 2% to 5% of the loan amount), which reduces the cash left for the down payment.
- Assuming qualifying for a maximum loan approval means the payment comfortably fits personal lifestyle spending goals.
Checklist
- Gather accurate pre-tax gross income records, including base wages, regular overtime, and bonuses.
- Tally recurring monthly debt obligations, such as auto loans, student loans, and credit card minimum payments.
- Verify the liquid cash available for a down payment, keeping emergency savings separate.
- Check current market mortgage interest rates for 15-year, 20-year, or 30-year fixed loans.
- Research local property tax rates and homeowners insurance averages for your target area.
- Exclude non-debt living expenses (utilities, groceries, entertainment) from the debt field; they are accounted for in the remaining income buffer.
Calculators Percentage Editorial Team
Calculator guides from the Calculators Percentage team. These introductory examples are educational, not professional advice.
Last reviewed:
This calculator and guide are provided for informational and educational purposes only and do not constitute financial, legal, or mortgage lending advice. Consult a licensed mortgage professional or certified financial advisor to evaluate your specific situation.
