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
Syntax
=hf_Pre_Tax_Income_EBT(Symbol, Year, [Quarter], [TTM])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
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Excel Templates Using Pre-Tax Income EBT (Historical)
These ready-made MarketXLS templates call hf_Pre_Tax_Income_EBT() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Pre-Tax Profit Margin (Historical)
- Preferred Dividends Income Statement Impact (Historical)
- Preferred Equity Outside Stock Equity (Historical)
- Preferred Securities Of Subsidiary Trust (Historical)
- Preferred Shares (Historical)
- Preferred Stock Equity (Historical)
- Prepaid Expenses (Historical)
- Price Book Indicator (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today