One compliance certificate from GAAP EBITDA to covenant EBITDA with the cap on add-backs, net debt with a netting cap, net leverage, FCCR, ICR, minimum liquidity and capex, the headroom in amount and in percent, and an eight-quarter forecast with the shortfall at each breach, tested alone.
A sponsor-owned company signs its Q4 year 3 (year-end) certificate at 5.65x net leverage against a maximum of 6.50x, after $979,850 of add-backs fell above the cap. The cushion is $7,520,814, 13.1 percent of covenant EBITDA. Three quarters later, in the downside, the step-down to 5.75x breaks it. The calculator rebuilds both on one sheet, ready for your own numbers.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Covenant_Compliance_Headroom_Calculator.xlsx (13 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This calculator is a simplified version of the companion workbook of The Covenant Compliance Handbook, which builds covenant EBITDA from the add-back file, tests every covenant at nine test dates, follows the certificate to signature, forecasts eight quarters with a downside and sensitivities, and prices operating levers, an equity cure, a waiver and an amendment.
One sheet in four blocks. Inputs are blue; everything else is a formula, every division is guarded against a zero divisor, and the last block counts the checks that fail.
| Measure | Value |
|---|---|
| GAAP EBITDA, LTM | $44,219,500 |
| Cap on the capped add-backs | $4,020,150 |
| Disallowed above the cap | $979,850 |
| Covenant EBITDA | $57,622,150 |
| Net debt | $325,658,685 |
| Net leverage | 5.65x against 6.50x |
| EBITDA cushion | $7,520,814 (13.1 percent) |
| FCCR | 1.22x |
| ICR | 2.00x |
| Liquidity | $43,528,156 |
| Downside leverage, Q3 year 4 | 5.87x against 5.75x |
| Equity cure at Q3 year 4, deemed EBITDA (the case's clause) | $1,194,125 |
| Same test, debt prepayment (comparison only) | $6,866,218 |
It recomputes one compliance certificate, the year-end certificate of the case, from its components, measures the headroom on net leverage in turns, in EBITDA and in percent, and carries leverage eight quarters out in a base and a downside, with the shortfall at each breach, tested alone.
Yes. The cap is a percentage of covenant EBITDA before the capped add-backs, the basket is compared with it, and the disallowed amount stays visible.
Read your agreement's definitions first, then replace the blue inputs: GAAP EBITDA, the add-backs, debt, cash, the netting cap, the levels and the forecast rows. Then delete the checks that tie the file to the book's case.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
The free workbook of The Covenant Compliance Handbook goes further: nine test dates, the capex cap by year, sensitivities, three operating levers, the amendment and the combination recomputed together.