Federal Debt

Returns the total U.S. federal government debt (national debt), including debt held by the public and intragovernmental holdings.

Data Source

U.S. Treasury via Federal Reserve Economic Data (FRED).

Usage Notes

  • No parameters required
  • Returns value in billions or trillions (check series)
  • Data updated quarterly
  • Includes both marketable and non-marketable debt

Debt Components

Component Description
Debt Held by Public Treasury securities owned by investors
Intragovernmental Debt owed to government trust funds (Social Security)

Debt Context

Metric Significance
Debt-to-GDP ratio Sustainability measure
Interest expense Budget impact
Debt ceiling Legal limit on borrowing

Examples

Total federal debt (billions/trillions)

When to Use

  • Tracking national debt levels
  • Fiscal sustainability analysis
  • Government finance research
  • Building economic dashboards

When NOT to Use

Scenario Use Instead
Need annual deficit/surplus FederalSurplusOrDeficit()
Need government spending FederalOutlays()
Need government revenue FederalReceipts()

Common Issues & FAQ

Q: What units is this in? A: Check the specific series - may be in billions or millions of dollars. The current debt exceeds $34 trillion.

Q: Does this include state/local debt? A: No, this is federal government debt only. State and local governments have separate debt.

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 Federal Debt and Other Financial Formulas
How does MarketXLS work?