A home affordability calculator estimates the loan amount and home price that fit a monthly principal-and-interest payment you enter, using an interest rate and loan term you supply. It returns an estimated payment and total interest; it does not determine what a lender will approve or include the full cost of owning a home.
Formula
This calculator works backward from a monthly principal-and-interest budget to estimate the loan principal supported by that payment. It then adds the down payment to estimate a purchase price, and calculates interest over the full term assuming every scheduled payment is made.
For monthly interest rate r = APR ÷ 1,200 and number of monthly payments n = years × 12:
- Estimated loan: P = M × [1 − (1 + r)−n] ÷ r
- Estimated home price: H = P + D
- Total interest: I = M × n − P
M is the monthly payment budget in dollars, r is the monthly rate as a decimal, n is the number of monthly payments, P is the estimated loan principal in dollars, D is the down payment in dollars, H is the estimated home price in dollars, and I is total interest in dollars. The APR input is a percentage per year; for example, 6% becomes 0.005 per month after dividing by 1,200.
Worked Example
Using the calculator’s defaults: monthly principal-and-interest budget M = $2,000, APR = 6%, term = 30 years, and down payment D = $60,000.
- Convert the annual percentage rate to a monthly decimal: r = 6 ÷ 1,200 = 0.005.
- Convert the term to monthly payments: n = 30 × 12 = 360.
- Substitute in the loan formula: P = 2,000 × [1 − (1.005)−360] ÷ 0.005 ≈ $333,583.98.
- Add the down payment: H = $333,583.98 + $60,000 = $393,583.98 estimated home price.
- Calculate total interest using the unrounded formula result: I = ($2,000 × 360) − $333,583.98 = $386,416.02.
Displayed figures are rounded to cents. The result describes the mathematical principal supported by the entered payment under the stated assumptions, not a purchase-price limit or lending decision.
Assumptions
- The rate stays fixed throughout the term.
- Payments are level monthly payments, made at the end of each monthly period.
- Interest compounds monthly at APR divided by 12.
- The calculation excludes property taxes, homeowners insurance, mortgage insurance, association dues, maintenance, utilities, closing costs, and lender fees.
- The down payment is added to the estimated loan to infer a price; it is not treated as a financed amount.
What Affordability Means Beyond the Payment
A home’s monthly cost is not just mortgage principal and interest. Taxes, insurance, mortgage insurance where applicable, association charges, and upkeep can materially change the amount of cash needed each month. Some costs are billed separately rather than collected with a mortgage payment, but they still affect a household’s budget.
There are also upfront expenses. A down payment reduces the amount borrowed, while closing and moving costs may require additional funds. The calculator adds only the stated down payment to the estimated loan amount; it does not reserve money for those other expenses. As a result, its estimated home price is a narrow arithmetic estimate, not a complete affordability assessment.
For a more complete personal budget, list recurring income and expenses, account for debts and savings goals, and estimate ownership costs using figures relevant to the property. This is useful context, but it does not predict approval: lenders assess applications using their own underwriting process and current information.
How to Use and Interpret the Estimate
- Enter a monthly amount intended for principal and interest, not a total housing budget that already includes taxes or insurance.
- Use the annual rate and term supplied for the scenario you want to examine. These are inputs, not claims about available offers; obtain actual loan figures directly from the lender.
- Enter the down payment in dollars. The estimated price equals the calculated loan plus that amount.
- Change one input at a time to see how the arithmetic responds. A longer term generally supports a larger principal at the same payment and rate, but it also means more scheduled payments.
The displayed total interest assumes the monthly payment remains exactly the entered amount for the whole term. Real payment schedules may have rounding adjustments, and a loan’s disclosed payment or total cost can differ because of fees, rate structure, payment timing, or other terms. The calculator does not estimate a debt-to-income ratio or account for income, assets, credit history, or other underwriting details.
Common Misunderstandings and Limits
A frequent mistake is to treat the estimated home price as a statement of what someone can afford or will be approved to borrow. It is neither. A payment can fit a formula while leaving too little room for taxes, repairs, emergencies, or other goals. Conversely, a different loan structure or payment amount changes the estimate.
Another common mix-up is entering a total housing payment as the principal-and-interest budget. If the entered $2,000 is meant to cover all monthly housing expenses, the calculator will overstate the loan supported by that amount because it assumes the full $2,000 goes to principal and interest. Estimate other costs separately before interpreting the result.
The formula also assumes a fixed rate and regular payments. It does not model adjustable rates, fees financed into the balance, extra payments, missed payments, taxes, insurance, or changes in expenses. APR and the interest rate used in an actual loan may not be interchangeable in every product; use the lender’s quoted figures and disclosures for a real comparison. This result is an estimate, and the lender’s disclosure gives the exact figures.
Frequently Asked Questions
Does this calculator tell me how much house I can afford?
No. It estimates a loan and price from a payment, rate, term, and down payment. It does not evaluate income, debts, savings, ownership costs, or lender approval.
Does the monthly amount include property taxes and insurance?
No. It covers principal and interest only. Taxes, homeowners insurance, mortgage insurance, and other property expenses are not included.
Why does a longer mortgage term increase the estimated price?
At a fixed monthly payment and rate, a longer term spreads repayment over more months. The formula therefore supports a larger starting principal, while total interest is calculated across all scheduled payments.
Should I enter APR or the interest rate?
Enter the annual percentage rate shown for the scenario, as the calculator divides it by 12 to derive a monthly rate. Loan disclosures can define and present costs differently, so follow the lender’s figures for the specific product.
Are closing costs part of the down payment here?
No. The price estimate is the calculated loan plus the down payment only. Closing costs and other upfront expenses are outside the formula.
Related
Formula used
in pmt | Monthly principal and interest budget | $ | 2000 | 1 | 1000000 in apr | Interest rate (APR) | % | 6 | 0.01 | 100 in yrs | Loan term | years | 30 | 0.0833 | 50 in down | Down payment | $ | 60000 | 0 | 100000000 out loan | Estimated loan amount | $ | pmt * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / (apr / 1200) | 2 out home | Estimated home price | $ | loan + down | 2 out int | Total interest | $ | pmt * yrs * 12 - loan | 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
- Y-12 Auto Loan Rates and Monthly Payment Calculator$405.53
- Y12 Auto Loan Rates and Monthly Payment Calculator$405.53
- Shorter Auto Loan Term: Payments, Interest and Trade-Offs$405.53
- Automobile Loan Calculator: Payments and Total Interest$405.53
- Long-Term Loan: Meaning, Terms, and Repayment$405.53
- Vehicle Loan Payment Calculator and How It Works$405.53