Pre-Tax Profit Margin (Historical)

Returns the historical pre-tax profit margin, which measures the percentage of revenue that becomes earnings before taxes (EBT).

Understanding the Metric

Pre-tax profit margin is calculated as:

Pre-Tax Margin = Earnings Before Tax / Revenue * 100

This metric shows:

  • Operational profitability before tax effects
  • Total business efficiency (operations + financing)
  • Comparable profitability across different tax jurisdictions

Parameters

Parameter Description
Symbol Stock ticker (e.g., AAPL, MSFT)
Year Fiscal year or period code (lq, ly, lq-1, ly-1, lt, lt-1)
Quarter Optional: 1, 2, 3, or 4 (default: 1)
TTM Optional: "TTM" for trailing twelve months

Relationship to Other Margins

Gross Margin > Operating Margin > Pre-Tax Margin > Net Margin
(typically)

Pre-tax margin includes interest expense and other non-operating items.

Examples

=hf_Pre_Tax_Profit_Margin("AAPL", 2023, 4)
Q4 2023 pre-tax margin
=hf_Pre_Tax_Profit_Margin("MSFT", "ly")
Last fiscal year
=hf_Pre_Tax_Profit_Margin("GOOGL", 2023, , "TTM")
TTM value
=hf_Pre_Tax_Profit_Margin(A1, B1, C1)
Cell references
=hf_Pre_Tax_Profit_Margin("META", "lq")
Last quarter

When to Use

  • Comparing profitability across tax jurisdictions
  • Analyzing total operational efficiency
  • Understanding impact of interest expense
  • Evaluating companies with different tax strategies
  • Building profitability trend analysis

When NOT to Use

Scenario Use Instead
Need gross profit margin hf_Gross_profit_margin_profit_margin_after_CGS()
Need net profit margin hf_Post_Tax_Profit_Margin()
Want to exclude interest Check operating margin functions
Need effective tax rate hf_Effective_tax_rate()

Common Issues & FAQ

Q: Why is pre-tax margin lower than operating margin? A: Pre-tax margin includes interest expense. Companies with significant debt will have lower pre-tax margins than operating margins.

Q: When is pre-tax margin more useful than net margin? A: When comparing companies with different tax situations (e.g., different countries, NOL carryforwards, or tax credits). Pre-tax margin normalizes for these differences.

Q: What if the company has interest income? A: Interest income is included in pre-tax income. Cash-rich companies may have pre-tax margins higher than operating margins due to interest income.

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 Pre-Tax Profit Margin (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions