calculate-loan

01 Loan payments

Home Affordability Formula and Calculator

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

Estimated home price $414,392
Estimated monthly principal and interest
$2,240.00
From the formula below, to the cent
Housing payment used by formula
$2,240.00
Level-payment formula, rounded to the cent
Gross monthly income
$8,000
Input
You enter
Gross monthly income ($), Other monthly debt payments ($), Housing payment share of income (%), Mortgage interest rate (APR) (%), Mortgage term (years), Down payment ($)
You get
Estimated home price ($), Estimated monthly principal and interest ($), Housing payment used by formula ($)
Rounding
0 dp · 2 dp

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.

The home affordability formula estimates a home price from the monthly housing payment a household can allow in its budget, its income and debts, and the mortgage’s interest rate and term. Enter those figures to estimate a maximum loan amount and, after adding a down payment, a corresponding home price; the result is a planning estimate, not an approval or a guarantee of affordability.

Formula

A common affordability estimate starts with two possible monthly payment ceilings and uses the smaller one. The first is a chosen share of gross monthly income; the second limits total monthly debt payments to a chosen debt-to-income ratio. This calculator uses the entered housing share and a 36% total-debt ratio as an illustrative model, not a universal lending standard.

Housing payment limit = min(gross monthly income × housing share, gross monthly income × 0.36 − other monthly debt payments).

Loan amount = payment limit × [1 − (1 + r)−n] ÷ r, where r = APR ÷ 1200 and n = term in years × 12.

Estimated home price = loan amount + down payment. The calculator expresses that combined amount directly as payment limit × [1 − (1 + r)−n] ÷ r + down payment.

  • Gross monthly income is income before deductions, in dollars per month.
  • Housing payment share is the entered percentage of gross income used for the first payment limit.
  • Other monthly debt payments are recurring debt obligations, in dollars per month.
  • APR is the entered annual percentage rate, in percent; the formula converts it to a monthly rate.
  • Term is the mortgage length in years; the formula converts it to monthly payments.
  • Down payment is the cash amount added to the estimated loan amount to produce the home-price estimate.

The payment limit represents principal and interest only. Property taxes, homeowners insurance, mortgage insurance, homeowners association charges, and other ownership costs are not subtracted from it. The zero adjustment in the calculator expression does not change the result; it keeps the displayed price expression in the supported calculator syntax.

Worked Example

Using the defaults: gross monthly income is $8,000, other monthly debts are $600, the housing share is 28%, APR is 6.5%, the term is 30 years, and the down payment is $60,000.

  1. Housing-share ceiling: $8,000 × 0.28 = $2,240 per month.
  2. Total-debt ceiling: $8,000 × 0.36 − $600 = $2,280 − $600 = $1,680 per month.
  3. Use the smaller amount: the payment limit is $1,680. The monthly rate is 0.065 ÷ 12 = 0.00541667, and the term is 30 × 12 = 360 months.
  4. Loan amount = $1,680 × [1 − (1 + 0.00541667)−360] ÷ 0.00541667 ≈ $270,357. The home-price estimate is $270,357 + $60,000 = $330,357.
  5. The estimated monthly principal-and-interest payment on the $270,357 loan is about $1,680.00. The displayed housing payment limit is $1,680.00.

Assumptions

  • The interest rate stays fixed throughout the illustrated term.
  • Payments are level monthly payments, made at the end of each period.
  • Interest is modelled monthly at APR divided by 12.
  • The payment and price do not include fees, taxes, insurance, mortgage insurance, escrow, or association charges. The calculation also does not model closing costs, maintenance, utilities, or income changes.
  • The 36% total-debt ratio and the housing share are model inputs for an estimate, not statements of lender rules or approval criteria.

How to Read the Estimate

The estimated home price combines the principal the selected payment limit could support with the down payment entered. It is not the maximum price a lender will finance, nor does it account for whether the down payment is also needed for closing expenses or reserves. If the debt-based ceiling is lower than the housing-share ceiling, existing monthly debts are the factor constraining this particular estimate.

