Amortization Schedule From a Monthly Payment

An amortization schedule shows how each monthly loan payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, annual APR, and term to calculate the scheduled payment and total interest; the schedule itself can then be built month by month from those figures.

Formula

The calculator estimates the fixed monthly payment for a fully amortizing loan, then subtracts the original loan amount from the total of the scheduled payments to estimate total interest.

• P is the starting loan principal, in dollars.
• APR is the annual percentage rate entered as a percentage per year.
• r is the monthly rate, calculated as APR ÷ 1,200.
• n is the number of monthly payments, calculated as years × 12.
• M is the unrounded monthly payment: P × r ÷ [1 − (1 + r)⁻ⁿ]. The calculator displays the result to the nearest cent.
• Total interest is displayed monthly payment × n − P. It uses the rounded payment, so it reflects the payment amount shown.

This is the standard level-payment formula for a fixed-rate loan with monthly periods. The calculator rounds the displayed payment to cents, but the formula for the payment uses the unrounded mathematical result before display rounding.

Worked Example

With the defaults, the principal is $20,000, APR is 8%, and the term is 5 years. The monthly rate is 8 ÷ 1,200 = 0.0066667, and the number of payments is 5 × 12 = 60.

Substitute those values in the payment formula:

M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] ≈ $405.53 per month.

Using the displayed payment, total scheduled payments are $405.53 × 60 = $24,331.80. Estimated total interest is $24,331.80 − $20,000 = $4,331.80. Results can differ slightly from a lender’s final figures because actual payment dates, rounding conventions, and contract terms may differ.

How to Build the Amortization Schedule

The calculator supplies the level payment and estimated total interest. To create each schedule row, apply the monthly rate to the balance at the start of that month, then split the payment:

1. Record the opening balance. For the first month, this is the original principal.
2. Calculate that month’s interest: opening balance × monthly rate.
3. Calculate principal paid: monthly payment − interest.
4. Calculate the closing balance: opening balance − principal paid.
5. Use that closing balance as the next month’s opening balance and repeat.

In the default example, first-month interest is $20,000 × 0.0066667, or about $133.33. Of the $405.53 payment, about $272.20 reduces principal. The balance after that payment is about $19,727.80. In the next month, interest is calculated on this smaller balance, so slightly more of the same payment goes to principal.

For a precise schedule, calculate from unrounded values internally and round displayed money to cents. If you round the interest and balance at every step, small rounding differences can accumulate. A final payment may need a small adjustment to bring the balance exactly to zero.

How to Read the Results

The payment is the scheduled amount for principal and interest under the stated assumptions; it is not necessarily the full amount due on a real loan statement. The total interest is the amount above the original principal across the modeled number of payments. It is not the total cost of borrowing if separate charges apply.

An amortization schedule typically includes the payment number or date, opening balance, payment, interest, principal, and closing balance. Early in a standard fixed-rate loan, the balance is relatively high, so the interest portion tends to be larger. As principal is paid down, the interest portion declines and the principal portion rises. This does not mean the lender changes the monthly payment; under the model, the scheduled payment remains level.

When This Estimate Applies—and Its Limits

This method is useful for understanding the repayment pattern of a fixed-rate loan with equal monthly payments. It can also help explain why the payment alone does not show how quickly principal falls: the APR and remaining term matter too.

The schedule is not an exact forecast for every contract. A variable rate can change the interest charged; irregular payment dates or daily-interest calculations can alter the split; and fees added to the balance change the amount being amortized. A loan with a balloon payment, interest-only period, deferred payments, or other nonstandard structure does not follow this simple level-payment pattern throughout its term.

The calculator requires APR of at least 0.01% because its stated formula divides by the monthly rate. A true zero-interest loan needs a separate calculation: principal divided by the number of payments. The maximum term and APR are calculator input limits, not claims about what a lender offers. Use the exact loan amount, APR, and term provided for the loan being evaluated.

Common Mistakes and Related Details

• Confusing APR with the monthly rate: enter annual APR as a percentage, such as 8, not 0.08 or 0.00667. The formula converts it to a monthly rate by dividing by 1,200.
• Mixing up term units: enter years in the term field. The calculator multiplies the number of years by 12 to get payment periods.
• Treating the payment as the total bill: the calculated payment covers modeled principal and interest only. Taxes, insurance, escrow, and other charges are not included.
• Assuming extra payments automatically reduce the total by a fixed amount: additional principal can change the balance path, but the result depends on when payments are credited and how the loan applies them. This calculator does not model extra payments.

For a lender-specific schedule, use the payment amount, rate, timing, and balance conventions stated in the loan documents or request the lender’s schedule. Small differences in rounding are normal when a displayed cent amount is repeated across many months.

Assumptions

• The APR is fixed for the full modeled term.
• Payments are equal, made monthly, and applied at the end of each monthly period.
• Interest compounds monthly at APR ÷ 12; the calculator uses APR ÷ 1,200 as a decimal monthly rate.
• Fees, taxes, insurance, PMI, escrow, extra payments, and changes to payment dates are not included.

Frequently Asked Questions

Can I make an amortization schedule if I know only the monthly payment?
Not completely. You also need the starting balance and the interest rate or monthly interest amount to divide each payment between interest and principal. The remaining term is needed to check whether the payment follows a fully amortizing schedule.

How do I calculate the principal portion of a payment?
For each month, subtract that month’s interest from the payment. Interest is the opening balance multiplied by the monthly rate; the remainder is principal, assuming no separate charges are included in the payment.

Why does more of the payment go to interest at the beginning?
Interest is calculated on the outstanding balance. The balance is highest at the start, so the interest charge is usually greatest then. As the balance falls, the interest amount falls and more of a level payment reduces principal.

Does the monthly payment include taxes and insurance?
Not in this calculator. It estimates principal and interest only. A real bill may include additional amounts, depending on the loan and its billing arrangement.

Why does my lender’s schedule differ by a few cents?
Lenders may use different rounding practices, payment dates, or interest-accrual methods. Repeated rounding can change the displayed balance or final payment slightly.

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

Related

• Savings Account Interest Rate: How It Works
• Student Loan Interest Rate Calculator and Costs
• Mortgage Interest Rate Calculator and Payment Formula

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