How to Calculate EMI for a Loan (Formula, Worked Example, Excel)

The short answer

Take the loan amount, the annual interest rate and the term in years. Convert the annual percentage into a monthly decimal rate by dividing it by 100 and then by 12, and convert the term into a number of monthly payments by multiplying the years by 12. Feed those three values into the amortization formula and the result is your EMI.

The calculator linked on this page does exactly that: it computes the base EMI from principal, annual rate and term, then shows total payment and total interest. If you want to do it yourself once and understand it forever, the formula is one line and the worked example below takes five.

• EMI = P × r × (1+r)^n ÷ ((1+r)^n − 1).
• P is the loan amount; r is the annual rate ÷ 12 ÷ 100; n is the term in years × 12.
• Multiply the EMI by the number of months to get the total payment; subtract P to get total interest.
• The result is principal plus interest only — fees, insurance and taxes are extra, whatever the salesperson says.

The formula, symbol by symbol

The standard formula is EMI = P × r × (1+r)^n ÷ ((1+r)^n − 1). The calculator's own copy calls this "the standard amortization formula", and it is the same one banks, dealers and spreadsheet functions use. Here is what each symbol is.

P is the principal — the amount actually financed, not the sticker price. A 600,000 car with a 100,000 down payment has P = 500,000. r is the monthly interest rate written as a decimal. You take the quoted annual percentage, divide by 100 to make it a decimal, and divide by 12 to make it a monthly slice: an 8.5% annual rate becomes 0.085 ÷ 12, which is 0.0070833 with the 3 repeating forever. n is the total number of monthly payments: five years times twelve months, so 60 payments.

Why that shape? An amortized loan is defined by one condition: the value of all your payments, discounted back at the loan's own monthly rate, must exactly equal what you borrowed. Written that way the condition is P = EMI × (1 − (1+r)^−n) ÷ r. Multiply the top and bottom by (1+r)^n and you get the familiar EMI = P × r × (1+r)^n ÷ ((1+r)^n − 1). The (1+r)^n term is the whole story: it is the growth factor of one unit of money over the life of the loan, and it is why a small change in term changes the payment so much.

A note on r, because it is a convention and not a law. The quoted annual rate is treated as a nominal rate: the lender simply carves it into twelve identical monthly pieces. If an 8.5% annual rate instead meant the debt genuinely grows 8.5% over a year of monthly compounding, the true monthly rate would be 1.085^(1/12) − 1, about 0.0068215 — smaller than dividing 0.085 by 12, which yields 0.0070833 repeating. Dividing by 12 is the universal quoting convention because it matches how contracts define the periodic rate, but it means the real annual cost is higher than the headline: compounding 0.0070833 monthly gives an effective annual rate of roughly 8.84%. Run the example below with the 0.0068215 monthly rate and the payment comes out around 10,182.71 — about 75.55 less per month, purely from a different convention. Every mainstream calculator, including the linked one, divides the annual rate by 12.

A worked example, step by step

Loan: P = 500,000 at an 8.5% annual rate for 5 years. Worked by hand, with every intermediate number shown. Money is rounded to two decimals only at the display step and each rounding is flagged. The totals below follow the convention that a bank bills a payment rounded to cents, so they use 10,258.27; a calculation that never rounds mid-way ends at 615,495.94 and 115,495.94 instead — 26 cents apart.

• Monthly rate. 8.5 ÷ 100 gives 0.085. Then 0.085 ÷ 12 gives r ≈ 0.0070833, with the 3 repeating forever; exactly 17/2400.
• Number of payments. The term is 5 years and payments are monthly, so n = 5 × 12, which is 60.
• Growth factor. (1 + 0.0070833) raised to the power 60 is approximately 1.5273006, rounded to seven decimals here.
• Numerator. P × r × the growth factor comes to about 5,409.19.
• Denominator. Subtract 1 from the growth factor and you get roughly 0.5273006.
• EMI. 5,409.19 ÷ 0.5273006 ≈ 10,258.2657, so the monthly payment rounds to $10,258.27.
• Total payment. $10,258.27 × 60 = $615,496.20.
• Total interest. $615,496.20 − $500,000 = $115,496.20.

Sanity checks and common mistakes

Before trusting a number — yours, a spreadsheet's, or a lender's — run three checks against the worked example.

First month's interest is the whole balance times the monthly rate. On the example loan that is 500,000 × 0.085 ÷ 12, about 3,541.67. Since $10,258.27 − $3,541.67 = $6,716.60, only about 65% of your first payment actually reduces the debt; the rest is interest. If someone's EMI is barely above the one-month interest figure, the term is enormous or the rate is wrong.

Second check: the EMI must exceed the principal spread evenly, which is P ÷ n. Here that is 500,000 ÷ 60 ≈ 8,333.33, and the true EMI sits above it. An EMI below that line can never clear the loan.

Third check: total interest must be positive and total payment must exceed the principal. Any amortized loan with a positive rate has $615,496.20 > $500,000; if a quote fails this, the figures were not computed on the same terms.

