Finance AI Skill

Debt Credit Management

Manage debt and credit operations including debt portfolio management, covenant compliance, credit facilities, debt refinancing, capital structure optimization, interest rate management, and leverage management. Use when managing the debt portfolio, monitor...

Debt & Credit Management

Manage the debt portfolio, credit facilities, and capital structure to optimize financing costs and maintain financial flexibility.

Debt Portfolio Management

Debt Schedule & Overview

DEBT PORTFOLIO OVERVIEW — Jan 2025
════════════════════════════════════

OUTSTANDING DEBT:
  ┌───────────────────────────┬────────────┬──────────┬──────────┬────────────┬──────────┐
  │ Facility                  │ Principal  │ Interest │ Maturity │ Type       │ Security │
  ├───────────────────────────┼────────────┼──────────┼──────────┼────────────┼──────────┤
  │ Term Loan A               │ $15,000K   │ 6.3%     │ Mar 2028 │ Fixed rate │ Senior   │
  │ Revolving Credit (RCF)    │ $25,000K   │ SOFR+1.25│ Mar 2027 │ Variable   │ Senior   │
  │  (undrawn)                │ ($0 drawn) │ =5.05%   │          │            │ secured  │
  │ Convertible Notes         │ $5,000K    │ 1.5%     │ Jun 2027 │ Fixed rate │ Senior   │
  │                           │            │ (coupon) │          │ convertible│          │
  │ ─────────────────────── │ ──────── │ ─────── │ ─────── │ ────────── │ ─────── │
  │ TOTAL                     │ $45,000K   │          │          │            │          │
  │ DRAWN                     │ $20,000K   │          │          │            │          │
  │ AVAILABLE (RCF)           │ $25,000K   │          │          │            │          │
  └───────────────────────────┴────────────┴──────────┴──────────┴────────────┴──────────┘

DEBT SCHEDULE (Annual Amortization):
  ┌────────────┬────────────┬────────────┬────────────┬────────────┬────────────┐
  │ ($000s)    │ FY2025     │ FY2026     │ FY2027     │ FY2028     │ Total      │
  ├────────────┼────────────┼────────────┼────────────┼────────────┼────────────┤
  │ Term Loan  │ $3,000     │ $4,000     │ $5,000     │ $3,000     │ $15,000    │
  │ Convert.  │ $0         │ $0         │ $5,000     │ $0         │ $5,000     │
  │ Total     │ $3,000     │ $4,000     │ $10,000    │ $3,000     │ $20,000    │
  │ Principal  │            │            │            │            │            │
  ├────────────┼────────────┼────────────┼────────────┼────────────┼────────────┤
  │ Interest   │ $1,125     │ $855       │ $306       │ $189       │ $2,475     │
  │ (est.)     │            │            │            │            │            │
  ├────────────┼────────────┼────────────┼────────────┼────────────┼────────────┤
  │ TOTAL     │ $4,125     │ $4,855     │ $10,306    │ $3,189     │ $22,475    │
  │ SERVICE   │            │            │            │            │            │
  └────────────┴────────────┴────────────┴────────────┴────────────┴────────────┘

INTEREST EXPENSE:
  Current annual interest: ~$1,125K (on $20M drawn debt)
  Interest coverage ratio: EBITDA / Interest = $42M / $1.125M = 37.3x (EXCELLENT)
  Fixed charge coverage: (EBITDA + fixed charges) / (interest + required principal)
    = ($42M + $0) / ($1.125M + $3M) = 10.2x (EXCELLENT)

CAPITAL STRUCTURE METRICS:
  Total debt: $20,000,000 (drawn)
  Cash & equivalents: $17,500,000
  ════════════════════════════════════
  NET DEBT: $2,500,000
  
  Net debt / EBITDA: $2.5M / $42M = 0.06x (VERY LOW — net cash position)
  Debt / EBITDA (gross): $20M / $42M = 0.48x (LOW — investment grade)
  Debt / Enterprise Value: $20M / $2,730M = 0.7% (MINIMAL)
  Interest coverage: 37.3x (VERY STRONG)
  Altman Z-score: 4.8 (well above 3.0 safe threshold)

  Credit profile: Investment grade equivalent
  Bank relationship: Strong (all covenants met with wide margin)
  Refinancing risk: LOW (maturity ladder spread over 3 years)

