Free calculator

EBITDA calculator

Compute EBITDA (earnings before interest, taxes, depreciation, and amortization) using either net income + interest + taxes + D&A or operating income (EBIT) + D&A—the two textbook paths. Depreciation and amortization stay separate so you can mirror Google Sheets and Excel. Optionally add revenue to see EBITDA margin %. Same currency throughout. Not adjusted EBITDA add-backs, not a GAAP or IFRS filing tool, not M&A or broker valuation advice—illustration only.

Choose how your inputs are organized:

Use the tab that matches the lines you already have; both arrive at the same EBITDA definition when the underlying statements reconcile.

Net income

Bottom-line net income for the same period as the add-backs (often labeled net earnings or net profit).

Interest expense

Typically positive when entered as an expense; use the sign your P&L uses (some displays net finance income).

Income taxes

Income tax expense for the period—usually positive as an expense; rare benefits may show as negative.

Depreciation

P&L depreciation on tangible assets for the same period (0 if none).

Amortization

P&L amortization of intangibles for the same period (0 if none).

Revenue (optional, for margin)

If greater than 0, we show EBITDA margin % = EBITDA ÷ revenue × 100. Leave blank to hide margin.

Results

EBITDA: 130,000
EBITDA margin: 26 %

Educational illustration only. Line-item definitions differ by accounting standard and company policy. You supply all numbers; we do not pull filings or benchmarks.

When to use this calculator

Quick operating earnings checks before you wire a full three-statement model in Sheets or Excel.

You have net income and the usual add-backs on one annual or quarterly view and want EBITDA without opening a template.
You already pulled EBIT and D&A from the face of the P&L and want EBITDA in one step.
You need EBITDA margin % for a single period when revenue and EBITDA are both known or just computed here.
Real estate NOI is a different metric—use the NOI calculator when the question is property cashflow before financing, not company P&L EBITDA.

How do you calculate EBITDA here?

We implement two common reconciling definitions used in models and interviews—you pick the input shape you already have.

From net income

EBITDA = net income + interest expense + income taxes + depreciation + amortization. Use the signs your P&L uses for interest and taxes.

From operating income

EBITDA = operating income (EBIT) + depreciation + amortization—same total as the net-income path when statements tie out.

EBITDA margin (optional)

When revenue > 0, EBITDA margin % = (EBITDA ÷ revenue) × 100. This is not gross margin or operating margin—only EBITDA over revenue.

What we do not model

Adjusted EBITDA add-backs, stock-based compensation policy choices, lease accounting presentation differences, currency translation, non-controlling interest, equity earnings, LTM / TTM rollups, or EV/EBITDA multiples—use your close package or a full model.

For real estate NOI and unlevered cap rate, use the NOI calculator and cap rate calculator elsewhere on this site—those metrics are not the same as corporate P&L EBITDA here.

Google Sheets & Excel

English function names. Net-income path: put net income in N2, interest in I2, taxes in T2, depreciation in D2, amortization in A2. EBIT path: put EBIT in B2; reuse D2/A2 for D&A. Optional revenue in R2 for margin.

EBITDA (net-income path)

=N2+I2+T2+D2+A2

Adjust cell letters to match your sheet layout.

EBITDA (EBIT path)

=B2+D2+A2

B2 = operating income (EBIT); D2/A2 depreciation and amortization.

EBITDA margin (decimal; format as %)

=E2/R2

If EBITDA is in E2 and revenue in R2; format as % or multiply by 100.

More tools in Unit economics

Browse all tools

Frequently asked questions

What does this EBITDA calculator do?

It computes EBITDA from either net income + interest + taxes + depreciation + amortization or operating income (EBIT) + depreciation + amortization, and optionally EBITDA margin % when you enter revenue > 0.

Why are there two tabs?

Statements and models surface the same EBITDA through different starting lines. Some teams start from net income and add back financing and non-cash D&A; others start from EBIT and add D&A only.

How is EBITDA margin calculated?

EBITDA margin % = (EBITDA ÷ revenue) × 100 when revenue is greater than 0. Leave revenue blank if you only need EBITDA in dollars.

Is EBITDA the same as NOI?

No. NOI (net operating income) is common in commercial real estate and is not the same line as corporate EBITDA on a company P&L. Use the NOI calculator for rent, vacancy, and property opex.

Can EBITDA be negative?

Yes. When operating income or the net-income path sum is below zero, EBITDA is negative—the tool still shows the number.

How do I match this in Google Sheets or Excel?

Use the spreadsheet block: =N2+I2+T2+D2+A2 for the net-income path with those labels in row 2, or =B2+D2+A2 for EBIT + D + A. For margin with EBITDA in E2 and revenue in R2, =E2/R2 formatted as %.

Is this audited financial advice?

No. It is a free educational calculator with numbers you enter. Auditors, tax authorities, and buyers apply their own policies and due diligence—not this page.

Explore templates Modeling services Book a consultation