Covenant check: headroom to breach and EBITDA −X%
Calculates debt ÷ EBITDA, interest cover, DSCR, the current ratio and equity to assets, compares them with the contract thresholds, shows by how many percent EBITDA can fall before the first breach and which covenants break when EBITDA falls by X%.
At a glance
- What question does it answer?
- Whether the credit agreement conditions are met, by how much EBITDA can fall before the first breach and what breaks if it falls by X percent.
- What data is needed?
- EBITDA, interest, tax, CAPEX and debt repayment for 12 months.
- How to read the result?
- On the default data (Model B: EBITDA 35,048,000, net debt 9,649,000) debt ÷ EBITDA is 0.28×, interest cover 9.27×, DSCR by the bank definition 2.87×, the current ratio 4.28×, equity to assets 64.9%: no breaches. DSCR breaks first when EBITDA falls by 46.5% (to 18,753,000, headroom 16,295,000); at a 20% fall all five covenants are met. Under the cautious definition (also minus working capital growth of 6,125,000 and CAPEX) DSCR is 1.83×, the headroom 17.6%, and at a 20% fall it drops below the 1.2× threshold. 95,495,000 more can be borrowed before the 3× threshold. For “Model R” (EBITDA 34,800,000, interest 8,250,000, repayment 10,000,000) the bank DSCR is 1.69× with a headroom of 25.9%, the cautious one is 0.42×, already below the threshold. Example on the default values: Debt ÷ EBITDA: 0.28× · net debt; Interest cover (ICR): 9.27×; DSCR: 2.87× · bank definition; Current ratio: 4.28×. The figures are illustrative: enter your own to see your result.
Why and how to reason
A covenant is a condition in a loan agreement: if an indicator crosses a threshold, the bank may demand early repayment or change the terms. So it is important to know not only today’s values but also the headroom to breach. The calculation counts five indicators. Debt ÷ EBITDA: (24 − 14.35) ÷ 35.05 = 0.28 against a threshold of not above 3. Interest cover: 35.05 ÷ 3.78 = 9.3. DSCR (ability to service debt): (EBITDA − tax) ÷ (interest + repayment) = 28.03 ÷ 9.78 = 2.87. Current ratio and equity share. For each threshold the lowest EBITDA at which it still holds is found: for DSCR it is 1.2 × 9.78 + 7.02 = 18.75 million, so EBITDA can fall 46.5% before DSCR is the first to be breached. Additional debt up to the threshold is 95.5 million.
When to use it
It is useful before signing a loan, when reviewing an agreement and quarterly with reporting. It does not replace the text of the agreement: definitions of indicators (net or gross debt, bank or cautious DSCR) differ in each agreement, so choose them as in the contract. Assumptions: EBITDA, taxes and repayment over one period, the stress lowers only EBITDA, tax, working capital and investment stay the same.
How to read the result
Read in this order. First the number of breaches now (0) and under stress (0): if it is non-zero it is a signal to talk to the bank in advance. Then the EBITDA headroom to the first breach (46% or 16.3 million) and the name of that covenant: it is the main risk. Then additional debt to the threshold: it shows how much more can be taken without breaking terms, but it is an upper limit, not a plan. A headroom of 46% is large, so the scenario is calm, but make the stress stronger (EBITDA minus 40 to 50%) and see which covenant breaks.
Common mistakes
Typical trap: taking EBITDA not by the contract’s definition (with one-off items), counting net debt when the contract demands gross, forgetting working capital growth and investment in a cautious DSCR, not updating thresholds after a contract change. Check formulas against the text of the contract, not by habit.
What data is needed?
- EBITDA, interest, tax, CAPEX and debt repayment for 12 months.
- Closing balance sheet: loans, cash, current assets, current liabilities, equity, assets.
- Thresholds from the agreement, the debt definition (net or gross) and the stress size.
Inputs
| Field | Unit | Value in the example | Meaning |
|---|---|---|---|
| EBITDA | ₽ | 35,048,000 | Profit before interest, tax and depreciation as defined in your credit agreement (adjustments may apply). The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Interest payable | ₽ | 3,780,000 | Interest on loans for the period. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Corporate income tax | ₽ | 7,017,000 | Accrued or paid for the period (as in the agreement); enters DSCR. Check the rate and procedure with an accountant. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Capital expenditure (CAPEX) | ₽ | 4,000,000 | Spend on fixed assets for the period: stores, equipment, tooling; enters the cautious DSCR. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Growth of net working capital | ₽ | 6,125,000 | Receivables + net inventory + advances − payables − payroll − loyalty at the end minus at the start. Needed only for the cautious DSCR; in fashion it is the largest DSCR factor. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Principal repaid in the period | ₽ | 6,000,000 | Scheduled payments excluding interest; for a forward test take the next 12 months. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Loans and borrowings | ₽ | 24,000,000 | All debt to banks and lenders at period end. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Cash | ₽ | 14,351,000 | Cash at bank and on hand at period end. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Current assets | ₽ | 97,526,000 | Cash, receivables, net inventory, supplier advances. For footwear and children’s seasonal stock lifts the figure: take your own data. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Current liabilities | ₽ | 22,795,000 | Payables, payroll, taxes, loyalty liabilities and the part of the loans due within 12 months. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Equity | ₽ | 75,531,000 | Equity at period end per the balance sheet. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Total assets | ₽ | 116,326,000 | Balance sheet total at period end. The default comes from the end-to-end “Model B” (a brand, illustrative data). |
| Debt in the covenant | Net: loans minus cash | How debt is defined in the agreement: many agreements net cash but not all. See the definition in the contract text. | |
| DSCR definition | Bank: (EBITDA − tax) ÷ (interest + repayment) | How DSCR is defined in the agreement. The bank definition is softer; the cautious one shows whether cash suffices after the investment in stock and capex, it suits as an internal guide. | |
| Threshold: debt ÷ EBITDA at most | × | 3 | The value from the agreement. There is no single standard in Russia. The example value is illustrative. |
| Threshold: interest cover at least | × | 3 | EBITDA ÷ interest, the value from the agreement. The example value is illustrative. |
| Threshold: DSCR at least | × | 1.2 | Debt service cover, the value from the agreement. The example value is illustrative. |
| Threshold: current ratio at least | × | 1.2 | Current assets ÷ current liabilities. Seasonal stock makes the ratio higher than in other industries. The example value is illustrative. |
| Threshold: equity to assets at least | % | 30 | Equity share of assets. The example value is illustrative. |
| Stress: EBITDA fall | % | 20 | By how many percent to test an EBITDA fall (a worse season, FX, demand). Your scenario. The example value is illustrative. |
How it is calculated
| Step | Formula |
|---|---|
| Ratios | debt ÷ EBITDA; EBITDA ÷ interest; DSCR (bank: EBITDA − tax; cautious: also minus NWC growth and CAPEX) ÷ (interest + repayment); current assets ÷ current liabilities; equity ÷ assets |
| Lowest EBITDA | debt ÷ threshold; threshold × interest; threshold × (interest + repayment) + tax (+ NWC growth and CAPEX if cautious) |
| Headroom | 1 − lowest EBITDA ÷ EBITDA; the first to break is the covenant with the highest lowest EBITDA |
| Stress | EBITDA × (1 − X%), ratios recalculated, tax, NWC and CAPEX unchanged |
| Conclusion | the number of breaches now and under stress, headroom in percent and money |
Worked numbers
Default values from the app; in the interactive version you enter your own.
- Debt ÷ EBITDA
- 0.28× · net debtThe contract threshold; when EBITDA is not above zero the ratio is not defined and counts as a breach if there is debt.
- Interest cover (ICR)
- 9.27×
- DSCR
- 2.87× · bank definitionBank: (EBITDA − tax) ÷ (interest + repayment); cautious: also minus working capital growth and CAPEX.
- Current ratio
- 4.28×
- Equity to assets
- 64.9 %
- Covenants breached now
- 0 of 5
- Breached when EBITDA falls
- 0 · −20 % · EBITDA 28 m ₽
- EBITDA headroom to the first breach
- 46.5 % · DSCRBy how many percent EBITDA can fall while all three EBITDA-based covenants stay met.
- EBITDA headroom to the first breach, money
- 16.3 m ₽
- Extra debt before the debt ÷ EBITDA threshold
- 95.5 m ₽Plus: how much more can be borrowed; minus: by how much debt is above the threshold.
Covenants: value, threshold, stress
| Covenant and threshold | Value | Status | EBITDA fall to breach | Value under stress | Status under stress |
|---|---|---|---|---|---|
| Debt ÷ EBITDA ≤ 3× | 0.28× | met | 90.8 % | 0.34× | met |
| Interest cover ≥ 3× | 9.27× | met | 67.6 % | 7.42× | met |
| DSCR ≥ 1.2× | 2.87× | met | 46.5 % | 2.15× | met |
| Current ratio ≥ 1.2× | 4.28× | met | does not depend on EBITDA | 4.28× | met |
| Equity to assets ≥ 30 % | 64.9 % | met | does not depend on EBITDA | 64.9 % | met |
All covenants are met; the first to break is “DSCR” when EBITDA falls by 46.5 % (to 18.8 m ₽).
Take the definitions of EBITDA, debt and test dates, the cure right and the list of covenants from your agreement: check with a lawyer and the bank. The calculation does not replace the contract wording. Tax, NWC growth and CAPEX are held constant when EBITDA falls; the current ratio and equity are not recalculated under stress. Amounts excl. VAT.
Nuances and limits
- Take the definitions of EBITDA and debt from the agreement: the bank’s may differ from the management ones.
- Test forward: the repayments of the next 12 months, not the past ones.
- Seasonal footwear and children’s stock inflates the current ratio: read it together with turnover and not as a safety cushion.