Long Term Debt (Historical)

Returns long-term debt (due after one year) from historical balance sheets.

Examples

=hf_Long_term_debt("AAPL", 2023, 4)
=hf_Long_term_debt("MSFT", "ly", 2)

When to Use

  • Leverage analysis
  • Debt structure analysis
  • Capital structure analysis

When NOT to Use

Scenario Use Instead
Need short-term debt hf_Short_term_debt()

Common Issues & FAQ

Q: Does this include bonds? A: Yes, long-term debt includes bonds, term loans, and other debt due after 12 months.

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

Related Functions