Real Government Consumption Expenditures and Gross Investment
Returns the real (inflation-adjusted) government consumption expenditures and gross investment from FRED. This is a key component of GDP.
Data Source
Data is sourced from the Bureau of Economic Analysis via FRED, reported quarterly.
Notes
- Includes federal, state, and local government spending
- Values are in billions of chained dollars
- No parameters required
Syntax
=RealGovtExpenditure()Returns
number
Real government expenditure in billions of dollars
Examples
=RealGovtExpenditure()When to Use
- GDP component analysis
- Fiscal policy research
- Government spending trends
- Economic impact analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Private investment | RealPrivateInvestment() |
| Total GDP | RealGDP() |
| Consumer spending | RealPersonalConsumptionExpenditure() |
Common Issues & FAQ
Does this include defense spending?
Yes, it includes all federal, state, and local government expenditures.
What's the difference from fiscal deficit?
This measures spending only, not the difference between spending and revenue.
Related Formulas
More MarketXLS Economic Data formulas you can use in the same worksheet:
- Real Imports
- Real Net Exports
- Real Output Per Hour - Nonfarm
- Real Personal Consumption Expenditures
- Real Personal Consumption Expenditures - Durable Goods
- Real Personal Consumption Expenditures - Nondurable Goods
- Real Personal Consumption Expenditures - Services
- Real Personal Income Excluding Transfer Receipts
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?