The example’s $1,680 is a principal-and-interest amount, not a complete monthly housing budget. For a fuller budget, independently estimate recurring home costs and consider how much cash remains after the down payment and purchase expenses. Because the formula treats the entire payment limit as available for principal and interest, additional housing costs can make the practical payment higher than the estimate suggests.

Choosing Inputs and Understanding Limits

Use gross monthly income that is reasonably stable, and enter the monthly payments for debts that matter to your budget. The housing share is a user-selected assumption: changing it changes the first ceiling, but the total-debt ceiling may still be lower. The 36% value is built into this example formula and should not be read as a universal threshold. Actual lender calculations and household budgets can differ.

Use a rate and term supplied for the scenario you want to examine; rates and fees vary by situation and must be obtained from the lender. The calculator’s APR input is used as a monthly interest rate of APR divided by 12. If a quoted APR includes costs or is defined differently from the interest rate used to calculate payments, this simplified conversion may not reproduce a lender’s payment exactly. The mortgage price estimate also assumes the down payment is applied to the purchase and does not model a loan with a different structure.

Common Mistakes and Related Measures

  • Using take-home pay as gross income: the formula asks for income before deductions. A separate household budget may be more useful for judging cash flow after taxes and payroll deductions.
  • Leaving out debts: omitting monthly debt payments raises the debt-based payment ceiling in the calculation.
  • Treating price as loan amount: the home-price estimate includes the down payment; the loan amount is the price minus that down payment.
  • Confusing principal and interest with total housing cost: taxes, insurance, and other costs are excluded.
  • Overinterpreting precision: the output is rounded to whole dollars, while the inputs and real transaction costs may be uncertain. Small changes in rate or term can affect the estimate.

Debt-to-income ratio is a related measure: it compares monthly debt payments with gross monthly income. In this calculator, the 36% total-debt ceiling is one way to bound the payment after accounting for other debts; it is not the same as a complete affordability assessment. A payment calculator can show the principal-and-interest cost for a selected loan amount, while this formula works backward from a payment limit to an estimated loan size.

Frequently Asked Questions

What is the formula for home affordability?
Set a monthly payment ceiling, convert it to a loan amount using the mortgage payment formula, then add the down payment. This calculator uses the lower of a selected share of gross income and a 36% total-debt ceiling after other monthly debt payments.

Does home affordability include property taxes and insurance?
Not in this calculator’s payment formula. It estimates principal and interest only, so taxes, homeowners insurance, mortgage insurance, association charges, and other costs need separate estimates.

Is the estimated home price the amount I can borrow?
No. The estimate includes the entered down payment, so it is a purchase-price estimate. The implied loan amount is the estimated price minus the down payment.

Why does existing debt reduce the estimate?
Monthly debts use part of the total-debt payment ceiling. When that ceiling is lower than the income-share ceiling, the remaining amount sets the principal-and-interest payment used to calculate the loan size.

How does a higher interest rate affect the estimate?
For the same monthly payment and term, a higher rate generally supports a smaller loan amount under the standard amortization formula. Use a rate supplied for your scenario rather than treating the example default as a current market quote.

Is this estimate a lender approval or financial advice?
No. It is general estimate arithmetic and does not model lender underwriting, program rules, or every household expense. The result is an estimate, and the lender’s disclosure gives the exact figures.

Related

Formula used
in inc | Gross monthly income | $ | 8000 | 0 | 100000000
in debt | Other monthly debt payments | $ | 600 | 0 | 100000000
in ratio | Housing payment share of income | % | 28 | 0.01 | 100
in apr | Mortgage interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Mortgage term | years | 30 | 0.0833 | 50
in down | Down payment | $ | 60000 | 0 | 100000000
out price | Estimated home price | $ | max(0, (min(inc * ratio / 100, inc * 0.36 - debt) - (inc * ratio / 100 * 0)) * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / (apr / 1200) / (1 + 0) + down) | 0
out pay | Estimated monthly principal and interest | $ | (price - down) * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out limit | Housing payment used by formula | $ | min(inc * ratio / 100, inc * 0.36 - debt) | 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 →