# The Covenant Compliance Handbook: companion files

Julian R. Sterling, julianrsterling.com/covenant-compliance

Covenant_Compliance_Workbook.xlsx rebuilds every figure of the book, from the add-back bridge of each test date to the combination of levers and amendment. Read its tabs in this order:

- Bridge: GAAP EBITDA to covenant EBITDA at each test date, the capped basket and the cap (chapters 3 and 4, exercises A.1 to A.3)
- Tests: net debt and the netting cap, net leverage, FCCR, ICR, liquidity, revolver usage and the capex cap by year (chapters 5 to 9, exercises A.4 to A.6)
- Headroom: headroom in turns, EBITDA cushion, cushion in percent and the internal alert (chapter 11, exercises A.7 to A.9)
- Forecast: eight quarters, base, downside and sensitivities, shortfall and capex room of year 4 (chapter 12, exercises A.10 and A.11)
- Levers: levers (a) to (c), the amendment and the combination, the equity cure both ways, amendment and waiver costs (chapters 13 to 15, exercises A.12 to A.14)

Each tab: inputs in blue, formulas in black, case values used by the checks in grey. Cell B2 of each tab counts the checks that fail, and Bridge!D2 adds the five tabs; send nothing to the agent while a count is above zero.
If a cell does not return the printed answer, find the first failing check on the earliest tab and fix the input, never the output. Replace the definitions first and the numbers second.

Dravenholt Industrial Services and everyone in the case are fictional. Every balance, rate, covenant level, cap, threshold and lever effect is a teaching assumption, not a market norm. Education only; not legal, accounting, tax or investment advice.
