How to read an amortisation schedule — column by column

An amortisation schedule is the month-by-month ledger of a fixed-rate reducing-balance loan. LoanCalc Lab’s amortisation schedule calculator prints five columns: Month, Payment, Interest, Principal and Balance. This guide is the companion to that table — what each column means, how the rows link, and how to spot the interest-heavy front of the term without needing a separate narrative.

For the wider story of why interest dominates early and principal later, see Amortisation explained; for the EMI formula behind the Payment column, see How EMI works. Here we stay on the columns themselves, using one labelled UK EXAMPLE: Loan A (£8,500 · 24.9% EXAMPLE · 48 months · £0 fee). All figures are illustrative under LoanCalc Lab’s simple monthly reducing-balance model — not a live quote, not a credit offer, and not personalised advice.

Why the schedule exists beside the EMI total

A single monthly repayment figure answers “how much leaves the account each month?” It does not answer “how much of that cash is interest this month?” or “what balance is left after month 12?” Those questions need a row breakdown. The schedule is that breakdown: one line per instalment, with the payment split and the outstanding balance carried forward.

On a level-EMI loan the Payment column barely moves (aside from a possible final clearing row). The drama sits in Interest, Principal and Balance. Reading left to right — and then down the months — is how you see cost and payoff timing under stated assumptions.

Column 1 — Month

Month is the instalment index, starting at 1 for the first repayment after drawdown under the model’s assumptions. It is not a calendar date. Your lender’s statement may show due dates, payment holidays or a different first-interest period; the on-site table uses a simple “month 1, month 2, …” sequence so you can compare rows without hunting for dates.

Use the month number to ask timed questions: What does month 12 look like? When does principal first exceed interest inside the EMI? What balance remains at month 24? The index is the hook for those checks.

Column 2 — Payment

Payment is the cash applied that month — the EMI sized by the standard reducing-balance formula for the chosen principal, annual rate and term. For EXAMPLE Loan A that fixed payment is about £281.36 EXAMPLE each month.

Most rows show the same payment. The final month can be slightly different if rounding or a residual balance needs clearing so the loan ends at zero. Extra payments, if you model them elsewhere, change this column; the basic schedule tool assumes the contractual-style EMI with no extras and, for EXAMPLE Loan A, no fee rolled into the balance.

Reading tip: if every Payment cell looks identical, that is expected on a fixed EMI. Do not stop there — open the Interest and Principal columns to see what the same cash is doing.

Column 3 — Interest

Interest is the charge for that month on the outstanding balance at the start of the month. Under LoanCalc Lab’s simple monthly model:

Interest ≈ opening balance × (annual rate ÷ 12 ÷ 100)

For EXAMPLE Loan A at 24.9% EXAMPLE, month 1 interest is about £176.38 EXAMPLE on the full £8,500 opening balance — roughly 63% of the £281.36 payment. By month 24, interest has fallen to about £112.99 EXAMPLE; by the final month it is only about £5.72 EXAMPLE. The rate has not changed; the balance has.

That is why early rows look “expensive” even when the EMI is fixed: interest is always computed on what is still outstanding. The Interest column is the clearest place to see that front-loaded cost without summing the whole term first.

Column 4 — Principal

Principal is the slice of the payment that reduces the loan:

Principal = Payment − Interest

In month 1 of EXAMPLE Loan A, principal is only about £104.99 EXAMPLE — less than the interest slice. By month 16 EXAMPLE, principal (≈ £142.87) overtakes interest (≈ £138.50) inside the same EMI for the first time in this EXAMPLE. By month 48 EXAMPLE, almost the entire payment is principal (≈ £275.64).

Reading tip: scan Principal down the table. When it climbs past Interest, you have crossed the point where each instalment is mostly clearing debt rather than servicing the balance. That crossover month depends on rate and term; it is not a universal calendar milestone.

Column 5 — Balance

Balance is what remains after that month’s principal is applied:

Closing balance = opening balance − Principal

