Mortgage & home buying · Calculation notebook

Home affordability calculator: formulas, examples and mathematical principles

Learn the inputs, formula and worked example behind the Home affordability calculator, including annuities and the remaining-balance recurrence, result interpretation, assumptions and sources.

Purpose and steps

Housing budget = min(gross monthly income × housing ratio, gross monthly income × total DTI limit − existing debt). Solve the home price whose mortgage, tax, insurance, HOA and PMI fit that budget. The calculation runs locally and keeps cash-flow timing consistent with the stated assumptions.

  1. Confirm currency and monthly versus annual amounts. U.S. tax and loan models should be used within their stated scope.
  2. Prepare Annual gross household income, Existing monthly debt payments, Available down payment, Annual interest rate, Loan term, Annual property tax rate, Annual homeowners insurance, Monthly HOA dues, Annual PMI rate, Housing / gross income limit, Total debt / gross income limit. Defaults demonstrate the model rather than your personal circumstances.
  3. Check the headline result and its components. A key interpretation for this tool is: The default 28% housing and 36% total-debt limits are editable planning assumptions, not universal lender requirements. The smaller budget binds; increasing debt can make total DTI the limiting condition.
  4. Compare the baseline with a changed scenario: Subtract recurring nonhousing debt payments from the total-debt budget, not twice from both ratios. Annual income must be gross, and debt payments must be monthly.

Input reference and units

These values reproduce the model’s demonstration. Replace them with your own records or measurements; they are not recommended targets.

On a small screen, swipe horizontally to see all columns. With a keyboard, focus the table and use the arrow keys.

Parameters used by this calculator
ParameterDemonstration valueHow to enter it
Annual gross household income100000 USDUse dollars and the monthly or annual period stated in the field label; do not enter thousands of dollars.
Existing monthly debt payments500 USDUse dollars and the monthly or annual period stated in the field label; do not enter thousands of dollars.
Available down payment80000 USDCheck the unit carefully: some tools use a percentage and others a cash amount.
Annual interest rate6.5 %Enter a percentage such as 6.5, not 0.065. The equation converts it to a decimal.
Loan term30 yearsUse years here. The model converts to months when the payment schedule requires it.
Annual property tax rate1.2 %Enter a percentage such as 6.5, not 0.065. The equation converts it to a decimal.
Annual homeowners insurance1800 USDUse dollars and the monthly or annual period stated in the field label; do not enter thousands of dollars.
Monthly HOA dues0 USDUse dollars and the monthly or annual period stated in the field label; do not enter thousands of dollars.
Annual PMI rate0.5 %Enter a percentage such as 6.5, not 0.065. The equation converts it to a decimal.
Housing / gross income limit28 %Enter a percentage such as 6.5, not 0.065. The equation converts it to a decimal.
Total debt / gross income limit36 %Enter a percentage such as 6.5, not 0.065. The equation converts it to a decimal.

Model-specific method

How this calculator produces its result

Housing budget = min(gross monthly income × housing ratio, gross monthly income × total DTI limit − existing debt). Solve the home price whose mortgage, tax, insurance, HOA and PMI fit that budget.

Annuities and the remaining-balance recurrence

A fixed-payment loan is an annuity: the discounted value of all future payments equals the amount borrowed today. Summing that geometric series gives the monthly-payment equation. Match the rate and time unit: monthly payments use an annual nominal rate divided by twelve and a term counted in months.

Each payment is split into interest and principal. Interest uses the opening balance, so paying extra principal now reduces later interest. A zero rate must use P/n rather than the formula’s zero-over-zero form. Keep full precision during the schedule and round only for display; a lender may round each actual posting differently.

P = Σ[t=1…n] M/(1+r)^t
M = Pr / (1 − (1+r)^−n)
Iₜ = Bₜ₋₁r; Bₜ = Bₜ₋₁ + Iₜ − paymentₜ
  • P: principal today
  • r: rate per payment period, not the annual percentage
  • n: number of payment periods
  • M: scheduled payment; B: remaining balance

Worked example

At $100,000 annual income, $500 monthly debt, and 28% / 36% limits, the housing budget is the lesser of $2,333.33 and $2,500, before translating it into a home price.

Reproduce the default scenario

This reproduces the default inputs in the reference table above; it is not an additional independent example. Displayed rounding may differ from intermediate precision.

Estimated maximum home price
367,313.92 USD
Available monthly housing budget
2,333.33 USD
Estimated monthly housing payment
2,333.33 USD
Loan amount
287,313.92 USD
Down payment
80,000 USD
Housing / gross income
28%
Total debt / gross income
34%

Reading results without overstating them

  • The default 28% housing and 36% total-debt limits are editable planning assumptions, not universal lender requirements. The smaller budget binds; increasing debt can make total DTI the limiting condition.
  • Subtract recurring nonhousing debt payments from the total-debt budget, not twice from both ratios. Annual income must be gross, and debt payments must be monthly.
  • The modeled housing payment includes principal, interest, property tax, insurance, HOA and conditional PMI. Personal living expenses, repairs, moving costs and closing cash need a separate budget.
  • Compare scenarios using the same income and debt: change the interest rate, down payment or taxes one at a time. Keep an emergency reserve outside the cash labeled as available down payment.

Is an affordability estimate a mortgage preapproval?

No. This tool compares your entered income, existing debts and housing expenses under stated debt-ratio assumptions. Lenders also assess credit, documentation, property eligibility and program rules. Compare the estimated budget with a lender’s actual offer, and include taxes, insurance and other housing costs.

Assumptions and exclusions

  • This is not preapproval. Credit score, reserves, lending program, local taxes, income stability, closing costs and actual underwriting can change the result.
Test a changed assumption in the calculator

Sources and content notes

Toolify describes the implemented algorithm and its assumptions. Sources below support the topic or applicable rules; they do not endorse this calculator. Examples are illustrative, and published rules take precedence over simplified estimates.

Report a formula, example or translation issue through our contact page. Include the tool name, inputs and expected result so it can be reproduced. Contact Toolify

From question to result

Continue with a related question

Explore all Mortgage & home buying tools and guides