calculate-loan

01 Loan payments

Loan Amount Calculation Formula Explained

Calculator No. 01-23365 · Updated · Formula and assumptions shown below

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

This page explains the formula used to calculate the maximum loan amount you can borrow based on your desired monthly payment, interest rate, and loan term. You enter the monthly payment you can afford, the annual interest rate (APR), and the loan term in years; the calculator returns the loan principal you could borrow and the total interest paid over the life of the loan.

Formula

The loan amount (principal) is calculated by rearranging the standard fixed-rate loan payment formula. The payment formula is:

P = PMT × [1 – (1 + r)^(-n)] / r

Where:

  • P = loan principal (the amount you borrow), in dollars
  • PMT = monthly payment amount, in dollars
  • r = monthly interest rate, expressed as a decimal (annual rate divided by 12, then divided by 100)
  • n = total number of monthly payments (loan term in years × 12)

For example, with an annual interest rate of 8%, the monthly rate r = 8 / 1200 = 0.0066667. For a 5-year loan, n = 60. If you want a monthly payment of $400, the loan amount is:

P = 400 × [1 – (1.0066667)^(-60)] / 0.0066667 ≈ 400 × 49.318 ≈ $19,727

This is the maximum principal you can borrow while keeping the payment at $400, assuming the rate stays fixed and no other fees are rolled in.

Worked Example

Using the calculator defaults: loan amount $20,000, APR 8%, term 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Total number of payments: n = 5 × 12 = 60
  3. Plug into the payment formula: PMT = 20000 × 0.0066667 / (1 – (1.0066667)^(-60))
  4. Calculate (1.0066667)^(-60) ≈ 0.67121
  5. Denominator: 1 – 0.67121 = 0.32879
  6. Numerator: 20000 × 0.0066667 = 133.334
  7. PMT = 133.334 / 0.32879 ≈ 405.53

So the monthly payment is $405.53 (rounded to cents). Total paid over 60 months = 405.53 × 60 = $24,331.80. Total interest = $24,331.80 – $20,000 = $4,331.80.

Notice the calculator’s first output is the monthly payment, not the loan amount, because the page title asks for the formula that connects them. To find the loan amount, you would enter the payment you can afford and read the loan amount from the result.

Assumptions

  • Fixed interest rate for the entire term (no adjustable-rate changes).
  • Payments are made at the end of each month (ordinary annuity).
  • Interest compounds monthly at APR / 12.
  • The formula does not include fees, taxes, insurance, PMI, or escrow amounts.
  • The loan is fully amortized, meaning each payment covers interest and principal, and the balance reaches zero at the end of the term.

How to Use the Loan Amount Formula

This formula is most useful when you have a target monthly payment in mind and want to know how large a loan that payment supports. For example, if your budget allows $500 per month for a car loan at 6% APR for 4 years, you can calculate the maximum car price (before taxes and fees) you can finance. The same logic applies to personal loans, student loans, or mortgages (though mortgages often include property tax and insurance escrow, which are not in this formula).

To use the formula:

  1. Determine your comfortable monthly payment.
  2. Get the current APR from a lender (rates vary by credit score, loan type, and market).
  3. Choose a loan term (longer terms reduce the payment but increase total interest).
  4. Plug those numbers into the formula to find the principal.

Remember that lenders also consider your debt-to-income ratio, credit history, and other factors when approving a loan. The formula gives a mathematical limit, not a guarantee of approval.

Common Mistakes and Misconceptions

  • Using the annual rate instead of the monthly rate: Always divide the APR by 12 before using it in the formula. Forgetting this step will produce a payment that is far too high.
  • Confusing the loan amount with the purchase price: If you are buying a car, the loan amount is the price minus your down payment and any trade-in value. The formula calculates the loan principal, not the sticker price.
  • Ignoring fees and taxes: Many loans include origination fees, sales tax, or documentation fees. These are either added to the principal or paid upfront, so the actual amount you need to borrow may be higher than the purchase price.
  • Rounding too early: Rounding the monthly rate to a few decimals can change the payment by a few cents. For precise results, keep full precision until the final step.
  • Assuming a 0% interest period: Some loans offer promotional 0% APR for a limited time. The formula assumes a constant rate for the entire term; if the rate changes later, the payment will change.

