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 bond pricing, managing coupon schedules, monitoring bond covenants, or evaluating refinancing opportunities. Triggers on phrases like "bond issuance", "manage bonds", "coupon payment", "bond maturity", "bond covenants", "bond pricing", "debt securities", "fixed income portfolio", "bond refinancing".
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
Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.