Personal Savings Rate
Returns the personal savings rate, which is personal saving as a percentage of disposable personal income.
Data Details
| Attribute | Value |
|---|---|
| Source | Bureau of Economic Analysis (BEA) / FRED |
| Frequency | Monthly |
| Unit | Percentage |
| Calculation | Personal Savings / Disposable Income |
Notes
- Higher rates indicate consumers are saving more of their income
- Lower rates may indicate increased spending or financial stress
- Spiked during COVID-19 due to stimulus payments and reduced spending
Syntax
=PersonalSavingsRate()Returns
number
Personal savings rate as a percentage of disposable income
Examples
Current personal savings rate
=PersonalSavingsRate()/100=100-PersonalSavingsRate()When to Use
- Analyzing consumer financial health
- Tracking savings behavior
- Economic research on consumption
- Forecasting consumer spending
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need population data | Population() |
| Need labor data | LaborForce() |
| Need inflation data | ConsumerPriceindex() |
Common Issues & FAQ
What unit is the result in?
Percentage of disposable income.
What is disposable income?
Personal income minus taxes paid.
Why did the savings rate spike in 2020-2021?
Stimulus payments increased income while lockdowns reduced spending opportunities.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Producer Price Index - Crude Goods
- Producer Price Index - Final Demand
- Producer Price Index - Final Demand (Excluding Food and Energy)
- Producer Price Index - Finished Goods
- Producer Price Index - Finished Goods (Excluding Food and Energy)
- Producer Price Index - Material
- Quits - Nonfarm
- Real Exports
See PersonalSavingsRate used in a complete workbook: CPI Inflation Tracker Excel: June 2026 May Print, Fed Watch & Sector Rotation 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?