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
Syntax
=TreasuryRate5y()Returns
number
5-year Treasury rate as percentage
Examples
5-year Treasury rate
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
When is 5-year used?
Auto loans, some corporate bonds, and intermediate-term analysis.
How does it compare to 10-year?
Usually lower than 10-year in a normal yield curve.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- U.S - Euro Foreign Exchange Rate
- U.S - UK Foreign Exchange Rate
- U.S Dollar Index
- Unemployment Rate
- Vehicle Sales - Light Weight
- Wilshire 5000 Total Market Index
- Average Hourly Earnings - Private
- Average Weekly Hours of Production
See TreasuryRate5y used in a complete workbook: Yield Curve Dashboard Excel: June 2026 Recession Indicator and Treasury Spread Tracker
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?