Overview
This Earnings Before Tax Excel Template is an educational resource that will show you how to calculate EBT using line items from the income statement. Earnings Before Tax is also referred to as pre-tax income, as it is the company’s earnings before tax is deducted. The figure can be found after deducting items including COGS, SG&A, depreciation and amortization, and interest expense. It is an important metric to measure a company’s profitability without the impact of taxes. This is particularly useful when comparing companies with different tax regimes.

Formulas for Earnings Before Tax

Below are some of the formulas used to get to EBT:
  • EBT = Sales Revenue – COGS – SG&A – Depreciation and Amortization
  • EBT = EBIT - Interest Expense
  • EBT = Net Income + Taxes

Comparing Between EBT, EBIT and EBITDA

It's critical to understand the differences between the three most commonly used financial metrics in financial analysis and modeling.
  • EBT is generally used for analyzing the profitability of a company without the impact of its tax regime. It is ideal for comparing companies in difference countries or operating regions due to the various tax rates.
  • Earnings before interest and taxes (EBIT) is similar to EBT but it adds back the interest expense. This metric excludes the impact of the company's capital structure on its profitability.
  • Earnings before interest, taxes, depreciation & amortization (EBITDA) adds back D&A since it is a non-cash item which does not impact the company's cash flow. This metric is the furthest away from the net income out of the three metrics.
Deciding which financial metrics are the most suitable for assessing a company's operational and financial performance depends on the business nature, geographic location, and capital structure of the company. The role of a financial analyst or finance manager then is to have a good understanding of the business and determine which kind of metrics should be used to analyze it.

Learn More on EBT

Read CFI's detailed guide on EBT to have a better understanding of the concept and calculations!  
Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
restructuring financial model template preview 1 Restructuring Financial Model Template
234
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
355
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…
bank financial model template preview 1 Bank Financial Model Template
326
0
This bank financial model template is used to value financial institutions group (FIG) companies. This is a comprehensive model that…
Synthetic Call Chart Option Profit/Loss Graph Maker
922
240
This free Option Profit/Loss Graph Maker allows the user to combine up to ten different types of options as well…
Directional Trading Strategies Template Directional Trading Strategies Template
742
0
The directional trading strategies template allow users to determine the profit when buying options. This template focuses on directional strategies…
HELOC Calculator Template Home Equity Line of Credit (HELOC) Calculator
439
106
This home equity line of credit (HELOC) calculator can calculate the maximum amount of loan a homeowner is eligible to…