Corporate Bond Index - AA
Returns the yield or index value for AA-rated corporate bonds, representing high-quality investment-grade corporate debt.
Data Source
Federal Reserve / ICE BofA indices via FRED.
Usage Notes
- No parameters required
- Returns yield as a percentage
- Data updated daily
- AA is high investment grade (one notch below AAA)
Credit Rating Context
| Rating | Quality | Risk Level |
|---|---|---|
| AAA | Highest | Minimal |
| AA | High | Very Low |
| A | Upper Medium | Low |
| BBB | Medium | Moderate |
| Below BBB | Speculative | Higher |
Syntax
=CorporateBondIndexAA()Returns
number
AA-rated corporate bond index value or yield
Examples
AA corporate bond yield (%)
When to Use
- Tracking investment-grade bond yields
- Credit spread analysis
- Fixed income portfolio benchmarking
- Corporate borrowing cost analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need BBB-rated bonds | CorporateBondIndexBBB() |
| Need AAA yields | BondYieldAAA() |
| Need BAA yields | BondYieldBAA() |
Common Issues & FAQ
What does AA rating mean?
AA is a high investment-grade credit rating, indicating very low default risk. Only one notch below the highest AAA rating.
How do I calculate credit spreads?
Credit spread = AA Corporate yield - Treasury yield (for same maturity).
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 CorporateBondIndexAA 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?