Long Term Debt Per Share (Historical)
Measures long-term debt burden per share outstanding.
Syntax
=hf_Long_term_debt_per_share(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
yearstringRequired
quarterstring
TTMstring
Returns
number
Long-term debt per share in dollars
Examples
=hf_Long_term_debt_per_share("AAPL", 2023, 4)When to Use
- Debt analysis
- Per-share leverage assessment
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current liabilities | hf_Current_liabilities_per_share() |
Common Issues & FAQ
What counts as long-term debt?
Debt with maturity greater than one year.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
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?