A loan EMI table shows the estimated fixed monthly instalment (EMI) for a loan and, in an amortization version, how each payment is divided between interest and principal. Enter the loan amount, annual interest rate and term in the calculator to see the monthly payment and total interest; the worked example below shows how to read those figures.
Formula
For a fixed-rate loan with equal monthly payments, the payment is calculated as:
EMI = P × r ÷ [1 − (1 + r)−n]
- P is the amount borrowed, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1200 when APR is entered as a percentage per year.
- n is the number of monthly payments: loan term in years × 12.
- EMI is the level monthly payment, in dollars.
The calculator’s total-interest estimate is monthly payment × number of payments − principal. It uses the displayed payment rounded to cents, so its total may differ slightly from a lender’s figures if the lender uses more precise payment amounts or a different schedule.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR and a five-year term:
- Convert the APR to a monthly decimal rate: 8 ÷ 1200 = 0.0066667.
- Find the number of monthly payments: 5 × 12 = 60.
- Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)−60].
- The monthly payment is $405.53, rounded to cents.
- Total of the rounded payments: $405.53 × 60 = $24,331.80. Estimated total interest: $24,331.80 − $20,000 = $4,331.80.
Assumptions
- The interest rate stays fixed for the full term.
- Payments are made monthly at the end of each payment period.
- Interest compounds monthly at APR ÷ 12.
- Fees, taxes, insurance, PMI and escrow are not included.
What a Loan EMI Table Shows
A basic EMI table lists the loan amount, interest rate, term, monthly instalment and often the total paid or total interest. An amortization table adds a row for each payment date or month. Each row can show the opening balance, interest charged, principal repaid, payment amount and remaining balance.
At the beginning of a standard amortizing loan, the balance is relatively large, so more of a level payment generally goes toward interest. As principal is repaid, the balance falls and the interest portion usually shrinks; the principal portion grows. The monthly payment can remain unchanged even though its components change. In the final period, rounding or lender-specific adjustments may make the last payment differ slightly.
The calculator here gives the payment and aggregate interest, not every row of a full schedule. A detailed table requires applying the balance calculation repeatedly using the lender’s actual payment dates, rate conventions and rounding rules.
How to Use the Estimate
- Loan amount: enter the principal being financed, not automatically the purchase price. Down payments, trade-ins or amounts rolled into financing can change the actual principal.
- APR: enter the annual percentage rate supplied for the loan. The example’s 8% is only a calculation input, not a statement about available rates. Obtain the rate and any fee information from the lender.
- Term: enter the repayment period in years. A five-year term represents 60 monthly payments under this model.
- Read the outputs: the first result is the estimated monthly payment; the second is estimated interest over the scheduled term. Add the principal to the interest to see the estimated sum of payments.
To compare scenarios arithmetically, change one input at a time and note what changed. A longer term usually spreads repayment over more months and can reduce the calculated monthly instalment, while increasing the number of periods over which interest is charged. A shorter term has fewer payments but can have a higher monthly instalment. These are formula outcomes, not a judgment about which borrowing arrangement is suitable.
Common Sources of Differences
An EMI table is an estimate, not necessarily the lender’s payment quote. A common mistake is entering a monthly rate as if it were an annual APR, or entering 8 when the calculator expects 0.08%; this calculator expects a percentage such as 8 for 8% per year. Another is treating the loan term as months when the input asks for years.
Actual schedules can also differ because of fees included in the financed balance, variable rates, payment dates that do not fall at regular monthly intervals, daily interest accrual, payment rounding, or a final adjustment. An APR and a nominal interest rate may be defined or presented differently in loan documents; use the lender’s stated figure and check what it includes. Taxes, insurance and escrow may be collected alongside a loan payment but are not part of this principal-and-interest formula.
Extra payments are not modelled. If an extra amount is applied directly to principal, it can change the remaining balance and payoff timing, but the result depends on how the lender processes that payment. A refinance or rate change likewise requires a new calculation using the updated balance, rate, term and any relevant costs.
Limits of the EMI Formula
The standard formula assumes a fixed rate, equal monthly payments, a fully amortizing balance and regular periods. It is not a fit for interest-only arrangements, balloon payments, payment holidays, irregular instalments or rates that change during repayment without additional modelling. The result also cannot determine lender fees, approval, or a borrower’s overall budget. Check the loan disclosure or repayment schedule for the contractual payment and the lender’s exact assumptions.
Frequently Asked Questions
What does EMI mean?
EMI means equated monthly instalment: a scheduled monthly payment that is generally level for a fixed-rate, fully amortizing loan. It combines interest and principal, although their shares change over time.
How do I calculate EMI from a loan amount?
Convert the annual APR to a monthly decimal rate by dividing the percentage by 1200, convert the term to months, and use the formula shown above. The calculator performs those steps and rounds the payment to cents.
Does an EMI include fees and insurance?
Not in this calculation. It estimates principal and interest only. Check the lender’s quote to see whether fees are financed or whether taxes, insurance or other charges are payable separately.
Why does an EMI table show more interest at the start?
Interest for each period is calculated on the outstanding balance. The balance is generally highest at the start, so the interest share of a level payment is typically larger then and falls as principal is repaid.
Is the EMI always the same?
It is level under the fixed-rate assumptions used here. A changing rate, irregular payment schedule, extra payments or lender adjustments can change the amount due or the payment breakdown.
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
- Secured Loan for Home Refinancing: Payment Calculator$405.53
- Closing Costs on a House Loan: What to Expect$405.53
- Closing Cost House Calculator: Estimate Buyer Costs$8,500.00
- Closing Cost House Estimate Calculator
- Loan Repayment Extension Request Letter: What to Include$405.53
- Refinance Calculator With PMI and Loan Term