This calculator works out the loan amount you can borrow based on a target monthly payment, interest rate, and loan term. Enter the payment you can afford, the APR, and the term in years, and you get the maximum principal loan amount and the total interest you would pay. Use it to see how much a given monthly budget supports before you talk to a lender.
Formula
The loan amount is the present value of a series of equal monthly payments, discounted at the monthly interest rate. The formula is:
Loan Amount = P × (1 − (1 + r)^(−n)) / r
Where:
- P = monthly payment (in dollars)
- r = monthly interest rate = APR / 1200 (APR in percent per year, divided by 100 to get a decimal, then divided by 12)
- n = total number of payments = loan term in years × 12
This is the standard present-value formula for an ordinary annuity. It assumes payments are made at the end of each month, and the interest rate is fixed for the entire term.
Worked Example
Using the default values from the calculator: monthly payment $500, APR 8%, term 5 years.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Total number of payments: n = 5 × 12 = 60
- Compute (1 + r)^(−n) = (1.0066667)^(−60) ≈ 0.67121
- Compute 1 − 0.67121 = 0.32879
- Divide by r: 0.32879 / 0.0066667 ≈ 49.3185
- Multiply by payment: 500 × 49.3185 ≈ $24,659.25
So with a $500 monthly payment, 8% APR, and 5-year term, the loan amount is about $24,659.25.
Total paid over the term = 500 × 60 = $30,000. Total interest = $30,000 − $24,659.25 = $5,340.75.
Assumptions
- Fixed interest rate for the entire loan term.
- Payments are made at the end of each month (ordinary annuity).
- Interest is compounded monthly at APR / 12.
- No fees, taxes, insurance, or other costs are included.
- The payment amount is level (same every month).
These are standard assumptions for amortizing loans like auto loans, personal loans, and many mortgages.
When to Use This Calculation
This is useful when you have a fixed monthly budget and want to know the maximum principal you can borrow. It is the reverse of the standard loan payment formula, which computes the payment from the loan amount. You might use it when:
- Comparing loan offers with different rates and terms.
- Planning a purchase (car, home improvement) and setting a budget.
- Understanding how changes in rate or term affect how much you can borrow.
Remember the result is the principal only—it does not include down payment, closing costs, or fees. Your actual loan amount may be lower if fees are rolled in.
How to Choose Your Inputs
To get a realistic estimate, use the actual APR you expect from a lender, not a guess. For a car loan, the term is often 3–7 years; for a personal loan, 1–7 years; for a mortgage, 15 or 30 years. The monthly payment should be what you can comfortably afford, but the calculator does not judge affordability—it only does the math.
If you are pre-qualified, use the APR from that quote. If not, you can run several scenarios to see the range. The result is an estimate; the lender’s exact numbers will depend on your credit, income, and the specific loan product.
Common Mistakes and Misconceptions
A frequent error is using the annual rate directly instead of dividing by 12. For example, using 8 instead of 0.0066667 in the formula will give a wildly wrong result. Always convert APR to a monthly decimal.
Another mistake is confusing the payment amount with the total cost. The monthly payment is only part of the picture—total interest can be large, especially with long terms. Also, some people think that a lower payment always means a better deal, but a longer term increases total interest even if the payment is lower.
Finally, this formula assumes the payment is exactly level. Some loans have balloon payments or adjustable rates, which this calculation does not model.
How This Differs from Payment Calculators
A standard loan payment calculator takes the loan amount, rate, and term and gives the payment. This calculator does the opposite: it takes the payment, rate, and term and gives the loan amount. Both use the same underlying formula, just rearranged. If you already know the loan amount, use the payment calculator; if you know your budget, use this one.
There is also the concept of a debt-to-income ratio, which lenders use to decide how much you can borrow. That is a separate calculation that includes your gross income and other debts. This calculator does not consider income or other obligations.
Limits of the Formula
The formula works only for fixed-rate, fully amortizing loans with equal payments. It does not apply to interest-only loans, balloon payments, or loans with variable rates. It also assumes that the payment is at least enough to cover the monthly interest; otherwise, the loan balance would grow, and the formula would give a negative or meaningless result. In the calculator, if the payment is too low relative to the rate and term, you may see a “Cannot compute” message, which is correct.
Additionally, the result is rounded to the nearest cent, but in reality, lenders may round payments up or down, and the final payment may differ slightly. The total interest shown is based on the exact loan amount, but actual amortization may vary by a few cents.
Frequently Asked Questions
How do I find the loan amount if I know the payment and APR?
You use the present value formula: Loan Amount = Payment × (1 − (1 + r)^(−n)) / r, where r is the monthly rate (APR/1200) and n is the number of months. This calculator does that automatically.
Does this include taxes and insurance?
No. The calculator only considers principal and interest. For a mortgage, property taxes, homeowners insurance, and PMI are additional costs that would increase your actual monthly payment. Those are not included in the payment input.
What if I want to include a down payment?
The loan amount is the principal you borrow, not the purchase price. If you have a down payment, subtract it from the purchase price to get the loan amount. This calculator gives you the maximum loan amount, so your down payment is the difference between the price and that amount.
Can I use this for a car loan?
Yes, car loans are typically fixed-rate and fully amortizing, so this formula applies. Just enter the monthly payment you can afford, the APR from the dealer or bank, and the term in years (often 3–7).
Why does the result show ‘Cannot compute’?
This happens when the monthly payment is not enough to cover the monthly interest on any loan amount. For example, with a very high rate and a very low payment, the formula tries to take the logarithm of a negative number. It means the payment is too low for the given rate and term—you would need a higher payment or a lower rate.
Is this the same as what a lender will offer?
No. Lenders consider your credit score, income, debt-to-income ratio, and other factors. The calculator gives a mathematical estimate based only on the inputs you provide. Your actual approved amount may be different. The result is an estimate, and the lender’s disclosure gives the exact figures.
Related
Formula used
in p | Monthly payment | $ | 500 | 1 | 1000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out loan | Loan amount | $ | p * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / (apr / 1200) | 2 out int | Total interest | $ | p * yrs * 12 - loan | 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
- JS Bank Credit Card: Features & How to Apply$405.53
- JD Gift Card Balance: How to Check It$60.00
- JD Bank Credit Card: How It Works & What to Know$405.53
- In-N-Out Gift Card Balance: Check & Use Guide$30.00
- JCPenney Credit Card Balance: How to Check It27 months
- Houston Metro Q Card Balance: Check & Add Funds$35.00