Bank Rate Installment Loan Calculator and Payment Formula

A bank rate installment loan calculator estimates your fixed monthly payment and total interest from the loan amount, annual percentage rate (APR), and repayment term. Enter the figures from a lender’s loan offer to see an arithmetic estimate; the result does not include fees or determine approval.

Formula

The calculator uses the standard fixed-payment amortization formula. It converts the annual APR to a monthly rate, then calculates the payment that would repay the principal and interest in equal monthly installments:

• Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]
• Total interest: I = (M × n) − P

Here, P is the amount borrowed in dollars; APR is the annual percentage rate entered as a percentage; r is the monthly rate, APR ÷ 1200; n is the number of monthly payments, loan term in years × 12; M is the unrounded formula payment before display rounding; and I is estimated total interest in dollars. The calculator displays the monthly payment and interest to two decimal places.

Worked Example

Using the default inputs—$20,000 borrowed, 8% APR, and five years—the calculation is:

1. Convert the APR to a monthly rate: 8 ÷ 1200 = 0.0066667, or about 0.66667% per month.
2. Convert the term to payments: 5 × 12 = 60 months.
3. Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)⁻⁶⁰] = $405.53 per month, rounded to cents.
4. Estimate interest using the displayed monthly payment: ($405.53 × 60) − $20,000 = $4,331.80.

The estimated payment is $405.53 per month, and estimated total interest is $4,331.80. Because the payment is rounded to cents while the underlying amortization may use more precise amounts, a real final payment can differ slightly.

Assumptions

• The APR stays fixed for the full term.
• Payments are equal monthly installments, made at the end of each monthly period.
• Interest accrues monthly using APR ÷ 12; this is a simplified calculation, not a lender’s daily-balance schedule.
• Fees, taxes, insurance, optional products, and other charges are not included.

What the Calculator Tells You

An installment loan is repaid through scheduled payments over a stated term. With a fixed rate and level payments, each payment covers interest accrued since the previous payment and reduces the remaining principal. Early in repayment, the interest portion is generally larger because the outstanding balance is higher; as principal falls, the interest portion usually declines.

The monthly payment is a useful way to understand the payment implied by the three inputs, while total interest estimates the cost of borrowing under the calculator’s assumptions. Neither figure is the complete amount you may pay. For example, an origination charge might be deducted from funds disbursed or added to the amount financed, depending on the contract. The calculator does not model either treatment.

Use the APR and amount that apply to the actual offer rather than relying on the default example. Ask the lender for the payment schedule and written disclosure if you need the precise amount, due dates, fees, or total repayment figure. An advertised or preliminary figure may not match the final loan terms.

Choosing Inputs and Interpreting Results

• Loan amount: Enter the principal amount being financed, not the total cost of a purchase unless that is also the amount borrowed. If a fee is financed, the lender’s stated financed balance may differ from the cash price.
• APR: Enter the annual APR as a percentage, so 8% is entered as 8, not 0.08. Obtain the applicable APR and its definition from the lender; do not substitute an unrelated advertised rate.
• Term: Enter years. A longer term generally produces a lower scheduled payment for the same principal and rate, but more payment periods can mean more total interest. This is a mathematical relationship, not a recommendation.

For a comparison to be meaningful, keep the loan amount and repayment assumptions consistent and change only the factor you are examining. If you compare two offers, check whether their fees, rate type, payment frequency, and financed amounts are handled the same way. This calculator does not account for variable rates, payment holidays, late payments, or extra principal payments.

Common Questions About Installment Loan Estimates

A common misconception is that APR and the interest rate are always interchangeable. APR is a lender-disclosed annual measure that may reflect certain borrowing costs under the lender’s calculation, while the calculator applies APR directly as a nominal annual rate divided by 12. It cannot reproduce every method used to calculate a disclosed APR or a contract’s balance.

Another source of mismatch is rounding. This calculator rounds the displayed payment to cents and uses that displayed value to estimate total interest. A lender may carry additional precision internally, use daily interest accrual, or adjust the final installment. Therefore, treat small differences as possible rather than assuming an error.

Before relying on a result, verify that the term is in years, the rate is entered as a percentage, and the amount is the principal being repaid. A rate of 8 entered as 0.08 would represent 0.08%, not 8%, and would produce a substantially different estimate.

Frequently Asked Questions

How do I calculate a monthly installment loan payment?
Convert APR to a monthly rate by dividing it by 1,200, convert the term to months, and use the fixed-payment formula shown above. This calculator performs those steps for you.

Does the result include loan fees?
No. The calculator uses the principal, APR, and term only. Check the lender’s disclosure for fees and whether any fee is paid separately or included in the financed amount.

Why is my lender’s payment different?
The contract may use a different balance, fee treatment, payment date, rounding method, or interest-accrual schedule. Compare the inputs and ask the lender for its payment schedule.

Does a longer loan term reduce total interest?
Not necessarily. For the same principal and fixed rate, a longer term generally lowers each scheduled payment but adds payment periods, which can increase total interest.

Can I use this for a variable-rate loan?
It can show a hypothetical payment if you enter one rate, but it assumes that rate remains fixed throughout the term. It cannot forecast payment changes on a variable-rate loan.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Google Sheets Accrued Interest Formula and Calculator
• Accrued Interest Paid: How to Report It
• Google Sheets Accrued Interest Bond Calculator

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