How this instrument works
The equated monthly installment is the fixed payment a reducing-balance loan produces once you fix three numbers — the amount borrowed, the periodic rate, and the number of payments. It is called equated because every installment is the identical dollar amount from the first month to the last, even though interest is charged only on whatever balance remains, so the mix inside each payment shifts from mostly interest at the start toward mostly principal at the end. This sheet is the bare version of that arithmetic: Loan principal, $ goes in directly, with no price, down payment, or trade-in to net out first.
That bareness is the point. Other instruments on this site fold asset-specific inputs into the same formula — a car loan starts from price minus down payment minus trade-in, a bike loan from price minus down payment — because a buyer negotiates those separately. A personal loan, a gold loan, an education loan, or a business term loan usually starts from a principal already agreed with the lender, the figure printed on a sanction letter or loan agreement, which is exactly what Loan principal, $ expects. The term EMI itself comes from reducing-balance lending markets outside the US — India, the Gulf states, much of Southeast Asia — where it appears on loan paperwork the way 'monthly payment' or 'P&I' appears on an American one; the arithmetic underneath is identical either way.
This sheet prices principal and interest only, at a constant reducing-balance rate held flat for the whole term. Processing fees, credit insurance, late charges, prepayment penalties, and any step-up or floating-rate clause in a real loan agreement are outside what Equated monthly installment returns — a lender's actual demand can run higher once those are added, and a variable-rate loan's true installment will drift as the rate resets even though this sheet, run once, only ever shows one fixed number.
- Enter the amount actually advanced under Loan principal, $ — a figure already agreed with the lender, not a price you still need to net a down payment out of.
- Set the lender's yearly reducing-balance rate under Annual interest rate, % — convert first if you were quoted a flat rate instead.
- Enter the repayment length in months under Loan term, months.
- Read Equated monthly installment for the fixed sum those three inputs produce every month of the loan.
- Change principal, rate, or term one at a time to see which lever moves the installment most for your numbers.
Worked example — $500,000 over five years
Take the golden case this sheet defaults to: Loan principal, $ set to 500,000, Annual interest rate, % at 9, and Loan term, months at 60. The monthly reducing-balance rate is r = 9 divided by 1200, or 0.0075, and 1 plus r raised to the 60th power works out to about 1.565680. Multiplying principal by r and by that factor, then dividing by the factor minus one, returns an Equated monthly installment of $10,379.18 — the exact figure this instrument shows for those three inputs.
Stretch Loan term, months from 60 to 120 while holding the other two fields fixed and the installment falls to $6,333.79 — a smaller monthly figure bought by letting interest accrue for twice as long, not by the arithmetic simply halving. Double Loan principal, $ instead, to $1,000,000 at the original 60-month term, and the installment doubles cleanly to $20,758.36, because principal enters the formula as a plain multiplier while rate and term sit inside the compounding exponent — one scales the answer in a straight line, the other two do not.
Questions
Why does this calculator take a principal directly instead of a price and a down payment?
Because it is the bare version of the formula every specific-context EMI page on this site builds on. Bike EMI and car loan EMI subtract a down payment or trade-in from a price before touching interest, since a buyer negotiates those separately; a personal loan, gold loan, or business term loan usually starts from a principal already agreed with the lender — the number on the sanction letter — so this sheet asks for Loan principal, $ directly and skips a subtraction step that would not apply.
Should I type the rate as 9 or as 0.09?
Type it as a whole percentage — 9 for nine percent — into Annual interest rate, %. The formula already divides by 100 and by 12 to reach the monthly reducing-balance rate, so entering the decimal form instead understates that rate roughly a hundredfold and returns an installment barely above principal spread evenly across the term, a number that looks plausible but is wrong by thousands of dollars on a loan this size.
Is EMI the same thing US paperwork calls a monthly payment?
Yes, the arithmetic is identical — equated describes the fact that every installment is the same dollar amount even though the split between interest and principal inside it shifts each month as the balance falls. Reducing-balance lending markets outside the US print EMI on a loan's schedule; US paperwork usually just says monthly payment or P&I. Both name the output of the same formula shown above.
Why did doubling the loan term from 60 to 120 months not cut the EMI exactly in half?
Because term sits inside the exponent of the formula, not as a plain multiplier. At the default $500,000 and 9%, 60 months gives $10,379.18; doubling the term to 120 months drops it to $6,333.79 — a 39% cut, not 50% — since a longer term also keeps the outstanding balance higher for longer, so more total interest accrues even as each individual payment shrinks.
Does the EMI this sheet returns include fees, insurance, or a prepayment penalty?
No — Equated monthly installment covers principal and interest on Loan principal, $ only. Processing fees, credit insurance premiums, late charges, and prepayment penalties are contract terms a lender adds separately, and none of them are amortized into this figure; check the loan agreement for those line items and add them to what this sheet returns before comparing offers.
Why might a lender's quoted EMI differ from what this calculator shows for the same numbers?
Small differences usually come from rounding or a day-count convention — some lenders compute interest on an actual 365-day calendar rather than a flat monthly rate, nudging the figure by cents to a few dollars. A larger gap usually means the quoted rate is not the reducing-balance rate this formula expects, or fees have been folded into what they call the EMI; ask for the amortization schedule and compare it against this sheet line by line.
References
- Consumer Financial Protection Bureau — Understanding loan options
- Federal Reserve — Consumer Credit statistical release (G.19)
Read this first: This instrument shows arithmetic, not advice. Real offers add fees, taxes and terms that vary by lender and place — verify the figures against your actual paperwork before deciding anything.