Limits of the Formula

The loan amount formula works only for fixed-rate, fully amortizing loans with level payments. It does not apply to:

  • Interest-only loans (where you pay only interest for a period).
  • Balloon loans (where a large final payment is due).
  • Adjustable-rate mortgages (where the rate changes periodically).
  • Loans with prepayment penalties or irregular payment schedules.

Additionally, the formula assumes payments are made on time every month. Late fees or missed payments are not modelled. For variable-rate loans, you would need to recalculate the payment each time the rate changes.

Another limitation: the formula gives the maximum principal based on a payment, but lenders often cap the loan-to-value ratio (e.g., 80% for a mortgage without PMI) or the debt-to-income ratio. Those limits are separate from this arithmetic and must be checked with the lender.

How to Choose a Loan Term

The loan term (n) has a direct effect on both the monthly payment and total interest. A longer term reduces the monthly payment but increases the total interest paid because you are borrowing the money for more time. A shorter term increases the monthly payment but reduces total interest.

For example, a $20,000 loan at 8% APR:

  • 3-year term (36 months): payment ≈ $626.73, total interest ≈ $2,562.28
  • 5-year term (60 months): payment ≈ $405.53, total interest ≈ $4,331.80
  • 7-year term (84 months): payment ≈ $311.24, total interest ≈ $6,144.16

Choosing a term is a trade-off between monthly affordability and long-term cost. The formula lets you see both numbers side by side. There is no universally “best” term; it depends on your budget and how long you want to carry the debt.

Frequently Asked Questions

How do I calculate the loan amount if I know the monthly payment?

Rearrange the payment formula: P = PMT × [1 – (1 + r)^(-n)] / r. Use the monthly interest rate (APR/1200) and the total number of payments (years × 12). For example, with a $300 monthly payment, 6% APR, and 5-year term, P = 300 × [1 – (1.005)^(-60)] / 0.005 ≈ $15,517.

What is the difference between APR and the interest rate?

APR (Annual Percentage Rate) includes the interest rate plus certain fees and costs spread over the loan term, expressed as a yearly rate. The interest rate is just the cost of borrowing the principal. For the payment formula, using APR gives a more accurate payment if fees are included, but the formula assumes those fees are financed. If you pay fees upfront, the actual interest rate may differ from the APR.

Can I use this formula for a mortgage?

Yes, but with caution. Mortgages often include property taxes, homeowners insurance, and possibly PMI in the monthly payment, which are not part of this formula. The formula calculates only principal and interest. Also, mortgage rates are often quoted with APR that includes closing costs, so the payment may differ slightly from the formula’s result if you finance those costs.

Why does the calculator show “Cannot compute” when I enter a very low payment?

If the monthly payment is less than the monthly interest on the loan, the loan will never be paid off—the balance grows instead of shrinking. The formula becomes mathematically invalid because the denominator becomes negative or zero. In that case, no loan amount can satisfy the payment, so the calculator returns “Cannot compute.”

Does the loan amount formula work for daily or weekly payments?

No, the formula is designed for monthly payments with monthly compounding. For weekly or biweekly payments, you would need to adjust the rate and number of periods accordingly. For example, for weekly payments, use a weekly rate (APR/52) and the number of weeks in the term. The math is the same structure but with different period lengths.

How do taxes and insurance affect the loan amount?

If you include taxes and insurance in your monthly budget, you need to subtract those amounts from your total monthly payment before using the formula. For example, if you can afford $1,500 per month total, and property tax and insurance cost $300, then you have $1,200 for principal and interest. Use that $1,200 in the formula to find the loan amount.

The result from this calculator is an estimate based on the inputs you provide; the exact figures will be in the lender’s loan disclosure.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →