Amortization Schedule Using Payment Amount

An amortization schedule using a payment amount shows how each regular payment is divided between interest and principal, and how the balance changes over time. Enter the loan amount, APR, term, and monthly payment; this calculator estimates the payoff timeline and total interest when the entered payment is made monthly.

Formula

The requested schedule needs a specified payment amount to calculate how quickly a balance is paid down. The calculator block above is the required standard fixed-payment calculator: it uses the loan amount, APR, and term to calculate the scheduled monthly payment, then estimates total interest across that term. It does not accept a separate custom payment amount, so the payment used is the calculated level payment.

• p is the original principal in dollars.
• apr is the annual percentage rate entered as a percentage per year.
• r is the monthly interest rate as a decimal: apr / 1200.
• n is the number of monthly payments: years × 12.
• pmt is the level monthly payment in dollars.

The unrounded payment formula is pmt = p × r / (1 − (1 + r)⁻ⁿ). The calculator displays that payment rounded to cents. Its total-interest calculation is pmt × n − p, using the displayed, rounded payment. A schedule row uses the prior balance: interest = prior balance × r; principal paid = payment − interest; new balance = prior balance − principal paid. This sequence is repeated for each month.

Worked Example

Using the calculator’s default values—$20,000 principal, 8% APR, and a five-year term—the number of payments is 5 × 12 = 60, and the monthly rate is 8 / 1200 = 0.0066667.

1. Calculate the monthly payment: $20,000 × 0.0066667 / (1 − (1.0066667)⁻⁶⁰) ≈ $405.53.
2. For the first month, interest is $20,000 × 0.0066667 ≈ $133.33.
3. Principal repaid in that payment is $405.53 − $133.33 = $272.20, leaving an estimated balance of $19,727.80.
4. Total payments using the rounded monthly payment are $405.53 × 60 = $24,331.80.
5. Estimated total interest is $24,331.80 − $20,000 = $4,331.80.

Amounts in an actual lender schedule may differ slightly because payment dates, day-count conventions, rounding, and the precise contract terms can affect interest calculations.

Assumptions

• The interest rate stays fixed throughout the term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest accrues monthly at APR divided by 12.
• Fees, taxes, insurance, PMI, and escrow are not included unless represented in the loan’s stated principal or rate; this calculator has no separate inputs for them.

How a Payment-Based Schedule Works

An amortization schedule is a month-by-month ledger, not just a total-cost estimate. At the start, most of each level payment may go toward interest because interest is calculated on a relatively large outstanding balance. As principal falls, the interest portion generally shrinks and more of the same payment goes toward principal. The final row clears the remaining balance, subject to rounding and contract-specific adjustments.

To construct a schedule with a payment amount you already know, start with the loan’s current principal and periodic rate. For every payment period, calculate interest on that period’s opening balance, subtract that interest from the payment to find the principal reduction, then subtract the reduction from the opening balance. Repeat until the balance reaches zero. If the payment is only slightly above the interest due, repayment is slow; if it is no greater than the interest due, the balance will not decline under this simple model.

Using a Different Payment Amount

A custom payment changes the schedule and may change the number of payments and total interest. The calculator above does not take a custom payment input: it derives the payment from the entered term. To model another amount, use the same row-by-row process with the amount actually paid, and calculate the final payment as the remaining balance plus interest for the last period. If extra payments are made, apply them according to the loan’s payment rules; the schedule here cannot model their timing or treatment.

For an ordinary level-payment loan, the balance after k payments can also be estimated as B_k = p(1 + r)^k − pmt × ((1 + r)^k − 1) / r, where k is the number of completed payments. This expression assumes the same monthly rate and payment throughout. It is useful for checking an approximate remaining balance, but a row-by-row schedule makes payment allocation easier to inspect.

How to Read the Results and Avoid Errors

• Check the rate unit. Enter an annual APR as a percentage, such as 8 for 8%, not 0.08. The monthly-rate conversion is apr / 1200.
• Distinguish term from payment count. A five-year term represents 60 monthly payments, not five payments.
• Expect cent-rounding differences. Rounding every monthly interest amount can create a small difference from calculations that retain extra decimal places. A lender may adjust the last payment.
• Separate principal and interest from the bill. A mortgage or other loan payment may be accompanied by taxes, insurance, fees, or escrow items that this formula does not calculate.
• Use the applicable balance. For a loan already in progress, the starting principal should be its current balance, not necessarily its original amount.

A common misconception is that every payment reduces principal by the same amount. With a fixed payment and rate, interest is recalculated on the remaining balance, so the principal portion usually grows over time. Another important distinction: an APR may include or reflect costs differently from the periodic interest rate in a contract. The calculator uses APR divided by 12 as a simplified monthly rate and does not reproduce every lender’s method.

Frequently Asked Questions

How do I make an amortization schedule with a payment amount?
For each month, multiply the opening balance by the monthly rate to find interest. Subtract that interest from the payment to find principal repaid, then subtract principal repaid from the balance. Repeat for later payments.

Does this calculator let me enter my own payment?
No. It calculates the level monthly payment from the principal, APR, and term. A schedule based on a different payment amount needs that amount as an additional input and must account for the resulting payoff period.

Why does the principal portion increase over time?
When the balance decreases, the interest charged at the same rate also decreases. With a level payment, the amount left after interest is therefore larger and goes toward principal.

What happens if my payment is less than the monthly interest?
Under the basic model, none of the payment is enough to cover interest, so the unpaid interest may be added to the balance or handled under other contract terms. This calculator does not model negative amortization or lender-specific payment rules.

Why might my lender’s schedule differ?
Actual calculations can use specific payment dates, daily interest accrual, different rounding practices, fees, or other contract terms. Use the lender’s disclosure and account records for exact figures.

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

Related

• Loan Against Property Interest Rate Calculator
• KVP Interest Rate: Current Rate and How It Works
• Yield vs. Effective Interest Rate: What’s the Difference?

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