Corporate Bond Yield - AAA (Moody's)
Returns the yield on Moody's AAA-rated corporate bonds, representing the highest quality corporate debt.
Data Source
Moody's via Federal Reserve Economic Data (FRED).
Usage Notes
- No parameters required
- Returns yield as a percentage
- Data updated daily
- AAA is the highest credit rating
AAA Rating Significance
AAA-rated bonds are issued by:
- The strongest companies
- Companies with minimal default risk
- Often used as a benchmark for corporate credit
Credit Spread Analysis
The spread between AAA and BAA yields indicates market risk appetite:
- Wide spread = Risk aversion / stress
- Narrow spread = Risk appetite / calm markets
Examples
=BondYieldAAA()When to Use
- Benchmarking corporate borrowing costs
- Credit spread analysis
- Risk-free corporate rate proxy
- Fixed income portfolio analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need lower-grade yields | BondYieldBAA() |
| Need AA corporate index | CorporateBondIndexAA() |
| Need BBB corporate index | CorporateBondIndexBBB() |
Common Issues & FAQ
Q: How many companies have AAA ratings? A: Very few - historically only a handful of U.S. companies maintain AAA ratings (e.g., Microsoft, Johnson & Johnson).
Q: What's the difference between AAA and Aaa? A: AAA is S&P/Fitch notation; Aaa is Moody's notation. They represent the same highest quality rating.
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?