An amortized schedule of payments shows how each scheduled loan payment is divided between interest and principal, and how the remaining balance changes over time. Enter the loan amount, annual percentage rate (APR), and term below to calculate the fixed monthly payment and total interest; the schedule mechanics and a worked example explain how to read the results.
Formula
For a fixed-rate loan with equal monthly payments, the level-payment formula is M = P × r / (1 − (1 + r)−n). Here, M is the monthly payment in dollars, P is the starting principal or loan amount in dollars, r is the monthly interest rate as a decimal (APR ÷ 1,200), and n is the number of monthly payments (years × 12). Total interest in this calculator is I = M × n − P, using the payment rounded to cents.
The formula calculates the payment needed to repay the stated principal and interest over the stated term under its assumptions. It does not produce every row of the schedule by itself, but the rows follow a recurring calculation: interest for the period is based on the outstanding balance, and the remainder of that period’s payment reduces principal.
Worked Example
Using the calculator’s defaults—$20,000 principal, 8% APR, and a five-year term:
- Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
- Find the payment count: 5 × 12 = 60 months.
- Substitute into the payment formula: M = 20,000 × 0.0066667 ÷ [1 − (1.0066667)−60]. The unrounded result is about $405.53, so the monthly payment is $405.53.
- Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.
The payment stays level in this simplified example, but the allocation changes. The first month’s interest is $20,000 × 0.0066667, or about $133.33. The rest of the $405.53 payment—about $272.20—reduces principal. After that payment, the balance is about $19,727.80. In the next month, interest is calculated on that lower balance, so a larger share of the same payment goes to principal.
How an Amortization Schedule Works
An amortization schedule is a dated or numbered list of payment periods. A standard row generally shows the starting balance, payment, interest charge, principal reduction, and ending balance. To build a row, multiply the balance at the start of the period by the periodic interest rate. Subtract that interest from the payment to find principal repaid, then subtract principal repaid from the balance.
For example, if a period begins with a $19,727.80 balance at a monthly rate of 0.0066667, its interest is approximately $131.52. With a $405.53 payment, about $274.01 goes to principal, leaving a balance of roughly $19,453.79. Small differences can appear if figures are rounded at each step; a lender’s system may retain more decimal places internally.
Early payments typically contain a larger interest portion because the balance is larger. As the balance declines, the interest charge generally declines too, leaving more of each level payment to reduce principal. The schedule reaches approximately zero after the final payment, subject to rounding and the lender’s actual calculation method.
Reading the Results and Using a Schedule
The calculator’s monthly payment is the modeled amount for principal and interest, while total interest is the sum of those payments minus the original principal. A schedule adds useful timing detail: it can show how much principal remains after a particular number of payments and how the interest-versus-principal split evolves.
People commonly use an amortization schedule to understand a loan’s repayment path, check a quoted payment, or estimate the effect of a payment date on the outstanding balance. For a real loan, use the lender’s disclosed amount, APR, term, payment frequency, and payment dates. If a quoted payment differs, check whether it includes fees or other charges, whether the term is expressed in whole months, and how the lender handles rounding and payment timing.
A standard schedule assumes payments arrive as planned. A late payment, skipped payment, variable rate, additional principal payment, or a change in the amount owed can alter later rows. The calculator here does not generate dates or an itemized schedule; it provides the level monthly payment and total interest for the inputs.
Common Misunderstandings and Limits
- Payment is not the same as total borrowing cost. The calculated payment covers modeled principal and interest only. Fees, taxes, insurance, escrow, and other charges are not included.
- APR is not entered as a decimal. Enter 8 for 8%, not 0.08; the formula divides the APR input by 1,200 to get the monthly decimal rate.
- Interest is not a fixed share of every payment. In a level-payment loan, the interest component usually changes as the balance changes.
- Rounding affects totals. This calculator rounds the monthly payment to cents and uses that rounded amount to calculate total interest. A lender may use more precise internal values, so its final figures can differ slightly.
The calculation uses a fixed APR and regular monthly periods. It does not model variable rates, irregular first periods, daily interest accrual, payment holidays, fees added to principal, or extra payments. If the loan’s terms use a different schedule or calculation convention, this estimate will not reproduce the lender’s complete ledger.
Assumptions
- The interest rate is fixed for the entire modeled term.
- Payments are equal, monthly, and made at the end of each monthly period.
- Interest compounds monthly at APR ÷ 12, represented as APR ÷ 1,200 when APR is entered as a percentage.
- Fees, taxes, insurance, PMI, and escrow are not included; no input for them is provided.
Frequently Asked Questions
What is an amortized schedule of payments?
An amortized payment schedule lists each installment and shows how much goes to interest, how much reduces principal, and what balance remains afterward.
How do I calculate the monthly payment on an amortizing loan?
Use the fixed-payment formula M = P × r / [1 − (1 + r)−n], where the monthly rate is APR divided by 1,200 and the number of payments is the term in years multiplied by 12.
Why does more of the payment go to interest at the beginning?
Interest for each period is calculated on the outstanding balance. The balance is largest at the start, so the interest charge generally falls as principal is repaid.
Does an amortization schedule include taxes and insurance?
Not necessarily. A principal-and-interest schedule excludes those costs unless they are separately added. This calculator includes only modeled principal and interest.
Can extra payments change the amortization schedule?
Yes. An extra amount applied to principal can reduce the balance and change later interest and repayment timing. This calculator assumes only the regular level payment, so it does not calculate that effect.
This result is an estimate; the lender’s disclosure gives the exact figures.
Related
Formula used
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
Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work
Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.
More in this section
- June Balance Date: What It Means for Loan Balances$405.53
- L&T Finance Gold Loan: How It Works and What to Check
- Journal Entry to Correct a Beginning Balance
- JS Bank Gold Loan: Eligibility, Process and Costs
- Journal Entry for a Bank Loan: Debit and Credit$20,000.00
- Journal Entry to Adjust Beginning Balance