Corporate Bond Yield - BAA (Moody's)
Returns the yield on Moody's BAA-rated corporate bonds, representing the lowest tier of investment-grade corporate debt (equivalent to S&P BBB).
Data Source
Moody's via Federal Reserve Economic Data (FRED).
Usage Notes
- No parameters required
- Returns yield as a percentage
- Data updated daily
- BAA (Moody's) = BBB (S&P/Fitch)
BAA Rating Significance
BAA bonds are significant because:
- Lowest investment-grade rating
- One downgrade away from "junk" status
- Largest segment of corporate bond market
- Closely watched during economic stress
Credit Spread
BAA-AAA spread is a key recession indicator:
- Widening = Economic stress
- Narrowing = Risk appetite
Examples
=BondYieldBAA()When to Use
- Credit spread analysis
- Recession probability models
- Corporate borrowing cost tracking
- Risk premium monitoring
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need highest-quality yields | BondYieldAAA() |
| Need AA corporate index | CorporateBondIndexAA() |
| Need BBB corporate index | CorporateBondIndexBBB() |
Common Issues & FAQ
Q: What's the relationship between BAA and BBB? A: BAA (Moody's) and BBB (S&P/Fitch) are equivalent ratings representing the lowest investment-grade tier.
Q: Why is the BAA-AAA spread important? A: The spread between BAA and AAA yields measures credit risk premium. A widening spread often precedes recessions.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?