Types of finance

How to calculate business loan repayments: formula and examples

You do not need a lender's calculator to know what a loan will cost each month. One formula covers most term loans, and a spreadsheet does the rest. This guide gives the formula, works it through at three terms, and shows how fees, flat rates and variable rates change the answer.

The Capzy teamBusiness finance brokers
Published 5 min readChecked against official sources
Capzbara, the Capzy mascot, moving beads on a wooden abacus beside a short row of plain coin stacks
The short answer

To calculate business loan repayments on a standard term loan, use the amortisation formula: monthly payment = P × r ÷ (1 − (1 + r) to the power of −n), where P is the loan, r the monthly rate and n the number of months. £50,000 at 9% a year over 3 years costs about £1,590 a month and £7,240 in interest, before fees.

At a glance

Repayment formula
P × r ÷ (1 − (1 + r)^−n)
£50,000 at 9% over 3 years
About £1,590 a month, £7,240 interest
Same loan over 5 years
About £1,038 a month, £12,275 interest
Bank of England Bank Rate, September 2026 decision
Held at 3.75%
What the APR must include on regulated credit
The total charge for credit, including compulsory fees

How do you calculate business loan repayments?

Most business term loans are repaid in equal monthly instalments, each covering that month's interest plus some of the capital. This is called an amortising or repayment loan, and one formula gives the instalment:

Monthly payment = P × r ÷ (1 − (1 + r)^−n)

  • P is the amount borrowed.
  • r is the monthly interest rate: the annual rate divided by 12, as a decimal. 9% a year is 0.09 ÷ 12 = 0.0075.
  • n is the number of monthly payments: 36 for three years.

In a spreadsheet, =PMT(0.09/12, 36, -50000) returns the same answer. Multiply the payment by n to get the total repaid, and subtract P to get the interest. The rate you are offered depends on your business and the lender; our guide to business loan interest rates explains what drives it. This page is about turning a rate into pounds.

What do the repayments look like at different terms?

£50,000 at an assumed 9% a year, monthly repayments
TermMonthly paymentTotal repaidTotal interest
2 years (24 payments)£2,284.24£54,821.69£4,821.69
3 years (36 payments)£1,589.99£57,239.52£7,239.52
5 years (60 payments)£1,037.92£62,275.07£12,275.07

Stretching the term from two years to five cuts the monthly payment by more than half but raises the interest by about £7,450. A shorter term costs less overall; a longer one is easier on monthly cash flow. Our guides to short-term business loans and long-term business loans cover when each fits.

An illustration, not a quote

9% is a round number chosen to show the arithmetic, not a market rate or any lender's price. Any offer is subject to status and lender criteria.

How much of each payment is interest?

Early payments are mostly interest; later ones are mostly capital. On the three-year example, month one's interest is £50,000 × 0.0075 = £375, so £1,214.99 of the £1,589.99 payment reduces the balance. Each month the balance is lower, so the interest share falls and the capital share rises.

  1. Interest this month = balance at the start of the month × r.
  2. Capital repaid = monthly payment less that interest.
  3. New balance = old balance less capital repaid.
  4. Repeat for each month to build the full repayment schedule.

This matters if you plan to settle early. After a year, the balance on the three-year loan is about £34,803, not two-thirds of £50,000, because the first year's payments were weighted towards interest.

How do you build a business loan repayment calculator in a spreadsheet?

Five columns are enough to build your own repayment calculator and see the whole schedule:

  1. Column A: month number, from 1 to the number of payments.
  2. Column B: opening balance. Month 1 is the loan; each later month is the previous closing balance.
  3. Column C: interest, the opening balance times the monthly rate.
  4. Column D: capital, the fixed payment from =PMT less the interest in column C.
  5. Column E: closing balance, the opening balance less the capital.
The first three months of £50,000 at 9% over 3 years
MonthOpening balanceInterestCapitalClosing balance
1£50,000.00£375.00£1,214.99£48,785.01
2£48,785.01£365.89£1,224.10£47,560.91
3£47,560.91£356.71£1,233.28£46,327.63

Fill the rows down to month 36 and the closing balance reaches zero. If it does not, check that the rate is monthly and the payment is the same in every row. Change the rate or term in one cell and the whole schedule updates, which makes it easy to compare two offers on the same sheet.

How do fees change the cost of a business loan?

