Corporate Bond Index - BBB

Returns the yield or index value for BBB-rated corporate bonds, representing the lower tier of 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
  • BBB is lowest investment grade (one notch above junk)

Credit Rating Context

Rating Quality Investment Grade
AAA/AA High Yes
A Upper Medium Yes
BBB Medium Yes (lowest IG)
BB and below Speculative No (High Yield/Junk)

BBB Significance

BBB bonds are important because:

  • Largest segment of investment-grade market
  • One downgrade away from "junk" status
  • Watched closely during economic stress

Examples

BBB corporate bond yield (%)

When to Use

  • Tracking lower investment-grade yields
  • Credit cycle analysis
  • Risk premium monitoring
  • Fallen angel risk assessment

When NOT to Use

Scenario Use Instead
Need AA-rated bonds CorporateBondIndexAA()
Need AAA yields BondYieldAAA()
Need BAA yields BondYieldBAA()

Common Issues & FAQ

Q: What's the difference between BBB and BAA? A: BBB (S&P/Fitch) and Baa (Moody's) are equivalent ratings. Both represent the lowest investment-grade tier.

Q: Why are BBB bonds important? A: BBB bonds are the largest segment of investment-grade debt. If downgraded to junk, many funds must sell them, causing price disruption.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Corporate Bond Index- BBB and Other Financial Formulas
How does MarketXLS work?