Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Logout MarketXLS

Enterprise Value Over EBITDA (Historical)

Live
Compares the value of a company—debt included—to the company’s cash earnings less non-cash expenses. The EV/EBITDA metric is a popular valuation tool that helps investors compare companies in order to make an investment decision.

Example usage

=hf_Enterprise_Value_over_EBITDA("MSFT",2021) - Returns the value for the year 2021.
=hf_Enterprise_Value_over_EBITDA("MSFT",2021,2) - Returns the value for the year 2021 and the calendar quarter 2
=hf_Enterprise_Value_over_EBITDA("MSFT",2021,3,"TTM") - Returns the value for the year 2021 and trailing twelve months from the calendar quarter
=hf_Enterprise_Value_over_EBITDA("MSFT","lq") - Returns the value for the last quarter
=hf_Enterprise_Value_over_EBITDA("MSFT","lq-1") - Returns the value for the last quarter-1
=hf_Enterprise_Value_over_EBITDA("MSFT","ly") - Returns the value for the last year
=hf_Enterprise_Value_over_EBITDA("MSFT","ly-1") - Returns the value for the last year - 1
=hf_Enterprise_Value_over_EBITDA("MSFT","lt") - Returns the value for the last 12 months.
=hf_Enterprise_Value_over_EBITDA("MSFT","lt-1") - Returns the value for the previous last 12 months.

Notes

The EV/EBITDA for the S&P 500 has typically averaged from 11 to 14 over the last few years. As a general guideline, an EV/EBITDA value below 10 is commonly interpreted as healthy and above average by analysts and investors.

Assets

Stocks