Earnings Before Interest and Taxes - EBIT in USD (Historical)
Returns historical Earnings Before Interest and Taxes (EBIT) converted to USD. EBIT measures a company's profitability from operations, excluding interest expenses and income taxes.
What is EBIT?
EBIT = Revenue - Operating Expenses (excluding interest and taxes)
This function returns EBIT converted to USD, useful for comparing companies that report in different currencies.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year (e.g., 2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last quarter |
| lq-1 | Two quarters ago |
| ly | Last year |
| ly-1 | Two years ago |
Notes
- Values are in USD regardless of company's reporting currency
- Quarterly data shows that quarter only
- Use TTM="TTM" for trailing twelve month aggregate
Examples
=hf_Earning_Before_Interest_and_Taxes_USD("AAPL", "2023", "4")=hf_Earning_Before_Interest_and_Taxes_USD("MSFT", "2023", "3")=hf_Earning_Before_Interest_and_Taxes_USD("AAPL", "lq")=hf_Earning_Before_Interest_and_Taxes_USD("GOOGL", "2023", "4", "TTM")=hf_Earning_Before_Interest_and_Taxes_USD(A1, B1, C1)When to Use
- Comparing EBIT across companies with different reporting currencies
- Historical operating profitability analysis in USD
- Building USD-normalized financial models
- Analyzing multinational companies in consistent currency
- Time series analysis of operating performance
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need EBIT in local currency | hf_Earning_Before_Interest_and_Taxes() |
| Need current period EBIT | EBIT() |
| Need EBITDA | hf_EBITDA() |
| Need net income | hf_Net_Income() |
| Need operating margin | hf_Operating_Margin() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that:
- The symbol is valid and has fundamental data available
- The year/quarter combination exists in the data
- The company has reported financials for that period
Q: What's the difference between this and hf_Earning_Before_Interest_and_Taxes()? A: This function (USD version) converts EBIT to USD for international companies. Use the non-USD version if you want values in the company's reporting currency.
Q: How do I get trailing twelve months EBIT?
A: Set the TTM parameter to "TTM":
=hf_Earning_Before_Interest_and_Taxes_USD("AAPL", "2023", "4", "TTM")
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today