calculate-loan

01 Loan payments

Home Affordability Calculator: How Much Can You Afford?

Calculator No. 01-12821 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

A home affordability calculator estimates a home price from the monthly housing payment you enter, your down payment, mortgage rate, and loan term. This estimate uses a housing-payment limit as its starting point; it does not determine lender approval or account for every household expense.

Formula

This calculator reverses the standard fixed-payment mortgage formula to estimate the loan amount supported by the monthly budget, then adds the down payment to estimate a home price.

  • r = monthly interest rate, calculated as APR ÷ 1,200.
  • n = number of monthly payments, calculated as loan term in years × 12.
  • B = monthly housing budget entered, in dollars. In this calculator, B is treated as principal and interest only.
  • D = down payment, in dollars.
  • L = estimated loan amount, in dollars: B × [1 − (1 + r)−n] ÷ r.
  • H = estimated home price, in dollars: L + D.

The calculator’s first output expresses the same calculation directly: H = D + B × [1 − (1 + r)−n] ÷ r. The payment output checks the result by applying the fixed-payment formula to the estimated loan. Outputs are rounded to whole dollars for estimated price and loan balance, and to cents for monthly principal and interest.

Worked Example

Using the defaults—$2,500 monthly budget, $60,000 down payment, 6.5% APR, and a 30-year term:

  1. Convert the annual APR to a monthly rate: r = 6.5 ÷ 1,200 = 0.0054167.
  2. Find the number of payments: n = 30 × 12 = 360.
  3. Estimate the loan amount: L = $2,500 × [1 − (1.0054167)−360] ÷ 0.0054167 ≈ $387,550.
  4. Add the down payment: H = $387,550 + $60,000 ≈ $447,550 estimated home price.
  5. Check the payment: the fixed-payment calculation on the estimated loan produces approximately $2,500.00 per month in principal and interest.

Assumptions

  • The mortgage has a fixed interest rate for the entire term.
  • Payments are made monthly, with the ordinary end-of-period payment convention.
  • Interest compounds monthly at APR ÷ 12.
  • The monthly budget is allocated entirely to principal and interest. Property taxes, homeowners insurance, mortgage insurance, association dues, maintenance, closing costs, and escrow are not included.
  • The down payment is applied to the purchase price, with no other cash-to-close costs modelled.

How to Use the Estimate

Enter the monthly amount you want to test as a principal-and-interest budget, the cash down payment, a mortgage APR, and the repayment term. The first result is an estimated purchase price; the next is the implied loan amount, and the last is the calculated monthly principal-and-interest payment. Because the price and loan outputs are rounded to whole dollars, the payment check may differ slightly from the budget by a few cents.

To use this as a broader household-planning estimate, first account for costs not represented in the formula. For example, if $2,500 is the total monthly amount you can set aside for housing, it would be misleading to enter all $2,500 as the principal-and-interest budget when taxes, insurance, or other recurring housing costs also need to fit within that amount. Estimate those costs separately from reliable property and insurance information, then reserve that portion of the budget before entering the remainder. Those figures vary by property and location, so the calculator does not supply them.

The input rate is an assumption, not a forecast or a quote. Use the rate and term supplied for the scenario you want to examine, and ask the lender for applicable loan figures and costs. A small change in APR or loan term changes the amount that the same monthly payment supports. The result is therefore a scenario estimate, not a statement of what a lender will offer.

What the Calculator Leaves Out

Affordability involves more than the mortgage payment. The calculator does not examine income, existing debts, savings after closing, job stability, credit information, lender underwriting, or approval criteria. It also does not model changing rates, adjustable-rate payments, extra principal payments, or the timing and size of property-related bills.

One common misconception is that a home-price estimate is the same as a preapproval or a personal spending recommendation. It is neither. The calculation answers a narrower question: what purchase price corresponds mathematically to the entered down payment and a fixed principal-and-interest budget under the stated assumptions? A lender’s review and a household’s complete budget are separate matters.

Common Errors and Alternatives

  • Entering the full housing budget: The calculator treats the entry as principal and interest only, not the complete monthly cost of owning a home.
  • Mixing annual and monthly rates: Enter APR as a yearly percentage, such as 6.5, not 0.065 or a monthly rate. The formula divides it by 1,200.
  • Confusing down payment with loan amount: The down payment is added to the supported loan to estimate price; it is not part of the mortgage balance.
  • Ignoring upfront cash: The estimate does not add closing costs, moving costs, or reserves to the required cash amount.

For a more complete scenario, use a mortgage payment calculation that includes separately researched taxes, insurance, and mortgage insurance where applicable, or build a monthly household budget that also includes debts and non-housing spending. Any added-cost estimate should be kept distinct from this calculator’s principal-and-interest result so the same cost is not counted twice.

Frequently Asked Questions

How does a home affordability calculator work?
It reverses the fixed-rate mortgage payment formula to estimate the loan amount supported by a specified monthly principal-and-interest payment, then adds the down payment to estimate a purchase price.

Does this estimate include property taxes and insurance?
No. The monthly budget in this calculator covers principal and interest only. Taxes, homeowners insurance, mortgage insurance, association dues, maintenance, and closing costs are excluded.

Is the estimated home price the amount I will be approved for?
No. It is a mathematical scenario based on your inputs, not a lender decision. Income, debts, documentation, lender criteria, and other factors are not evaluated.

Should I enter my APR as 6.5 or 0.065?
Enter 6.5 for a 6.5% annual percentage rate. The formula converts the percentage to a monthly rate by dividing by 1,200.

Why does a longer loan term change the estimate?
A longer term spreads repayment over more monthly payments. Under the fixed-rate formula, that changes how much principal a given monthly principal-and-interest payment can support; it does not add omitted ownership costs.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

Formula used
in pay | Monthly housing budget | $ | 2500 | 0 | 1000000
in down | Down payment | $ | 60000 | 0 | 100000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Loan term | years | 30 | 0.0833 | 50
out price | Estimated home price | $ | down + (pay - down * (apr / 1200)) * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / ((apr / 1200) * (1 + apr / 1200) ^ -(yrs * 12)) | 0
out loan | Estimated loan amount | $ | price - down | 0
out pmt | Principal-and-interest payment | $ | (price - down) * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →