Real Personal Consumption Expenditures - Durable Goods
Returns real (inflation-adjusted) personal consumption expenditure on durable goods from FRED.
What Are Durable Goods?
Durable goods are items expected to last 3+ years:
- Motor vehicles
- Furniture and appliances
- Recreational goods
- Electronics
Data Source
Data is sourced from the Bureau of Economic Analysis via FRED.
Notes
- Most volatile component of PCE
- Leading indicator of consumer confidence
Syntax
=RealPersonalConsumptionExpDurableGoods()Returns
number
Real PCE durable goods in billions
Examples
Durable goods spending
When to Use
- Consumer durables analysis
- Auto and housing sector research
- Consumer confidence assessment
- Business cycle analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Total consumer spending | RealPersonalConsumptionExpenditure() |
| Nondurable goods | RealPersonalConsumptionExpNondurableGoods() |
| Services spending | RealPersonalConsumptionExpServices() |
Common Issues & FAQ
What counts as a durable good?
Items expected to last 3+ years: cars, appliances, furniture, electronics.
Why is this volatile?
Big-ticket purchases are easily deferred, making them sensitive to economic conditions.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Real Personal Income Excluding Transfer Receipts
- Real Potential Gross Domestic Product
- Real Private Nonresidential Fixed Investment
- Real Private Residential Fixed Investment
- Residential Construction
- S&P 500
- Sales - Retail & Food Services
- St. Louis Fed Financial Stress Index
See RealPersonalConsumptionExpDurableGoods used in a complete workbook: PCE Inflation Tracker Excel: Core PCE Dashboard for May 2026 Fed Watchers
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?