Home Loan Affordability Calculator and Formula

A home loan affordability calculator estimates the mortgage principal supported by a monthly payment you enter, at a stated annual interest rate and term. Enter the payment budget, APR, and loan term to see the estimated loan amount, along with the total paid and interest over the term; this is a payment-based estimate, not an approval decision or a full household budget.

Formula

This calculator reverses the standard fixed-payment loan formula to estimate the principal that a monthly payment can repay. It assumes the entered monthly budget is entirely available for principal and interest. With a monthly interest rate above zero:

Loan amount = payment × [1 − (1 + monthly rate)^{−number of payments}] ÷ monthly rate

• Payment is the monthly principal-and-interest amount, in dollars.
• Monthly rate is APR ÷ 1,200, converting an annual percentage into a monthly decimal rate.
• Number of payments is loan term in years × 12.
• Total paid is the entered monthly payment, rounded to cents, multiplied by the number of payments.
• Total interest is total paid minus the estimated loan principal.

The input calls the payment a budget, but it should be understood narrowly: it represents only the mortgage’s principal and interest. The calculation does not determine what payment a household can safely sustain. APR must be entered as a percentage, such as 6.5—not as 0.065. The formula uses monthly amortization, with the payment treated as fixed throughout the term.

Worked Example

Using the calculator’s default inputs—$2,000 per month, 6.5% APR, and a 30-year term:

1. Convert APR to a monthly rate: 6.5 ÷ 1,200 = 0.0054166667.
2. Calculate the number of monthly payments: 30 × 12 = 360.
3. Substitute into the principal formula: $2,000 × [1 − (1 + 0.0054166667)⁻³⁶⁰] ÷ 0.0054166667.
4. The estimated loan amount is approximately $312,861.54, rounded to cents.
5. Total principal and interest paid is $2,000 × 360 = $720,000.00.
6. Estimated total interest is $720,000.00 − $312,861.54 = $407,138.46.

The example assumes the full $2,000 payment is made every month for all 360 months. It does not mean that $2,000 is an appropriate payment for any particular household. In a real mortgage, payment dates, rate terms, rounding, and other charges can change the figures.

Assumptions

• The interest rate is fixed for the entire term; changes to a variable rate are not modelled.
• Payments are level monthly payments made at the end of each monthly period.
• Interest accrues monthly using APR divided by 12; the formula treats APR as a nominal annual rate.
• Fees, taxes, homeowners insurance, mortgage insurance, escrow, and closing costs are not included.
• The budget is rounded to cents for total-paid calculations; the estimated loan amount is also rounded to cents.

How to Use the Estimate

Use the result as a mathematical starting point for comparing possible payment, rate, and term combinations—not as a home-price estimate by itself. The estimated loan amount is the modeled principal. A home’s purchase price may differ because the down payment affects how much must be borrowed, while closing costs and other transaction expenses are outside this calculation.

For a more complete household estimate, separately account for recurring housing costs and other obligations. Property-related charges, insurance, maintenance, utilities, and any association dues can affect the amount left in a monthly budget even though they do not appear in the calculator. A lender may also evaluate income, existing debts, assets, credit history, and other information; this calculator does not model those assessments or predict approval.

To explore scenarios, change one input at a time. Holding payment and term fixed, a higher APR generally supports a smaller principal because more of each payment goes to interest. Holding payment and APR fixed, a longer term generally produces a larger calculated principal, but also more monthly payments and usually more total interest under the model. These are formula relationships, not claims about available market rates or an individual’s eligibility. Enter the rate and charges from the lender’s own written estimate or disclosure when available.

Common Errors and Limits

• Confusing payment with total housing cost: the calculator includes principal and interest only. It does not turn the entered amount into an all-in monthly housing budget.
• Entering APR in the wrong format: type 6.5 for 6.5%, not 0.065. The calculator divides the percentage by 1,200 itself.
• Mixing years and months: term is entered in years, and the formula multiplies it by 12. A 30-year term therefore means 360 payments.
• Treating the estimate as a purchase price: the output is loan principal, not the home’s price. Down payment and other costs require separate calculations.
• Assuming all loans stay fixed: the formula does not represent a changing rate, irregular payments, interest-only periods, or extra principal payments.

At very low rates, small differences in APR and rounding can affect the result; the input minimum prevents a zero rate, which would require a separate zero-interest formula. The calculator also cannot account for lender-specific payment conventions, fees financed into the loan, or payment changes. Use consistent figures when comparing scenarios, and do not treat precision to the cent as proof that the underlying assumptions are exact.

Frequently Asked Questions

How do I calculate how much home loan I can afford?
For a payment-based estimate, enter the monthly principal-and-interest amount, APR, and term in the formula above. The result is the principal supported by those inputs; it does not assess household affordability or approval.

Does the calculator include property taxes and insurance?
No. The payment input covers principal and interest only. Add any taxes, insurance, mortgage insurance, escrow charges, and other housing expenses separately when working out a broader monthly budget.

Is the estimated loan amount the same as the home price?
No. The estimate is the amount borrowed. The purchase price can differ depending on the down payment and costs that are not included in this calculation.

Why does a longer mortgage term increase the estimated loan amount?
With the same payment and rate, a longer term provides more monthly payments to repay principal. It can therefore support a larger principal in this formula, while increasing the number of payments and modeled total interest.

Will this calculation tell me whether a lender will approve me?
No. It only applies a standard amortizing-loan formula to the figures entered. Approval and actual loan terms depend on information and criteria the calculator does not evaluate.

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

Related

• Total Cost Reduction Calculator and Loan Savings
• Total Cost of Quality Graph: How to Read It
• Total Cost of Quality Calculator and Formula

in budget | Monthly principal-and-interest budget | $ | 2000 | 1 | 1000000
in apr | Interest rate (APR) | % | 6.5 | 0.01 | 100
in yrs | Loan term | years | 30 | 0.0833 | 50
out loan | Estimated loan amount | $ | round(budget * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / (apr / 1200), 2) | 2
out paid | Total principal and interest paid | $ | round(budget, 2) * yrs * 12 | 2
out int | Total interest | $ | paid - loan | 2