Calcumetrics — Free online financial calculatorsCalcumetrics
Formulas & Methodology

Loan Affordability Calculator

Discover how much loan principal you can qualify for given your target monthly payment budget.

$

Maximum monthly payment you can comfortably afford

%

Anticipated loan interest rate

Planned duration of the loan in years

Results

Maximum Affordable Loan
$229,593
Monthly Payment Budget$2,000
Total Loan Repayment$360,000
Total Interest Payable$130,407
Principal Share63.8%

Based on reducing-balance amortization. Actual sanctioned loan amount depends on lender credit policies.

How loan affordability is determined

Loan affordability models invert the standard reducing-balance loan payment equation by calculating the Present Value (PV) of an ordinary annuity. Lenders calculate the maximum principal balance your monthly disposable cash flow can service:

1. Periodic Monthly Rate: r = Annual Interest Rate (%) ÷ 12 ÷ 100

2. Total Payment Installments: n = Loan Term (Years) × 12

3. Maximum Affordable Principal: Pmax = PMT × [ (1 + r)n − 1 ] ÷ [ r × (1 + r)n ]

4. Total Cumulative Outflow: Total Repayment = PMT × n

5. Total Lifetime Interest: Total Interest = (PMT × n) − Pmax

Step-by-Step Worked Example (Default Scenario)

Suppose you can comfortably dedicate $2,000 per month toward debt service, applying for a loan at an expected annual interest rate of 9.00% over a 15-year tenure (180 months):

Metric / ParameterFormula / MethodologyComputed OutputUnderwriting Interpretation
Monthly Repayment Budget (PMT)Target Monthly Allocation$2,000 / MonthRepresents 40% of a $5,000 monthly income.
Periodic Monthly Rate (r)6.50% ÷ 120.542% per monthMonthly compounding rate applied to reducing loan balance.
Total Installments (n)15 Years × 12 Months180 MonthsCumulative number of regular monthly installments.
Maximum Sanctionable Principal (Pmax)Present Value of $2,000 Annuity$229,593Maximum loan principal a lender will disburse based on cash flow.
Total Cash Repaid over 15 Years$2,000 × 180 Months$360,000Gross cash outflow paid to the lending institution.
Total Cumulative Interest Overhead$360,000 − $229,593$130,407 (36.2%)Pure interest financing charges earned by the bank.
Principal vs Interest Composition$229.6K (P) vs $130.4K (I)63.8% Principal / 36.2% InterestOver half of your total lifetime payments go toward principal retirement.

The Tenure Trap: Diminishing Borrowing Power

Extending loan tenure increases loan principal, but each extra year delivers sharply diminishing borrowing power while exploding total interest:

  • 10-Year Loan: Borrow $176,137. Total interest paid is $63,863 (26.6% of outflow).
  • 15-Year Loan (Default): Borrow $229,593 (+$53.5K borrowing power). Total interest paid is $130,407 (+$66.5K).
  • 20-Year Loan: Borrow $268,250 (+$38.7K borrowing power). Total interest paid is $211,750 (+$81.3K).
  • 25-Year Loan: Borrow $296,205 (+$28K borrowing power). Total interest paid is $303,795 (+$92K) — 1.03× the principal borrowed.

Debt-to-Income Underwriting Limits

Lenders do not let borrowers commit their whole income to loan payments. They cap total debt payments as a share of income (see the country boxes below):

  • Debt-to-Income Cap: Total monthly debt payments are usually limited to a fixed share of income, set by the lender, loan program and country.
  • Existing Debt Deductions: If you earn $5,000/month and already pay $750 on a car loan, your budget for a new loan drops from $2,000 to $1,250.
  • Credit Score Hurdle: The best rates go to borrowers with strong credit scores. A higher rate means a smaller loan for the same monthly payment.

Assumptions & Real-World Exclusions

  • LTV (Loan-to-Value) Ceiling: Even if your income supports a $229.6K loan, lenders will not lend more than 75% to 80% of the property's appraised market value. You must provide the remaining 20% to 25% as an upfront cash down payment.
  • Interest Rate Volatility: This calculation models a constant 6.50% fixed rate. Many long-term loans are variable. If rates rise by 150 bps, your affordable principal shrinks by about 8.8% for the same monthly budget.
  • Incidental Closing Costs: Mandatory statutory outlays like stamp duty, property registration, legal documentation fees, and property insurance are excluded from the sanctioned loan sum.

Country rules at a glance

India

  • Banks cap the FOIR (fixed obligations to income ratio) at about 40–50% of net monthly income, depending on income level and lender.
  • A CIBIL score of 750+ usually gets the best rates.
  • 18% GST is charged on credit card interest and fees.

United States

  • The 28/36 guideline: housing up to 28% and all debts up to 36% of gross income.
  • There has been no fixed Qualified Mortgage DTI cap since 2022 (CFPB replaced the 43% limit with a price-based test); limits come from each loan program and lender.
  • Card minimum payments are typically 1% of the balance plus interest and fees, or a fixed floor (often $25–$40), whichever is higher.

United Kingdom

  • Lenders must run an FCA affordability assessment of income and committed spending before lending.
  • Card minimum payments must cover at least interest, fees and 1% of the balance.
  • No VAT is charged on credit interest.
Wondering how lenders evaluate your debt limits?Read our mortgage underwriting guide on Debt-to-Income (DTI) Ratio for Mortgages: Front-End vs Back-End Limits to understand the exact benchmark percentages banks enforce during loan qualification.

Frequently asked questions

How is maximum loan affordability calculated?
It inverts the standard loan payment formula by calculating the present value of an annuity. Given your maximum affordable monthly installment, loan tenure, and prevailing interest rate, it solves for the maximum principal sum a lender would sanction.
What percentage of my monthly income should go toward loan payments?
Prudent financial planning guidelines suggest keeping total debt obligations (including home loan, car loan, and credit cards) under 35% to 40% of gross monthly income (the Debt-to-Income or DTI benchmark).
How does interest rate affect my borrowing capacity?
Interest rates have an inverse relationship with borrowing capacity. A 1% increase in loan interest rate typically reduces your maximum affordable loan amount by approximately 6% to 9% for the same monthly payment.
Does increasing loan tenure increase borrowing power?
Yes, spreading the loan over a longer duration (e.g. 25 years instead of 15 years) lowers each monthly installment, enabling a larger total loan principal for the same monthly budget. However, total interest paid over the life of the loan increases significantly.
What other costs should I budget for besides the loan payment?
Borrowers should budget for loan processing fees, legal verification costs, stamp duty, mandatory property or loan insurance, and future maintenance or property taxes.

Related calculators

Loans

Mortgage Calculator

Calculate monthly mortgage payments, down payment impact, and total loan interest.

Loans

Home Loan Calculator

Calculate the monthly payment, loan interest, and amortization schedule for a home loan.

Loans

Debt-to-Income Ratio Calculator

Assess your borrowing health and loan approval eligibility using front-end and back-end DTI.

Maximum Affordable Loan

$229,593

Cookie settings

Choose which optional cookies Calcumetrics may use. You can change this at any time from the footer.