Detailed Amortization Schedule Calculator

A detailed amortization schedule calculator shows how each level monthly loan payment is divided between interest and principal, along with the remaining balance after each payment. Enter the loan amount, annual percentage rate (APR), and term to calculate the monthly payment and total interest; the schedule itself can be generated by applying the same balance calculation month by month.

Formula

The calculator uses the standard fixed-rate, fully amortizing loan payment formula. It calculates a level monthly payment, then total interest as the sum of those payments minus the original principal.

• p is the starting loan principal, in dollars.
• apr is the annual percentage rate as a percentage, such as 8 for 8% per year.
• r is the monthly interest rate as a decimal: r = apr / 1200.
• n is the number of monthly payments: n = years × 12.
• pmt is the monthly payment, in dollars: pmt = p × r / [1 − (1 + r)⁻ⁿ].
• Total interest is pmt × n − p, in dollars.

The calculator rounds the payment to cents for display. A detailed schedule is built using that cent-rounded payment: for each period, interest is the starting balance multiplied by the monthly rate, principal paid is the payment minus interest, and the new balance is the old balance minus principal paid. Because actual payments are rounded to cents, the last payment may need a small adjustment to clear the remaining balance.

Worked Example

Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term:

1. Convert APR to a monthly decimal rate: r = 8 / 1200 = 0.0066667.
2. Find the number of monthly payments: n = 5 × 12 = 60.
3. Calculate the payment: 20,000 × 0.0066667 / [1 − (1.0066667)⁻⁶⁰] = $405.53 per month, rounded to cents.
4. Calculate total interest using the displayed rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

For the first month, interest is $20,000 × 0.0066667, or about $133.33. The remaining $272.20 of the $405.53 payment reduces principal, leaving a balance of about $19,727.80. In the second month, interest is calculated on that lower balance, so a slightly larger share of the same payment goes toward principal.

Assumptions

• The interest rate stays fixed throughout the term.
• Payments are equal monthly payments made at the end of each monthly period.
• Interest compounds monthly at APR / 12.
• Fees, taxes, insurance, PMI, and escrow are not included.

How to Read a Detailed Amortization Schedule

A schedule usually has one row per payment period and columns for the payment number or date, starting balance, payment, interest, principal, and ending balance. The payment is generally steady under this formula, but its allocation changes over time. Early in repayment, the balance is larger, so monthly interest is larger. As principal falls, the interest portion declines and the principal portion rises.

For example, the first payment in the worked example applies about $133.33 to interest and $272.20 to principal. Later rows will show less interest than that, assuming the payment is made as scheduled and the rate and timing remain unchanged. The final balance should be zero, subject to cent rounding and any final-payment adjustment. A schedule is a mathematical projection, not a statement of the amount currently owed by a lender.

When to Use It and What It Leaves Out

Use an amortization schedule to understand how a fixed-rate loan is projected to decline over time, estimate cumulative interest under stated assumptions, or inspect how much principal a particular payment period repays. It can also help explain why the total of all payments exceeds the amount borrowed: the difference is interest in this simplified calculation.

The result is not necessarily the same as a lender’s payoff quote or billing schedule. The calculator does not model daily interest accrual, variable rates, irregular payment dates, skipped or late payments, lender-specific rounding, fees added to the balance, or extra principal payments. It also does not determine taxes, insurance, or other amounts that may be collected with a payment. Get the actual rate, fees, payment timing, and loan terms from the lender’s disclosure before using figures for a real transaction.

Common Errors and Limits

• Entering APR in the wrong form: enter 8 for 8%, not 0.08. The formula divides the percentage by 1200 to get the monthly decimal rate.
• Confusing the payment with principal repayment: the scheduled payment includes both interest and principal; the entire payment does not reduce the balance.
• Using a different payment count: a five-year monthly loan has 60 payments, not five. A term stated in months must be converted consistently.
• Expecting exact agreement after rounding: the formula rounds the payment to cents, while a lender’s system may accrue and round interest differently. Small differences can accumulate, especially in the final payment.
• Assuming every loan amortizes evenly: interest-only periods, balloon payments, variable rates, and other structures do not follow this level-payment schedule.

APR is entered as the annual rate for this calculation, but this schedule uses a monthly rate equal to APR divided by 12. It is a stated mathematical assumption, not a complete model of every method a loan contract may use. The calculator provides an estimate, and the lender’s disclosure gives the exact figures.

Frequently Asked Questions

What is a detailed amortization schedule?
A table that breaks each scheduled loan payment into interest and principal and shows the balance remaining after the payment.

How do I calculate interest for each month?
Multiply the balance at the start of that month by the monthly rate, APR / 1200. The rest of the payment reduces principal under the assumptions used here.

Why does the principal portion increase over time?
With a fixed payment and rate, a lower outstanding balance produces less interest in each later period. More of the same payment can then go toward principal.

Does total interest include fees or insurance?
No. This calculator’s total interest is the rounded monthly payment times the number of payments, minus the original principal. It excludes fees, insurance, taxes, and escrow.

Will the calculated balance exactly match my lender’s balance?
Not always. Actual accrual dates, payment timing, rounding, fees, and loan-specific terms can change the figures. Consult the lender’s account information or disclosure for its exact schedule.

Related

• Amortization Schedule Monthly Payments Explained
• Amortization Schedule in Excel: Formula and Example
• Amortization Schedule Maker: Payments and Balance

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