Long-Term Debt To Equity Ratio (Historical)
Returns the ratio of long-term debt to shareholders' equity, a key leverage metric showing how much debt financing is used relative to equity financing.
Formula
Long-Term Debt to Equity = Long-Term Debt / Total Shareholders' Equity
Interpretation
| Value | Meaning |
|---|---|
| < 0.5 | Conservative leverage |
| 0.5-1.0 | Moderate leverage |
| > 1.0 | High leverage |
| > 2.0 | Very high leverage |
Notes
- Higher ratios indicate more debt financing
- Industry norms vary significantly (utilities vs tech)
- Important for credit analysis
Examples
=hf_Long_Term_Debt_to_Equity_Ratio("AAPL", 2023)=hf_Long_Term_Debt_to_Equity_Ratio("MSFT", 2023, 2)=hf_Long_Term_Debt_to_Equity_Ratio("GOOGL", "lq")=hf_Long_Term_Debt_to_Equity_Ratio("TSLA", "ly")=hf_Long_Term_Debt_to_Equity_Ratio(A1, B1, C1)When to Use
Leverage analysis, credit risk assessment, capital structure analysis
When NOT to Use
Common Issues & FAQ
Q: What year formats are accepted? A: Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Q: Why am I getting "NA"? A: The company may not report this metric, or data may not be available for the requested period.
Q: What's the difference between quarterly and TTM? A: Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
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?