Tracks financial covenant compliance with calculation methodology and certification requirements. Use when monitoring covenants, calculating compliance metrics, or preparing compliance certificates.
Assessing the impact of a proposed transaction (acquisition, dividend, capex) on covenant headroom
Responding to a lender inquiry or waiver request triggered by a covenant breach or near-miss
Onboarding a new credit facility and building the initial covenant tracking framework
Inputs To Gather
Credit agreement (or indenture): Full executed document including all amendments, waivers, and side letters — focus on the definitions section and financial covenant article
Financial statements: Most recent quarterly/annual financials (income statement, balance sheet, cash flow statement) on the basis specified in the agreement (GAAP, IFRS, or adjusted)
Permitted adjustments schedule: Pro forma adjustments, add-backs (e.g., non-cash charges, restructuring costs, acquisition synergies), and any lender-approved modifications to standard definitions
관련 스킬
Prior compliance certificates: Last 2-4 certificates to confirm calculation methodology continuity and catch definitional drift
Debt schedule: Outstanding principal, drawn revolver balances, letters of credit, and any off-balance-sheet obligations that count toward indebtedness definitions
Material pending transactions: Any signed LOIs, board-approved capital plans, or dividend declarations that could affect forward-looking compliance
Workflow
Extract covenant definitions — Pull each financial covenant from the credit agreement (e.g., Maximum Total Leverage Ratio, Minimum Interest Coverage Ratio, Minimum Consolidated Net Worth, Maximum Capital Expenditures). Map every defined term back to its contractual definition — do not substitute standard textbook definitions. Note any "stepping" thresholds that tighten or loosen over the facility term.
Build the calculation model — For each covenant, construct the numerator and denominator using the agreement's definitions:
Identify the measurement period (trailing four quarters, single quarter, rolling twelve months) [VERIFY against agreement]
Determine whether Consolidated EBITDA uses the agreement's specific add-back/exclusion list or a generic proxy
Apply permitted pro forma adjustments for acquisitions/dispositions completed during the measurement period
Flag any "equity cure" or "EBITDA cure" provisions that allow equity contributions to count toward compliance
Run compliance calculations — Populate each ratio using the gathered financial data:
Total Leverage Ratio = Consolidated Total Debt / Consolidated EBITDA (per agreement definition)
Interest Coverage Ratio = Consolidated EBITDA / Consolidated Interest Expense
Minimum Liquidity = Unrestricted Cash + Available Revolver Capacity
Maximum Capex = Year-to-date capital expenditures vs. annual cap (note any carryover provisions)
Assess headroom and risk — For each covenant:
Calculate absolute headroom (how far the actual ratio is from the threshold)
Express headroom as a percentage cushion and as a dollar-equivalent sensitivity (e.g., "EBITDA could decline by $X before breach")
Identify which covenants are tightest and most at risk of breach in the next 1-2 periods
Model stress scenarios: revenue decline of 10-20%, margin compression, or incremental debt from a pending transaction
Prepare the compliance certificate — Draft or review the officer's certificate in the form required by the credit agreement:
Confirm the reporting period and delivery deadline [VERIFY — typically 45-60 days after quarter-end, 90-120 days after fiscal year-end]
Attach detailed calculations showing each step from financial statements to final ratio
Include a representation that no Default or Event of Default has occurred and is continuing (or disclose any exceptions)
Obtain appropriate officer signature (usually CFO or Treasurer)
Escalate if breach is likely — If any covenant is at risk:
Notify treasury, legal, and senior management immediately
Evaluate remediation options: equity cure, asset sale proceeds, EBITDA add-back reclassification, or operational changes
If breach is unavoidable, prepare a waiver or amendment request to the administrative agent with supporting projections showing a return to compliance
Document the timeline — most agreements provide a cure period of 15-30 days after delivery of the compliance certificate [VERIFY]
Output
Covenant compliance summary table: Each covenant, its contractual threshold, calculated actual result, pass/fail status, and dollar headroom
Detailed calculation workpapers: Step-by-step build from financial statements to each ratio, with line-item references and adjustment footnotes
Headroom sensitivity analysis: Stress-tested scenarios showing how much key drivers (revenue, EBITDA, debt) can move before triggering a breach
Draft compliance certificate: In the form attached as an exhibit to the credit agreement, ready for officer review and signature
Risk flag memo (if applicable): Summary of any covenant trending toward breach, recommended remediation actions, and proposed lender communication strategy
Quality Checks
Every defined term in the calculation traces back to a specific section of the credit agreement — no substituted or assumed definitions
Add-backs and exclusions match the permitted adjustment list exactly; no unapproved items included
Measurement periods align with the agreement (LTM vs. single quarter vs. fiscal year) and pro forma adjustments use the correct acquisition/disposition dates
Calculations tie to the audited or reviewed financial statements; any management adjustments are clearly labeled and supportable
Prior-period calculations are consistent — if methodology changed, the reason is documented
Compliance certificate uses the exact form and representations required by the agreement exhibit
Delivery deadline is tracked and met — late delivery can itself constitute a default [VERIFY]
All [VERIFY] markers are resolved against the specific credit agreement before finalizing