Mortgage Affordability Calculator
Estimate the maximum fixed-rate mortgage and purchase price that fit two debt limits you choose. The calculation compares a housing-only limit with a total-debt limit, deducts recurring ownership costs, and converts the remaining monthly payment into a loan amount.
By Dr. Hassan Khames EliwaLast updated
Result
- Maximum purchase price before closing costsDeposit is assumed fully available for the purchase.
- $366,896.57
- Monthly principal and interest capacity
- $1,840.00
- Monthly housing cap
- $2,240.00
- Monthly housing capacity under total debt limit
- $2,380.00
- Monthly budget shortfall
- $0.00
How it works
Translate income into two separate limits
Use gross monthly income before payroll deductions, not annual salary or take-home pay. Divide annual income by twelve when income is stable; variable earnings deserve a conservative sustainable average. Other monthly debt payments include contractual payments such as vehicle loans, student loans, and credit cards. Do not enter outstanding balances in that field.
The housing cap equals monthly income multiplied by your housing ratio. The total-debt cap for housing equals monthly income multiplied by your total-debt ratio, minus other debt payments. Available housing spending is the smaller cap. The displayed 28% and 36% defaults illustrate a planning scenario; they are neither universal lending rules nor approval thresholds.
Separate ownership costs from the loan payment
Subtract monthly property taxes, homeowners insurance, association charges, and any mortgage insurance from the smaller cap. The remainder, floored at zero, is the maximum principal-and-interest payment. Estimate annual bills monthly and update those estimates for the prospective property. A cost that rises with purchase price may require several trial calculations rather than one definitive answer.
For monthly interest r, payment M, and n monthly payments, maximum loan = M × [1 − (1 + r)^−n] ÷ r. The annual nominal rate is divided by 1,200; years are multiplied by twelve. When interest is zero, loan = M × n. The purchase price is this loan plus the entered cash deposit, before transaction costs.
Understand the limits of the answer
A fixed monthly amortization model does not simulate adjustable rates, balloon payments, tax benefits, qualification stress tests, or future income changes. The rate should be the contract interest rate, not a fee-inclusive APR substituted without adjustment. The model accepts whole-year terms from one to fifty and shows money in generic dollars; consistent currency inputs work without exchange conversion.
A positive shortfall means the chosen debt caps cannot cover the entered recurring ownership costs even before borrowing. The loan is then zero. A deposit-only price still appears arithmetically, but it does not establish that ongoing ownership is affordable. Compare the result with actual take-home cash flow, emergency reserves, and lender-specific underwriting before setting an offer ceiling.
Worked example
Example 1: the lower cap controls
Gross monthly income is $8,000, other debt payments are $500, the deposit is $60,000, and recurring housing costs are $400 monthly. With a 28% housing limit, the housing cap is $2,240. With a 36% total limit, housing capacity is $2,880 − $500 = $2,380. The smaller $2,240 cap leaves $1,840 for principal and interest. At 6% over 30 years, maximum loan is $306,896.57 and purchase price is $366,896.57.
Example 2: interest-free planning comparison
Use $5,000 monthly income, $300 other debt, $20,000 deposit, $200 monthly ownership costs, a 30% housing ratio, a 40% total-debt ratio, and a ten-year term at zero interest. Caps are $1,500 and $1,700. Payment capacity is $1,300. Over 120 months the loan is $156,000 and purchase price is $176,000. This isolates the payment arithmetic rather than suggesting interest-free mortgages are generally available.
Expert tips
Common mistakes
- Entering annual salary as monthly income exaggerates borrowing capacity twelvefold before interest effects.
- Subtracting other debt again from the housing-only cap double-counts it; this calculator subtracts it only within the total-debt test.
- Treating the maximum price as a recommendation ignores savings goals, irregular expenses, job security, and maintenance.
For education, not financial advice. Results are estimates based on the inputs you give. Lenders, tax authorities and advisers may use different rules, fees and rounding. Check the numbers with a qualified professional before you commit to anything.
Frequently asked questions
Are the default ratios lender requirements?
No. They are editable examples. Requirements differ by lender, loan program, jurisdiction, credit profile, and compensating factors. Obtain current criteria directly from the lender.
Which limit controls?
The smaller housing capacity controls. A stricter total-debt limit can bind even when the housing-only ratio looks comfortable, particularly when other debt payments are high.
Does the deposit reduce monthly debt?
The deposit is added to borrowing capacity to estimate price. Existing monthly debt remains unchanged unless it is actually repaid before purchase; do not assume both uses of the same cash.
Are taxes and insurance included?
Only through the recurring-cost figure you enter. The tool does not fetch local rates or infer insurance from the home price, so revise that input for each property.
Why is the loan zero?
The chosen caps may leave no money after existing debt and ownership costs. Review the shortfall rather than interpreting the deposit-only price as an affordable ownership recommendation.
Is this a mortgage approval?
No. Credit checks, documentation, appraisal, loan-to-value restrictions, reserves, and product rules are outside this calculation. The result is a transparent planning estimate, not an offer of credit.
Related calculators
Related guides
FinancialMortgage Affordability Ratios: Set Your Own LimitsCompare user-set housing and debt ratios, deduct other housing costs, and translate a monthly payment budget into a loan estimate.17 November 2026 · 7 min read
FinancialHow mortgage amortization really worksEarly payments are mostly interest because the balance is still large—not because the lender charges all the interest upfront.14 November 2026 · 7 min read
FinancialComparing two loan offers: when the lower rate losesCompare loan payments, upfront fees, full-term costs and early payoff balances so a lower interest rate does not disguise a worse offer.16 November 2026 · 8 min readSources and standards
About the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee