Finance AI Skill

Bond Management

Manage corporate bond portfolios including issuance, tracking, coupon payments, maturity management, covenant compliance, bond pricing analysis, and secondary market transactions. Use when structuring a bond issuance, tracking bond obligations, analyzing bo...

Bond Management

Manage the full lifecycle of corporate bonds — from issuance through maturity, including coupon payments, pricing, covenants, and refinancing decisions.

Workflow

Inventory the bond portfolio: List all outstanding bonds with key terms (issuer, maturity, coupon rate, frequency, face value, call provisions, covenants).
Track upcoming obligations: Build a calendar of coupon payment dates, maturity dates, and call option windows.
Monitor market conditions: Track comparable bond yields, credit spreads, and benchmark rates (SOFR, LIBOR transition, treasury yields) to assess refinancing opportunities.
Calculate coupon payments: Compute exact payment amounts accounting for day-count conventions (30/360, ACT/ACT, ACT/360) and any accruals.
Ensure covenant compliance: Run quarterly checks against financial covenants (debt-to-EBITDA, interest coverage, minimum liquidity).
Evaluate refinancing: When market rates are favorable or a bond is callable, model the cost-benefit of calling and reissuing.
Manage secondary transactions: If trading existing bonds (buy back, sell, pledge as collateral), execute with proper settlement and accounting treatment.
Prepare investor reporting: Distribute periodic reports to bondholders, trustees, and rating agencies as required.
Account for bond valuation: Record bonds at amortized cost or fair value depending on classification (held-to-maturity, available-for-sale, trading).
Document and archive: Maintain complete bond register, indentures, offering memorandums, and all communication with trustees and rating agencies.

Bond Register Template

Maintain a master register for every bond:

