Free Excel templates

A free covenant compliance and headroom calculator in Excel

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.

Get the calculator

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

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.

1. Covenant EBITDA
GAAP EBITDA, uncapped add-backs, pro forma EBITDA of acquisitions, the capped basket against the cap, the allowed and the disallowed amounts.
2. Net leverage
Total debt, cash netted up to the netting cap, net debt, leverage against the maximum, headroom in turns, the EBITDA cushion in dollars and in percent, and the alert color.
3. Coverage, liquidity and capex
FCCR and ICR against their minimums, liquidity with letters of credit deducted, and the capex test against the room of the year.
4. Eight-quarter forecast
Covenant EBITDA and net debt by quarter for a base and a downside, leverage against the stepped maximum, the cushion, the breach flag and the shortfall if tested alone, as deemed EBITDA or as debt (only the first is a cure the case would allow).

What the worked case returns

MeasureValue
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 leverage5.65x against 6.50x
EBITDA cushion$7,520,814 (13.1 percent)
FCCR1.22x
ICR2.00x
Liquidity$43,528,156
Downside leverage, Q3 year 45.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

How to use it on your own case

  1. Read the definitions of your own agreement: what the add-back cap applies to, what counts as debt, whether cash is netted and up to what amount.
  2. Enter GAAP EBITDA for the LTM, your uncapped add-backs, any pro forma earnings and the capped basket, with the cap percentage your agreement sets.
  3. Enter debt, cash, the levels in force, interest, principal, capex and taxes, and read each test with its headroom.
  4. Fill the forecast rows from your budget and a downside you could defend, and read the first quarter that breaks.

Questions people ask

What does the covenant compliance calculator do?

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.

Does it apply the cap on add-backs?

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.

How do I use it on my own company?

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.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

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.

See the book and its free files →

Related reading and templates