Housing Affordability Calculator
A Market-Level Gauge, Not a Personal Budget
Where the Affordability Calculator answers "what can I personally spend?", the Housing Affordability Index answers a different question: is the typical family in a given market earning enough to qualify for the typical home there? It's the calculation economists and housing analysts use to track whether a metro area is becoming more or less accessible over time, built on the same NAR-style methodology used in published affordability indexes.
The Formula
Monthly PITI = Mortgage Payment (P&I) + Monthly Tax + Monthly Insurance
Qualifying Income = (Monthly PITI / Qualifying Ratio) × 12
HAI = (Median Family Income / Qualifying Income) × 100
An index of exactly 100 means the median family has precisely enough income to qualify for a mortgage on the median-priced home under the assumed terms.
Where This Calculation Matters
- Comparing markets — an HAI of 150 versus 90 tells you immediately which of two metro areas is more accessible to its typical resident, independent of the actual price level.
- Tracking a market over time — rising home prices without matching income growth push the index down even if nominal wages are increasing.
- Policy and lending research — analysts and journalists use this index (or close variants of it) to describe housing affordability trends at the national or regional level.
- Sanity-checking your own numbers — if your local market's HAI is well under 100, expect that qualifying for a median-priced home will require above-median income, a larger down payment, or both.
Reading the Index
| HAI value | Meaning |
|---|---|
| Above 100 | Median family has more than enough income to qualify for the median home |
| Exactly 100 | Median family has exactly enough qualifying income |
| Below 100 | Median family falls short of the income needed to qualify |
Worked example: a $75,000 median family income against a $350,000 median home price at 6.5% for 30 years, 20% down, 25% qualifying ratio, $4,200 annual property tax, and $1,400 annual insurance produces a qualifying income of $107,349.94 and an HAI of 69.9 — meaning that family has only about 70% of the income needed to qualify for that home under these terms.
How to Use This Calculator
- Enter the Median Family Income ($/yr) and Median Home Price for the market you're evaluating.
- Adjust Down Payment % if you're not assuming the 20% default.
- Enter the prevailing Interest Rate and Loan Term (years).
- Adjust the Qualifying Ratio % if you want a stricter or looser income-to-payment assumption than the 25% default.
- Optionally enter Annual Property Tax and Annual Insurance for a fuller PITI estimate.
- Select Calculate to see the index value and the qualifying income it implies.
Related Calculations
For your own numbers rather than market medians, use the Affordability Calculator, or compare buying against renting directly with the Rent vs Buy Calculator.
Principles of Mortgage Underwriting and Debt-to-Income Thresholds
A housing affordability calculator determines the maximum home purchase price and mortgage loan amount a prospective homebuyer can prudently qualify for based on gross annual household income, recurring monthly debt obligations, available cash down payment reserves, and prevailing mortgage interest rates. Commercial mortgage lenders evaluate applicant creditworthiness using standardized Debt-to-Income (DTI) qualifying ratios.
The 28/36 Qualifying Ratio Rule
In conventional conforming mortgage underwriting (governed by Fannie Mae and Freddie Mac guidelines), lenders establish affordability limits using two complementary benchmark ratios:
- The Front-End (Housing) Ratio (≤ 28%): Total monthly housing expenses — encompassing Principal, Interest, Property Taxes, Homeowners Hazard Insurance, and mandatory HOA dues (PITI) — should not exceed 28.0% of gross monthly household income.
- The Back-End (Total Debt) Ratio (≤ 36% to 43%): Total monthly debt obligations — combining full housing PITI payments plus all recurring consumer debts (auto loans, student loans, minimum credit card payments, child support) — should not exceed 36.0% (expandable up to 43.0% to 50.0% under automated underwriting for strong credit profiles).
The PITI Payment Components
- P & I (Principal & Interest): Amortized debt service payment determined by loan amount, term, and interest rate.
- T (Property Taxes): Local municipal real estate taxes (typically 0.8% to 2.5% of assessed property value annually).
- I (Hazard Insurance): Homeowners property casualty and fire insurance premiums.
- PMI (Private Mortgage Insurance): Mandatory monthly insurance fee (0.3% to 1.5% of loan balance) charged when down payment is less than 20% (Loan-to-Value > 80%).
Step-by-Step Worked Calculation Example
Example: Calculating Maximum Affordable Home Purchase Price
Problem: A prospective homebuying couple earns a combined gross annual income of $120,000 ($10,000/month) and has $600/month in recurring student and auto loan payments. They have $60,000 saved for a down payment. The 30-year fixed mortgage rate is 6.50% (monthly payment factor ≈ $6.32 per $1,000 borrowed). Property taxes are estimated at 1.20%/year, home insurance at $100/month, and PMI at $120/month. Determine maximum affordable home purchase price under the 36% back-end DTI rule.
Step 1: Calculate maximum allowable total monthly debt:
Max Total Debt (36% of $10,000) = $3,600.00 / month
Step 2: Subtract non-housing debts to find maximum allowable housing PITI:
Max PITI = $3,600.00 - $600.00 = $3,000.00 / month
Step 3: Subtract escrow items (Taxes, Insurance, PMI) to find allowable Principal & Interest:
Estimated monthly escrow = $400 (Taxes) + $100 (Insurance) + $120 (PMI) = $620.00
Allowable Principal & Interest (P&I) = $3,000.00 - $620.00 = $2,380.00 / month
Step 4: Solve for maximum supported mortgage loan amount:
Max Loan = $2,380.00 / 0.00632068 = $376,542.00
Step 5: Add cash down payment to determine total home price:
Max Home Purchase Price = $376,542 + $60,000 = $436,542.00
Conclusion: The couple can afford a maximum home purchase price of approximately $436,500 with a $60,000 down payment and $376,500 mortgage.
Common Homebuyer Budgeting Pitfalls
- Forgetting Ongoing Home Maintenance: Homeowners must budget 1.0% to 2.0% of total property value annually for routine maintenance, roof repairs, and HVAC replacements.
- Failing to Account for Rising Property Taxes: Property purchases often trigger municipal tax re-assessments that significantly increase escrow payments after Year 1.
Interest Rate Sensitivity and Purchasing Power Erosion
In residential real estate economics, mortgage interest rate fluctuations exert a profound non-linear impact on homebuyer purchasing power. Because monthly principal and interest payments scale with the interest rate, every 1.0% increase in 30-year fixed mortgage rates reduces a buyer's maximum affordable home purchase price by approximately 10.0% to 11.0% for a fixed monthly budget.
FHA vs. Conventional Conforming Loan Qualifying Guidelines
Federal Housing Administration (FHA) government-insured loans permit higher debt-to-income flexibility (up to 46.9% front-end and 56.9% back-end DTI under automated underwriting) with down payments as low as 3.5% for credit scores down to 580, expanding homeownership access for first-time buyers who exceed conventional conforming loan limits.
VA Loan Zero Down Payment Benefits
Eligible military veterans and active-duty service members qualify for US Department of Veterans Affairs (VA) home loans, which offer 100% financing (zero down payment), no ongoing monthly private mortgage insurance (PMI), and competitive interest rates, substantially increasing housing affordability.