Covenant Compliance

Monitoring & Management

COVENANT COMPLIANCE MONITORING:
════════════════════════════════

AFFIRMATIVE COVENANTS (Must Do):
  ┌───────────────────────────────────┬──────────┬────────────┐
  │ Covenant                          │ Status   │ Evidence   │
  ├───────────────────────────────────┼──────────┼────────────┤
  │ Financial statements delivery     │ ✓ Comply │ Filed Q4   │
  │   (within 45 days of quarter end) │          │            │
  │ Insurance maintenance             │ ✓ Comply │ Cert. on   │
  │   (adequate coverage)             │          │ file       │
  │ Tax compliance                    │ ✓ Comply │ Tax clearance│
  │   (timely filing, payment)        │          │            │
  │ Property maintenance              │ ✓ Comply │ N/A (leased│
  │   (good condition)                │          │  facilities)│
  │ ERISA compliance                  │ ✓ Comply │ HR cert.   │
  │   (benefit plans funded)          │          │            │
  │ Notice of material events         │ ✓ Comply │ N/A (none │
  │                                   │          │  in period)│
  └───────────────────────────────────┴──────────┴────────────┘

FINANCIAL COVENANTS (Must Maintain):
  ┌───────────────────────────────────┬──────────┬──────────┬──────────┐
  │ Covenant                          │ Required │ Actual   │ Cushion  │
  ├───────────────────────────────────┼──────────┼──────────┼──────────┤
  │ Fixed charge coverage ratio       │ >1.5x    │ 10.2x    │ 8.7x     │
  │ (FCCR)                            │          │          │          │
  │ Leverage ratio                    │ <3.0x    │ 0.48x    │ 2.52x    │
  │ (total debt / EBITDA)             │          │          │          │
  │ Net leverage ratio                │ <2.5x    │ 0.06x    │ 2.44x    │
  │ (net debt / EBITDA)               │          │          │          │
  │ Minimum liquidity                 │ >$10M    │ $42.5M   │ $32.5M   │
  │ (cash + revolver availability)    │          │          │          │
  │ Interest coverage                 │ >3.0x    │ 37.3x    │ 34.3x    │
  │ ─────────────────────────────── │ ──────── │ ──────── │ ──────── │
  │ STATUS                            │ ALL COVENANTS COMFORTABLY MET              │
  └───────────────────────────────────┴──────────┴──────────┴──────────┘

  Monitoring frequency: Monthly (internal) + Quarterly (bank certificate)
  Last bank certificate: Q4 2024 — submitted January 30, 2025
  Next certificate: Q1 2025 — due April 30, 2025

NEGATIVE COVENANTS (Must Not Do):
  ┌───────────────────────────────────┬──────────┬────────────┐
  │ Covenant                          │ Status   │ Notes      │
  ├───────────────────────────────────┼──────────┼────────────┤
  │ Additional debt (>$5M without    │ ✓ Comply │ No new debt│
  │   consent)                        │          │  planned   │
  │ Liens on assets                   │ ✓ Comply │ Clean title│
  │ Dividend payment (if net leverage │ ✓ Comply │ No div.    │
  │   >1.5x)                          │          │  currently │
  │ M&A (acquisitions >$10M)          │ N/A      │ No M&A in │
  │                                   │          │  pipeline  │
  │ Asset sales (>$2M)                │ ✓ Comply │ No sales   │
  │ Change of control                 │ ✓ Comply │ Stable     │
  │ Related party transactions        │ ✓ Comply │ None       │
  │ Industry change                   │ ✓ Comply │ Focused    │
  └───────────────────────────────────┴──────────┴────────────┘

