Payment Calculator With Amortization Schedule

A payment calculator with an amortization schedule estimates a fixed monthly loan payment and shows how each payment is divided between interest and principal over time. Enter the loan amount, annual percentage rate (APR), and term; the calculator returns the monthly payment and total interest, while the schedule can be built by applying the same payment to each month’s opening balance.

Formula

The calculator uses the standard fixed-payment loan formula:

Payment = round(P × r / (1 − (1 + r)−n), 2)

• P is the starting loan principal, in dollars.
• r is the monthly interest rate as a decimal: APR ÷ 1,200. For an 8% APR, r = 8 ÷ 1,200, or about 0.0066667 per month.
• n is the number of monthly payments: loan term in years × 12.
• Payment is the fixed monthly principal-and-interest payment, rounded to the nearest cent.

Total interest is calculated as monthly payment × n − P. The schedule’s row-by-row figures follow this monthly calculation: interest = opening balance × r, principal paid = payment − interest, and closing balance = opening balance − principal paid. The closing balance becomes the next month’s opening balance.

Worked Example

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

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

For an illustrative first schedule row, monthly interest is $20,000 × 0.0066667, or $133.33 when rounded to cents. The principal portion is $405.53 − $133.33 = $272.20, leaving an estimated balance of $19,727.80. In later months, interest is calculated on the smaller remaining balance, so more of the same payment generally goes toward principal.

Assumptions

• The interest rate is fixed for the full term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest accrues monthly using APR divided by 12; this is the calculator’s monthly compounding assumption.
• The estimate covers principal and interest only. It excludes fees, taxes, insurance, mortgage insurance, and escrow.
• The displayed total uses the rounded monthly payment. A lender’s final payment may be adjusted slightly to clear any rounding difference.

How to Read an Amortization Schedule

An amortization schedule is a table showing the loan’s progress, usually one row per payment. Common columns are the payment number or date, payment amount, interest charged, principal repaid, and remaining balance. The balance should generally decline as principal is repaid, reaching zero after the final scheduled payment, subject to rounding and the lender’s exact accrual method.

At the start of a conventional fixed-payment loan, the balance is largest, so the interest portion tends to be larger. As the balance falls, the interest calculation falls too. This does not mean the lender changes the scheduled payment: under the assumptions above, the payment stays level and its principal share increases over time.

A schedule can help answer practical arithmetic questions: how much principal remains after a given number of payments, how much interest has accrued by that point, or how an additional principal payment might alter the projected payoff. Those questions require a balance calculation or a separate extra-payment model; the two outputs in this calculator alone are not a complete month-by-month table.

When to Use the Estimate

Use this calculation when you have the amount financed, APR, and repayment term and want a baseline principal-and-interest payment. Enter the lender’s quoted figures when available. The example values are placeholders, not an indication of a current or typical borrowing rate. A quoted APR can include certain financing costs depending on the product and disclosure, but this calculator treats the APR simply as a fixed annual rate divided into monthly periods.

To produce a full schedule, repeat the monthly steps for each of the 60 months in the example: calculate interest on the opening balance, subtract that amount from the payment to find principal repaid, then subtract principal from the opening balance. If the final calculated balance is a few cents below or above zero, it is usually a rounding artifact in the illustration; actual payoff calculations can use more precise daily or periodic accrual rules.

Common Mistakes and Limits

• Confusing APR with the monthly rate: enter 8 for 8%, not 0.08. The formula divides the percent value by 1,200 to get a monthly decimal.
• Using years as months: a five-year term means 60 payments, not five.
• Reading principal and interest as the whole housing or borrowing cost: the estimate excludes additional charges such as taxes, insurance, fees, and escrow unless separately entered.
• Assuming every loan has level payments: variable-rate, interest-only, graduated-payment, or irregular-payment arrangements do not follow this model throughout their lives.
• Ignoring payment timing and rounding: daily interest, payment dates, a first or final partial period, and rounding conventions can shift actual figures.

The formula requires a positive APR because it divides using the monthly rate; a zero-interest loan needs a different simple calculation. The result is also an estimate rather than a payoff quote. For exact dates, balances, and charges, use the lender’s disclosed payment terms and account information.

Frequently Asked Questions

What does an amortization schedule show?
It lists each scheduled payment and separates it into interest and principal, while tracking the remaining loan balance after each payment.

Why does more of my payment go to interest at first?
Interest for each period is calculated from the outstanding balance. The starting balance is largest, so the interest portion often starts larger and generally falls as principal is repaid.

Does the monthly payment include taxes and insurance?
No. This calculator estimates principal and interest only. Taxes, insurance, mortgage insurance, escrow, and fees are not included.

How do I calculate total interest?
For this fixed-payment estimate, multiply the monthly payment rounded to cents by the number of monthly payments, then subtract the original principal.

Will my lender’s payment match this result exactly?
Not necessarily. Payment timing, rounding, fees, rate changes, and the lender’s interest-accrual method can affect disclosed amounts. The result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Loan Payoff Calculator: Estimate Your Payment-Free Date
• Loan Payment Calculator to Pay Off Early
• Loan Payment Calculator: Estimate Monthly Payments

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