This calculator estimates the loan amount you can borrow based on your monthly payment capacity, the Annual Equivalent Rate (AER), and the loan term. You enter your desired monthly payment, the AER, and the term in years, and the calculator returns the maximum principal loan amount you could borrow under those assumptions, along with the total interest you would pay.
Formula
The loan amount is the present value of a series of equal monthly payments, discounted at the monthly interest rate derived from the AER. The formula is:
P = PMT × (1 − (1 + r)^(−n)) / r
Where:
- P = loan amount (principal) in dollars
- PMT = monthly payment in dollars
- r = monthly interest rate = AER / 12 / 100 (as a decimal)
- n = total number of monthly payments = years × 12
This is the standard present value of an annuity formula. It assumes that payments are made at the end of each month (ordinary annuity) and that the interest rate is constant over the entire term.
Worked Example
Using the default values from the calculator:
- Monthly payment (PMT) = $500
- AER = 8% per year
- Term = 5 years
First, convert the AER to a monthly rate: r = 8 / 100 / 12 = 0.0066667.
Next, find the total number of payments: n = 5 × 12 = 60.
Now apply the formula:
P = 500 × (1 − (1 + 0.0066667)^(−60)) / 0.0066667
Calculate (1 + 0.0066667)^(−60) ≈ 0.671216.
Then 1 − 0.671216 = 0.328784.
Divide by r: 0.328784 / 0.0066667 ≈ 49.3176.
Multiply by PMT: 500 × 49.3176 ≈ $24,658.80.
So the loan amount is approximately $24,658.80.
Total paid over the term: $500 × 60 = $30,000. Total interest = $30,000 − $24,658.80 = $5,341.20.
Assumptions
- The interest rate (AER) is fixed for the entire loan term.
- Payments are made at the end of each month (standard for most loans).
- Interest compounds monthly at a rate of AER / 12.
- The calculation does not include any fees, charges, taxes, or insurance that might be added to the loan.
- The AER is used as the nominal annual rate; if the lender quotes a different type of rate (e.g., APR with fees), the result may differ.
What Does AER Mean in Loan Context?
AER stands for Annual Equivalent Rate. It is often used for savings accounts to show the annual interest with compounding. For loans, lenders may quote an AER to reflect the true annual cost of borrowing, including the effect of monthly compounding. However, be aware that some lenders use APR (Annual Percentage Rate) which may include fees and other costs. When you enter an AER into this calculator, you are assuming that the rate is the nominal annual rate and that interest is compounded monthly. If the lender gives you a different rate type, ask for the nominal annual rate to use here.
How to Use This Calculator
This calculator is useful for reverse budgeting: you decide what monthly payment fits your budget, and the calculator tells you the maximum loan amount you could borrow at a given rate and term. To use it:
- Enter your comfortable monthly payment (the amount you can realistically afford after other expenses).
- Enter the interest rate (AER) quoted by the lender or the rate you expect to be offered.
- Enter the loan term in years (e.g., 3, 5, 10).
- The calculator shows the loan amount and total interest.
For example, if you can pay $500 per month at 8% AER for 5 years, you can borrow about $24,659. If you extend the term to 10 years, the loan amount rises (because you have more payments) but the total interest also increases. Try different combinations to see how the term and rate affect the amount.
Common Mistakes and Misconceptions
- Mixing up AER and APR: AER is typically the annual rate with compounding, while APR includes fees. Using APR directly in this formula may overstate the loan amount if fees are significant.
- Forgetting to convert the rate: The formula requires the monthly rate (AER/12/100). If you enter the annual rate directly without dividing by 12, the result will be wildly wrong.
- Ignoring fees and charges: The calculator only covers principal and interest. If the lender charges origination fees, they reduce the amount you actually receive.
- Assuming the rate is fixed: If the loan has a variable rate, the loan amount you can borrow may change over time.
- Rounding too early: In the worked example, rounding the monthly rate to 0.0067 changes the result slightly. Use the full precision in your calculations.
Factors That Affect Your Actual Loan Amount
While this calculator gives a theoretical maximum based on the inputs, lenders consider many other factors when approving a loan:
- Your credit score and credit history
- Your debt-to-income ratio (DTI)
- Your employment history and income stability
- The loan-to-value ratio if it’s a secured loan (like a mortgage)
- The lender’s specific underwriting criteria
- Any co-signer or collateral you provide
These factors can increase or decrease the loan amount you’re actually offered. The calculator’s result is an estimate based only on the payment, rate, and term.
Frequently Asked Questions
What is the difference between AER and APR for a loan?
AER (Annual Equivalent Rate) is the annual rate that accounts for compounding, typically used for savings but also seen on loans. APR (Annual Percentage Rate) includes the nominal interest rate plus any fees and charges, giving a more complete cost of borrowing. For the same loan, APR is usually higher than AER if fees are present.
Can I use this calculator for any type of loan?
Yes, the formula works for any fixed-rate amortizing loan where you make equal monthly payments, such as personal loans, auto loans, student loans, and mortgages. It does not apply to interest-only loans, balloon payments, or credit cards with revolving balances.
What if I don’t know the AER, but I know the APR?
If you only have the APR, you can approximate the AER by using the APR as the rate, but remember that APR includes fees, so the loan amount will be slightly overestimated. For a more accurate result, ask the lender for the nominal annual interest rate.
Why does the loan amount increase when I extend the term?
Because you are making more payments over a longer period, the total amount repaid increases, and the present value of those payments is higher. However, you also pay more total interest, so the cost of borrowing is higher.
Does the calculator include taxes or insurance?
No, it only calculates principal and interest. For a mortgage, property taxes and homeowners insurance are usually escrowed and added to the monthly payment, which would reduce the amount available for principal and interest.
What is a good monthly payment to use?
A common guideline is that your total monthly debt payments (including this loan) should not exceed about 36% of your gross monthly income, but that’s a rule of thumb, not a guarantee. Use a number that fits your budget after essential expenses and savings.
The result from this calculator is an estimate based on the inputs you provide; the exact loan amount and terms will be stated in the lender’s official disclosure.
Related
Formula used
in pmt | Monthly payment you can afford | $ | 500 | 1 | 100000000 in apr | Interest rate (AER) | % | 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
- 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