EBITDA USD (Historical)
Returns historical EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) converted to US dollars. This is useful for comparing EBITDA across companies that report in different currencies.
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| International ADRs | SYMBOL | TSM, SHOP |
| Foreign Stocks | SYMBOL | Various markets |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Currency Conversion
| Scenario | Behavior |
|---|---|
| US Company | Same as hf_EBITDA() |
| Foreign Company | Converted using historical FX rate |
| ADR | Converted from local currency |
Notes
- Uses historical exchange rates at period end
- Enables apples-to-apples EBITDA comparison
- Useful for EV/EBITDA comparisons across countries
Examples
=hf_EBITDA_USD("AAPL", 2023)=hf_EBITDA_USD("TSM", 2023, 2)=hf_EBITDA_USD("SHOP", "ly")=hf_EBITDA_USD("MSFT", 2023, , "TTM")=hf_EBITDA_USD(A1, B1, C1)When to Use
- Comparing international companies on EBITDA
- Building USD-denominated financial models
- Cross-border M&A analysis
- Global EV/EBITDA screening
- Portfolio analysis with foreign holdings
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need local currency EBITDA | hf_EBITDA() |
| Need current EBITDA | EBITDA() |
| Need EBITDA margin | hf_EBITDA_Margin() |
| Need revenue in USD | hf_Revenue_USD() |
Common Issues & FAQ
Q: Why might USD and local currency EBITDA differ significantly? A: Currency fluctuations between reporting periods can cause differences. A strong USD decreases USD-converted values.
Q: What exchange rate is used? A: Historical exchange rates as of the period end date are used for conversion.
Q: Why am I getting "NA"? A: Check that the symbol is valid and EBITDA data is available for that period.
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?