Long-Term Debt To Total Capital (Historical)
Returns the ratio of long-term debt to total capital (debt + equity), showing what percentage of the company's capital structure is long-term debt.
Formula
LT Debt to Capital = Long-Term Debt / (Long-Term Debt + Shareholders' Equity)
Interpretation
| Value | Meaning |
|---|---|
| < 0.3 | Low debt reliance |
| 0.3-0.5 | Moderate debt |
| > 0.5 | Debt-heavy capital structure |
Notes
- Expressed as decimal (0.35 = 35%)
- Compare across industry peers
- Trend analysis shows financing strategy changes
Examples
=hf_Long_Term_Debt_to_Total_Capital("AAPL", 2023)=hf_Long_Term_Debt_to_Total_Capital("MSFT", 2023, 2)=hf_Long_Term_Debt_to_Total_Capital("GOOGL", "lq")=hf_Long_Term_Debt_to_Total_Capital("TSLA", "ly")=hf_Long_Term_Debt_to_Total_Capital(A1, B1, C1)When to Use
Capital structure analysis, comparing debt reliance across companies, leverage trends
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?