COVENANT BREACH RISK ASSESSMENT:
  Current risk: VERY LOW (all covenants met with significant cushion)
  Stress test (moderate recession scenario):
    Revenue -25%, EBITDA -40%:
      FCCR: 10.2x → 6.1x (still >1.5x threshold) ✓
      Leverage: 0.48x → 1.2x (still <3.0x threshold) ✓
      Net leverage: 0.06x → 0.9x (still <2.5x threshold) ✓
      Liquidity: $42.5M → $32.0M (still >$10M threshold) ✓
    Conclusion: No breach risk under stress scenarios

  Covenant monitoring dashboard: Updated monthly
  Early warning: Automated alerts if any covenant approaches 80% of threshold

Debt Refinancing & Optimization

Refinancing Analysis

REFINANCING ANALYSIS — Term Loan A
═══════════════════════════════════

CURRENT TERMS:
  Principal: $15,000,000
  Interest rate: 6.3% fixed (locked at origination, 2023)
  Maturity: March 2028 (3 years remaining)
  Amortization: $3M/year (accelerated final year)
  Prepayment: 1% penalty if prepaid within 2 years; 0.5% years 3-4; 0% after
  Current prepayment penalty: 0.5% ($75,000) — if refinanced now

MARKET CONDITIONS:
  Current SOFR: 3.8%
  Current fixed-rate lending: SOFR + 2.0-2.5% = 5.8-6.3%
  Investment grade bonds (BBB): ~4.5-5.0%
  Market trend: Interest rates expected to decline in 2025

REFINANCING SCENARIOS:

SCENARIO 1: Refinance to new term loan at current rates
  New rate: 6.0% fixed (market rate, slight improvement)
  Savings: 0.3% × $15M = $45,000/year
  Cost: Prepayment penalty $75,000 + arrangement fees $50,000 = $125,000
  Payback: 2.8 years (not worthwhile — marginal rate improvement)
  RECOMMENDATION: ✗ DO NOT REFINANCE

SCENARIO 2: Hold and benefit from potential future rate decline
  Expected rate in 2026: 5.0-5.5% (Fed rate cut scenario)
  Potential savings: 0.8-1.3% × $11M (remaining balance) = $88K-$143K/year
  Cost: $0 (no action needed — wait for better rates)
  RECOMMENDATION: ✓ HOLD — WAIT FOR BETTER RATES

SCENARIO 3: Convertible note call protection
  Convertible notes: $5M, 1.5% coupon, maturity June 2027
  Conversion price: $45.00/share
  Current stock price: $54.20/share (20% above conversion price)
  Conversion likelihood: HIGH (rational holders would convert)
  Impact if converted:
    - Debt eliminated: $5M
    - Shares issued: ~111,000 (5M / 45.00)
    - Dilution: 0.22% (minor)
    - Interest savings: $75K/year (1.5% × 5M)
    - Net benefit: Debt reduction + interest savings at minimal dilution
  RECOMMENDATION: ✓ MONITOR — LIKELY CONVERSION BENEFICIAL

CAPITAL STRUCTURE OPTIMIZATION:
  Current structure:
    Equity: 99.3% of capital
    Debt: 0.7% of capital
    Net cash position (debt < cash)
  
  Optimization considerations:
    - Current debt level is conservative (preserves flexibility)
    - Additional debt capacity: ~$100M+ (before covenant limits)
    - Use of additional debt: Only for strategic M&A or large capex
    - Cost of debt advantage: 6.3% vs. cost of equity 12.5%
    - Tax shield benefit: 6.3% × 25% = 1.6% additional value creation
    - Recommendation: Maintain current conservative structure
      (debt available when needed, not forced when not)

WACC IMPACT OF CAPITAL STRUCTURE:
  Current: WACC = 11.6% (85% equity, 15% debt — target structure)
  If increase debt to 30%:
    WACC = 10.2% (lower, but higher financial risk)
  If maintain current:
    WACC = 11.6% (slightly higher, but more conservative)
  Trade-off: 1.4% WACC reduction for 3x leverage increase
  Decision: Maintain conservative structure (growth-stage company)

Interest Rate Risk Management

Rate Risk Assessment

INTEREST RATE RISK MANAGEMENT:
══════════════════════════════

