Skip to content

Finance Tools

Loan Repayment Calculator

Work out the instalment, the total interest and the full repayment schedule for a business loan or asset finance, and convert a quoted flat rate into the reducing-balance rate that costs the same.

FreeNo signupRuns in your browser

Overview

Why calculate a loan repayment?

Enter the amount, the annual rate and the term to get the monthly instalment, the total interest and a month-by-month schedule showing where each payment goes. Add an overpayment to see what it removes from the term and from the interest.

The part worth the page, though, is the flat-rate conversion. Asset finance and short-term business lending are routinely quoted as a flat rate, which charges interest on the original amount for every month of the agreement, whether or not the balance has fallen. It is written in the same units as an ordinary rate (a percentage, per year), and it means something close to twice as much.

How much depends on the rate and the term together, and the figures are worth having concretely: over 60 months a 5% flat rate costs the same as 9.15% reducing, and over 36 months the same 5% flat comes to 9.31%. Both numbers come from this calculator, and a test checks them against the annuity formula rather than against a rule of thumb.

This works out the arithmetic of terms you have been offered, in the same way the VAT calculator works out tax. It is not advice about whether to borrow, and nothing you type is transmitted anywhere.

Step by step

How to work out a loan repayment

  1. Enter the amount, rate and term

    Type what is being borrowed, the annual interest rate you were quoted, and how many months the agreement runs for.

  2. Read the instalment and the total

    The monthly payment appears with the total interest and the total repaid. The total is the figure worth comparing between offers.

  3. Convert any flat rate you were quoted

    If a lender quoted a flat rate, enter it separately. It converts to the reducing-balance rate that would cost the same, which is usually close to double.

  4. Try an overpayment

    Add an amount to pay each month on top of the instalment to see how many months it removes and how much interest it saves.

What you get

  • Monthly instalment, total interest and total repaid
  • A full month-by-month schedule that ends at exactly zero
  • Flat rates converted to the reducing-balance rate that costs the same
  • What overpaying each month saves, in interest and in months
  • Names the final instalment, which is never quite like the others
  • Arithmetic on terms you were offered, not advice about borrowing

Background

Why the same rate can mean two different loans

Almost every loan you will meet charges interest on the outstanding balance. You borrow, you make a payment, part of it clears interest for that month and the rest reduces what you owe, so next month's interest is smaller, and the month after that smaller still. That is the reducing-balance arrangement, and it is what a rate normally means.

A flat rate does something different. It calculates the whole interest bill at the start, on the original amount, for the entire term, and then divides the total into equal instalments. In the last year of a five-year agreement you are still paying interest on money you repaid in the first, because the calculation never looked at your balance. Both are quoted as an annual percentage, and nothing in either number tells you which kind it is.

The gap is large and consistently in the same direction. Across the rates and terms businesses actually use, a flat rate converts to between roughly 1.6 and 1.95 times the reducing-balance rate that would cost the same. Where in that range depends on both: the multiple is closest to double at low rates, and falls steadily as the flat rate rises. So a lender quoting 6% flat against a bank's 10% is offering the more expensive deal, by a margin that is invisible unless you convert.

The reducing-balance structure also explains where each instalment goes, which is the other thing the schedule makes visible. Early payments are mostly interest and late ones mostly principal, because interest is charged on a balance that starts large. That is not a fee structure or a trick; it falls out of charging interest on what is owed. It does mean an overpayment early removes interest for every remaining month, while the same amount late removes almost none.

One small thing worth naming, because it looks like an error and is not. The final instalment is almost never identical to the others. A monthly payment is a rounded figure, so it cannot divide the debt evenly, and the last one is whatever clears the balance exactly. Real lenders do the same. A schedule that instead ends at a balance of a few pence either way is one built from floating-point arithmetic that nobody reconciled.

What none of this includes is fees. An arrangement fee, a documentation charge or a broker's commission is a real cost of borrowing and does not appear in an interest rate. That is what an APR is for: it folds the charges into a single comparable figure, which is why a loan's APR sits above its interest rate and why APR is the number to compare when you have it.

Not to be confused with

A reducing-balance rate
Interest charged on what is still owed, recalculated every month. What a rate ordinarily means, and what this calculator's main result assumes.
A flat rate
Interest charged on the original amount for the whole term, regardless of repayments. Common in asset finance, quoted identically to a reducing rate, and close to twice as expensive.
APR
The interest plus the compulsory charges, expressed as one annual figure. Always at or above the interest rate, and the right number to compare between offers when both lenders publish it.
The annuity formula
The arithmetic that finds the single instalment clearing both balance and interest over a fixed term. It cannot be rearranged to solve for the rate, which is why converting a flat rate needs a numerical search.
An amortisation schedule
The month-by-month split of each payment into interest and principal. The only view that shows how little of an early instalment touches the debt.
A balloon payment
A large final sum some agreements defer to the end, which lowers the monthly instalment without lowering the cost. Not modelled here: a schedule with one is not comparable to a schedule without.
Interest-only
Instalments that cover interest and nothing else, leaving the full balance due at the end. The monthly figure looks cheap because it is not repaying anything.

Reference

What goes into a repayment calculation

