This home affordability calculator estimates a home purchase price from the monthly amount you choose to spend on principal and interest, your down payment, and an assumed loan rate and term. Enter those figures to see an estimated maximum loan and purchase price; this is a payment-based estimate, not a lender approval or a complete household budget.
Formula
The calculation reverses the standard fixed-payment loan formula. It finds the loan principal whose monthly principal-and-interest payment equals the entered budget, then adds the down payment to estimate a purchase price.
- r = monthly interest rate = APR ÷ 1,200, expressed as a decimal.
- n = number of monthly payments = loan term in years × 12.
- M = monthly principal-and-interest budget, in dollars.
- L = estimated loan principal, in dollars: L = M × [1 − (1 + r)−n] ÷ r.
- D = down payment, in dollars.
- H = estimated home price, in dollars: H = L + D.
The rate input is an annual percentage, so dividing by 1,200 converts it to a monthly decimal rate. The calculator rounds the estimated loan to cents before adding the down payment. It assumes a fixed rate and equal monthly payments across the full term.
Worked Example
Using the defaults—$2,000 per month, 6.5% APR, a 30-year term, and a $60,000 down payment:
- Convert the annual APR to a monthly rate: 6.5 ÷ 1,200 = 0.0054166667.
- Find the number of payments: 30 × 12 = 360.
- Calculate the loan estimate: $2,000 × [1 − (1 + 0.0054166667)−360] ÷ 0.0054166667 = $316,925.66, rounded to cents.
- Add the down payment: $316,925.66 + $60,000 = $376,925.66 estimated home price.
The result means that, under these assumptions, a loan of about $316,925.66 has a principal-and-interest payment of $2,000 for 360 months. It does not mean a home at that price will have total housing costs of $2,000 per month.
What Home Affordability Means
Home affordability is not one universal price or a single income threshold. It depends on the housing costs a household is prepared to carry, its other expenses and debts, available savings, and the terms of a possible loan. This calculator answers a deliberately narrow question: what principal could match a stated monthly principal-and-interest amount?
For a more complete budget, account for property-related costs that are not in the formula. Depending on the property and circumstances, these may include property taxes, homeowners insurance, mortgage insurance, homeowners association dues, utilities, repairs, and routine maintenance. Some costs are billed monthly; others arrive annually or irregularly. Converting annual costs to a monthly equivalent can make a budget easier to compare.
For example, if the amount you can devote to all housing expenses is $2,000 monthly, setting the calculator’s principal-and-interest input to $2,000 would use the entire amount for the loan payment alone. Taxes, insurance, and other expenses would come on top. To reflect a total monthly housing budget, first subtract the costs you expect outside principal and interest, then enter the remainder as the calculator’s monthly amount.
How to Use the Estimate
- Choose a monthly amount for principal and interest, rather than entering take-home pay or total housing costs.
- Enter an APR and loan term that match a scenario you want to examine. These are assumptions; ask a lender for figures that apply to your situation.
- Enter the down payment as a dollar amount. The estimated home price is the estimated loan plus that amount.
- Change one input at a time to see how the estimate responds to a different payment, rate, term, or down payment.
- Compare the output with a fuller monthly budget and remember that a purchase may also involve upfront costs not represented here.
The payment budget is the key constraint in this model. A longer term generally produces a larger loan estimate for the same payment and rate because repayment is spread over more months; it also means payments continue for longer. A higher assumed rate produces a smaller loan estimate for the same payment and term. These are mathematical effects of the formula, not predictions about rates or loan availability.
Limits and Common Misunderstandings
The estimated home price is not a loan offer, preapproval, guarantee of eligibility, or recommendation about what to spend. Lenders evaluate applications using information and criteria that this calculator does not collect. The output also does not establish what monthly payment fits your circumstances.
Only principal and interest are modelled. The calculation does not include taxes, insurance, mortgage insurance, fees, closing costs, escrow, association dues, utilities, or maintenance. It does not account for a changing interest rate, extra payments, a different payment schedule, or a down payment that varies with the purchase price. Since the down payment is entered as a fixed dollar amount, the estimated price is simply the estimated loan plus that amount.
Keep units consistent: enter APR as a percentage such as 6.5, not as 0.065, and enter the term in years. The monthly-rate conversion assumes a nominal annual rate divided by 12. Actual loan disclosures may use different conventions or include costs that change the payment. Rounding also means displayed values are estimates to the cent, not a substitute for a lender’s amortization schedule.
Frequently Asked Questions
What does a home affordability calculator calculate?
It estimates a loan amount and, when a down payment is entered, a home price based on a chosen monthly principal-and-interest budget, APR, and repayment term. This version excludes other ownership costs.
Does the estimated price include property taxes and insurance?
No. The formula includes only principal and interest in its monthly-payment limit. Consider taxes, insurance, and other recurring costs separately when building a total housing budget.
Is the result the amount I can borrow or will be approved for?
No. It is a mathematical estimate based on the inputs. A lender makes its own assessment using application information and applicable criteria; this calculator cannot predict an approval or loan amount.
Should I enter my total monthly housing budget?
Enter only the portion allocated to principal and interest. If you have a total monthly housing limit, account for taxes, insurance, dues, and other expected housing costs first, then use the remainder as the input.
Why does a longer loan term increase the estimated price?
With more monthly payments available to repay principal, the same principal-and-interest budget can support a larger loan in this formula. A longer term also extends repayment, and the estimate does not compare total costs or loan terms for you.
Assumptions
- The APR is fixed for the full term, with monthly interest calculated at APR ÷ 12.
- Payments are equal, made monthly, and continue for the full term; the model treats the first payment as one month after the loan begins.
- The entered monthly budget is entirely for principal and interest.
- Fees, taxes, insurance, mortgage insurance, escrow, closing costs, and other ownership expenses are not included.
This result is an estimate; the lender’s disclosure gives the exact figures.
Related
Formula used
in pay | Monthly principal-and-interest budget | $ | 2000 | 0.01 | 1000000 in apr | Assumed interest rate (APR) | % | 6.5 | 0.01 | 100 in yrs | Loan term | years | 30 | 0.0833 | 50 in down | Down payment | $ | 60000 | 0 | 100000000 out loan | Estimated maximum loan | $ | round(pay * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / (apr / 1200), 2) | 2 out price | Estimated home price | $ | loan + down | 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
- Rent-to-Income Ratio by Country: How Comparisons Work30.00 %
- Rent-to-Income Ratio: Definition and Calculator30.00 %
- Rent-to-Income Ratio Calculator and What It Means30.00 %
- Rent-to-Income Ratio by City: How to Compare
- Gross Income-to-Rent Ratio Calculator and Guide3.33 x
- Reasonable Income to Rent Ratio: A Practical Guide