Amortization Table Using Payment Amount?

An amortization table using a payment amount shows how each loan payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual APR, and term below to calculate the level monthly payment and total interest, then use the schedule method explained here to build a full table.

Formula

The calculator determines a fixed monthly payment using the standard fully amortizing loan formula, then subtracts the original principal from all scheduled payments to estimate total interest.

Monthly payment: M = P × r / [1 − (1 + r)⁻ⁿ]. Here, M is the monthly payment in dollars, P is the starting loan principal in dollars, r is the monthly interest rate as a decimal, and n is the number of monthly payments. Convert an APR entered as a percentage to a monthly decimal with r = APR / 1200. The number of payments is n = years × 12.

Total interest: I = M × n − P, where I is the estimated interest in dollars. The calculator uses the unrounded payment formula internally for its displayed payment and total; real servicers may round each payment and interest posting to cents, causing small differences.

Worked Example

Using the default inputs—$20,000 principal, 8% APR, and a 5-year term—the schedule contains 5 × 12 = 60 monthly payments. The monthly rate is 8 / 1200 = 0.0066667.

1. Calculate the payment: M = 20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰].
2. Evaluating the expression gives approximately $405.53 per month when rounded to cents.
3. Using the calculator’s displayed figures, 60 × $405.53 − $20,000 = $4,331.80 in estimated total interest. Because the calculator’s total-interest expression uses its unrounded payment result, its displayed total may differ slightly from this cents-rounded illustration.

The payment formula’s precise result is about $405.528, so the monthly payment output is $405.53. The unrounded formula gives total interest of about $4,331.69. A cent-by-cent amortization schedule applies rounding to each period and can produce a different final total or a small adjusted last payment. The figures are estimates rather than a substitute for a lender’s exact schedule.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are equal, made monthly, and assumed to arrive at the end of each monthly period.
• Interest compounds monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, missed payments, and extra payments are not included.

How to Build an Amortization Table from a Payment

Once you know the payment amount, an amortization table calculates the interest and principal portions one period at a time. For a fixed-rate loan with monthly payments, use the prior period’s balance to calculate interest; then subtract that interest from the payment. The remainder reduces principal.

1. Start with the opening balance, usually the original amount borrowed.
2. Multiply the opening balance by the monthly rate to find that month’s interest.
3. Subtract interest from the payment to find the principal repaid.
4. Subtract principal repaid from the opening balance to get the closing balance.
5. Use the closing balance as the next month’s opening balance and repeat.

In symbols, for month t: interest = opening balance × r; principal = payment − interest; closing balance = opening balance − principal. If the payment is fixed and the rate is positive, the interest portion generally declines as the balance falls, while the principal portion grows. The scheduled payment itself remains level, except where the last payment needs adjustment for rounding.

Reading the Results and Choosing a Payment

The calculator answers a specific question: what level payment would repay this principal over the entered term at the entered APR, assuming the stated conditions? It does not let you enter a payment directly. To make a table from a payment amount already specified in a loan document, use that exact payment in the monthly steps above, along with the lender’s rate and opening balance.

A payment must cover that period’s interest for the balance to decline. If it equals the interest, the balance does not fall; if it is less, unpaid interest can cause the balance to grow, depending on the loan’s terms. This calculator instead derives the payment needed to amortize the balance over the chosen term.

When comparing schedules, check that they use the same principal, APR, payment frequency, and number of payments. A longer term usually means more payment periods, which can increase total interest even if the periodic payment is lower. That is a mathematical effect of the inputs, not a recommendation about which loan structure to use. Get the exact APR, payment, and schedule assumptions from the lender’s disclosure.

Common Errors and Limits

• Using an annual rate as a monthly rate: divide APR by 12 to get a monthly percentage, or by 1200 to get a monthly decimal. For 8% APR, the monthly decimal is 0.0066667—not 0.08.
• Applying interest to the original principal each month: the schedule calculates interest on the current opening balance, which changes each period.
• Rounding every intermediate value: keeping extra precision during calculations reduces accumulated rounding drift. A real account may still round posted interest and payments to cents.
• Assuming every loan has level payments: variable-rate, interest-only, balloon, and payment-adjustment structures do not follow this simple schedule throughout their full lives.

The estimate also excludes charges that may be part of a real monthly bill, such as insurance or escrow, and does not model payment dates, daily interest, fees, or changes to the rate. For an exact period-by-period schedule, use the lender’s balance and interest conventions rather than relying on a generic monthly model.

Frequently Asked Questions

How do I make an amortization table using a payment amount?
For each period, multiply the opening balance by the periodic interest rate, subtract that interest from the payment to get principal repaid, then subtract principal from the opening balance. Repeat using the new balance.

How do I find the interest portion of a monthly payment?
Multiply the balance at the start of the month by the monthly interest rate. The remaining part of the payment, after interest, is principal if the payment is sufficient to cover interest.

Why does the principal portion increase over time?
With a fixed rate and level payment, the balance generally declines, so the interest calculated on that balance also declines. More of the unchanged payment can then go toward principal.

Can I use this for an extra-payment schedule?
The displayed calculator does not include extra payments. In a manual schedule, add an extra principal payment to that period’s principal reduction, then calculate later interest from the reduced balance. Loan terms may affect how extra payments are applied.

Why doesn’t my lender’s total match this estimate?
Differences can come from payment rounding, the exact first payment date, daily rather than monthly interest calculations, fees, or a final payment adjustment. Check the lender’s disclosed schedule for the account-specific figures.

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

Related

• Amortization Calculator With Extra Monthly Payments
• Amortization Calculator Based on Payment
• Biweekly Amortization Calculator: Payment and Interest

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