Three inputs produce the instalment, and a fourth changes what it costs. The one that most often turns out to mean something different from what the reader assumed is the rate.

  • The amount borrowed

    The sum advanced, after any deposit and before any fees added to the balance. A fee rolled into the loan is borrowed money and belongs in this figure.

    Required

  • The annual rate

    And, crucially, which kind it is. A reducing-balance rate goes in the main field; a flat rate goes in the comparison field, because putting one in the other understates the cost by nearly half.

    Required

  • The term in months

    How long the agreement runs. A longer term lowers the instalment and raises the total, which is the trade the two figures shown together are meant to make visible.

    Required

  • Any regular overpayment

    An amount paid on top each month. It comes entirely off the balance, so it removes interest for every month that follows. That is why it saves more than its face value.

    Optional

  • The total repaid

    Amount plus interest. The figure to compare between offers, because two loans with the same instalment over different terms are not the same loan.

    Optional

  • The final instalment

    Shown separately because it differs from the rest. Rounding means the regular payment never divides the debt evenly, so the last one clears whatever is left.

    Optional

  • What is not included

    Arrangement fees, documentation charges, broker commission, and any early-settlement penalty. All are real costs and none appears in an interest rate.

    Optional

Who it helps

Who needs a loan repayment calculator?

Small businesses buying equipment

Asset finance is where flat rates are most common, and where the quoted number is most likely to be compared against a bank rate it is not comparable with.

Anyone offered finance by a supplier

A dealer or supplier arranging the finance is quoting terms they chose. Converting the rate is a two-minute check on whether the convenience has a price attached.

Freelancers and sole traders

A vehicle, a machine or a piece of kit bought on finance is a fixed monthly commitment against variable income. The total repaid is the number that matters to that decision.

Bookkeepers and accountants

Asked regularly whether an offer is good. The schedule splits interest from principal month by month, which is also what the accounts need.

Anyone thinking about overpaying

Whether to put spare cash against a loan is a question the schedule answers directly: it shows how much interest a payment now removes, and how little the same payment removes later.

Anyone comparing two offers

Different terms and different rate structures make headline instalments meaningless. Total repaid, on the same amount, is the comparison that survives.

Do it properly

Best practices

  1. Ask which kind of rate you are being quoted

    Flat or reducing. Nothing in the number itself says, the difference is close to a factor of two, and the question takes one line in an email.

  2. Compare the total repaid, not the monthly payment

    A longer term always produces a smaller instalment and a larger total. Comparing instalments across different terms rewards the more expensive offer.

  3. Ask for the APR where one exists

    It folds the compulsory fees in, which an interest rate never does. Two APRs on the same amount and term are directly comparable in a way two interest rates are not.

  4. Overpay early or not at all

    The saving comes from removing interest on every remaining month, so a payment in year one is worth several times the same payment in year four. Check the early-settlement terms first.

  5. Add rolled-up fees to the amount

    A fee added to the balance is borrowed money that accrues interest like everything else. Leaving it out understates both the instalment and the total.

  6. Check the schedule ends where it should

    A schedule closing at anything other than zero means somebody built it in floating point. It is a small error and a reliable sign of how carefully the rest was done.

  7. Match the term to the life of what you are buying

    Financing a three-year machine over five years means paying for it after it has stopped working. The instalment looks better and the arrangement is worse.

Avoid these

Common mistakes

Comparing a flat rate against a reducing-balance rate

Convert first. Over 60 months a 5% flat rate is the equivalent of 9.15% reducing, so a 6% flat quote loses to a 10% bank rate despite looking like the better deal.

Choosing on the monthly payment

Look at the total repaid. Any offer can produce a smaller instalment by lengthening the term, and every month added increases what the loan costs in total.

Ignoring arrangement and documentation fees

Add them to the amount, or compare APRs instead. Fees do not appear in an interest rate, and on a short loan they can outweigh a difference of several points.

Assuming an overpayment always pays off

Check for early-settlement charges first. Where they exist, an overpayment can trigger a penalty that cancels the interest it saved: the arithmetic is only half the question.

Reading the odd final instalment as an error

Expect it. A rounded monthly payment cannot divide the debt evenly, so the last one clears the remainder. Lenders do exactly this, and a schedule that does not is the suspect one.

Treating an interest-only quote as comparable

Ask what is left at the end. Instalments that cover only interest look far cheaper because they repay nothing, and the full balance still falls due.

Stretching the term to make it affordable

Reconsider the purchase instead. If the instalment only works over a term longer than the asset's useful life, the term is not the thing that needs adjusting.

FAQ

Frequently asked questions

With the annuity formula: the instalment is the amount, times the monthly rate, divided by one minus (one plus the monthly rate) to the power of minus the number of months. It produces the single payment that clears both the balance and the interest over the term exactly.

A flat rate charges interest on the original amount for every month of the term, whether or not the balance has fallen, so in the final year you are still paying interest on money you repaid in the first. It is quoted in the same units as an ordinary rate and costs close to twice as much.

Between roughly 1.6 and 1.95 times, depending on the rate as much as the term: closest to double at low rates, and less as the flat rate climbs. Over 60 months a 5% flat rate costs the same as 9.15% reducing; over 36 months the same 5% flat comes to 9.31%. Both figures come from this calculator, and a test checks them against the annuity formula.

Because a monthly instalment is rounded to whole pence or cents, it never divides the debt evenly. The last one is whatever clears the balance exactly, which is how real lenders do it and why the schedule here ends on zero rather than on a few pence either way.

Yes, and by a lot. Interest is charged on what is still owed, so a payment made in month six removes interest for every remaining month, while the same payment in month fifty removes almost none. The schedule shows exactly where the split moves.

No. This calculates interest only. An APR also folds in arrangement fees, documentation charges and anything else the agreement requires, so a loan's APR is usually a little above its interest rate. Compare APRs between offers where you have them.

No. It works out the arithmetic of terms you have already been offered, in the same way the VAT calculator works out tax. Whether to borrow, and from whom, is a question for you and a qualified adviser.

Ready to run your numbers?

Loan Repayment Calculator is at the top of this page. Free, no signup, nothing uploaded.

Open the Loan Repayment Calculator