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
Syntax
=hf_Long_Term_Debt_to_Total_Capital(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year
Quarter (1-4)
Use TTM for trailing twelve months
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
| Need debt to equity | hf_Long_Term_Debt_to_Equity_Ratio() |
| Need interest coverage | InterestCoverage() |
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