MarketXLS

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

Syntax

=hf_Total_Debt_USD(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Total debt in USD

Examples

=hf_Total_Debt_USD("AAPL", 2023, 4)
Q4 2023 debt in USD
=hf_Total_Debt_USD("TOYOTA", "ly")
Toyota debt in USD
=hf_Total_Debt_USD("SAP", 2023, , "TTM")
SAP debt in USD
=hf_Total_Debt_USD(A1, B1, C1)
From cell references

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

Scenario Use Instead
Need local currency debt hf_Total_Debt()
Need total liabilities hf_Total_Liabilities()
Need cash in USD hf_Cash_and_Equivalents_USD()
Need enterprise value EnterpriseValue()

Common Issues & FAQ

How do I calculate net debt in USD?

Net Debt USD = Total Debt USD - Cash USD: =hf_Total_Debt_USD("SAP","lq") - hf_Cash_and_Equivalents_USD("SAP","lq")

Why might USD debt change even if local debt is stable?

Exchange rate movements. A Euro-denominated debt will have different USD values as EUR/USD changes.

Which version should I use for US companies?

Either - they're identical. Use USD version for consistency in global comparisons.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Total Debt USD (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions