Skip to content
Calculation

Calculating a business loan: payment, interest, principal — and what your bank reads from it

Calculating a business loan comes down to one core task: work out the periodic payment from the loan amount, interest rate and term — then understand how that payment splits into an interest portion and a principal portion. That result is exactly the number that feeds into debt service in every lending decision your bank makes.

This guide covers the formula behind the payment, a worked example with a full amortization schedule, how term and interest rate push the payment against each other — and what your bank reads from this calculation when it checks debt service capacity.

What “calculating a loan” means

Before any payment gets calculated, there’s usually a prior question: how much capital the project actually needs. That total comes from a capital requirements plan — only once it’s set does the financing plan decide how much of it gets covered by a loan.

On a typical business loan — an investment loan or term loan with a fixed maturity — you pay a periodic payment to the lender. That payment has two parts:

  • Interest portion: interest on the outstanding balance at the start of the period.
  • Principal portion: the amount that actually reduces the outstanding balance.

On the fixed-payment structure standard for business financing, the payment itself stays constant over the whole term. Because the outstanding balance falls with every principal repayment, the interest portion falls from period to period too — and since the total payment doesn’t change, the principal portion rises to compensate. Add interest and principal for one period and you get debt service — the same figure at the centre of calculating debt service capacity. For a short-term, fluctuating need, an overdraft facility is often the cheaper and more fitting tool instead, since it only charges interest on what you actually draw. If the loan amount isn’t paid out all at once but drawn down in tranches instead, the still-undrawn part often carries its own commitment fee.

Calculating the payment

The payment on a fixed-payment loan follows from three inputs: the loan amount (the starting balance), the periodic interest rate, and the number of periods. In every single period, the same simple mechanics apply:

FigureFormula
Interest portion, this periodOutstanding balance (start of period) × period interest rate
Principal portion, this periodPayment − interest portion
New outstanding balanceOutstanding balance (start of period) − principal portion

The payment itself is set so that the outstanding balance hits exactly zero after the final period — in practice your bank or an amortization calculator does this for you. What matters for understanding the mechanics is not the derivation of the formula, but the consequence: the interest/principal split shifts across the term even though the payment itself never changes.

Worked example

A worked example using generic illustrative figures (not real numbers): an investment loan of €100,000, interest rate 5% p.a., 5-year term, annual payment.

YearBalance, start (€)Interest (€)Principal (€)Balance, end (€)
1100,0005,00018,09781,903
281,9034,09519,00262,901
362,9013,14519,95242,949
Payment (fixed)about €23,097 per year

In the example, the payment stays at about €23,097 year after year. The interest portion falls from €5,000 in year 1 to €3,145 in year 3, while the principal portion rises over the same period from €18,097 to €19,952 — so the outstanding balance shrinks at an accelerating pace. After five years, the balance in this example reaches zero.

Term and interest rate: the trade-off behind the payment

Two levers determine how high the payment runs and how expensive the financing turns out overall:

A longer term lowers the periodic payment, because interest and principal are spread across more periods — that eases debt service in any given year immediately. In exchange, total interest paid over the full term rises, because the balance stays outstanding — and keeps accruing interest — for longer.

A higher interest rate pushes the payment in the same direction as a longer term: it raises both the individual payment and the total interest burden. The rate on offer, in turn, depends on creditworthiness and the collateral provided — including how convincingly debt service capacity can be demonstrated up front.

The “right” term is therefore not a mathematical optimum but a trade-off: as short as possible, to keep total interest cost down — but long enough that the resulting payment stays affordable from ongoing cash flow, without putting the rest of the liquidity forecast at risk.

What your bank reads from the calculation

For the bank, the calculated payment isn’t the point of the exercise — it’s the starting point of the actual test: it adds the interest and principal portions into debt service for the period and sets that against the business’s available cash flow — debt service capacity. If cash flow covers it with a visible buffer, that supports the financing; if the buffer is thin or missing, it affects the lending decision and terms, regardless of how cleanly the payment itself was derived.

Above a certain volume, a statutory duty kicks in too: under Section 18(1) sentence 1 KWG (the German Banking Act), a bank in Germany may only extend a loan exceeding €1,500,000 or 10 percent of its core capital if the borrower discloses its financial position — in particular by providing annual financial statements. What documents and figures the bank wants to see beyond that is covered in the financial status guide.

Debt service from real numbers, not an assumption

LiquidityLens sets debt service from your bank mirror against available cash flow from your real bank transactions — before you walk into the bank with a payment calculation.

See the Liquidity Control Sprint

The liquidity question: the payment alone isn’t enough

The payment, interest and principal calculation answers what a loan costs on average per year — not whether enough free cash is actually available on the specific due date for that payment. Interest and principal dates often fall quarterly or even monthly, while other payments fall due in the very same week.

That’s why the dates from the amortization schedule belong in the same 13-week cash flow forecast as every other receipt and payment — next to the available headroom from your bank mirror. Only once both sit side by side can you reliably tell whether a new loan is actually affordable without putting other due payments at risk. The debt service capacity calculator shows that buffer at a glance.

Free Excel template: 13-week cash flow forecast

Plan interest and principal dates alongside every other receipt and payment in one weekly grid — ready to use.

Get the free template

Frequently asked questions

The most important questions on calculating a loan repayment are gathered at the end of this page.

Frequently asked questions

What is the difference between the payment, interest and principal on a loan?
The payment is the amount you pay the lender each period. It has two parts: the interest portion, which covers interest on the balance still outstanding, and the principal portion, which actually reduces that balance. With a fixed-payment (annuity-style) loan, the payment stays constant over the term — only the split between the two parts shifts.
Why does the interest portion of a payment fall over the term?
Interest is always calculated on the current outstanding balance. Since principal repayments reduce that balance every period, the interest charged on it falls too — and because the total payment stays the same, the principal portion rises to make up the difference. Interest is highest at the start of the term and lowest at the end.
How does a longer term affect a business loan?
A longer term lowers the periodic payment, because interest and principal are spread over more periods — that eases debt service in any given year. In exchange, total interest paid over the life of the loan rises, because the balance stays outstanding, and accruing interest, for longer. The right term is always a trade-off between an affordable payment and the total cost of the financing.
What does a bank read from this calculation?
The bank adds the interest and principal portions together into debt service for the period and sets it against the business's available cash flow — the debt service capacity check. If cash flow covers it with a visible buffer, that supports the financing; if the buffer is thin or absent, it affects the lending decision and terms, regardless of how cleanly the payment itself was calculated.
Is there a German legal threshold for disclosing financial statements to a bank?
Yes. Under Section 18(1) sentence 1 KWG (the German Banking Act), a bank in Germany may only extend a loan exceeding €1,500,000 or 10 percent of its core capital if the borrower discloses its financial position — in particular by providing annual financial statements. Below that threshold, banks often still ask for the same documents in practice, just without that statutory requirement behind it.