Finance & Economics · Real Estate & Mortgages · Mortgage Calculations
Mortgage Affordability Calculator
Calculates the maximum home price you can afford and your estimated monthly mortgage payment based on income, debts, down payment, and lender guidelines.
Calculator
Formula
M is the monthly mortgage payment. P is the principal loan amount (home price minus down payment). r is the monthly interest rate (annual rate divided by 12). n is the total number of monthly payments (loan term in years multiplied by 12). Affordability is constrained by two lender ratios: the front-end ratio (housing costs \leq 28\% of gross monthly income) and the back-end ratio (total debt \leq 36\% of gross monthly income).
Source: Fannie Mae / Freddie Mac underwriting guidelines; standard amortization formula from Fabozzi, F.J. — Fixed Income Mathematics (4th ed.).
How it works
Mortgage affordability is governed by two fundamental lender guidelines known as the front-end and back-end ratios. The front-end ratio (also called the housing ratio) limits your total monthly housing costs — principal, interest, property taxes, and insurance (collectively called PITI) — to no more than 28% of your gross monthly income. The back-end ratio (total debt-to-income ratio) limits your PITI plus all other recurring monthly debts to no more than 36% of gross monthly income. These thresholds come from Fannie Mae and Freddie Mac underwriting standards, which govern the majority of conventional U.S. mortgages. Some lenders allow higher ratios (up to 43–50% back-end) for borrowers with strong credit, but 28/36 remains the benchmark for conservative affordability planning.
Once the maximum allowable monthly housing payment is determined (the stricter of the two ratio constraints), the calculator subtracts estimated taxes and insurance to isolate the maximum principal-and-interest (P&I) payment. This P&I payment is then used in the standard mortgage amortization formula to back-calculate the maximum supportable loan principal. The formula is M = P × [r(1+r)^n] / [(1+r)^n − 1], where M is the monthly P&I payment, P is the loan principal, r is the monthly interest rate (annual rate ÷ 12), and n is the total number of payments (years × 12). Solving for P gives the maximum loan amount, and adding your down payment yields the maximum affordable home price.
This calculator is used by first-time homebuyers estimating their budget before engaging a real estate agent, by financial advisors reviewing a client's housing affordability in context of their full balance sheet, and by mortgage brokers providing quick pre-qualification estimates. It is also a valuable planning tool for anyone considering refinancing or upgrading to a more expensive property, as it quantifies exactly how much income or debt reduction would be needed to reach a target price point.
Worked example
Consider a household with the following profile:
- Annual gross income: $85,000 (monthly: $7,083)
- Existing monthly debts: $400 (car loan + student loan)
- Down payment: $40,000
- Annual interest rate: 6.5%
- Loan term: 30 years
- Annual property tax: $3,000 (monthly: $250)
- Monthly home insurance: $100
Step 1 — Front-end limit: $7,083 × 0.28 = $1,983/month maximum PITI.
Step 2 — Back-end limit: ($7,083 × 0.36) − $400 = $2,550 − $400 = $2,150/month maximum PITI.
Step 3 — Binding constraint: The stricter limit is the front-end at $1,983/month.
Step 4 — Maximum P&I payment: $1,983 − $250 (tax) − $100 (insurance) = $1,633/month.
Step 5 — Monthly rate and payment count: r = 6.5% ÷ 12 = 0.5417%, n = 30 × 12 = 360 payments.
Step 6 — Maximum loan amount: P = $1,633 × [(1.005417)^360 − 1] / [0.005417 × (1.005417)^360] ≈ $257,400.
Step 7 — Maximum home price: $257,400 + $40,000 down payment = $297,400.
Step 8 — Total interest paid: ($1,633 × 360) − $257,400 ≈ $330,480 in interest over 30 years.
This household should target homes priced at or below approximately $297,000 to stay within conservative lending ratios at a 6.5% rate.
Limitations & notes
This calculator uses the conventional 28/36 qualifying ratios, which are conservative benchmarks. FHA loans allow back-end ratios up to 43%, VA loans may permit higher ratios for eligible veterans, and some lenders use automated underwriting that approves ratios up to 50% for borrowers with excellent credit scores and large reserves. The calculator also does not account for Private Mortgage Insurance (PMI), which is typically required when the down payment is less than 20% of the home price and can add $50–$200/month or more to housing costs. HOA fees, maintenance costs, and utilities are excluded and can be substantial. The output represents a maximum borrowing capacity, not a recommended spending level — financial advisors often suggest targeting the 25% front-end ratio or less for a more comfortable financial cushion. Interest rates change daily; always verify current rates with a licensed lender before making purchasing decisions. This tool is for educational and planning purposes only and does not constitute a mortgage pre-approval or financial advice.
Frequently asked questions
What is the 28/36 rule for mortgage affordability?
The 28/36 rule is the standard underwriting guideline used by most conventional mortgage lenders. It states that your total housing costs (principal, interest, taxes, and insurance — PITI) should not exceed 28% of your gross monthly income (front-end ratio), and your total monthly debt obligations including PITI should not exceed 36% of gross monthly income (back-end ratio). These thresholds were established by Fannie Mae and Freddie Mac and remain the benchmark for qualifying borrowers on conforming loans.
How does the down payment affect mortgage affordability?
A larger down payment directly increases your maximum affordable home price by reducing the loan amount needed, which lowers the required monthly P&I payment and allows the same income to support a higher-priced home. Additionally, putting down 20% or more eliminates the need for Private Mortgage Insurance (PMI), which can save $50–$250/month and effectively increases the loan size you can qualify for. A higher down payment also reduces the loan-to-value ratio, which may qualify you for lower interest rates.
Does this calculator account for Private Mortgage Insurance (PMI)?
No — this calculator does not automatically include PMI. If your down payment is less than 20% of the purchase price, lenders typically require PMI, which usually costs 0.5%–1.5% of the loan amount annually. For a $250,000 loan, this could add $104–$312 per month to your housing costs. To manually account for PMI, add the estimated monthly PMI cost to your monthly insurance input. PMI is automatically cancelled once your loan balance drops below 80% of the original home value under the Homeowners Protection Act.
What is the difference between front-end and back-end debt-to-income ratios?
The front-end ratio (housing ratio) considers only housing-related costs — your monthly principal, interest, property taxes, and homeowner's insurance (PITI) — as a percentage of gross monthly income. The back-end ratio (total DTI) adds all other recurring monthly debt obligations such as car loans, student loans, credit card minimum payments, and personal loans to the PITI before dividing by income. Lenders evaluate both; the back-end ratio is generally the binding constraint for borrowers carrying significant non-housing debt.
How does the interest rate affect how much house I can afford?
Interest rate has a powerful effect on affordability. At a 5% rate, a $1,500/month P&I budget supports roughly a $279,000 loan. At 7%, the same $1,500/month only supports approximately $225,000 — a difference of $54,000 in purchasing power for every 2 percentage point rate increase. This is why affordability fell sharply during the 2022–2023 rate cycle when the 30-year fixed mortgage rate rose from under 3% to over 7%. When planning, it is prudent to model affordability at a rate 0.5%–1% above current market rates as a stress test.
Last updated: 2025-01-15 · Formula verified against primary sources.