An arrangement fee is either deducted from the advance or added to the loan. Either way it raises the true cost. If a 3% fee (£1,500) is deducted from the £50,000 three-year loan, you receive £48,500 but still repay £1,589.99 a month. The total cost in pounds becomes £8,739.52, and the annual percentage rate rises from about 9.4% to about 11.7%.

That is why the APR is a better comparison than the interest rate. Under the FCA's consumer credit rules (CONC App 1), the APR equates the present value of what you draw with the present value of everything you repay, including the total charge for credit: compulsory fees, and a broker's fee if the lender knows of it. Most lending to limited companies is not regulated, so ask the lender for the total repayable and work it out yourself. Our guide to APR explains it in full.

How do you calculate repayments on a flat-rate loan?

Some lenders quote a flat rate: interest is charged on the original amount for the whole term, even as you repay it. The sum is simple: total interest = P × flat rate × years. Monthly payment = (P + total interest) ÷ months.

£50,000 over 3 years: 9% amortising against 9% flat
Feature9% on the reducing balance9% flat
Total interest£7,239.52£13,500.00
Monthly payment£1,589.99£1,763.89
Equivalent APRAbout 9.4%About 17.5%

A factor rate works the same way as a multiplier: a factor of 1.2 on £50,000 means £60,000 to repay, however long it takes. Convert any flat or factor quote into a total repayable and an APR before comparing it with a term loan. Our guide on how to compare business loan lenders covers this in more depth.

What happens to repayments on a variable rate?

A variable rate usually tracks a reference rate such as the Bank of England's Bank Rate, which the Bank held at 3.75% in its September 2026 decision. The Bank says that when it raises Bank Rate, banks will usually increase how much they charge on loans. When the rate changes, the lender recalculates the payment on the remaining balance and term.

On the three-year example, if the rate rose from 9% to 11% after the first year, the payment would be recalculated on the £34,803 balance over the remaining 24 months: about £1,622 a month instead of £1,590, and about £770 more interest over the life of the loan.

Test the worst case

Before you sign a variable-rate loan, rerun the formula at a rate two or three points higher and check your cash flow can carry it. Capzy does not give financial advice.

Do all business loans use the same calculation?

  • Interest-only. You pay P × r each month and repay the capital at the end. Common on property and bridging finance.
  • Capital repayment holidays. Interest-only for a set period, then amortising over the rest of the term, so the later payments are higher.
  • Revolving credit. Interest is charged only on what you draw, so the payment changes with your balance. See our guide to the revolving credit facility.
  • Revenue-based repayments. A share of sales rather than a fixed amount, so there is no fixed monthly figure to calculate.
  • Asset finance. Similar to a term loan, but deposits and balloon payments change the sum. Our guide to asset finance repayments works through them.

How do you use the result?

Put the monthly figure into your cash flow forecast and check the business can pay it in a slow month, not just an average one. Then ask lenders for a written total repayable to compare with your own sums. Capzy is a credit broker, paid by the lender. You can check your eligibility with a soft search that does not affect your credit score, or browse more types of finance.

Sources

  1. CONC App 1.2: Total charge for credit and APR, Financial Conduct Authority
  2. The interest rate (Bank Rate), Bank of England

Capzy is a credit broker, not a lender. We get paid by the lender. This page is general information, not financial, tax or legal advice. Finance is subject to status, lender criteria and affordability; rates and terms depend on your circumstances.

Common questions

For an amortising loan, monthly payment = P × r ÷ (1 − (1 + r)^−n), where P is the loan, r the annual rate divided by 12 and n the number of months. In a spreadsheet, use =PMT(rate/12, months, -loan).
At an assumed 9% a year, about £2,284 over 2 years, £1,590 over 3 years and £1,038 over 5 years. Your rate depends on your business and the lender.
Usually yes. On £50,000 at 9%, interest is about £4,822 over 2 years and £12,275 over 5 years, even though the monthly payment is lower.
No. A flat rate charges interest on the original amount for the whole term. 9% flat over 3 years is roughly 17.5% as an APR, against about 9.4% for 9% on the reducing balance.
Many do not. Add any arrangement fee to the cost, and if it is deducted from the advance, remember you receive less than you repay on.
You can estimate the remaining balance from a repayment schedule, but the lender's settlement figure may include interest to a set date or an early repayment charge. Ask the lender for it in writing.

See what you could borrow

Free Funding Score in about 90 seconds, with no impact on your credit score.

Check my options
  • Free
  • No credit impact
  • About 90 seconds