INTEREST RATE EXPOSURE:
  Fixed rate debt: $15,000,000 (75% of drawn debt)
    - Term Loan A: $15M @ 6.3% fixed (no rate risk)
    - Convertible Notes: $5M @ 1.5% fixed (no rate risk)
  Variable rate debt: $0 (RCF undrawn — no current exposure)
    - If drawn: SOFR + 1.25% (rate risk proportional to amount drawn)
  
  Net interest rate exposure: LOW (75% fixed, variable undrawn)

INTEREST RATE SCENARIOS:
  If RCF drawn ($10M scenario):
    ┌──────────────────┬──────────┬──────────┬──────────┐
    │ Rate Environment │ SOFR     │ RCF Rate │ Annual   │
    │                  │          │          │ Interest │
    ├──────────────────┼──────────┼──────────┼──────────┤
    │ Rates rise 100bp │ 4.8%     │ 6.05%    │ +$100K   │
    │ Rates rise 200bp │ 5.8%     │ 7.05%    │ +$200K   │
    │ Rates decline    │ 2.8%     │ 4.05%    │ -$100K   │
    │ Rates decline    │ 1.8%     │ 3.05%    │ -$200K   │
    │ ──────────────── │ ─────── │ ─────── │ ─────── │
    │ Current          │ 3.8%     │ 5.05%    │ baseline │
    └──────────────────┴──────────┴──────────┴──────────┘
  
  Impact materiality: LOW (even at +200bp, additional cost is $200K/year
    vs. $42M EBITDA — immaterial)

INTEREST RATE HEDGING:
  Current hedges: NONE (not required given low exposure)
  Available instruments:
    - Interest rate swap (variable to fixed)
    - Interest rate cap (limit maximum rate)
    - Interest rate collar (cap + floor)
    - Forward rate agreement (FRA)
  
  Hedging policy:
    - Hedge if variable rate debt >$10M drawn for >3 months
    - Cap strategy preferred (protects upside, allows downside benefit)
    - Maximum hedge: 75% of variable rate exposure
    - Counterparty: Investment-grade bank only
    - Mark-to-market disclosure: Quarterly

FIXED vs. VARIABLE RATE MIX:
  Current: 100% fixed (RCF undrawn)
  Target: 75% fixed / 25% variable (if RCF drawn)
  Rationale:
    - Fixed rate provides certainty for planning
    - Variable rate allows benefit from rate declines
    - Balanced approach minimizes cost while managing risk

Credit Facility Management

RCF Management

REVOLVING CREDIT FACILITY MANAGEMENT:
══════════════════════════════════════

FACILITY DETAILS:
  Bank: [Lending Bank]
  Amount: $25,000,000
  Maturity: March 2027 (2 years)
  Interest: SOFR + 1.25% (current: 5.05%)
  Commitment fee: 0.25% on undrawn amount ($62,500/year)
  Letters of credit sublimit: $5,000,000
  Swing line sublimit: $2,000,000
  
  Security: First lien on all assets (standard for senior secured)
  Guaranteors: Parent company + all material subsidiaries

USAGE HISTORY:
  FY2024: Never drawn (strong cash generation)
  FY2023: Drawn 2 times (seasonal — max draw $5M, avg. 3 days)
  FY2022: Drawn 1 time (acquisition bridge — max draw $10M, avg. 14 days)
  
  Current utilization: 0%
  Available capacity: $25,000,000
  Commitment cost (annual): $62,500 (0.25% × $25M)
  Cost-benefit: LOW cost for HIGH flexibility (excellent value)

DRAW PROCEDURES:
  Authority:
    <$1M: CFO (sole authority)
    $1M-$5M: CFO + Controller
    $5M-$10M: CFO + CEO
    >$10M: Board authorization
  
  Process:
    1. Draw request (amount, purpose, expected duration)
    2. Approval per authority matrix
    3. Certificate delivery (compliance with covenants)
    4. Funds wired to operating account (same day)
    5. Tracking (purpose, repayment timeline)
  
  Repayment:
    Standard: As cash available (no mandatory amortization)
    Target: Repay within 30 days (minimize interest cost)
    Minimum retention: $5M cash (do not draw below threshold)

