Treasury Rate - 5 Year

Returns the 5-year constant maturity Treasury rate from FRED.

Data Source

Data is sourced from the Federal Reserve H.15 release via FRED, updated daily.

Notes

  • Intermediate-term benchmark
  • Used for medium-term discounting
  • Popular for TIPS comparison

Examples

=TreasuryRate5y()
5-year Treasury rate
=TreasuryRate10y()-TreasuryRate5y()
10y-5y spread

When to Use

  • Medium-term discount rate
  • Intermediate yield curve analysis
  • Auto loan rate benchmarking
  • Medium-term fixed income research

When NOT to Use

Scenario Use Instead
Long-term rate TreasuryRate10y()
Short-term rate TreasuryRate3m() or TreasuryRate1y()
Mortgage rates TreasuryRate10y()

Common Issues & FAQ

Q: When is 5-year used? A: Auto loans, some corporate bonds, and intermediate-term analysis.

Q: How does it compare to 10-year? A: Usually lower than 10-year in a normal yield curve.

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 Treasury Rate - 5 Year and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions