# How to Calculate EBITDA: Formula, Example and EBITDA Margin

- URL: https://betteranalyst.com/metrics/ebitda
- Published: 2026-10-29
- Updated: 2026-10-29
- Author: David Bressler, Founder (https://betteranalyst.com/authors/david-bressler)

> **Summary:** EBITDA = Net income + Interest + Taxes + Depreciation + Amortization (or Operating income + D&A). It approximates operating earnings before financing, tax and non-cash charges. A dental group with $512,000 of net income and $619,000 of interest, tax and D&A has EBITDA of $1,131,000, a 16.5% margin on $6.85M revenue.

Category: [Finance](https://betteranalyst.com/metrics#finance)

EBITDA formula from net income or operating income, a worked example for a multi-location business, EBITDA margin, and adjustments to watch.

## EBITDA formula

```
EBITDA = Net income + Interest expense + Income tax expense + Depreciation + Amortization
```

- **Net income**: Bottom-line profit after all expenses, interest and taxes, from the income statement.
- **Interest expense**: Cost of debt for the period. Add back net interest if you also earn interest income.
- **Income tax expense**: Tax charged on the income statement for the period (not cash taxes paid).
- **Depreciation and amortization**: Non-cash charges spreading the cost of equipment (depreciation) and intangibles such as acquired patient lists or software (amortization) over their useful lives.

## How to calculate EBITDA in Excel and Google Sheets

Excel, using the cells in the worked example below:

```
=SUM(B3:B7)
```

## Worked example

A three-location dental group is talking to a buyer who values practices on a multiple of EBITDA. The owner pulls last year's income statement lines into a sheet.

*Income statement extract, fiscal 2025 (table starts in cell A1)*

| Line item | Amount |
| --- | --- |
| Revenue | $6,850,000 |
| Net income | $512,000 |
| Interest expense | $148,000 |
| Income tax expense | $171,000 |
| Depreciation | $236,000 |
| Amortization | $64,000 |

1. Start with net income: $512,000.
2. Add interest ($148,000) and taxes ($171,000): $831,000. That is EBIT, or operating income if there are no other non-operating items.
3. Add depreciation ($236,000) and amortization ($64,000): EBITDA = $1,131,000.
4. EBITDA margin = 1,131,000 ÷ 6,850,000 = 16.5%. In Excel: =SUM(B3:B7)/B2.

**Result:** $1,131,000 EBITDA (16.5% EBITDA margin)

## How to interpret EBITDA

EBITDA is popular for comparing businesses with different debt levels, tax situations and asset ages, and it is the base for many valuation multiples and loan covenants. It is not cash flow: it ignores capital expenditure, working-capital swings and actual tax payments. A business with heavy equipment needs, like a dental group replacing chairs and imaging, can show healthy EBITDA and still be short of cash. Track EBITDA margin over time and next to capex before drawing conclusions.

## Common mistakes

- Adding back items that aren't interest, tax, depreciation or amortization (owner perks, one-off legal fees) without labelling the result 'Adjusted EBITDA'. Buyers and lenders will separate the two.
- Double-counting D&A that is already excluded from operating expenses. Check whether depreciation sits inside COGS or opex before adding it back.
- Treating EBITDA as cash. Subtract capex and the change in working capital to approximate free cash flow.
- Mixing periods: trailing-twelve-month EBITDA against a single quarter's revenue gives a meaningless margin.

## Calculate EBITDA with Better Analyst

Connect your data or upload a spreadsheet, then ask in plain English. Better Analyst writes and runs the calculation and shows the steps, so you can check the number.

- “Calculate EBITDA and EBITDA margin by location for each quarter from this P&L export.”
- “Bridge net income to EBITDA for last year and show which add-backs are largest.”
- “Chart trailing-twelve-month EBITDA against capex for the last three years.”

Usually calculated from: [Google Sheets](https://betteranalyst.com/data-connectors/google-sheets), [OneDrive](https://betteranalyst.com/data-connectors/onedrive), [SharePoint](https://betteranalyst.com/data-connectors/sharepoint), [Microsoft SQL Server](https://betteranalyst.com/data-connectors/mssql), [Snowflake](https://betteranalyst.com/data-connectors/snowflake), [Google BigQuery](https://betteranalyst.com/data-connectors/bigquery).

[Try Better Analyst free](https://betteranalyst.com/signup)

## Further reading

- [Gross margin formula](https://betteranalyst.com/metrics/gross-margin)
- [Income statement template](https://betteranalyst.com/excel-templates/income-statement-template)
- [Profit and loss template](https://betteranalyst.com/excel-templates/profit-and-loss-template)
- [Explain changes in monthly P&L](https://betteranalyst.com/blog/how-to-explain-changes-in-monthly-profit-and-loss)
- [Better Analyst for finance teams](https://betteranalyst.com/solutions/finance)

## Frequently asked questions

### What is the difference between EBIT and EBITDA?

EBIT (earnings before interest and taxes) still deducts depreciation and amortization; EBITDA adds them back. In the example EBIT is $831,000 and EBITDA is $1,131,000.

### How do I calculate EBITDA margin?

Divide EBITDA by revenue for the same period: $1,131,000 ÷ $6,850,000 = 16.5%. In Excel, =EBITDA_cell/Revenue_cell formatted as a percentage.

### Can I calculate EBITDA from operating income?

Yes: EBITDA = Operating income + Depreciation + Amortization. It matches the net-income route when there are no non-operating gains, losses or other income below the operating line.

## Related metrics

- [Net Profit Margin Formula: Calculate It in Excel (Example)](https://betteranalyst.com/metrics/net-profit-margin)
- [Gross Margin Formula: How to Calculate Gross Margin in Excel](https://betteranalyst.com/metrics/gross-margin)