How Loan EMI Works

A friend of mine once forwarded a car-loan offer and asked a single question: “They want €489 a month. Is that mostly interest?” The honest answer is that it depends on which month you mean. An equated monthly installment (EMI) is a fixed payment, but the ingredients inside it are not fixed. Early on, interest takes a large share. Later, principal does. That shift is amortization, and it is the whole point of this guide.

PercentBox’s loan calculator uses the standard fixed-rate formula so you can see the payment, the total interest, and a month-by-month schedule. It is an educational estimate. It does not know your lender’s fees, insurance, or a floating index.

What an EMI actually is

An EMI is one payment, due every month, sized so that a fixed interest rate and a fixed number of payments exactly pay the loan off. “Equated” means the payment amount stays the same. It does not mean each payment contains the same amount of interest.

Each month the lender does three things:

1. Compute interest on whatever you still owe.
2. Subtract that interest from your payment. The remainder reduces principal.
3. Carry the new, slightly smaller balance into next month.

Because the balance falls, next month’s interest is a little smaller, so a little more of the same payment hits principal. The pattern is slow at first and faster near the end.

People sometimes expect a loan to behave like a subscription: pay the fee, keep the thing. A loan is the opposite. You are buying back the principal you borrowed, and renting the unpaid part at the agreed rate until it is gone.

The formula, without the fog

If the annual nominal rate is R (as a percent), the monthly rate is r = R / 100 / 12. For n months and principal P, the payment M is:

M = P × r × (1 + r)^n / ((1 + r)^n − 1)

When r is zero, the payment is simply P / n. There is no interest to allocate.

Take a concrete personal loan: €25,000, 6.5% nominal annual interest, 5 years (60 months). The monthly rate is 0.065 / 12 = 0.00541666…. The formula produces a payment of about €489.15.

Check the first month by hand:

• Interest = 25,000 × 0.00541666… ≈ €135.42
• Principal = 489.15 − 135.42 ≈ €353.73
• New balance ≈ €24,646.27

Month two’s interest is charged on €24,646, not on €25,000, so it is a few euros smaller. Nothing dramatic happens in any single month. The drama is the sum.

A short amortization, then the ending

Figures are rounded to the cent for reading; a lender’s schedule may differ by a few cents because of their rounding rule. The shape is what matters. After a year you have paid about €5,870 and still owe about €20,700. You are not “halfway” in any sense that matches the calendar.

Over the full 60 months you pay about €29,349. Interest is the difference: about €4,349, or roughly 17% of the amount you borrowed, spread across five years. That is not the same thing as a 17% interest rate. The rate was 6.5% a year, charged on a shrinking balance.

Why the early months feel like “all interest”

They are not all interest — in the example above, principal is already the larger slice in month one — but interest is at its peak, and that feels wrong if you expected the payment to be a down payment on the car. The feeling comes from comparing the interest line with the purchase price in your head, not with the remaining balance.

A larger loan or a longer term makes the early interest share bigger. A €200,000 mortgage at 4% for 30 years has a payment near €955. First-month interest is about €667. Principal is only about €288. That really does look like “mostly interest,” and the math is doing exactly what the contract says.

Two consequences follow:

• Selling or refinancing early means you have repaid less principal than a straight-line guess suggests.
• The interest you will still pay is mostly a function of how long the large balance stays large.

Term length changes the total more than people expect

Same €25,000 at 6.5%, three different terms:

The seven-year payment is easier to fit in a monthly budget. The extra cost is a bit over €3,500 compared with the three-year loan. Neither choice is “wrong.” One buys a lower payment with future interest; the other buys less interest with a higher payment. The loan calculator is useful precisely when you want to slide the term and see that trade instead of trusting the headline installment.

Extra principal payments

Suppose that after month 12 you add €1,000 on top of the regular payment, and the contract applies it to principal. The balance falls by an extra €1,000 immediately. Every later month charges interest on a smaller number, so each regular payment retires principal a little faster, and the loan ends before month 60 if you keep the same installment.

