How to Read a Loan Amortization Schedule
By Prince Yadav, Founder & Lead Developer.
What a schedule shows
An amortization schedule lists each payment period and typically separates the payment into interest, principal repaid, and the remaining balance.
Interest is calculated on the outstanding balance
For a simple monthly example, a ₹100,000 balance at 1% monthly interest accrues ₹1,000 interest in the first month. If the payment is ₹4,000, ₹3,000 reduces principal and the new balance is ₹97,000.
Why the split changes
As the balance falls, the interest portion often falls too. If the scheduled payment stays the same, a larger share of later payments can go toward principal.
What assumptions can change the schedule
Payment timing, rate changes, fees, extra payments, rounding, and lender-specific rules can change the actual schedule. A standard calculator models only the assumptions and fields it supports.
Compare total cost as well as payment
A longer term can reduce each scheduled payment while increasing the number of interest-bearing periods. Review total interest and repayment amount, not just the first payment.
Worked example: follow one payment through the schedule
For a $10,000 balance at a 12% nominal annual rate with monthly payments, a simple monthly-rate estimate is 1%. The first month’s interest is about $100; if the payment is $300, roughly $200 reduces principal and the balance falls to about $9,800. Later interest is calculated on the lower balance, so the interest portion generally shrinks when the rate and payment stay fixed.
Reconcile the schedule with the lender
Real schedules may use daily interest, payment-date rules, fees, irregular first periods, rate changes, or rounding at each posting. Extra payments may be applied differently depending on the contract. Treat a calculator schedule as a model; compare its opening balance, rate, payment, and first interest charge with the lender’s statement before relying on the projected payoff date.
How to spot an implausible schedule
Check that the opening balance matches the loan, the first period’s interest is plausible for the rate and timing, and each payment reduces the balance when it exceeds accrued interest and charges. The final payment may differ slightly because of rounding; a large unexplained residual calls for reviewing the inputs.
Sources and further reading
- Consumer Financial Protection Bureau: how mortgage payments are calculated — U.S. mortgage education; actual loan terms and local rules vary.
Related Calculators
Use the Calculator
Try the worked-example inputs in Amortization Calculator, then change one assumption at a time to see what drives the result.
Open Amortization Calculator