Excel guide · 5 min read
How to calculate EBITDA in Excel
=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.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Line | Category | 2025 | 2026 | Measure | 2025 | 2026 | |
| 2 | Product sales | Revenue | 712000 | 798000 | Revenue | 750000 | 840000 | |
| 3 | Service income | Revenue | 38000 | 42000 | EBITDA (top-down) | 132000 | 153000 | |
| 4 | Cost of goods sold | COGS | 401000 | 446000 | D&A | 22000 | 28000 | |
| 5 | Salaries | Opex | 138000 | 156000 | Operating profit (EBIT) | 110000 | 125000 | |
| 6 | Rent and utilities | Opex | 52000 | 54000 | Net profit | 80000 | 94500 | |
| 7 | Marketing | Opex | 27000 | 31000 | EBITDA (bottom-up) | 132000 | 153000 | |
| 8 | Depreciation | Depreciation | 18000 | 22000 | Check | 0 | 0 | |
| 9 | Amortization of software | Amortization | 4000 | 6000 | EBITDA margin | 0.176 | 0.18214285714 | |
| 10 | Loan interest | Interest | 11000 | 9500 | ||||
| 11 | Income tax | Tax | 19000 | 21000 |
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.
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.
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.
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.
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.
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
- How to make a profit and loss statement in Excel
- How to calculate free cash flow in Excel
- How to calculate the interest coverage ratio in Excel
- How to calculate profit margin in Excel
- ABC inventory analysis in Excel
- How to make an accounts payable aging report in Excel
Updated