A rough way to think about the saving: you avoid 6.5% a year on that €1,000 for as long as it would have stayed borrowed. It is not a perfect quote — the amortization curve is not a flat 6.5% of the extra amount for the original remaining term — but it stops the fantasy that “interest is already baked in, so overpaying does nothing.”

What the fantasy gets right is fees. Some personal loans, especially fixed-rate consumer credit in Europe, charge an early-repayment indemnity. If the fee is large, the interest you save can be partly eaten. Read the clause. A calculator cannot see it.

Also distinguish three actions people mix up:

• Paying the next installment early may not reduce interest at all if the lender just parks the money until the due date.
• Paying extra principal reduces the balance on which interest accrues.
• Shortening the term (recasting) lowers how long you pay; keeping the payment and the term the same is not always what the lender does by default. Ask which one your extra payment triggers.

Fixed rate, variable rate, and “I’ll just type Euribor”

The formula above assumes r never changes. A mortgage priced as Euribor plus a spread fails that assumption on purpose. If 12-month Euribor is 2.4% and the spread is 1.1%, today’s all-in rate is 3.5%. You can type 3.5 into a fixed calculator and get a payment that matches the current period. You cannot get a promise about next year’s Euribor.

A practical way to use the tool anyway:

• Run the payment at the rate in the offer.
• Run it again at the rate plus 2 percentage points, and at the rate minus 1, if you want a stress range.
• Compare the payments as a household-budget question (“could I still pay this?”), not as a forecast.

Percentage points matter here. A move from 3.5% to 5.5% is 2 percentage points, which is a 57% relative increase in the rate. The payment does not rise by 57%, because principal repayment is mixed into the installment, but it rises enough to surprise people who only looked at the relative wording in a headline.

What this calculator leaves out

A real annual percentage rate of charge (APR, or TAEG in Portugal and similar measures elsewhere) folds in certain fees so borrowers can compare offers. The nominal rate in the EMI formula does not. If one lender advertises 6.5% and another advertises 6.2% plus a €400 opening fee and mandatory insurance, the cheaper-looking rate can be the dearer loan. See APR versus interest rate for that distinction.

Also outside a simple schedule:

• Interest-only periods, balloons, and step payments
• Payment holidays that add unpaid interest back onto the balance
• Day-count conventions (some contracts accrue daily, not in neat twelfths)
• Taxes, stamp duty, or notary costs paid up front
• Inflation, which changes what the future payment feels like but does not change what you owe

If you are comparing a loan with saving the same monthly amount, the compound interest calculator is the other half of the picture. A loan’s interest is the price of having the money now. Compound growth is the price of waiting. They use related math and answer different questions.

Mistakes that throw the schedule off

Using the annual rate as the monthly rate. Dividing by 12 is required. Feeding 6.5% straight into the monthly formula inflates the payment into nonsense.

Confusing the payment with the cost. €489 × 60 is what leaves your account. Only €4,349 of that is interest. Quoting either number alone misleads.

Averaging the interest. “Half the term, so half the interest” is false. More interest is paid in the first half because the balance is higher.

Ignoring zero and negative nonsense. A zero term or a zero principal is not a loan. A negative rate is a different product. The calculator should refuse a broken input rather than invent a payment.

Treating the schedule as advice. A lower payment can be the right choice for cash flow and a poor choice for total cost, or the reverse. The table does not know your emergency fund, your job, or whether the purchase can wait.

When to use the loan calculator

Use it when you have a principal, a fixed annual rate, and a term, and you want the installment plus a picture of how interest and principal trade places. Use it to compare terms before you sit down with a lender. Use it to test an extra principal payment as a scenario.

Do not use it as a substitute for the European Standardised Information Sheet, a mortgage offer, or a variable-rate illustration. Do not use it to decide that a payment you can technically make is a payment you should make. When the rate can move, run more than one rate and read the contract’s revision rule.

The schedule is a story about a shrinking balance. Once you can see month one and month sixty side by side, the “why is it all interest?” feeling usually turns into a smaller, more useful question: how long do I want this balance to stay large?