When a number is wrong, it is almost always a unit error rather than a formula error. Work through this list before blaming the math.

• Term entered where months belong: n must be the number of payments. The tool takes years and multiplies by 12 itself; a spreadsheet needs years*12 written explicitly.
• Rate units: the calculator wants the annual rate as a percent (enter 8.5, not 0.085); Excel's PMT wants the decimal monthly rate (8.5%/12). Feeding the wrong unit shifts the answer by a factor of 100 in one direction or a catastrophic one in the other.
• Using the sticker amount instead of the financed amount — the down payment reduces P.
• Trusting a flat-rate number in an amortized formula, or vice versa (see the flat-rate section).
• Assuming the number is permanent: on a floating-rate loan the EMI is recomputed whenever the rate resets or the anniversary arrives.
• A 0% loan needs no formula at all: EMI = P ÷ n. Note that the linked calculator does not currently produce a result for a 0% rate — just divide principal by the number of months.

Calculating EMI in Excel or Google Sheets

Spreadsheets have a purpose-built function, and it agrees with the formula above: =PMT(rate/12, years*12, -P). For the example loan, =PMT(8.5%/12, 60, -500000) displays 10,258.27 once you show two decimals.

Two things trip people up. PMT expects the rate as a decimal, so 8.5% must be written as 8.5% (which Excel evaluates as 0.085) or 0.085 — typing 8.5 gives a payment calculated at 8.5% per month, which is astronomically wrong. And the principal is entered negative because PMT follows cash-flow sign: money you receive is positive and money you pay out is negative. Borrowing 500,000 is a positive inflow and the EMI is a negative outflow, so =PMT(8.5%/12, 60, 500000) displays −10,258.27 — the correct magnitude with the bank's perspective attached. Negate the principal in the argument and the result comes back positive and readable.

For splitting a single payment into its parts, use =IPMT(rate/12, period, total_months, -P) for the interest portion and =PPMT(...) with the same arguments for the principal portion. Month 1 of the example: =IPMT(8.5%/12, 1, 60, -500000) shows 3,541.67 and the matching PPMT shows 6,716.60 — the two always add up to the EMI, which is how you build the month-by-month schedule the linked calculator does not show: one column of IPMT, one of PPMT, one rolling balance.

For interest over a stretch of months, =CUMIPMT(rate/12, total_months, -P, first_month, last_month, 0) sums it up; pass 0 in the last argument to match a standard end-of-month loan. Feeding the whole term, =CUMIPMT(8.5%/12, 60, -500000, 1, 60, 0), comes back as 115,495.94 to the cent. That is 26 cents below the 115,496.20 in the hand-worked example because Excel never rounds the payment to cents mid-calculation — a rounding-at-the-end versus rounding-at-the-front difference, not an error in either.

Two useful reversals: =NPER(8.5%/12, -10258.27, 500000) tells you how many months a given payment clears the loan, and =RATE(months, -payment, P) × 12 recovers the true annual rate behind any quoted schedule — keep that one handy for the flat-rate section below.

The same math, different loans

The formula never changes; the loan products change what goes into it. Here is what typically varies for each common search, and what each product wraps around the EMI that the pure math does not see.

Car loan EMI

Secured by the vehicle itself, with the lender holding a lien until it is paid off. Tenors are short — a handful of years — so rates rarely float mid-loan on these products. Finance the drive-away price (after down payment, inclusions and registration), not the sticker price. Extra costs that sit outside the EMI: registration and title fees, road tax, insurance you are required to carry, processing fees, and prepayment penalties on some contracts.

Home loan EMI

The longest term in consumer lending, and EMI responds: the same principal stretched over decades turns a high total interest into a small monthly number. Rates commonly float with the lender's benchmark, so the calculated EMI is today's answer, not this contract's whole-life answer. The extras are the heaviest of any product: mortgage insurance or PMI when the down payment is small, stamp duty and registration, legal and valuation fees, closing costs, and then annual property taxes and home insurance that never enter the EMI at all. The calculator's own FAQ is blunt about this: "Additional costs like PMI…, property taxes, closing fees, or servicing charges are not included."

Personal loan EMI

Unsecured, so you pay a premium for the absence of collateral; terms are short to medium and the rate is usually fixed for the whole term. Watch the processing fee: it is commonly deducted from the disbursement, so you receive less cash than the sanctioned amount on which your EMI is calculated. Insurance is sometimes bundled and offered as a separate financed amount — treat it as its own loan and add the EMIs, do not blend them into one principal.

Education loan EMI

The distinguishing feature is the moratorium: interest may accrue while you study, either serviced or added to the principal. If it is capitalised, calculate the EMI on the accrued balance at the moment repayment starts, not on the amount originally disbursed — otherwise the schedule is understated. Larger amounts usually need collateral, smaller ones may not. Repayment terms can be long, so run the total-interest figure, not just the EMI, when comparing offers.

