This calculator estimates the loan amount you may qualify for based on your monthly payment budget, interest rate, and loan term. You enter the payment you can afford, the APR, and the term in years; the calculator returns the maximum principal loan amount and the total interest paid over the life of the loan.
Formula
The calculator uses the standard present-value annuity formula, rearranged to solve for the principal (P) given a fixed monthly payment (M), monthly interest rate (r), and number of payments (n):
P = M × (1 − (1 + r)^(−n)) / r
- P = loan principal (the amount you borrow), in dollars
- M = monthly payment, in dollars
- r = monthly interest rate = APR / 1200 (APR in percent per year)
- n = total number of monthly payments = term in years × 12
This is the inverse of the standard loan payment formula. Instead of asking “what is my payment for a given loan amount?”, it asks “what loan amount can I borrow if I pay a fixed amount each month?”
Worked Example
Using the default values: monthly payment = $500, APR = 8%, term = 5 years.
- Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
- Calculate number of payments: n = 5 × 12 = 60
- Compute (1 + r)^(−n) = (1.0066667)^(−60) ≈ 0.671216
- Subtract from 1: 1 − 0.671216 = 0.328784
- Divide by r: 0.328784 / 0.0066667 ≈ 49.3176
- Multiply by 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. The total interest paid would be $500 × 60 − $24,658.80 = $5,341.20.
Assumptions
- Fixed interest rate for the entire term (no adjustable rates).
- Payments are made at the end of each month (ordinary annuity).
- Interest compounds monthly at APR/12.
- The payment amount is level (same every month).
- This does not include origination fees, closing costs, taxes, insurance, PMI, or any other charges that could reduce the actual amount you receive or increase your total cost.
How to Use This Calculator in Real Life
Start with a monthly payment figure that fits your budget. That number should come from your income, expenses, and other debts—not from what a lender advertises. Then choose an interest rate that reflects current market conditions for your credit profile and loan type. You can get a realistic rate estimate from a lender’s website or by asking for a quote; the calculator treats the rate as an input, so you can also test different rates to see how they change the loan amount.
The result is the maximum principal you could borrow under those exact assumptions. In practice, lenders also look at your debt-to-income ratio, credit history, and the value of collateral (for secured loans like auto or home loans). This calculator only models the mathematical relationship between payment, rate, and term.
Common Mistakes and Misconceptions
- Confusing APR with monthly rate: Always divide the APR by 1200 to get the monthly rate. Using 8% directly instead of 0.6667% per month will massively overstate the payment.
- Ignoring fees: If a loan has a 2% origination fee, you might receive $24,658 but owe $25,160. The calculator shows the principal, not the total amount you pay upfront.
- Assuming the rate stays the same: For adjustable-rate loans, the payment can change. This calculator only works for fixed-rate loans.
- Thinking the loan amount is what you can “afford”: The calculator shows what a given payment supports, not what a lender will approve. Your credit score, employment history, and other debts matter.
When to Use This Instead of a Payment Calculator
Use a loan payment calculator when you know the loan amount and want the payment. Use this qualification calculator when you have a target payment in mind and want to know how much you can borrow. For example, if you want to keep your car payment under $400 and you see a car priced at $25,000, you can check whether that price fits your payment target at a given rate and term.
This is also useful for comparing term lengths. A 5-year loan at $500 per month gives a larger principal than a 3-year loan at the same payment, because you have more months to repay. But the longer term also means more total interest, as shown in the output.
Limits of the Formula
The formula assumes the payment is constant and the rate never changes. It does not account for:
- Balloon payments or interest-only periods
- Prepayment penalties or extra payments
- Variable rates that reset
- Fees that are rolled into the loan
- Minimum income requirements or maximum debt-to-income ratios set by lenders
For secured loans, the loan amount may also be capped by the value of the collateral (e.g., you can’t borrow more than the car is worth for an auto loan). This calculator gives a mathematical ceiling, not a lender’s approval limit.
Frequently Asked Questions
What is a good debt-to-income ratio for a loan?
Many lenders prefer a total debt-to-income ratio (including the new loan payment) below 36% to 43%, but this varies by loan type and lender. This calculator does not include DTI; you would need to compare the proposed payment to your gross monthly income and other debts separately.
Does the calculator include taxes and insurance?
No. For a mortgage, property taxes, homeowners insurance, and PMI are often added to the monthly payment, but they are not part of the loan principal. You would need to subtract those from your budgeted monthly payment before entering it here.
Can I use this for an auto loan?
Yes, for a fixed-rate auto loan. Just enter your desired monthly payment, the APR you expect, and the term in years. The result is the maximum vehicle price you could finance (before down payment and fees). Remember that the loan amount cannot exceed the car’s value in most cases.
What if I make extra payments?
Extra payments reduce the principal faster and shorten the loan term, but this calculator assumes level payments for the full term. If you plan to make extra payments, the actual loan amount you could borrow might be higher because you could afford a larger payment, but the formula would need to be adjusted.
Why does the result show “Cannot compute”?
This happens if the monthly payment is too low to cover the interest on any loan amount at that rate. For example, at 8% APR, a $1 monthly payment cannot cover the interest on even a $1 loan because the interest exceeds the payment. Increase the payment or lower the rate.
The result is an estimate based on the inputs you provide; the lender’s disclosure will give the exact figures for any loan you are offered.
Related
Formula used
in pmt | Monthly payment you can afford | $ | 500 | 1 | 100000000 in apr | Interest rate (APR) | % | 8 | 0.01 | 100 in yrs | Loan term | years | 5 | 0.0833 | 50 out p | Loan amount you qualify for | $ | pmt * (1 - (1 + apr / 1200) ^ -(yrs * 12)) / (apr / 1200) | 2 out int | Total interest paid | $ | 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
- 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