Next month’s Interest is calculated on this closing figure. For EXAMPLE Loan A: after month 1 the balance is about £8,395.01 EXAMPLE; after month 12 about £7,085.96 EXAMPLE (most of the original £8,500 still outstanding after a year of EMIs); after month 24 about £5,276.72 EXAMPLE; and after month 48 £0.00.

The Balance column answers “how much of the loan is left?” at each step. Pair it with Interest: a high balance and a high rate produce a large interest cell next month. That linkage is the whole reducing-balance idea in one glance.

Worked EXAMPLE — Loan A rows to practise on

All figures below are labelled EXAMPLE. Inputs: £8,500 principal · 24.9% EXAMPLE annual rate · 48 months · £0 arrangement fee. Fixed EMI ≈ £281.36 EXAMPLE; total repayable ≈ £13,505.36 EXAMPLE; total interest ≈ £5,005.36 EXAMPLE. Snapshot rows (rounded to the nearest penny):

• Month 1 EXAMPLE: Payment £281.36 · Interest ≈ £176.38 · Principal ≈ £104.99 · Balance ≈ £8,395.01
• Month 2 EXAMPLE: Interest ≈ £174.20 · Principal ≈ £107.17 · Balance ≈ £8,287.85 — interest edges down as the balance falls
• Month 12 EXAMPLE: Interest ≈ £149.76 · Principal ≈ £131.60 · Balance ≈ £7,085.96
• Month 16 EXAMPLE (crossover): Interest ≈ £138.50 · Principal ≈ £142.86 — first month in this EXAMPLE where principal exceeds interest
• Month 24 EXAMPLE: Interest ≈ £112.99 · Principal ≈ £168.38 · Balance ≈ £5,276.72
• Month 36 EXAMPLE: Interest ≈ £65.93 · Principal ≈ £215.43 · Balance ≈ £2,961.84
• Month 48 EXAMPLE (final): Interest ≈ £5.72 · Principal ≈ £275.64 · Balance £0.00

Open the amortisation schedule with the same EXAMPLE Loan A defaults and match these cells. Change one input at a time (rate, term or amount) and watch which columns move most — usually Interest and Balance early on, Principal later.

A short reading checklist

• Confirm Payment is the EMI you expect for the inputs (and note any final clearing row).
• Check month 1 Interest ÷ Payment — a high share means a high opening balance relative to the rate, not a “broken” table.
• Find the first month where Principal > Interest (the crossover in this EXAMPLE is month 16).
• Read Balance at month 12 and month 24 — calendar halfway is not the same as half the principal cleared when interest is front-loaded.
• Treat penny differences vs a lender printout as normal under different day-count and rounding rules.

UK disclosures — totals and APR sit beside the path

Regulated UK consumer-credit advertising and agreements use cost-of-credit disclosures — including the APR and the total amount payable — so borrowers can compare products on more than a monthly instalment alone. The FCA’s Consumer Credit sourcebook sets out how the total charge for credit and APR are determined for regulated agreements (FCA Handbook, CONC App 1). MoneyHelper explains common ways to borrow, including personal loans with fixed monthly repayments, and stresses comparing options on more than the instalment alone (MoneyHelper — Options for borrowing money). An amortisation schedule does not replace those disclosures; it shows the month-by-month path of interest and principal that produces the totals under a stated model. LoanCalc Lab is not a lender and does not replace the lender’s figures.

Try the schedule tool

Load EXAMPLE Loan A (£8,500 · 24.9% EXAMPLE rate · 48 months · £0 fee) in the amortisation schedule calculator, then use this column guide while you scroll the preview. For the EMI total, total interest and total repayable on the same inputs, open the personal loan / EMI calculator. For the narrative of interest vs principal over the full term, return to Amortisation explained. The point of the pair is clearer payoff maths under labelled assumptions — not a sales pitch for any particular loan.

Disclaimer

This guide and all EXAMPLE figures are illustrative only. They are not personalised financial advice, not a credit offer, and not a recommendation to take any loan. LoanCalc Lab is not a lender. Rates, fees, day-count conventions and early-settlement terms vary by product and lender. Always read the lender’s disclosure and regulated pre-contract information for your circumstances before you borrow.