How this calculation works
Inspect how each scheduled instalment is divided between interest and principal. The EMI can stay level while the interest share changes because reducing-balance interest is charged on the opening balance. The month-by-month table makes the outstanding amount at an intermediate date visible. Flat mode instead keeps monthly interest based on original principal, so its schedule has a different shape.
Worked example
This example uses illustrative inputs. Your current result is shown above.
For ₹1,20,000 at 12% annual reducing-balance interest for one year, EMI is ₹10,661.85. First-month interest is ₹1,200 and principal reduction ₹9,461.85, leaving ₹1,10,538.15. Total interest across the twelve-payment schedule is ₹7,942.26; schedule totals retain unrounded internal values.
Assumptions and limits
- The rate, payment interval and interest method stay constant, with no missed or extra instalments.
- The schedule excludes fees and actual calendar day counts. Currency displays may not sum exactly when individually rounded rows are added.
Questions people ask
Why is first-month principal less than the EMI?
Part of the payment settles interest accrued on the opening balance. Only the remainder reduces the amount owed.
Can I insert a part payment into this schedule?
No. Use Loan Prepayment to model a selected lump sum after scheduled instalments and compare lower EMI with shorter tenure.