Loan Affordability Calculator

Loan Affordability Calculator

Emerging AI Skill PRO

Enter Calculation

Formula

L=M·1−(1+r)−nrwhere{M=Monthly Paymentr=Rate (%)1200n=12×Term (years)\begin{gathered} L = M \cdot \frac{1 - (1+r)^{-n}}{r} \\[1.5em] \text{where}\quad \left\{ \begin{aligned} M &= \text{Monthly Payment} \\ r &= \dfrac{\text{Rate (\%)}}{1200} \\ n &= 12 \times \text{Term (years)} \end{aligned} \right. \end{gathered}
Usage stats

Advertisement

Results

Maximum Loan Amount
166,791.61
you can borrow at this payment
Total of Payments 360,000
Total Interest 193,208.39

Report an error on this page

What Is a Loan Affordability Calculator?

A loan affordability calculator works backwards from the monthly payment you can comfortably afford to the maximum loan amount you can borrow. Instead of asking "what is the payment on this loan?", it answers "how big a loan fits my budget?" This is ideal for mortgages, car loans, and personal loans when you know your spare monthly cash but not the price you should target.

How to Use It

Enter three values: the monthly payment you can afford, the annual interest rate (APR) the lender quotes, and the loan term in years. The calculator converts the rate and term into monthly figures and returns the maximum principal that payment will support, plus the total you will pay and the total interest cost over the life of the loan.

The Formula Explained

The calculation is the present value of an annuity:

$$\text{MaxLoan} = \text{PMT} \times \frac{1 - (1 + r)^{-n}}{r}$$

Here PMT is the monthly payment, r is the monthly interest rate (annual rate \(\div 12 \div 100\)), and n is the total number of monthly payments (years \(\times 12\)). When the interest rate is zero, the formula simplifies to \(\text{MaxLoan} = \text{PMT} \times n\).

Advertisement
Diagram showing a fixed monthly payment splitting into principal and interest, summing to a maximum loan amount
The maximum loan is the present value of all your fixed monthly payments discounted at the interest rate.

Worked Example

Suppose you can afford $1,000 per month, the rate is 6% APR, and the term is 30 years. Then \(r = 0.06 \div 12 = 0.005\) and \(n = 360\). $$\text{MaxLoan} = 1000 \times \frac{1 - 1.005^{-360}}{0.005} \approx \$166{,}791.61$$ Over 30 years you would pay $360,000 in total, of which about $193,208 is interest.

Stacked bar comparing principal portion versus total interest paid over the loan term
Worked example: how the affordable loan amount compares to the total interest paid over the term.

Interpreting Your Result

The result is a principal-and-interest ceiling. It is the largest loan whose level monthly payments, at a fixed interest rate over the chosen term, equal the payment you entered. Total interest is simply total payments (payment × number of payments) minus the principal.

  • Higher rates shrink the loan that each payment dollar can support.
  • Longer terms increase the loan size for the same payment but raise the total interest paid, because the balance stays outstanding longer.
  • Not included: property taxes, insurance, loan fees, closing costs, mortgage insurance, and any down payment. Variable or adjustable rates are also excluded, since the payment can change over time.

Lenders commonly use debt-to-income (DTI) ratios as a general benchmark. One widely cited mortgage guideline in the United States is the 28/36 rule: housing costs of roughly 28% of gross monthly income and total debt payments of roughly 36%. Actual lender criteria vary by country, loan type, and lender. This is general information, not personal financial advice.

Advertisement

Key Terms

  • Principal: the amount borrowed, before interest. In this calculator it is the maximum loan \(L\).
  • APR (annual percentage rate): the yearly cost of borrowing expressed as a percentage. Depending on the jurisdiction it may include certain fees, not just the nominal interest rate.
  • Monthly rate \(r\): the annual rate in percent divided by 1200 (12 months × 100), for example 6% gives \(r = 0.005\).
  • Number of payments \(n\): the term in years multiplied by 12.
  • PMT: the periodic payment on a loan. The calculator solves the PMT formula for the principal instead of the payment.
  • Amortization: paying off a loan through scheduled payments, each covering that period's interest and reducing part of the principal.
  • Total interest: total of all payments minus the principal borrowed.
  • Present value of an annuity: the current value of a series of equal future payments discounted at a fixed rate, \(M \cdot \frac{1-(1+r)^{-n}}{r}\). It equals the loan amount those payments can repay.

Central bank policy rates today

The latest official policy rates of major central banks, updated automatically — the benchmark that bank deposit and loan rates follow.

Federal Reserve · United States
3.75–4.00%
As of
2026-11-12
Change in 1 year
0 pp

Latest change Up +25 bp Federal Reserve changed its rate on 2026-09-17: from 3.50–3.75% to 3.75–4.00%.

Federal Reserve
Central bankPolicy rateAs ofChange in 1 year
Banco Central do Brasil (Selic) · Brazil13.75%2026-11-15−1.25 pp
Banco de México · Mexico6.25%2026-11-10−1.00 pp
Federal Reserve · United States3.75–4.00%2026-11-120 pp
ECB2.50%2026-11-16+0.50 pp
Sveriges Riksbank · Sweden2.00%2026-11-16+0.25 pp
Saudi Central Bank (SAMA) · Saudi Arabia4.50%2026-10-290 pp
Reserve Bank of Australia · Australia4.60%2026-10-31+1.00 pp
Central Bank of the Republic of Türkiye · Türkiye36.00%2026-11-06−3.50 pp
Bank of Russia · Russia14.00%2026-11-10−2.50 pp
People’s Bank of China · China3.00%2026-11-100 pp
Bank of Canada · Canada2.50%2026-11-12+0.25 pp
Reserve Bank of India · India5.50%2026-10-190 pp
Bank of England · United Kingdom4.00%2026-11-160 pp
Bank of Japan · Japan1.25%2026-11-10+0.75 pp
Bank of Korea · South Korea3.00%2026-11-02+0.50 pp

Federal Reserve: key rates and overnight market rates

The rates that frame monetary policy and the overnight market rate they steer, each with the date of its latest published value.

RateLevelAs ofChange in 1 year
Federal funds target range3.75–4.00%2026-11-120 pp
Effective federal funds rate (EFFR)3.88%2026-11-12+0.01 pp
Secured Overnight Financing Rate (SOFR)3.90%2026-11-12−0.08 pp
Effective federal funds rate (EFFR)

Each rate keeps the date of its own latest published value; overnight market rates are published on the next business day.

Latest figure: 2026-11-12 Data last updated 2026-11-16 · current

Source: Banco Central do Brasil ODbL; Bank for International Settlements (BIS) Terms of permitted use of BIS statistics; Federal Reserve Bank of New York New York Fed Terms of Use; Board of Governors of the Federal Reserve System Public domain (U.S. government work); European Central Bank ECB reuse policy; Sveriges Riksbank Riksbank open data terms; The World Bank Group CC BY 4.0; Reserve Bank of Australia 2026 RBA copyright terms (Cash Rate); Bank of Canada Bank of Canada terms of use; Bank of England Open Government Licence v3.0

The one-year change is computed by CalculatorLib from these data. The EFFR and SOFR are subject to the Terms of Use posted at newyorkfed.org. The New York Fed is not responsible for publication of the EFFR and SOFR by CalculatorLib, does not sanction or endorse any particular republication, and has no liability for your use.

Source details and methodology

Interest rates in United States: all figures and history

FAQ

Does this include taxes and insurance? No. It calculates the loan principal supported by your payment toward principal and interest only. For a mortgage, reserve part of your budget for property taxes, insurance, and fees.

Why does a longer term let me borrow more? Stretching payments over more months spreads the principal out, so each fixed payment supports a larger loan — but you pay far more interest overall.

Is this currency-specific? No. Enter amounts in any currency; the math is universal as long as the payment, rate, and term are consistent.

Last updated:

Most popular in Financial

View all Financial calculators