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.
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
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| EBITDA per year | ₽ | 30,000,000 | Operating profit before depreciation for the last 12 months or the plan. The example value is illustrative. |
| Taxes paid per year | ₽ | 3,000,000 | Corporate 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,000 | How 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,000 | Repairs and replacement of equipment and stores without growth. Empty = 0. The example value is illustrative. |
| Target DSCR | × | 1.3 | The 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 | % | 21 | The annual rate. With a high key rate the loan is expensive and the capacity falls fast. The example value is illustrative. |
| Loan term | years | 5 | Payments 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,000 | Needed for a check: what DSCR you will get. Empty = 0 (no check needed). The example value is illustrative. |
| Net debt now | ₽ | 15,000,000 | Loans and borrowings minus cash on accounts. Empty = 0. The example value is illustrative. |
| Covenant: maximum net debt ÷ EBITDA | × | 3 | The 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
| Step | Formula |
|---|---|
| Cash flow CFADS | 30 m ₽ − 3 m ₽ − 2 m ₽ − 1 m ₽ = 24 m ₽ |
| Maximum payment | 24 m ₽ ÷ 1.3 = 18.5 m ₽ |
| Annuity factor | (1 − (1 + 21%)^−5) ÷ 21% = 2.926 |
| Maximum loan | 18.5 m ₽ × 2.926 = 54 m ₽ |
| Limit by the covenant | covenant × EBITDA − net debt; the smaller of the two limits is taken |
| DSCR at a loan | CFADS ÷ (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×
Data as a table
| Measure | Balance |
|---|---|
| 0 | 54 |
| 1 | 46.9 |
| 2 | 38.3 |
| 3 | 27.9 |
| 4 | 15.3 |
| 5 | 0 |
Repayment schedule of a loan at the limit
| Year | Payment | Interest | Principal | Balance |
|---|---|---|---|---|
| 1 | 18.5 m ₽ | 11.3 m ₽ | 7.12 m ₽ | 46.9 m ₽ |
| 2 | 18.5 m ₽ | 9.85 m ₽ | 8.61 m ₽ | 38.3 m ₽ |
| 3 | 18.5 m ₽ | 8.04 m ₽ | 10.4 m ₽ | 27.9 m ₽ |
| 4 | 18.5 m ₽ | 5.85 m ₽ | 12.6 m ₽ | 15.3 m ₽ |
| 5 | 18.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.