Amortization Schedule by Payment Amount: How It Works

An amortization schedule by payment amount shows how each loan payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, APR, and term to calculate the standard monthly payment and total interest; a full schedule can then be built by applying the same balance calculation to each payment period.

Formula

The calculator uses the standard fixed-payment loan formula. It first finds the monthly payment, then estimates total interest by subtracting the original principal from all scheduled payments.

• Monthly payment: M = P × r ÷ [1 − (1 + r)⁻ⁿ]
• Total interest: I = M × n − P

Here, P is the amount borrowed in dollars; APR is the annual percentage rate entered as a percentage; r is the monthly rate, APR ÷ 1200; n is the number of monthly payments, years × 12; M is the monthly payment in dollars, rounded to cents; and I is total interest in dollars based on that rounded payment. The calculator assumes monthly payments and a fixed rate.

Worked Example

Using the defaults—$20,000 borrowed, 8% APR, and a 5-year term—the monthly rate is 8 ÷ 1200 = 0.0066667, and the number of payments is 5 × 12 = 60.

1. Substitute the values: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰].
2. The unrounded payment is about $405.5277, which rounds to $405.53 per month.
3. Total scheduled payments using the rounded payment are $405.53 × 60 = $24,331.80.
4. Estimated total interest is $24,331.80 − $20,000 = $4,331.80.

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 is compounded monthly using APR ÷ 12 as the periodic rate.
• Fees, taxes, insurance, mortgage insurance, escrow, and other charges are not included.

How a Payment-by-Payment Schedule Works

A schedule is created one period at a time. For each month, calculate interest on the opening balance, subtract that interest from the payment to find principal repaid, and subtract principal repaid from the opening balance. The resulting balance becomes the next month’s opening balance.

• Monthly interest = opening balance × monthly rate.
• Principal paid = payment − monthly interest.
• Closing balance = opening balance − principal paid.

For the example, first-month interest is $20,000 × 0.0066667, or about $133.33. Of the $405.53 payment, about $272.20 reduces principal, leaving a balance near $19,727.80. In later months, interest is calculated on the smaller balance, so more of the same payment goes toward principal. Rounding each row to cents can create a small difference from calculations that retain extra decimal places; lenders may adjust the final payment to clear the remaining balance.

Reading and Using the Results

The monthly payment is the scheduled amount for principal and interest under the stated assumptions. It is not necessarily the entire amount due on a bill: an actual loan may include separately calculated charges or fees that this estimate does not model. Total interest is the sum of interest over the stated payment count, not a separate amount paid all at once.

A full schedule is useful for seeing the projected balance at a particular month, estimating how much principal has been repaid, and checking how interest changes over time. To calculate a balance, repeatedly apply the monthly steps above, or use the equivalent balance formula: B_k = P(1 + r)^k − M × [(1 + r)^k − 1] ÷ r. Here, B_k is the balance after k payments. The formula assumes the regular payment is made on schedule and does not account for extra payments or fees.

Payment Amount, Term, and Common Misunderstandings

The calculator derives the payment from the loan amount, APR, and term. If you already know a different payment amount and want a schedule based on it, use that amount in the monthly schedule steps instead. The result may not match the standard term: a larger payment can repay principal sooner, while a payment that does not cover that month’s interest will allow the balance to grow.

A frequent misunderstanding is that a fixed payment means a fixed principal reduction. It does not: with a standard amortizing loan, the interest portion generally declines as the balance falls, and the principal portion rises. Another is to multiply an unrounded payment by the number of months. Since actual installments are generally expressed in cents, a schedule that uses a rounded installment can produce a slightly different total than one using an unrounded mathematical value.

Limits and Details to Check

This estimate describes a level-payment loan with a fixed rate and regular monthly periods. It does not model variable rates, skipped or late payments, daily interest calculations, irregular payment dates, fees added to the balance, or extra principal payments. APR conventions and payment allocation can also differ by contract, and the calculator cannot infer those details from the three inputs.

For a schedule tied to a real loan, use the principal, rate, term, payment frequency, and payment amount shown in the lender’s documents. Confirm whether the stated APR and payment include any financed costs, and whether the final installment is adjusted. Rates, fees, and other contract details should come from the lender rather than from an assumed example.

Frequently Asked Questions

How do I make an amortization schedule for a specific payment amount?
Start with the loan balance and monthly rate. For each month, multiply the opening balance by the monthly rate to find interest; subtract interest from the payment to find principal; then subtract principal from the balance. Repeat, and adjust the final payment if needed to bring the balance to zero.

Does a higher payment reduce total interest?
When extra amounts are applied to principal and the loan is paid sooner, less balance remains to accrue interest. The precise effect depends on the loan’s payment terms, rate, and how the servicer applies payments; this calculator assumes equal scheduled payments only.

Why does the first payment have more interest?
Interest is calculated on the outstanding balance. At the beginning, the balance is highest, so the interest portion is generally larger. As principal is repaid, the balance—and therefore the interest calculated each month—declines.

Is APR the same as the monthly interest rate?
No. For this estimate, the monthly rate is APR divided by 12, or APR ÷ 1200 when APR is entered as a percentage. Contractual APR calculations and fees may not be represented by this simplified monthly-rate assumption.

Why might my lender’s schedule differ?
The contract may use different rounding, payment timing, rate conventions, fees, or a final-payment adjustment. Compare the calculator’s assumptions with the lender’s disclosed schedule and terms.

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

Related

• Refinance First Month Payment? How the Timing Works
• QQQ Options Open Interest: What It Shows
• Quarterly Interest-Only Payment Calculator

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