EMI Calculator Repayment Schedule: Monthly Breakdown

An EMI calculator repayment schedule shows the fixed monthly instalment, total interest, and how each payment reduces the loan balance over time. Enter the loan amount, annual interest rate, and term to estimate the payment and total interest; the schedule is based on monthly payments and a fixed rate.

Formula

The level-payment EMI formula calculates the monthly instalment needed to repay principal and interest over a fixed number of monthly payments:

EMI = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the amount borrowed, in your currency.
• r is the monthly interest rate as a decimal: annual APR in percent ÷ 1,200.
• n is the number of monthly payments: loan term in years × 12.

The monthly EMI is rounded to two decimal places. Estimated total interest is EMI × number of payments − principal. Because this total uses the rounded monthly payment, it may differ slightly from an unrounded mathematical total or a lender’s final statement.

Worked Example

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

1. Monthly rate: 8 ÷ 1,200 = 0.0066667.
2. Number of payments: 5 × 12 = 60.
3. Apply the formula: 20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = 405.53 after rounding.
4. Total paid using that rounded EMI: 405.53 × 60 = 24,331.80.
5. Estimated total interest: 24,331.80 − 20,000 = 4,331.80.

The estimated monthly EMI is 405.53 in your currency, and estimated interest over the term is 4,331.80 in your currency. The calculator provides these totals, not a row-by-row amortization table.

Assumptions

• The interest rate remains fixed throughout the term.
• Payments are made monthly, at the end of each monthly period.
• Interest is calculated monthly using APR divided by 12.
• Fees, taxes, insurance, PMI, escrow, and other charges are not included.

What a Repayment Schedule Shows

A full repayment schedule, often called an amortization schedule, lists each payment period and separates the instalment into interest and principal. It also shows the remaining balance after the payment. In a standard fixed-rate loan, the EMI usually stays level, but its components change: early payments generally allocate a larger share to interest, while later payments allocate more to principal.

For a schedule row, the basic calculations are:

• Interest for the month: opening balance × monthly rate.
• Principal repaid: EMI − interest for the month.
• Closing balance: opening balance − principal repaid.

For example, with the default values, first-month interest is approximately 20,000 × 0.0066667 = 133.33. Subtracting that from the 405.53 EMI leaves about 272.20 to reduce principal, so the balance after the first payment is about 19,727.80. Minor differences can arise from rounding conventions; lenders may calculate interest daily or handle the final payment differently.

How to Read and Use the Estimate

Use the calculator to understand the relationship between principal, rate, and term, or to check the broad shape of a proposed fixed-payment loan. The EMI is a scheduled payment estimate, not a complete monthly housing or borrowing cost. For a practical comparison of figures, use the same principal, interest-rate basis, term, payment frequency, and fee treatment for each calculation.

• Enter the amount actually financed, rather than a purchase price if a deposit or down payment reduces borrowing.
• Use the annual APR supplied for the loan and confirm whether it is fixed or variable.
• Convert the term into years for this calculator; it multiplies years by 12.
• Check the lender’s payment date, rounding rules, and any separate charges against the estimate.

The calculator accepts a minimum APR of 0.01% because its formula divides by the monthly rate. It does not calculate a zero-interest loan; a zero-rate loan’s simple payment is principal divided by the number of payments. For a changing rate, irregular payment dates, an initial payment holiday, or additional repayments, a single fixed-rate EMI formula cannot reproduce the full schedule.

Common Mistakes and Limits

A frequent error is entering an annual percentage as if it were a monthly rate. Here, 8 means 8% per year, and the formula converts it to 8 ÷ 1,200 per month. Another mistake is confusing the EMI with the amount of principal repaid: the instalment includes both principal and interest.

Term length also matters. Holding the principal and rate constant, a longer term generally lowers each scheduled payment but increases the number of payments and can raise total interest. This is a mathematical effect, not a recommendation about which term to choose. The actual rate, fees, and payment terms must come from the lender’s disclosure; they are not inferred by this calculator.

Calculations are estimates because real loan agreements can use different day-count conventions, payment dates, rounding methods, fees, or final-payment adjustments. If you need the exact period-by-period balance, use the lender’s official repayment schedule and check how it treats extra payments or rate changes.

Frequently Asked Questions

What does EMI mean?
EMI means equated monthly instalment. It is a recurring payment intended to cover interest due for the period and part of the principal under a level-payment loan.

Does the EMI calculator show a full repayment schedule?
This calculator estimates the monthly EMI and total interest, but it does not print every monthly row. A full amortization schedule lists each period’s interest, principal repayment, and remaining balance.

Why does the principal portion increase over time?
For a standard fixed-rate loan, monthly interest is calculated on the outstanding balance. As payments reduce that balance, the interest portion tends to shrink; with a level EMI, more of the payment can then go toward principal.

Does a longer loan term reduce total interest?
Not necessarily. With principal and rate held constant, a longer term usually reduces the scheduled monthly payment but extends repayment and generally increases the total interest calculated under this formula.

Why might my lender’s EMI differ?
The lender may use a different rate, financed amount, term, compounding or day-count method, payment date, or rounding rule. Fees and other charges can also be separate from the EMI shown here.

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

Related

• BRAC Bank EMI Calculator: Estimate Monthly Payments
• EMI Calculator: Estimate Your Monthly Loan Payment
• EMI Calculator: Estimate Your Monthly Loan Payment

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 EMI | - | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2
out int | Total interest | - | pmt * yrs * 12 - p | 2