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
Syntax
=BondYieldBAA()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
What's the relationship between BAA and BBB?
BAA (Moody's) and BBB (S&P/Fitch) are equivalent ratings representing the lowest investment-grade tier.
Why is the BAA-AAA spread important?
The spread between BAA and AAA yields measures credit risk premium. A widening spread often precedes recessions.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Corporate Profits After Tax
- Crude Oil Prices
- Currency In Circulation
- Dow Jones Industrial Average
- Employees - Goods Producing
- Employees - Government
- Employees - Nonfarm Payroll
- Employees - Private
See BondYieldBAA used in a complete workbook: Junk Bond ETF Tracker Excel: June 2026 Credit Spread Recession Signal Dashboard
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?