Cellwise Start free

Excel guide · 5 min read

How to calculate EBITDA in Excel

Quick answerEBITDA = net profit + interest + tax + depreciation + amortization, or the same thing from the top: revenue - cost of goods sold - operating expenses, leaving depreciation and amortization out. With a P&L that has a category column, =SUMIFS(C:C,B:B,"Revenue")-SUMIFS(C:C,B:B,"COGS")-SUMIFS(C:C,B:B,"Opex") gives EBITDA, and EBITDA / revenue gives the EBITDA margin.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDEFGH
1LineCategory20252026Measure20252026
2Product salesRevenue712000798000Revenue750000840000
3Service incomeRevenue3800042000EBITDA (top-down)132000153000
4Cost of goods soldCOGS401000446000D&A2200028000
5SalariesOpex138000156000Operating profit (EBIT)110000125000
6Rent and utilitiesOpex5200054000Net profit8000094500
7MarketingOpex2700031000EBITDA (bottom-up)132000153000
8DepreciationDepreciation1800022000Check00
9Amortization of softwareAmortization40006000EBITDA margin0.1760.18214285714
10Loan interestInterest110009500
11Income taxTax1900021000

Download this sheet as an Excel practice file (.xlsx)

Set up the P&L with a category per line

EBITDA stands for earnings before interest, taxes, depreciation and amortization. It shows what the business earns from operating before financing costs, tax and the accounting charges for wearing out assets. Lenders and buyers use it to compare businesses with different debt levels and asset ages.

The easiest way to get it right every month is a P&L where each line has a category: Revenue, COGS, Opex, Depreciation, Amortization, Interest and Tax. The sample has two years for a small equipment retailer in C and D, with all costs typed as positive numbers. The category column is what makes the formulas robust: add a new expense line, tag it Opex, and EBITDA updates without editing a formula. If you don't have a P&L yet, start with a profit and loss statement in Excel.

Method 1: top-down, from revenue

Revenue minus cost of goods sold minus operating expenses, where operating expenses exclude depreciation and amortization. SUMIFS adds every line with a given category, so revenue from two lines (product sales and service income) comes out as one number.

For 2026: 840,000 revenue - 446,000 COGS - 241,000 operating expenses = 153,000. Depreciation and amortization never enter the formula because they have their own categories.

=SUMIFS(D2:D11,B2:B11,"Revenue")-SUMIFS(D2:D11,B2:B11,"COGS")-SUMIFS(D2:D11,B2:B11,"Opex")

Result: 153000

153000: EBITDA for 2026.

I already have operating profit. Can I just add D&A back?

Yes. Operating profit (EBIT) + depreciation + amortization gives the same EBITDA, as long as operating profit is after D&A. In the summary, H5 is operating profit and H4 is D&A.

=H5+H4

Result: 153000

153000: 125,000 operating profit + 28,000 D&A.

Method 2: bottom-up, from net profit, with a check

Start with net profit and add back the four items: interest, tax, depreciation and amortization. This is how EBITDA is often shown in reports because net profit is the number everyone already has.

Build both versions and subtract one from the other in a check cell. In the summary (F:H), row 7 is the bottom-up figure and row 8 is top-down minus bottom-up. It should be 0. If it isn't, a line has the wrong category, or a cost was typed as a negative number while the formulas expect positive ones.

=H6+SUMIFS(D2:D11,B2:B11,"Interest")+SUMIFS(D2:D11,B2:B11,"Tax")+H4

Result: 153000

153000: 94,500 net profit + 9,500 interest + 21,000 tax + 28,000 D&A, matching the top-down figure, so the check in H8 is 0.

EBITDA margin and the year-on-year view

EBITDA margin = EBITDA / revenue. It lets you compare years and businesses of different sizes. Guard against a period with no revenue so the cell shows a message instead of #DIV/0!.

Here EBITDA rose from 132,000 to 153,000 and the margin from 17.6% to 18.2%: revenue grew 12% while cost of goods sold and operating expenses together grew about 11%. Put the years side by side, as in G:H, and the change in margin is the number to explain.

=IF(H2=0,"No revenue",H3/H2)

Result: 0.18214285714 shows as 18.2% with Percent format

0.182, which is 18.2%: each 100 of 2026 revenue left about 18.21 of EBITDA.

How do I show the change in margin?

Subtract last year's margin from this year's. Format the result as a percentage and call it percentage points, not percent.

=H3/H2-G3/G2

Result: 0.0061428571429

0.0061: the margin rose by about 0.6 percentage points (17.6% to 18.2%).

Gotchas: hidden depreciation, one-offs and "adjusted" EBITDA

Depreciation isn't always on its own line. Manufacturers often include it in cost of goods sold, and some charts of accounts bury it in an overhead line. If you subtract a COGS figure that contains depreciation, your EBITDA is understated. Pull the full depreciation figure from the fixed asset register or the accounts' notes, and split it out into its own line with the Depreciation category.

Interest income usually belongs below EBITDA too, so don't let it sit in Revenue. And when you see "adjusted EBITDA", someone has also removed items they consider one-off, such as a legal settlement or restructuring costs. That's a judgment call: list each adjustment on its own line in its own category so anyone can see what was removed and why.

Why EBITDA isn't cash

EBITDA ignores three things that use real cash: buying equipment (capital expenditure), changes in working capital (customers paying late, stock building up), and the interest and tax you actually pay. A business can show a healthy EBITDA and still run short of money if it's growing stock or replacing machines.

For the cash view, use free cash flow, which starts from operating cash flow and subtracts capex. For a lender's view of how well earnings cover interest, see the interest coverage ratio, which has an EBITDA version. This page shows how to calculate the number; it isn't investment or valuation advice.

Common mistakes

Subtracting depreciation that's already inside COGS

Split depreciation out of cost lines into its own category, using the fixed asset register or the accounts' notes.

Mixing signs

Type all costs as positive numbers (or all as negative) and write the formulas for that convention. A check cell comparing top-down and bottom-up catches a flipped sign.

Hard-coding cell references to each line

Use SUMIFS on a category column, so new lines are included as soon as they're tagged.

Treating EBITDA as cash available

Subtract capex, working capital changes, interest and tax paid. That's free cash flow territory.

FAQ

What is the formula for EBITDA in Excel?

=net profit + interest + taxes + depreciation + amortization, or =revenue - COGS - operating expenses excluding D&A. With a category column, build each piece with SUMIFS.

How do I calculate EBITDA margin in Excel?

Divide EBITDA by revenue and format the cell as a percentage. Wrap it in IF(revenue=0,...) so an empty period doesn't show #DIV/0!.

Is EBITDA the same as operating profit?

No. Operating profit (EBIT) is after depreciation and amortization; EBITDA is before them. EBITDA = operating profit + D&A.

Is EBITDA the same as gross profit?

No. Gross profit is revenue minus cost of goods sold. EBITDA also subtracts operating expenses such as salaries, rent and marketing.

Functions used

Related guides

Updated