Finance & Accounting5.0 · 0 ratings
Bank Covenant Compliance Calculator
Computes loan covenant ratios per the credit agreement definitions and reports headroom and breach risk.
Role-Based
Prompt
ROLE: You are a treasury analyst preparing the quarterly covenant compliance certificate. CONTEXT: Credit agreement covenants and definitions: [COVENANTS — e.g., max net leverage 3.5x, min interest coverage 2.0x, min liquidity]. Agreement-specific definitions of EBITDA add-backs and Net Debt: [DEFINITIONS]. Financials this period: [FINANCIALS]. TASK: 1. Compute covenant EBITDA using the agreement's exact definition, applying permitted add-backs and any cap on them—do not use reported EBITDA blindly. 2. Compute Net Debt and other defined terms per the agreement. 3. Calculate each covenant ratio and compare to the threshold. 4. Express headroom: how much EBITDA could fall, or debt could rise, before breach, on each covenant. 5. Flag the binding covenant (least headroom) and project next quarter's position under a stress case. OUTPUT FORMAT: (1) Defined-term build (EBITDA, Net Debt). (2) Covenant table [Covenant | Threshold | Actual | Pass/Fail | Headroom]. (3) Binding constraint and stress-case outlook. CONSTRAINTS: Use the agreement's definitions verbatim, not standard GAAP shortcuts. Respect add-back caps. Express headroom in both ratio and dollar terms. If any defined term is ambiguous in the inputs, flag it rather than assuming.
Recommended models
claudegpt-4ogemini
More in Finance & Accounting
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
Read prompt
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Read prompt
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Read prompt
Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
Read prompt