FACILITY RENEWAL:
  Current maturity: March 2027
  Early renewal consideration: 12 months before maturity
  Expected renewal timing: Q1 2026
  
  Renewal strategy:
    - Engage multiple banks (competitive process)
    - Maintain relationship with current lender
    - Benchmark pricing (SOFR margin, commitment fee)
    - Extend maturity (3-5 years preferred)
    - Consider facility increase (if growth trajectory warrants)
  
  Alternative financing (if RCF unavailable):
    - New RCF with different bank(s)
    - Asset-based lending (ABL) — AR-backed
    - Corporate bond issuance (if investment grade)
    - Equity issuance (last resort — dilutive)

Output

Debt Management Dashboard

DEBT MANAGEMENT DASHBOARD — Jan 27, 2025
══════════════════════════════════════════

Debt Portfolio:
  Total drawn: $20.0M
  Term Loan A: $15.0M @ 6.3% fixed (Mar 2028)
  Convertible Notes: $5.0M @ 1.5% (Jun 2027)
  RCF: $25.0M available (undrawn)
  
Capital Structure:
  Net debt: $2.5M ($20M debt - $17.5M cash)
  Net debt / EBITDA: 0.06x (very low)
  Gross debt / EBITDA: 0.48x (investment grade)
  Interest coverage: 37.3x (very strong)
  WACC: 11.6% (current structure)
  
Covenant Compliance:
  FCCR: 10.2x (threshold: >1.5x) ✓
  Leverage: 0.48x (threshold: <3.0x) ✓
  Net leverage: 0.06x (threshold: <2.5x) ✓
  Liquidity: $42.5M (threshold: >$10M) ✓
  Status: ALL COVENANTS MET — WIDE MARGIN
  
Interest Expense:
  Annual: ~$1.1M (on current debt)
  As % of EBITDA: 2.6% (very low)
  As % of revenue: 0.7% (very low)
  
Interest Rate Risk:
  Fixed rate: 75% (drawn debt)
  Variable: 0% (RCF undrawn)
  Hedging: None needed (low exposure)
  
Refinancing:
  Term Loan: Hold (current rates not better)
  Convertible: Monitor (likely conversion beneficial)
  RCF renewal: Q1 2026 (March 2027 maturity)
  
Actions:
  1. Q1 bank certificate (due April 30)
  2. Convertible note conversion monitoring (monthly)
  3. RCF renewal planning (start Q4 2026)
  4. Market rate monitoring (quarterly)
  5. Stress test update (semi-annual)

Integration Points

ERP/GL: Debt accounting, interest accruals, amortization
Banking platforms: Account access, draw/repayment processing, statements
Treasury management systems: Cash positioning, debt tracking
BI platforms: Debt dashboards, covenant monitoring
Financial data feeds (Bloomberg, Reuters): Market rates, benchmarking
Accounting platforms: Debt schedule management, interest calculation
Board portals: Debt reporting, covenant compliance certificates
Credit rating services: Internal rating, benchmarking
Legal platforms: Credit agreement management, covenant tracking
Risk management platforms: Interest rate risk modeling

Edge Cases

Covenant breach: Immediate notification; waiver request; remediation plan; investor communication
Credit rating downgrade: Higher borrowing costs; covenant tightness; investor concern
Interest rate spike: Variable rate exposure; hedging activation; cost impact assessment
Refinancing risk (maturity wall): Multiple facilities maturing simultaneously; market conditions; bridge financing
Convertible note conversion: Dilution impact; share price dynamics; accounting treatment
Debt capacity utilization: Growth capital needs; M&A funding; balance sheet flexibility
Cross-default provisions: One facility default triggers others; contagion risk; coordinated response
Change of control: Acceleration clauses; consent requirements; deal structuring
Currency risk on foreign debt: FX hedging; translation impact; natural hedging
Restructuring: Distressed exchange; creditor negotiation; equity conversion; plan confirmation