Business loan EMI

Underwriting looks at cash flow rather than a pay slip, and security often includes a personal guarantee. The important warning here is structural: many business facilities are bullet or interest-only loans, where you service interest monthly and repay the principal in one lump at maturity. The amortization formula simply does not apply to those — you cannot split a balloon payment into an EMI and call it equivalent. Confirm the product amortizes before using any EMI figure on it.

Gold loan EMI

Secured by pledged jewellery, with short tenors. The EMI math applies, but the real cost lives around it: valuation and refinement charges on the gold, storage or safekeeping fees, and periodic servicing charges. On default the lender can auction the pledged items, so factor the consequence, not just the rate. Interest-only structures are common here too — check whether the principal is amortizing at all before comparing an EMI with an interest figure.

Why the quoted EMI is not your monthly cost

Every product above comes with costs the formula cannot see. Processing fees are paid upfront (amortize them yourself: fee ÷ number of months, added to the true monthly cost). Required insurance either rides outside the EMI or gets financed into its own EMI. PMI, stamp duty, registration, closing costs, property taxes and servicing charges are simply not part of principal-and-interest math — and the linked tool says so: it "computes the base EMI using only principal, interest rate, and term", and the extras are "not included".

So treat any calculated EMI as the loan's principal-plus-interest component, then add the amortized extras to get a realistic all-in monthly figure. When comparing two offers, compare the all-in number and the total interest, because two lenders with identical headline EMIs can differ once fees and financed insurance are counted.

Flat rate vs amortized EMI: the number that misleads

Some lenders — typically for car loans, personal loans and gold loans — quote a flat rate: interest on the original principal for the full term, whether or not you have been repaying. Amortized math charges interest on the outstanding balance, which shrinks every month. The first repayment month alone shows why that matters: if you have paid back a sixth of the principal, you should owe interest on five-sixths of it, and a flat-rate quote ignores that entirely.

Worked through: borrow 120,000 for 3 years at a 10% flat rate. Interest is 120,000 × 0.10 for one year, which is 12,000, and over three years 36,000. Total repayment: 120,000 + 36,000 = 156,000. Divided into 36 monthly payments: about 4,333.33 a month. Now compute the same loan properly amortized at a 10% reducing rate, with the monthly slice 0.10 ÷ 12 over 36 payments: the EMI is about 3,872.06 — roughly 461 less every month.

The flat quote is not charging 10% on the outstanding balance; it is charging a much higher effective rate. The internal rate of the flat schedule above works out to about 1.493% per month, which annualizes to roughly 18% on a declining-balance basis — close to double the headline. Before signing, feed the quoted monthly payment back through =RATE(months, -payment, amount_financed) in a spreadsheet, multiply by 12, and compare that number with the advertised rate. This single check is the most valuable thing you will do on this page.

Reducing balance and the principal-only comparison

The linked calculator does one thing beyond the standard EMI: it also prices a principal-only (reducing-balance) plan for the same loan. In that plan you repay a fixed slice of principal every month — P ÷ n — plus interest on whatever balance remains. It is how some education and business loans are actually structured, and it is the benchmark against which an EMI looks expensive.

On the example loan the first principal-only payment is 500,000 ÷ 60 (about 8,333.33) plus interest of 3,541.67 on the full balance, totaling 11,875.00. That is higher than the 10,258.27 EMI, and it falls every month as the balance drops — by the final payment you are paying barely above the 8,333 principal slice. The EMI plan smooths that declining staircase into one flat figure.

The trade-off is visible in totals: total interest under the principal-only plan works out to roughly 108,021, against roughly 115,496 under the EMI plan — about 7,475 more interest for the privilege of a constant, budgetable payment. Both totals are rounded to the dollar here, from 108,020.83 and 115,495.94 unrounded. If cash flow lets you pay more early, a plan that front-loads principal is cheaper; the calculator shows both so you can see the gap on your own numbers rather than a salesperson's.

What the online EMI calculator does

The tool linked below takes three inputs — loan amount, annual rate in percent, and term in years — and runs the amortization formula shown on this page. You get the EMI, the total payment and total interest for the EMI plan, plus the principal-only plan's first payment and totals so you can see both structures side by side. Its copy describes the method as "the standard amortization formula", which is exactly what it is.

Know its limits before relying on it. There is no month-by-month amortization schedule — build one with the IPMT/PPMT columns described above if you need the per-month breakdown. There is no currency picker: the inputs are unitless amounts and the results are rendered as US dollars, so read the figures as units of your own currency. PMI, taxes, closing fees and servicing charges are not included, and nothing it prints is a bank-approved figure — real sanctions come from a lender after underwriting.

It runs entirely locally. In its own words: "This tool runs entirely in your browser. Your loan amounts, rates, and terms are never sent anywhere." Enter your three numbers, sanity-check the output against the worked example above, then take the EMI plus your amortized extras to whatever offer you are comparing.

Frequently asked questions