Earnings Before Tax Template

Earnings Before Tax Template

This earnings before tax template shows you how to calculate the earnings before tax using line items in the income statement.

Below is a screenshot of the EBT template:

Download the Free Template

Enter your name and email in the form below and download the free template now!

Earnings before tax (EBT), or pre-tax income, is the last subtotal found in the income statement Income StatementThe Income Statement is one of a company's core financial statements that shows their profit and loss over a period of time. The profit orbefore the penultimate net incomeNet IncomeNet Income is a key line item, not only in the income statement, but in all three core financial statements. While it is arrived at through line item. Earnings before tax is found after all deductions have been made against sales revenueSales RevenueSales revenue is the income received by a company from its sales of goods or the provision of services. In accounting, the terms "sales" and. These deductions include COGS, SG&ASG&ASG&A includes all non-production expenses incurred by a company in any given period. It includes expenses such as rent, advertising, marketing, depreciationDepreciation ExpenseWhen a long-term asset is purchased, it should be capitalized instead of being expensed in the accounting period it is purchased in. and amortization, and interest expense.Interest ExpenseInterest expense arises out of a company that finances through debt or capital leases. Interest is found in the income statement, but can also

Earnings Before Tax Formula

There are three formulas that can be used to calculate Earnings Before Tax (EBT):

1. EBT = Sales Revenue – COGS – SG&A – Depreciation and Amortization
2. EBT = EBIT – Interest Expense
3. EBT = Net Income + Taxes

Earnings Before Tax is used for analyzing the profitability of a company without the impact of its tax regime.  This makes companies in different states or countries more comparable, as tax rates may differ significantly across borders.   Analysts often prefer to add back taxes so they can have an apples-to-apples comparison of earning power across a wide range of companies.

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.

• Excel Modeling TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
• PowerPoint Presentation Templates
• Transaction Document TemplatesTemplatesFree business templates to use in your personal or professional life. Templates include Excel, Word, and PowerPoint. These can be used for transactions,