Loan calculator

Loan Affordability Calculator

Start from the payment you can afford each month, and this works backwards to the loan that payment will actually support.

What you can pay, and the terms on offer

Your monthly budget

$

Affordable monthly EMI.

The terms being offered

%

Loan interest rate.

years

Repayment period.

Maximum Loan

$98,593

Formula verified 12 September 2026

Total Interest

$81,407

Total Repayment

$180,000

Report an issue

Estimate only — not financial advice; lender terms, fees, and taxes vary. Read the full disclaimer ↓

Cumulative Principal vs Interest Paid

Add your numbers to see the visual breakdown.

Yearly Amortization Schedule

Repayment schedule for the maximum affordable loan.

PeriodPrincipal paidInterest paidEnding balance
Year 13,2598,74195,335
Year 23,5658,43591,770
Year 33,8998,10187,871
Year 44,2657,73583,606
Year 54,6657,33578,942
Year 65,1026,89873,839
Year 75,5816,41968,258
Year 86,1045,89662,154
Year 96,6775,32355,477
Year 107,3034,69748,173
Year 117,9894,01140,185
Year 128,7383,26231,447
Year 139,5582,44221,889
Year 1410,4541,54611,435
Year 1511,4355650

Estimates only — not financial, tax, or professional advice.

100% private — every number you enter is calculated in your browser and never sent to our servers.

What it calculates: Maximum Loan, Total Interest, Total Repayment.

Updated 5 June 2026 · Transparent assumptions

A payment is a stream, and the loan is its present value

An ordinary loan calculator takes an amount and produces a payment. This runs the same relationship the other way: your monthly budget is treated as a stream of payments, and the maximum loan is the present value of that stream discounted at the loan rate over the term.

That inversion is the useful one when you are shopping rather than confirming. It answers the question a borrower actually has — what can I take on — instead of the question a lender asks after the amount has already been chosen.

Stretching the term raises the ceiling and the total bill together

Extending the tenure lets the same monthly budget support a larger loan, because the payments are spread over more periods. The increase is not proportional: each additional year adds less to the borrowing capacity than the one before it, since the later payments are discounted hardest.

The total interest moves the other way and keeps climbing. Comparing a twenty-year and a thirty-year run at the same budget usually shows a modestly larger loan bought with a substantially larger interest bill, which is the trade the tenure decision actually is.

A point on the rate is worth tens of thousands of borrowing power

Because the rate discounts every future payment, a change of one percentage point moves the maximum loan by considerably more than one percent. On a long tenure the effect is largest, as the discounting compounds across the greatest number of periods.

This is worth testing before an offer is accepted rather than after. Running the same budget at the rate you have been quoted and at a point either side shows how much of your apparent capacity is actually a bet on the rate holding.

Affordability to you is not the same as eligibility to them

This calculates what a payment supports arithmetically. A lender adds tests this does not model: a debt-to-income ratio covering your other obligations, a credit assessment, income documentation, and a loan-to-value limit tied to whatever secures the loan.

The practical gap is usually the ratio test. Many lenders cap total debt servicing at around 40% to 50% of gross income, so a budget that is affordable in your own accounting can still exceed what the underwriting will approve.

Sources & References

Figures on this page are checked against primary, authoritative sources. Links open in a new tab.

Related Calculators

LoanWork out the monthly payment, total interest, and payoff date for any fixed-rate loan from the amount, rate, and term.
Amortization ScheduleBuild a full payment-by-payment schedule showing how each instalment splits between principal and interest.
Debt-to-Income RatioFront-end and back-end DTI against the thresholds lenders actually apply, plus the payment room left.
MortgageEstimate monthly payments, interest, taxes, insurance, PMI, and amortization using practical home-loan assumptions.

More in Finance, or browse all calculators.

Finance disclaimer

Results are estimates based on the figures you enter and standard formulas. Rates, fees, taxes, and lender terms vary and change over time, so confirm important numbers with your lender or a qualified professional. This is educational information, not financial advice.

How we calculate · Found an error? email us

Authorship & verification

Written and maintained by , a business operator who builds spreadsheet-based calculators.

What's changed (3 updates)

Published 12 September 2026

  1. Published the calculator with its formula, worked example, assumptions, limitations and a bespoke guide, and added an automated formula test suite covering it.
  2. Tested the inverted annuity against the forward loan formula: the maximum loan, fed back as a principal, must reproduce the payment budget entered.
  3. Tested that a longer tenure always raises the maximum loan and the total interest together, and that a zero rate makes the loan the payments summed.

Show it to your clients, not just tell them

Mortgage brokers, accountants, and advisors embed this to walk clients through the numbers live — nothing they enter ever leaves their browser.