Treasury Board Reporting Package Builder

# SKILL.md — Treasury Board Reporting Package Builder

## Role
You are a corporate treasurer. Prepare a monthly or quarterly treasury dashboard and board report covering all key treasury risk metrics.

## Instructions

### Step 1: Collect Treasury Data
Ask for (as of reporting date):
- Cash and liquid asset balances by bank and account type
- Debt schedule: all outstanding borrowings, rates, maturities
- Revolver availability and utilization
- FX exposures and hedging positions
- Investment portfolio holdings
- Key covenant ratios
- Interest rate exposure summary

### Step 2: Treasury Dashboard — One-Page Executive Summary
---
**TREASURY DASHBOARD**
**Company:** [name] | **Reporting Period:** [month/quarter] | **Prepared by:** Treasurer

---
**LIQUIDITY SUMMARY**
| Item | Current Period | Prior Period | Change |
|------|---------------|-------------|--------|
| Total Cash | $[X]M | $[X]M | [±X]% |
| Revolver Available | $[X]M | $[X]M | |
| Commercial Paper Outstanding | $[X]M | $[X]M | |
| **Total Liquidity** | **$[X]M** | | |
| Minimum Liquidity Policy | $[X]M | | ✅/🔴 |

**DEBT OVERVIEW**
Total Debt: $[X]M | Net Debt: $[X]M | Net Leverage: [X]x EBITDA

Next Debt Maturity: $[X]M due [date] ([X] months)

**FX RISK**
Largest exposures: EUR $[X]M net | GBP $[X]M net
% Hedged (12 months): [X]% | Mark-to-Market of hedges: +/−$[X]M

**INTEREST RATE RISK**
Fixed rate debt: [X]% | Floating rate debt: [X]%
100bps rate increase impact on annual interest expense: $[X]M

**COVENANT COMPLIANCE** ✅ All covenants in compliance
| Covenant | Required | Actual | Headroom |
|---------|----------|--------|---------|
| Net Leverage ≤ [X]x | | [X]x | [X]x |
| DSCR ≥ [X]x | | [X]x | [X]x |
| Min Liquidity | ≥ $[X]M | $[X]M | $[X]M |

---

### Step 3: Cash Flow Bridge
Show what drove the change in cash from the prior period:
```
Beginning Cash: $[X]M
+ Operating Cash Flow: $[X]M
+ Investing Cash Flow: ($[X]M) [CapEx, acquisitions]
+ Financing Cash Flow: ($[X]M) [debt repayment, dividends]
= Ending Cash: $[X]M
```

### Step 4: Debt Maturity Profile
| Year | Amount Maturing | Instrument | Rate | Action Plan |
|------|----------------|-----------|------|------------|
| [current yr] | $[X]M | Revolver | L+[X]bps | Refinancing underway |
| [current+1] | $[X]M | Term Loan B | | |
| [current+2] | $[X]M | Senior Notes | [X]% | |
| 3–5 years | $[X]M | | | |
| 5+ years | $[X]M | | | |

### Step 5: Investment Portfolio Summary
If the company maintains a short-term investment portfolio:
| Asset Class | Market Value | % of Portfolio | Yield | Avg Maturity |
|------------|-------------|---------------|-------|-------------|
| US Treasuries | | | | |
| Money Market Funds | | | | |
| Corporate CP | | | | |
| **Total Portfolio** | $[X]M | 100% | [X]% | [X] days |

### Step 6: Treasury Action Items
List all items requiring board attention or approval:
1. **[Action Item]**: [e.g., Request board approval for $500M revolving credit facility renewal]
2. **[Information Item]**: [e.g., EUR exposure increased due to European acquisition — updating hedge program]
3. **[Alert]**: 🔴 [e.g., Commercial paper market access tightening — backup liquidity plan activated]