Bank Loan Repayment Schedule Calculator and Guide

A bank loan repayment schedule shows each payment’s due date, amount, interest charge, principal reduction, and remaining balance. Enter the loan amount, annual interest rate, and term below to estimate the monthly payment and total interest for a fixed-rate loan with monthly payments.

Formula

For a fixed-rate loan repaid in equal monthly installments, the payment is calculated using the amortization formula:

Payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the starting loan principal, in dollars.
• r is the monthly interest rate as a decimal: annual APR ÷ 12 ÷ 100.
• n is the number of monthly payments: loan term in years × 12.

The calculator rounds the monthly payment to the nearest cent. Estimated total interest is the rounded payment multiplied by the number of payments, minus the original principal. These figures describe the standard level-payment calculation; they do not create a lender’s contractual schedule.

Worked Example

Using the default inputs—$20,000 principal, 8% annual APR, and a five-year term—the loan has 60 monthly payments. The monthly rate is 8 ÷ 1,200 = 0.0066667.

Payment = 20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)⁻⁶⁰] = $405.53 per month, rounded to the nearest cent.

Estimated total paid = $405.53 × 60 = $24,331.80. Estimated total interest = $24,331.80 − $20,000 = $4,331.80. The first month’s estimated interest is $20,000 × 0.0066667 = $133.33; the remaining $272.20 of that payment reduces principal. Later payments generally contain less interest as the balance falls.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12.
• The estimate excludes fees, taxes, insurance, PMI, escrow, late charges, and any optional add-ons.

How a Repayment Schedule Works

A repayment schedule, often called an amortization schedule, breaks a loan into payment-by-payment accounting. Each installment is divided between interest due for that period and principal. The interest portion is calculated from the outstanding balance; the principal portion is what remains after interest is accounted for. Subtracting that principal portion from the prior balance gives the next estimated balance.

With a level payment and fixed rate, the interest portion is usually largest at the beginning because the balance is largest then. As principal is repaid, interest charges decline, so more of each later payment goes toward principal. The payment itself can remain unchanged even though its components shift. A schedule may also show a final payment adjusted slightly for rounding or the lender’s day-count method.

For example, in the calculator’s first payment, about $133.33 goes to interest and $272.20 to principal. The new estimated balance is $19,727.80. The next interest charge is calculated on that lower balance, rather than on the original $20,000.

What a Lender’s Schedule May Include

A lender’s official schedule is based on the signed loan terms and the actual dates and amounts posted. It may differ from a simple estimate for reasons such as payment dates, daily interest calculations, fees included in the financed balance, or a rate that can change. Some loans also have irregular payment structures, deferred payments, a balloon balance, or separate charges that are not principal-and-interest installments.

Check the loan disclosure or servicing statement for the amount financed, rate type, payment frequency, first due date, number of payments, and any charges. A quoted APR and the interest rate used to accrue interest can serve different purposes in loan documents, particularly when fees are involved. Use the figures and definitions supplied for the specific loan rather than assuming the calculator captures every contract feature.

Using the Estimate Carefully

Enter the principal actually borrowed, not a target payment or the total cost of an item unless that full amount is being financed. Use an annual percentage rate as a percentage: enter 8 for 8%, not 0.08. The term is in years, and the calculator converts it to monthly payments. A shorter term generally means fewer payments, while a longer term means more periods over which interest can accrue; the resulting payment and interest depend on the rate and loan amount as well.

• Verify whether the rate is fixed or variable. This estimate assumes fixed.
• Check that the APR and term match the lender’s quoted loan terms.
• Do not treat total interest as the same as total cost if charges or insurance apply separately.
• Expect small differences if the lender rounds each period differently or uses actual calendar dates.

Payments beyond the required installment can change the schedule only if they are accepted and applied to principal as intended. The timing and handling of additional payments depend on the loan agreement and servicer. The calculator does not model extra payments, missed payments, payment holidays, refinancing, or a changing interest rate.

Common Misunderstandings and Limits

A schedule is not simply the original loan divided by the number of months: that arithmetic leaves out interest. Nor does the monthly payment necessarily include every amount due. For mortgages, for example, taxes, insurance, and escrow may be separate from principal and interest. Other loan types can have fees or optional products billed independently.

The APR input is used here as a nominal annual rate divided by 12, not as a complete measure of all borrowing costs. If fees are financed or the contract uses a different calculation convention, the displayed payment and interest will not exactly match the lender’s schedule. The outputs are rounded estimates and should not be used as a payoff quote; a payoff amount can reflect accrued interest and other account-specific items.

Frequently Asked Questions

What is a bank loan repayment schedule?
A table showing scheduled payments over a loan’s term, including each payment’s interest, principal, and remaining balance.

How do I calculate a monthly loan payment?
Use the amortization formula with the principal, monthly rate (annual rate divided by 12), and total number of monthly payments. This calculator applies that formula and rounds the result to cents.

Why does more of my early payment go to interest?
Interest for a period is calculated on the outstanding principal. The balance is highest near the start, so the interest portion is usually greater then; as principal declines, the interest charge generally declines too.

Does a repayment schedule include fees and insurance?
Not necessarily. This calculator includes only estimated principal and interest. Review the lender’s documents for fees, taxes, insurance, escrow, and other amounts.

Why is my lender’s payment different from this estimate?
The lender may use different dates, rounding, rate terms, financed charges, or payment features. Compare the calculator’s assumptions with the loan disclosure and servicing information.

This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.

Related

• Personal Loan APR Calculator and Rate Guide
• Personal Loan 0% APR? Check the Payment and Total Cost
• Pennymac Loan Payoff Request: Steps and Details

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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 2