MarketXLS

EBITDA (Historical)

Returns historical EBITDA (Earnings Before Interest, Taxes, Depreciation, and Amortization) for a company. EBITDA is a measure of operating performance that excludes financing and accounting decisions, making it useful for comparing companies across industries.

Formula

EBITDA = Operating Income + Depreciation + Amortization
      OR
EBITDA = Net Income + Interest + Taxes + Depreciation + Amortization

Supported Symbols

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ
International SYMBOL SHOP, TSM

Parameters

Parameter Description
Symbol Stock ticker symbol
Year Fiscal year (2020, 2021) or period code (lq, ly, lt)
Quarter Optional: 1, 2, 3, or 4 for quarterly data
TTM Optional: Set to "TTM" for trailing twelve months

Uses of EBITDA

Use Case Description
Valuation EV/EBITDA multiples
Comparison Compare profitability across companies
Debt Analysis Debt/EBITDA leverage ratios
Cash Proxy Rough estimate of operating cash generation

Notes

  • EBITDA is not GAAP but widely used
  • Does not account for capital expenditures
  • Values are in company's reporting currency

Syntax

=hf_EBITDA(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (lq, ly, etc.)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

EBITDA value in company's reporting currency

Examples

=hf_EBITDA("AAPL", 2023)
Apple EBITDA
=hf_EBITDA("MSFT", 2023, 2)
Microsoft Q2 2023
=hf_EBITDA("GOOGL", "ly")
Alphabet last fiscal year
=hf_EBITDA("AMZN", 2023, , "TTM")
Amazon TTM
=hf_EBITDA(A1, B1, C1)
Cell references

When to Use

  • Calculating EV/EBITDA valuation multiples
  • Comparing profitability across companies
  • Analyzing operating performance trends
  • Debt capacity analysis
  • M&A valuation analysis

When NOT to Use

Scenario Use Instead
Need current EBITDA EBITDA()
Need USD values hf_EBITDA_USD()
Need EBITDA margin hf_EBITDA_Margin()
Need net income hf_Net_Income()
Need operating income hf_Operating_Income()

Common Issues & FAQ

Why is EBITDA controversial?

EBITDA ignores capital expenditures and working capital needs. It can overstate cash generation for capital-intensive businesses.

How do I calculate EV/EBITDA?

EV/EBITDA = Enterprise Value / EBITDA. Use EnterpriseValue() and hf_EBITDA() together.

Why am I getting "NA"?

Check that the symbol is valid and the company has sufficient financial data to calculate EBITDA.

Excel Templates Using EBITDA (Historical)

These ready-made MarketXLS templates call hf_EBITDA() in their worksheet formulas. Open one to see the function working inside a complete model.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use EBITDA (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions