Interest Rate Table Calculator and Loan Payment Formula

An interest rate table calculator shows how a fixed annual percentage rate and loan term affect a level monthly payment and total interest. Enter the loan amount, APR, and term to estimate those amounts; this calculator uses a standard fixed-rate amortization formula, not a table of current lender offers.

Formula

The monthly payment is the amount that, paid at the end of each month, repays the starting balance plus interest over the selected number of months:

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

Here, P is the amount borrowed in dollars, r = APR / 1200 is the monthly interest rate as a decimal, and n = years × 12 is the number of monthly payments. APR is entered as a percentage per year. The total interest estimate is PMT × n − P, using the displayed monthly payment rounded to cents. This is a standard amortizing-loan calculation; it is not a lookup of market rates.

Worked Example

Using the calculator’s defaults—$20,000 borrowed, 8% APR, and a five-year term:

• Convert the APR to a monthly decimal rate: r = 8 / 1200 = 0.0066667.
• Convert the term to payments: n = 5 × 12 = 60.
• Substitute: PMT = 20000 × 0.0066667 / (1 − (1 + 0.0066667)−60).
• The monthly payment is approximately $405.53, rounded to the nearest cent.
• Total payments are $405.53 × 60 = $24,331.80; estimated total interest is $24,331.80 − $20,000 = $4,331.80.

The results are estimates for the stated assumptions. A lender’s schedule can differ if its payment amount, timing, rate calculation, or included charges differ.

Assumptions

• The interest rate stays fixed for the entire term.
• Payments are equal and made monthly, at the end of each monthly period.
• Interest accrues monthly using the APR divided by 12.
• The calculation excludes fees, taxes, insurance, PMI, escrow, and any optional add-ons.
• The total-interest figure uses the monthly payment rounded to cents; actual final payments may be adjusted to clear a remaining balance.

What an Interest Rate Table Shows

An interest rate table usually organizes loan estimates by rate, term, or both. A printed table might show a monthly payment per $1,000 borrowed, while an online calculator can compute a payment for a specific principal. Either way, the result depends on more than the rate: the amount financed, repayment period, and payment schedule also matter.

For example, a longer term generally spreads repayment across more months, which can lower the scheduled payment while increasing the number of months on which interest accrues. A higher APR raises the payment and, all else equal, the interest paid over the same term. These relationships describe the formula; they do not indicate what rate a particular person will receive. Obtain the applicable rate, fees, and repayment terms directly from the lender’s loan disclosure.

How to Use the Estimate

1. Enter the principal—the amount being financed, not necessarily the advertised price. If charges are added to the loan, confirm whether they are included in the amount financed.
2. Enter the annual APR as a percentage. For example, enter 8 for 8%, not 0.08.
3. Enter the term in years. The calculator converts it to monthly payments.
4. Read the monthly payment first, then the total interest. The latter is the estimated cost of interest over all scheduled payments under the assumptions above.

Use the same principal, APR convention, and term when comparing your own scenarios. If an offer provides a payment but not a rate, this calculator cannot reliably infer the rate without additional information such as exact payment count and treatment of upfront charges.

Tables, APR, and Common Pitfalls

APR and an interest rate are related but are not always interchangeable in real loan disclosures. APR may reflect certain borrowing costs in addition to the stated interest rate, depending on the loan and disclosure method. This calculator treats the entered APR as a nominal annual rate divided by 12. It does not separately model fees or reproduce every regulatory APR calculation. For a precise comparison, use the lender’s disclosed payment schedule and cost figures.

• Percent entry: Entering 0.08 to mean 8% makes the estimate dramatically too small; the input expects 8.
• Term units: The term field is years. A five-year term means 60 monthly payments, not five payments.
• Rounding: The payment is rounded to cents before total interest is calculated. A real schedule may use unrounded internal amounts and adjust its final payment.
• Variable rates: A changing rate does not fit a single fixed-rate payment formula. The estimate cannot forecast future rate changes or resulting payment adjustments.
• Extra payments: Additional principal payments can change the payoff date and interest, but they are not included here.

A table can be useful for a quick illustration, but it is not an offer or a guarantee. The actual amount due can also depend on payment dates, fees, and contract terms not represented by these three inputs.

Frequently Asked Questions

What is an interest rate table?
An interest rate table is a presentation of borrowing costs or payment estimates organized by interest rate, loan amount, term, or another factor. The exact figures and assumptions depend on the table’s source.

How do I calculate a monthly loan payment from an interest rate?
Convert the annual percentage rate to a monthly decimal by dividing it by 1,200, convert years to months, and apply the amortizing-payment formula shown above. This calculator performs those steps.

Is the interest rate the same as APR?
Not necessarily. A stated interest rate describes the rate used to calculate interest, while APR can incorporate certain borrowing costs under applicable disclosure methods. Check the lender’s documents to understand the figures shown.

Does a lower monthly payment mean less interest overall?
No. A lower payment can result from a longer repayment term, which may mean more total interest. Compare the term and total cost as well as the monthly amount.

Can this calculator show a variable-rate loan’s future payment?
No. It assumes the entered rate remains fixed for the full term. Future payments on a variable-rate loan depend on rate changes and contract terms that are not entered here.

The result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Japan Interest Rate: How the BOJ Rate Works
• Interest Rate Index: Meaning, Uses, and Loan Calculator
• VA Loan Interest Rate Calculator and Payment Guide

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