Long Term Debt (Historical)
Returns long-term debt (due after one year) from historical balance sheets.
Syntax
=hf_Long_term_debt(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Long term debt amount
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
Does this include bonds?
Yes, long-term debt includes bonds, term loans, and other debt due after 12 months.
Excel Templates Using Long Term Debt (Historical)
These ready-made MarketXLS templates call hf_Long_term_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:
- Long Term Debt As Percentage Of Invested Capital (Historical)
- Long Term Debt As Percentage Of Total Liabilities (Historical)
- Long Term Debt Per Share (Historical)
- Long-Term Debt To Equity Ratio (Historical)
- Long-Term Debt To Total Capital (Historical)
- Low Price-Earnings Ratio (Historical)
- Machinery Furniture And Equipment (Historical)
- Market Capitalization (Historical)
See hf_Long_term_debt used in a complete workbook: Interest Rate Sensitive Stocks Screener: How to Identify and Analyze Rate-Exposed Equities in Excel
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?