| Field | Example | |-------|---------| | Bond Name | ABC Corp 4.5% Senior Notes due 2030 | | ISIN / CUSIP | US001234AB56 | | Issuer | ABC Corporation | | Issue Date | Mar 15, 2024 | | Maturity Date | Mar 15, 2030 | | Original Principal | $150,000,000 | | Outstanding Principal | $150,000,000 | | Coupon Rate | 4.50% | | Coupon Frequency | Semi-annual | | Day-Count Convention | 30/360 | | Next Coupon Date | Sep 15, 2025 | | Next Coupon Amount | $3,375,000 | | Call Provision | Callable after Mar 15, 2027 at par | | Put Provision | None | | Credit Rating (Moody's/S&P) | Baa2/BBB | | Trustee | JPMorgan Chase Bank | | Governing Law | New York | | Covenants | D/EBITDA < 4.0x, Interest Coverage > 3.0x | | Use of Proceeds | Refinance existing debt, general corporate purposes |

Coupon Payment Calculation

Day-Count Conventions

Different bonds use different day-count conventions to calculate accrued interest:

| Convention | Formula | Common In | |-----------|---------|-----------| | 30/360 | (30 × full months + remaining days) / 360 | US corporate bonds | | ACT/ACT | Actual days in period / actual days in year | Government bonds | | ACT/360 | Actual days / 360 | Floating rate notes, money market | | ACT/365 | Actual days / 365 | UK bonds, some EUR bonds |

Calculation Steps (30/360 Example)

Bond: ABC Corp 4.5% Senior Notes
Principal: $150,000,000
Coupon: 4.50% annual, paid semi-annually
Last payment: Mar 15, 2025
Next payment: Sep 15, 2025

Step 1: Determine days in period
  Mar 16 → Sep 15 = 180 days (using 30/360)

Step 2: Calculate accrued interest
  Accrued = Principal × Coupon Rate × (Days / Year Basis)
  Accrued = $150,000,000 × 0.045 × (180 / 360)
  Accrued = $150,000,000 × 0.045 × 0.50
  Accrued = $3,375,000

Step 3: Wire instruction to trustee
  Amount: $3,375,000
  Date: Sep 15, 2025 (or next business day if holiday)
  Reference: ABC Corp 4.5% Notes due 2030 — Sep 2025 Coupon

Settlement on Secondary Market

When bonds trade between payment dates, the buyer pays accrued interest to the seller:

Trade Date: Jun 30, 2025
Settlement: Jul 2, 2025 (T+2)
Price quoted: 98.50% of par

Clean Price = $150,000,000 × 0.985 = $147,750,000
Accrued Interest (Mar 15 → Jul 2 = 109 days, 30/360):
  = $150,000,000 × 0.045 × (109/360) = $2,043,750
Dirty Price (total payment) = $147,750,000 + $2,043,750 = $149,793,750

Call Provision Management

When to Consider Calling a Bond

Evaluate a call when:

TRIGGERS:
  1. Market rates have fallen significantly (spread vs. coupon > 100bps)
  2. Bond has entered call window
  3. Company has excess cash or wants to optimize capital structure
  4. Refinancing would reduce weighted average cost of debt

DECISION FRAMEWORK:
  Step 1: Calculate present value of remaining coupon payments
  Step 2: Model refinancing at current market rate (add 25-50bps for issuance cost)
  Step 3: Compare PV of current obligations vs. PV of new issuance
  Step 4: Account for call premium (if any), issuance costs ($500K-$2M typically)
  Step 5: Calculate NPV of refinancing decision
  Step 6: Assess non-financial factors: rating impact, investor relationships, covenant flexibility

CALL PREMIUM STRUCTURE (typical step-down):
  Year 1-2: 1.00% of par
  Year 3:   0.75%
  Year 4:   0.50%
  Year 5+:  0.00% (call at par)

Covenant Compliance Monitoring

Common Bond Covenants

| Covenant Type | Metric | Typical Threshold | Check Frequency | |--------------|--------|-------------------|-----------------| | Maximum Leverage | Total Debt / EBITDA | < 4.0x | Quarterly | | Interest Coverage | EBITDA / Interest Expense | > 3.0x | Quarterly | | Minimum Liquidity | Cash + revolver availability | > $50M | Monthly | | Maximum Capital Expenditure | CapEx / EBITDA | < 25% | Quarterly | | Restricted Payments | Dividends + buybacks | Subject to excess cash flow test | Per occurrence | | Asset Sale Proceeds | Requirement to apply to debt | Varies | Per occurrence | | Cross-Default | Default on any other debt triggers | Any default | Ongoing | | Rating Maintenance | Maintain investment grade | BBB-/Baa3 minimum | Ongoing |

Covenant Testing Process

QUARTERLY COVENANT CHECKLIST:
  [ ] Pull latest financial statements (GAAP, audited if annual)
  [ ] Calculate each covenant ratio using defined formulas
  [ ] Compare to covenant thresholds
  [ ] Document calculation methodology and data sources
  [ ] Prepare covenant compliance certificate
  [ ] Deliver to trustee within required timeframe (typically 45 days post-quarter)
  [ ] Flag any near-miss covenants (< 10% buffer) for management awareness
  [ ] If breach detected: immediately assess waiver/consent request with lenders

Bond Pricing Analysis

Understanding Bond Pricing

Bond Price Components:
  Clean Price: Quoted price excluding accrued interest
  Dirty Price: Clean Price + Accrued Interest (actual transaction price)
  
Key Price Drivers:
  1. Interest rate environment (inverse relationship with price)
  2. Credit quality changes (rating upgrades/downgrades)
  3. Supply/demand in secondary market
  4. Liquidity premium (less liquid = lower price)
  5. Time to maturity (longer = more sensitive to rate changes)

PRICE MOVEMENT ESTIMATION:
  Duration × Change in Yield ≈ % Price Change
  
  Example: Bond with duration of 5 years, rates rise 50bps
  Expected price decline ≈ 5 × 0.50% = 2.50%

Refinancing Decision Framework

STEP-BY-STEP REFINANCING ANALYSIS:

1. Current Obligation:
   Outstanding: $150M at 4.50%
   Remaining coupons (6 payments): PV at current rates = $142.3M

2. Proposed Refinancing:
   New issuance at: 3.25% (current market rate for similar credit)
   Size: $150M (match outstanding)
   Issuance costs: $1.2M (underwriting, legal, rating)
   Call premium on old bond: $0 (callable at par)

3. Annual Savings:
   Old interest: $150M × 4.50% = $6,750,000
   New interest: $150M × 3.25% = $4,875,000
   Annual savings: $1,875,000
   PV of savings over 5 years: ~$8.2M

4. Net Benefit:
   PV of savings: $8,200,000
   Less issuance costs: ($1,200,000)
   Net benefit: $7,000,000 → RECOMMEND REFINANCE

5. Non-Financial Considerations:
   • Does new indenture have tighter covenants?
   • Impact on credit rating?
   • Investor base diversification?
   • Maturity extension opportunity?

Edge Cases

Distressed bonds: When issuer is in financial stress, bond price can drop below 50% of par; model recovery scenarios based on restructuring options
Convertible bonds: Track conversion ratio, conversion price, and trigger events; account for dilution impact on EPS
Zero-coupon bonds: No periodic interest; discount accretion recognized over life; maturity value = present value at market rate
Sustainability-linked bonds: Track KPIs (ESG metrics); covenant breach triggers step-up in coupon rate
Cross-border bonds: Consider withholding tax, currency risk, regulatory approval requirements, and local listing rules
Private placements: Fewer regulatory requirements but less liquidity; manage direct investor communications and reporting
Tender offers: When company wants to retire debt voluntarily at a premium before call date; model economics vs. waiting for call window

Output

Bond Obligation Dashboard

BOND PORTFOLIO — January 2025
==============================
TOTAL OUTSTANDING DEBT: $450,000,000

BONDS:
  1. ABC Corp 4.5% Notes due 2030
     Outstanding: $150M | Rating: BBB | Wtd. Avg Cost: 4.50%
     Next Coupon: Sep 15, 2025 ($3,375,000) | Callable: Mar 2027
     Market Price: 98.50% | Duration: 4.8 years
     
  2. ABC Corp 5.25% Notes due 2028
     Outstanding: $200M | Rating: BBB | Wtd. Avg Cost: 5.25%
     Next Coupon: Jun 1, 2025 ($5,250,000) | Callable: N/A
     Market Price: 102.30% | Duration: 2.9 years
     
  3. ABC Corp 3.75% Notes due 2034
     Outstanding: $100M | Rating: BBB+ | Wtd. Avg Cost: 3.75%
     Next Coupon: Dec 15, 2025 ($1,875,000) | Callable: Jun 2029
     Market Price: 95.20% | Duration: 7.1 years

COUPON CALENDAR (Next 12 Months):
  Jun 1, 2025    — $5,250,000 (Notes due 2028)
  Sep 15, 2025   — $3,375,000 (Notes due 2030)
  Dec 15, 2025   — $1,875,000 (Notes due 2034)
  Jun 1, 2026    — $5,250,000 (Notes due 2028)

COVENANT STATUS:
  Debt/EBITDA:       2.8x  (limit: 4.0x) ✓
  Interest Coverage:  4.2x  (min: 3.0x) ✓
  Min Liquidity:     $85M  (min: $50M) ✓

Integration Points

Treasury Management System (TMS): Bond register, payment scheduling
ERP/Accounting: Coupon payment journal entries, amortized cost accounting
Bloomberg/Refinitiv: Market pricing, yield curves, comparable bond data
Rating agencies (Moody's, S&P, Fitch): Rating monitoring, review notifications
Trustee platforms (JPMorgan, BofA): Payment processing, bondholder communications
Legal document management: Indentures, offering memorandums, amendments
Capital structure modeling tools: Refinancing analysis, duration matching
Calendar systems: Coupon and maturity date alerts