calculate-loan

01 Loan payments

Aer Loan Budget: How to Calculate Your Monthly Payment

Calculator No. 01-25467 · 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.

An AER loan budget calculator works out your monthly payment and total interest for a loan when the interest is quoted as an Annual Equivalent Rate (AER). You enter the loan amount, the AER, and the term in years, and you get back the level monthly payment and the total interest paid over the life of the loan.

Formula

The calculator uses the standard level-payment amortization formula, adapted for an AER input. The monthly payment M is:

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

where:

  • P = loan amount (the principal, in dollars)
  • r = monthly interest rate = AER ÷ 12 ÷ 100 (as a decimal, e.g. 8% → 0.08/12 = 0.0066667)
  • n = total number of monthly payments = term in years × 12

The total interest is simply the monthly payment times the number of payments, minus the original loan amount:

Total interest = M × n − P

This is the same formula used for any fixed-rate installment loan—car loans, personal loans, student loans, and mortgages—when the quoted rate is an annual percentage rate (APR). The only difference here is that the input is labeled AER, which is the annual rate that includes the effect of compounding. For a loan with monthly compounding, the AER is exactly the APR divided by 12 for the monthly rate, so the formula is identical.

Worked Example

Using the default values from the calculator: loan amount $20,000, AER 8%, term 5 years.

  1. Convert AER to monthly rate: r = 8 ÷ 100 ÷ 12 = 0.0066667
  2. Number of payments: n = 5 × 12 = 60
  3. Calculate (1 + r)−n = (1.0066667)−60 ≈ 0.67121
  4. Denominator: 1 − 0.67121 = 0.32879
  5. Payment: 20000 × (0.0066667 / 0.32879) = 20000 × 0.020276 = 405.52
  6. Total paid: 405.52 × 60 = 24,331.20
  7. Total interest: 24,331.20 − 20,000 = 4,331.20

The calculator shows a monthly payment of $405.52 and total interest of $4,331.20, matching the step-by-step result.

Assumptions

  • Fixed interest rate for the entire term (no rate changes).
  • Payments are made monthly, at the end of each month, starting one month after the loan is taken out.
  • Interest compounds monthly at the AER divided by 12.
  • The loan is fully amortized—each payment covers interest plus a portion of principal, and the balance reaches zero after the final payment.
  • No fees, origination charges, prepayment penalties, taxes, or insurance are included. If any of those apply, they will change the true cost.

How to Use the Result

The monthly payment figure is what you would pay each month if you borrowed the exact amount at the given rate and term. It helps you compare different loan offers side by side: a lower payment may come with a longer term, which usually means more total interest. For example, a 5-year loan at 8% on $20,000 costs $405.52 per month and $4,331.20 in interest. The same loan over 3 years would have a higher monthly payment (around $626.73) but much lower total interest (around $2,562.28).

When you see a loan advertised with a low monthly payment, check the term. Extending the term reduces the payment but increases the total interest. Use the calculator to see the trade-off before you commit.

Also remember that the AER is the annual rate that reflects compounding, so it is usually higher than the nominal annual rate (APR) if compounding happens more often than annually. For a loan with monthly compounding, the AER is calculated as (1 + APR/12)^12 − 1. If a lender quotes an AER of 8%, the monthly rate is not 8%/12; it is the rate that, when compounded monthly, gives an effective annual rate of 8%. That monthly rate is (1.08)^(1/12) − 1 ≈ 0.006434, slightly lower than 0.006667. The calculator here simplifies by using the AER directly as the APR in the formula, which is a common approximation. For most consumer loans, the difference is small, but for a precise quote, ask the lender for the monthly rate or the APR.

Common Mistakes

  • Using the AER as if it were a simple annual rate without converting to monthly. The formula requires a monthly rate; dividing the AER by 12 is correct only if the AER equals the APR, which is usually the case for loans with monthly compounding.
  • Forgetting to convert years to months. If you enter 5 years but use 5 as the number of payments, the result will be wildly wrong.
  • Rounding the monthly rate too early. Keep several decimal places during calculation, then round the final payment to the nearest cent.
  • Ignoring fees. A loan with a 7% AER but a $500 origination fee costs more than a loan with an 8% AER and no fee. The calculator does not include fees, so add them separately or ask the lender for the APR that includes them.
  • Confusing AER with APR. AER is the effective annual rate after compounding; APR is the annualized rate that may or may not include fees. For loans, the APR is often the more useful number for comparing costs, but the AER is what appears in many European and international contexts.

When to Use This Calculator

Use this calculator when you have a loan offer that states the interest rate as an AER and you want to know the monthly payment and total interest. It is appropriate for fixed-rate personal loans, car loans, and some student loans where the rate does not change. It is not appropriate for variable-rate loans, credit cards with revolving balances, or loans with balloon payments or interest-only periods. For those, you need a different calculation.

If you are comparing loans with different terms, use the calculator to find the monthly payment for each, then multiply by the number of months to find the total cost. The loan with the lower total interest is not always the better choice if the monthly payment is too high for your budget. The calculator gives you the numbers; you decide what fits your cash flow.

Limits of the Formula

The formula assumes a level payment every month for the entire term. Real loans may have first payments that are higher or lower due to odd first periods, or they may allow extra payments that reduce the balance faster. The formula does not handle those. It also assumes the interest rate is fixed; if the rate changes, the payment will change at each adjustment. Finally, the result is an estimate based on the inputs you provide. Lenders may round payments differently or include fees that change the total. Always check the lender’s disclosure statement for the exact payment and total cost.

Frequently Asked Questions

What is the difference between AER and APR?

AER (Annual Equivalent Rate) shows the effective annual interest rate after compounding is taken into account. APR (Annual Percentage Rate) is a broader measure that often includes fees and other costs, expressed as an annual rate. For a loan with no fees and monthly compounding, the APR and AER are the same. When fees are present, APR is typically higher than the nominal rate and is a better tool for comparing true costs.

How do I convert AER to a monthly interest rate?

If the AER is the effective annual rate, the monthly rate is (1 + AER)^(1/12) − 1. For example, 8% AER gives a monthly rate of (1.08)^(0.08333) − 1 ≈ 0.006434, or 0.6434% per month. Many loan calculators and lenders use the simpler APR/12 approach, which is accurate when the APR is the nominal rate with monthly compounding. Check which method your lender uses.

Does the calculator include taxes and insurance?

No. The calculator only computes the principal and interest portion of the payment. Property taxes, homeowners insurance, private mortgage insurance (PMI), or other escrow items are not included. If your loan requires escrow, add those monthly amounts to the payment to get your true monthly obligation.

What happens if I make extra payments?

Extra payments reduce the principal faster, which means you pay less interest over the life of the loan and may finish early. The calculator does not model extra payments. To see the effect, use a separate extra-payment calculator or recalculate with a shorter term that reflects the faster payoff.

Is a longer loan term better because the payment is lower?

A longer term lowers the monthly payment but increases the total interest paid. For example, a $20,000 loan at 8% over 5 years costs $405.52 per month and $4,331.20 in interest. Over 7 years, the payment drops to about $311.62, but the total interest rises to about $6,176.08. The right choice depends on your budget and how much you are willing to pay over time.

This result is an estimate for educational purposes; the lender’s disclosure gives the exact figures for any specific loan offer.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (AER) | % | 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 →