Mortgage Affordability by City Calculator
Calculate Mortgage Affordability by City instantly — see monthly payments, total interest, and full amortization schedule.
Reviewed by Daniel Agrici, Founder & Lead Developer
Formula
Max Home Price = Max Loan Amount / (1 - Down Payment %) where Max Loan = (Max PITI - Taxes - Insurance) x Mortgage Factor
The maximum affordable home price is determined by calculating the maximum monthly housing payment (28% of gross income), subtracting city-specific monthly property tax and insurance estimates, then converting the remaining principal and interest payment to a loan amount using the mortgage present value factor. The down payment is added to get the total purchase price.
Worked Examples
Example 1: Young Professional in Austin, TX
Problem:Income: $85,000/year, Monthly debts: $400, Down payment: 20%, Interest rate: 6.5%, 30-year term. What can they afford in Austin?
Solution:Monthly income: $85,000 / 12 = $7,083\nMax housing (28%): $7,083 x 0.28 = $1,983\nMax total debt (36%): $7,083 x 0.36 = $2,550\nMax mortgage from DTI: $2,550 - $400 = $2,150\nBinding limit: min($1,983, $2,150) = $1,983\nAfter taxes (1.8%) and insurance (1.35%), iterative calculation\nAustin median: $450,000
Result:Max affordable price ~$315,000 vs Austin median $450,000 - gap of ~$135,000
Example 2: Dual Income Household in Chicago
Problem:Combined income: $140,000/year, Monthly debts: $600, Down payment: 20%, Rate: 6.5%, 30-year. What can they afford in Chicago?
Solution:Monthly income: $140,000 / 12 = $11,667\nMax housing (28%): $11,667 x 0.28 = $3,267\nMax total debt (36%): $11,667 x 0.36 = $4,200\nMax mortgage: min($3,267, $3,600) = $3,267\nChicago has higher property tax (2.27%) reducing purchase power\nChicago median: $330,000
Result:Max affordable price ~$430,000 vs Chicago median $330,000 - comfortably affordable
Frequently Asked Questions
How is mortgage affordability calculated for different cities?
Mortgage affordability varies dramatically by city due to differences in median home prices, property tax rates, homeowners insurance costs, and local cost of living. The calculation starts with your gross income and applies standard debt-to-income ratios, typically 28 percent for housing costs and 36 percent for total debt. From the maximum housing payment, monthly property taxes and insurance are deducted based on city-specific rates to determine the maximum principal and interest payment you can afford. This payment is then converted to a maximum loan amount using the mortgage payment formula, and the down payment is added to determine your maximum purchase price. Cities with high property tax rates like Houston and Dallas effectively reduce your purchasing power compared to low-tax cities like Denver or Phoenix.
What debt-to-income ratios do lenders use for mortgage approval?
Lenders typically use two debt-to-income ratio thresholds when evaluating mortgage applications. The front-end ratio, also called the housing ratio, limits your total housing costs including principal, interest, taxes, and insurance to 28 percent of your gross monthly income. The back-end ratio limits your total monthly debt obligations, including housing costs plus car payments, student loans, credit card minimums, and other debts, to 36 percent of gross monthly income. Some loan programs are more flexible, with FHA loans allowing up to 31 percent front-end and 43 percent back-end ratios. VA loans have no front-end limit and allow up to 41 percent back-end. Conventional loans with strong credit scores and compensating factors may stretch to 45 or even 50 percent back-end ratios in some cases.
How do property taxes affect mortgage affordability across cities?
Property taxes significantly impact affordability because they are part of your total monthly housing payment but do not contribute to building equity. Effective property tax rates vary enormously by location, ranging from under 0.5 percent in Hawaii and parts of Colorado to over 2.5 percent in New Jersey and Illinois. In practical terms, a $400,000 home in a city with a 0.5 percent tax rate costs $167 per month in property taxes, while the same priced home in a city with a 2.5 percent rate costs $833 per month in taxes alone. This $666 monthly difference translates to roughly $100,000 less in borrowing power. When comparing affordability across cities, it is essential to factor in property taxes rather than looking solely at home prices and mortgage rates.
What credit score do I need for the best mortgage rates?
A FICO score of 760 or higher typically qualifies you for the lowest advertised mortgage rates. Dropping from 760 to 700 can cost you 0.25-0.50% more in interest — on a $400,000 30-year loan, that difference costs roughly $60-$120 more per month and over $25,000 in extra interest. Scores between 620-699 still qualify for conventional loans but at noticeably higher rates. Scores below 580 generally require FHA loans, which accept down payments as low as 3.5% but mandate mortgage insurance for the life of the loan. Before applying, pay down revolving balances to below 30% of credit limits — this alone can boost your score 20-40 points.
References
Reviewed by Daniel Agrici, Founder & Lead Developer · Editorial policy