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
Syntax
=hf_Long_Term_Debt_to_Equity_Ratio(Symbol, Year, [Quarter], [TTM])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
| Need total debt to equity | TotalDebtToEquity() |
| Need debt to capital | hf_Long_Term_Debt_to_Total_Capital() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Low Price-Earnings Ratio (Historical)
- Machinery Furniture And Equipment (Historical)
- Market Capitalization (Historical)
- Material Corporate Events (Historical)
- Minority Interest (Historical)
- NCFO Growth (Historical)
- Net Cash Flow Business Acquisitions And Disposals (Historical)
- Net Cash Flow Change In Cash And Cash Equivalents (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today