Syntha Lab RU

Debt capacity: the largest loan for a target debt service coverage (DSCR)

From the cash flow available for debt service (CFADS: EBITDA minus taxes, the growth of working capital and maintenance capex) and a target DSCR it finds the largest annual payment, and from it the largest loan at your rate and term. It compares with the limit from the covenant “net debt ÷ EBITDA”, shows the DSCR for the loan you want to take, the repayment schedule and how much loan a mistaken reliance on EBITDA would give.

Cash and working capital For whom: Finance directors and owners preparing a talk with a bank about a loan.

Calculate on your data →

At a glance

What question does it answer?
What loan the business can bear at the target coverage and whether it will breach the covenant.
What data is needed?
EBITDA, taxes, working capital growth and capex for the year.
How to read the result?
First CFADS and the payment, then the smaller of the two limits; check the DSCR on a scenario with lower revenue. Example on the default values: Cash flow available for debt service (CFADS): RUB 24 million; Maximum payment per year: RUB 18.5 million; Maximum loan by coverage: RUB 54 million; Limit by the covenant: RUB 75 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

What a business can bear is set not by profit but by the cash flow after taxes, working capital growth and capex. In the example it is 24 m RUB; at a target DSCR of 1.3 the payment is at most 18.46 m RUB a year, and at 21% for 5 years it is a loan of up to 54.02 m RUB. Relying on EBITDA would give 67.52 m RUB: 13.50 m RUB more.

When to use it

Before talking with a bank, when choosing between a loan and a lease and when checking covenants.

How to read the result

Take the smaller of two limits: by coverage and by the covenant “net debt ÷ EBITDA”; then check the DSCR at a lowered EBITDA.

Common mistakes

The cash flow by EBITDA without taxes and working capital; DSCR without a written definition; yearly payments instead of monthly ones without a note.

What data is needed?

  • EBITDA, taxes, working capital growth and capex for the year.
  • The target DSCR, the rate and the term.
  • Net debt and the covenant from the contract.

Inputs

FieldUnitValue in the exampleMeaning
EBITDA per year₽30,000,000Operating profit before depreciation for the last 12 months or the plan. The example value is illustrative.
Taxes paid per year₽3,000,000Corporate income tax or the tax of the simplified regime that really leaves cash. Empty = 0, but then the capacity is overstated. The example value is illustrative.
Growth of working capital per year₽2,000,000How much cash the growth of stock and receivables net of payables tied up. If working capital was released, enter a minus. Empty = 0. The example value is illustrative.
Maintenance capex per year₽1,000,000Repairs and replacement of equipment and stores without growth. Empty = 0. The example value is illustrative.
Target DSCR×1.3The coverage the bank requires or you consider safe: cash flow ÷ payments per year. The exact requirement is written in the contract. The example value is illustrative.
Loan rate%21The annual rate. With a high key rate the loan is expensive and the capacity falls fast. The example value is illustrative.
Loan termyears5Payments once a year in equal parts (annuity). With monthly payments the capacity differs slightly. The example value is illustrative.
The loan you want to take₽40,000,000Needed for a check: what DSCR you will get. Empty = 0 (no check needed). The example value is illustrative.
Net debt now₽15,000,000Loans and borrowings minus cash on accounts. Empty = 0. The example value is illustrative.
Covenant: maximum net debt ÷ EBITDA×3The limit from the contract. 0 or empty: no covenant, the limit from it is not counted. The example value is illustrative.

How it is calculated

StepFormula
Cash flow CFADS30 m ₽ − 3 m ₽ − 2 m ₽ − 1 m ₽ = 24 m ₽
Maximum payment24 m ₽ ÷ 1.3 = 18.5 m ₽
Annuity factor(1 − (1 + 21%)^−5) ÷ 21% = 2.926
Maximum loan18.5 m ₽ × 2.926 = 54 m ₽
Limit by the covenantcovenant × EBITDA − net debt; the smaller of the two limits is taken
DSCR at a loanCFADS ÷ (loan ÷ annuity factor)

Worked numbers

Default values from the app; in the interactive version you enter your own.

Cash flow available for debt service (CFADS)
24 m ₽EBITDA − taxes − working capital growth − capex.
Maximum payment per year
18.5 m ₽CFADS ÷ the target DSCR.
Maximum loan by coverage
54 m ₽Payment × (1 − (1 + rate)^−term) ÷ rate.
Limit by the covenant
75 m ₽Covenant × EBITDA − current net debt.
Loan under both limits
54 m ₽The smaller of the two limits.
Interest in the first year
11.3 m ₽
Overpayment over the term
38.3 m ₽Payments over the term minus the loan itself (at the maximum loan by coverage).
Loan if EBITDA is used instead of CFADS
67.5 m ₽A typical mistake: taxes, working capital and capex are not subtracted.
DSCR at your loan
1.76×
DSCR by the bank definition at your loan
1.98×(EBITDA − taxes) ÷ payment, without working capital and capex: the definition from the metric passport.
Net debt ÷ EBITDA after the loan
1.83×
Debt balance by year, m RUB
Line chart: Balance: 54 → 00102030405060012345Balance, 0: 54Balance, 1: 46.9Balance, 2: 38.3Balance, 3: 27.9Balance, 4: 15.3Balance, 5: 0
Data as a table
MeasureBalance
054
146.9
238.3
327.9
415.3
50

Repayment schedule of a loan at the limit

YearPaymentInterestPrincipalBalance
118.5 m ₽11.3 m ₽7.12 m ₽46.9 m ₽
218.5 m ₽9.85 m ₽8.61 m ₽38.3 m ₽
318.5 m ₽8.04 m ₽10.4 m ₽27.9 m ₽
418.5 m ₽5.85 m ₽12.6 m ₽15.3 m ₽
518.5 m ₽3.2 m ₽15.3 m ₽0 ₽

What to do with the result: the talk with the bank goes from the sum under the smaller of the two limits and from the scenario “revenue −10%”: repeat the calculation with a lowered EBITDA and see whether the DSCR stays above one.

A typical mistake: counting the cash flow by EBITDA without taxes and working capital growth. Always write down the DSCR definition: the bank and the cautious ones give different numbers.

Nuances and limits

  • Counting the cash flow by EBITDA.
  • Not writing down the DSCR definition.
  • Forgetting the net debt covenant.

Terms used

Calculate on your data →