MarketXLS

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

Syntax

=hf_Total_Debt(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Total debt (short-term + long-term)

Examples

=hf_Total_Debt("AAPL", 2023, 4)
Q4 2023 total debt
=hf_Total_Debt("MSFT", "ly")
Last fiscal year
=hf_Total_Debt("T", 2023, , "TTM")
Trailing period
=hf_Total_Debt(A1, B1, C1)
From cell references

When to Use

  • Debt-to-equity calculation
  • Debt-to-EBITDA analysis
  • Net debt calculation
  • Credit analysis
  • Leverage assessment

When NOT to Use

Scenario Use Instead
Need total liabilities hf_Total_Liabilities()
Need debt in USD hf_Total_Debt_USD()
Need debt issuance activity hf_Issuance_Repayment_of_Debt_Securities()
Need enterprise value EnterpriseValue()

Common Issues & FAQ

How do I calculate net debt?

Net Debt = Total Debt - Cash: =hf_Total_Debt("AAPL","lq") - hf_Cash_and_Equivalents("AAPL","lq")

How do I calculate debt-to-EBITDA?

Debt/EBITDA = Total Debt / EBITDA: =hf_Total_Debt("AAPL","lq") / EBITDA("AAPL")

Why is total debt less than total liabilities?

Total liabilities include non-interest-bearing items like accounts payable, deferred revenue, and deferred taxes. Total debt is just borrowings.

Excel Templates Using Total Debt (Historical)

These ready-made MarketXLS templates call hf_Total_Debt() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

See hf_Total_Debt used in a complete workbook: DCF Model Excel: Build a Discounted Cash Flow Valuation Template (2026)

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 Total Debt (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions