Total Debt (Historical)
Returns the historical total interest-bearing debt - the sum of short-term and long-term borrowings. This is a key metric for leverage and credit analysis.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, MSFT) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Debt Components
| Type | Description |
|---|---|
| Short-term Debt | Credit facilities, commercial paper, current portion LTD |
| Long-term Debt | Bonds, term loans, notes payable |
| Finance Leases | Capitalized lease obligations |
Notes
- Interest-bearing obligations only
- Different from total liabilities (which includes payables, deferred items)
- Used for debt-to-equity and debt-to-EBITDA ratios
- Net Debt = Total Debt - Cash
Examples
=hf_Total_Debt("AAPL", 2023, 4)=hf_Total_Debt("MSFT", "ly")=hf_Total_Debt("T", 2023, , "TTM")=hf_Total_Debt(A1, B1, C1)When to Use
- Debt-to-equity calculation
- Debt-to-EBITDA analysis
- Net debt calculation
- Credit analysis
- Leverage assessment
When NOT to Use
Common Issues & FAQ
Q: How do I calculate net debt?
A: Net Debt = Total Debt - Cash: =hf_Total_Debt("AAPL","lq") - hf_Cash_and_Equivalents("AAPL","lq")
Q: How do I calculate debt-to-EBITDA?
A: Debt/EBITDA = Total Debt / EBITDA: =hf_Total_Debt("AAPL","lq") / EBITDA("AAPL")
Q: Why is total debt less than total liabilities? A: Total liabilities include non-interest-bearing items like accounts payable, deferred revenue, and deferred taxes. Total debt is just borrowings.
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?