Pre-Tax Income EBT (Historical)
Returns earnings before taxes (EBT), also known as pre-tax income. This is net income before the deduction of income tax expense.
Formula
EBT = Revenue - Operating Expenses - Interest Expense (+ Interest Income) EBT = Net Income + Income Tax Expense
Notes
- Shows profitability before tax effects
- Useful for comparing companies with different tax rates
- Also called "Income Before Taxes"
- Key input for effective tax rate calculation
Examples
=hf_Pre_Tax_Income_EBT("AAPL", 2023)=hf_Pre_Tax_Income_EBT("MSFT", 2023, 2)=hf_Pre_Tax_Income_EBT("GOOGL", "lq")=hf_Pre_Tax_Income_EBT("TSLA", "ly")=hf_Pre_Tax_Income_EBT(A1, B1, C1)When to Use
Pre-tax profitability analysis, tax-neutral comparisons, effective tax rate calculation
When NOT to Use
| Need EBIT | hf_Earning_Before_Interest_and_Taxes() |
| Need net income | hf_Net_Income() |
Common Issues & FAQ
Q: What year formats are accepted? A: Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Q: Why am I getting "NA"? A: The company may not report this metric, or data may not be available for the requested period.
Q: What's the difference between quarterly and TTM? A: Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today