Total Debt USD (Historical)
Returns the historical total interest-bearing debt converted to US dollars. Essential for comparing debt levels across companies that report in different currencies.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, TOYOTA) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Currency Conversion
- Uses period-end exchange rates
- For US companies, same as local currency version
- Enables apples-to-apples debt comparison globally
- Exchange rate fluctuations affect USD values
Notes
- Interest-bearing debt only
- USD-normalized for global comparison
- Identical to local currency for US companies
- Use for consistent global screening
Examples
=hf_Total_Debt_USD("AAPL", 2023, 4)=hf_Total_Debt_USD("TOYOTA", "ly")=hf_Total_Debt_USD("SAP", 2023, , "TTM")=hf_Total_Debt_USD(A1, B1, C1)When to Use
- Comparing debt across currencies
- Global leverage screening
- International portfolio analysis
- Currency-neutral debt comparison
- Cross-border company analysis
When NOT to Use
Common Issues & FAQ
Q: How do I calculate net debt in USD?
A: Net Debt USD = Total Debt USD - Cash USD: =hf_Total_Debt_USD("SAP","lq") - hf_Cash_and_Equivalents_USD("SAP","lq")
Q: Why might USD debt change even if local debt is stable? A: Exchange rate movements. A Euro-denominated debt will have different USD values as EUR/USD changes.
Q: Which version should I use for US companies? A: Either - they're identical. Use USD version for consistency in global comparisons.
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?