calculate-loan

01 Loan payments

Loan Amount Based on Monthly Payment

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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 calculator works out the maximum loan principal you can borrow given a target monthly payment, an annual interest rate (APR), and a loan term in years. Enter your desired monthly payment, the APR your lender quotes, and the term, and you get back the loan amount you could borrow along with the total interest you would pay over the life of the loan. The math reverses the standard loan payment formula to solve for the principal.

Formula

The calculator uses the standard amortization formula, rearranged to solve for the principal (P) instead of the payment (M). The ordinary formula for a fixed-rate, fully amortizing loan is:

M = P × r × (1 + r)^n / ((1 + r)^n − 1)

where:

  • M = monthly payment (dollars per month)
  • P = loan principal, the amount borrowed (dollars)
  • r = monthly interest rate = APR ÷ 12 (as a decimal; e.g., 8% APR → 0.08 ÷ 12 = 0.006666…)
  • n = total number of monthly payments = term in years × 12

Solving for P gives:

P = M × (1 − (1 + r)^−n) / r

That is exactly what the calculator computes. The total interest is simply the total of all payments minus the principal: Interest = (M × n) − P.

Worked Example

Use the default values from the calculator: a monthly payment of $500, an APR of 8%, and a term of 5 years.

  1. Convert the APR to a monthly rate: r = 8 ÷ 1200 = 0.0066667 (0.66667% per month).
  2. Find the number of payments: n = 5 × 12 = 60.
  3. Compute (1 + r)^−n = (1.0066667)^−60 ≈ 0.671216.
  4. Then 1 − 0.671216 = 0.328784.
  5. Divide by r: 0.328784 ÷ 0.0066667 ≈ 49.3176.
  6. Multiply by the payment: 500 × 49.3176 ≈ $24,658.80.

So with a $500 monthly payment at 8% APR for 5 years, you could borrow about $24,658.80. Total paid = $500 × 60 = $30,000. Total interest = $30,000 − $24,658.80 = $5,341.20. The calculator shows the same result (rounded to the cent).

Assumptions

  • Fixed interest rate for the entire term (no adjustable-rate changes).
  • Payments are made at the end of each month, starting one month after the loan originates.
  • Interest compounds monthly at APR ÷ 12.
  • The loan is fully amortizing: each payment covers the interest due and reduces the principal so the balance reaches zero after the last payment.
  • No fees, taxes, insurance, PMI, or escrow are included. Those would reduce the amount you can borrow for a given monthly budget.

How to Use This Calculator

Start with a monthly payment that fits your budget. That number comes from your own cash flow, not from a lender’s pre-approval. Then enter the APR you were quoted or expect to qualify for, and the term you want (for example, 3, 5, or 7 years for a personal or auto loan; 15 or 30 years for a mortgage). The calculator tells you the maximum principal you could borrow under those assumptions.

This is useful when you are comparing loan offers or deciding how much to ask for. For example, if a lender offers you $30,000 but your budget only allows $450 per month, you can work backwards: at 7% APR for 5 years, a $450 payment supports about $22,730. You would either borrow less or extend the term (which increases total interest).

Common Mistakes and Pitfalls

  • Using the annual rate directly. The formula needs the monthly rate. Always divide the APR by 12 (and by 100 to convert from percent to decimal). The calculator does this automatically.
  • Ignoring the effect of term length. A longer term lowers the monthly payment for the same principal, but increases total interest. For instance, a $20,000 loan at 8% APR costs $405.53 per month over 5 years (total interest $4,331.80) but only $242.66 per month over 10 years (total interest $9,119.20).
  • Forgetting that the payment must cover the interest. If your monthly payment is less than the monthly interest on the principal, the loan would never be paid off. The formula will return an error (Cannot compute) in that case, which is correct—no finite term exists.
  • Rounding too early. If you round the monthly rate to 0.007 before calculating, you might get a slightly different principal. Keep several decimal places until the final step.

How to Choose Your Inputs

Your monthly payment is the anchor. A common rule of thumb is that your total monthly debt payments (including this loan) should stay below a certain percentage of your gross income, but that is a guideline, not a rule. Use your actual budget: list your income, fixed expenses, and other debt payments, and see what is left over. That leftover is your realistic monthly payment.

For the APR, use the rate a lender actually quotes you, not an advertised or average rate. Rates vary by credit score, loan type, and market conditions. If you are shopping around, run the calculator with each quoted APR to see how the loan amount changes.

For the term, consider how long you want to be in debt. A shorter term means higher payments but less interest; a longer term means lower payments but more interest. Choose a term that you can commit to, and remember that extending a term to “afford” a payment often costs thousands in extra interest.

Limits of This Calculation

This calculator gives the principal based on the payment, rate, and term you enter. It does not account for:

  • Origination fees, application fees, or prepayment penalties that reduce the amount you actually receive.
  • Required insurance (like PMI on a mortgage with less than 20% down) or property taxes that are often escrowed into the monthly payment.
  • Balloon payments or interest-only periods, which are not standard amortizing loans.
  • Changes in interest rate if the loan has a variable rate.

Also, the result is a mathematical maximum. Lenders will look at your credit history, income, and debt-to-income ratio to decide whether they will actually approve you for that amount. This calculator does not predict approval or what you can afford—it only converts a payment, rate, and term into a principal.

Frequently Asked Questions

What if I want to include fees in the loan amount?

If the lender charges fees that are rolled into the loan, you need to borrow more than the amount you actually get. For example, if you want $20,000 in cash and there is a 2% origination fee ($400), you would need to borrow about $20,408 to net $20,000 after the fee. This calculator does not model fees; you can approximate by increasing your target monthly payment proportionally, but the exact effect depends on how the fee is structured.

How do I find the monthly payment if I already know the loan amount?

Use the standard formula: M = P × r × (1 + r)^n / ((1 + r)^n − 1). For example, a $25,000 loan at 6% APR for 4 years (48 months) gives r = 0.005, n = 48, and M ≈ $587.13. Most loan calculators on this site can do that directly.

Is it better to choose a longer term to lower the payment?

Lowering the payment by extending the term increases the total interest you pay. For a $20,000 loan at 8% APR, a 5-year term costs $405.53 per month and $4,331.80 total interest; a 10-year term costs $242.66 per month but $9,119.20 total interest—more than double. The right choice depends on your budget and how much interest you are willing to pay over time.

What does “Cannot compute” mean in the calculator?

It means the monthly payment you entered is less than the monthly interest on the loan. For example, at 12% APR, the monthly interest on $10,000 is $100. If you enter a payment of $90, the interest alone exceeds your payment, so the balance would grow forever and the loan would never be paid off. You need to either increase the payment or lower the interest rate.

Does this work for mortgages, auto loans, and personal loans?

Yes, the math is the same for any fixed-rate, fully amortizing loan. The calculator does not include property taxes, insurance, or PMI, which are common for mortgages, so for a mortgage you should subtract those from your monthly budget before entering the payment. For auto loans, you might also need to account for sales tax and fees that are financed.

This result is an estimate based on the inputs you provide; your lender’s loan disclosure will show the exact figures, including any fees and charges.

Related

Formula used
in pmt | Monthly payment you can afford | $ | 500 | 1 | 10000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out p | Loan amount | $ | pmt * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / (apr / 1200) | 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 →