Free Amortization Table Calculator: Payments and Balance

Yes—this free amortization table calculator estimates a fixed-rate loan’s monthly payment and total interest from the amount borrowed, annual interest rate, and term. It provides the core figures used to build a payment-by-payment schedule; the calculation assumes monthly payments and does not include fees, taxes, insurance, or other charges.

Formula

The calculator uses the standard level-payment formula for a fixed-rate loan. It first calculates a monthly payment, rounds that payment to cents, and then estimates total interest by multiplying the rounded payment by the number of monthly payments and subtracting the original principal.

• Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]
• Total interest: I = M × n − P
• Monthly rate: r = APR ÷ 1,200
• Number of payments: n = years × 12

P is the starting loan principal in dollars; APR is the annual percentage rate entered as a percentage, such as 8 for 8%; r is the monthly interest rate as a decimal; n is the number of monthly payments; M is the monthly payment in dollars; and I is estimated total interest in dollars. For example, an APR of 8% becomes a monthly rate of 8 ÷ 1,200, or about 0.006667.

Worked Example

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

1. Apply the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
2. The unrounded payment is about $405.53; rounded to cents, the monthly payment is $405.53.
3. Use the rounded payment in the interest estimate: $405.53 × 60 − $20,000 = $4,331.80.

These figures are estimates under the stated formula. A lender’s actual schedule may differ because of payment dates, rounding conventions, fees, or loan terms not represented here.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are level monthly installments and are made at the end of each monthly period.
• Interest accrues monthly at APR divided by 12; the APR is treated as a nominal annual rate for this calculation.
• Fees, taxes, insurance, private mortgage insurance, escrow deposits, and extra payments are not included.

How an Amortization Table Works

An amortization table shows how each scheduled payment is divided between interest and principal. Early in a fully amortizing loan, the outstanding balance is larger, so the interest portion is generally larger too. As principal is repaid, less interest accrues each period and more of the same level payment goes toward reducing principal.

For a month-by-month schedule, calculate that month’s interest as the opening balance multiplied by the monthly rate. Subtract the interest from the payment to find the principal reduction, then subtract that reduction from the opening balance. The result is the next month’s opening balance. In a real schedule, the final payment may be adjusted slightly to clear the remaining balance because payments and interest are rounded.

This page gives the payment and total-interest estimates, not a row for every month. Those outputs help check the broad cost and payment pattern, but they are not a payoff quote. To reproduce a lender’s exact table, use its balance, dates, payment rules, and rounding method.

When to Use the Calculator and How to Read It

Use the calculator when you have a principal, a quoted fixed APR, and a term and want a consistent estimate of the scheduled payment and interest under monthly-payment assumptions. Enter the amount borrowed rather than the total purchase price if the loan covers only part of a purchase. Enter the annual rate as a percentage: type 8 for 8%, not 0.08.

The monthly payment is the modeled principal-and-interest installment, not necessarily the full amount due each month. A mortgage payment may include escrowed taxes or insurance, and other loans can have separate charges. Total interest is the sum implied by the rounded installment over the stated number of payments; it is not the total of all possible borrowing costs.

For a quick scale check, the default example produces a $405.53 payment for 60 months. Multiplying that payment by 60 gives $24,331.80 in scheduled installments; subtracting $20,000 principal leaves $4,331.80 in estimated interest. This arithmetic does not account for any upfront or recurring charges outside the formula.

Common Mistakes and Calculation Limits

• Confusing APR formats: The input is a percentage per year, so enter 8 for 8%. The formula converts it to a monthly decimal rate.
• Using a variable rate as if it were fixed: A changing rate can alter payments or the payoff timeline. This calculator holds the entered rate constant.
• Expecting an all-in payment: The result excludes taxes, insurance, fees, and escrow; those amounts must be obtained separately.
• Assuming extra payments are included: Additional principal payments can change the balance and interest, but there is no extra-payment input here.
• Overlooking rounding: The payment is displayed to cents, and total interest uses that rounded payment. A lender’s daily accrual or different rounding can produce a small difference.

The formula applies to a conventional fixed-rate, fully amortizing schedule with equal monthly payments. It is not a complete model for interest-only periods, balloon payments, irregular payment dates, changing rates, or loans whose payment is recalculated under other rules. APR may also reflect costs differently from the nominal rate used to calculate periodic interest, so confirm which rate belongs in the lender’s payment calculation.

Frequently Asked Questions

Is an amortization table calculator free?
Yes. This calculator can be used without a charge to estimate the monthly payment and total interest from the entered amount, APR, and term.

Does this calculator show every payment in the amortization schedule?
No. It calculates the level monthly payment and estimated total interest. A full schedule requires calculating the interest, principal paid, and remaining balance for each month.

Why does the payment differ from my lender’s figure?
Possible reasons include fees or insurance in the quoted amount, a different rate or term, a variable rate, payment timing, and rounding or accrual conventions. Compare the same principal, rate, term, and payment components.

Does total interest include fees or insurance?
No. It is the interest estimate implied by the rounded monthly payment and the entered term. Fees, insurance, taxes, and other charges are not modeled.

Can I use it to model extra payments?
Not directly. The formula assumes the same scheduled payment each month and does not account for additional principal. A schedule that includes extra payments needs those amounts and their timing as inputs.

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

Related

• PTP Qualifying Income Exception Explained
• Qualified Income Account: Meaning and Loan Calculator
• PTP Qualifying Income: What Counts and How It Works

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