Paying users zone. Data is covered by hidden.

  • Get to Comcast Corp. for $19.99, or

  • get to whole website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Enterprise Value to EBITDA (EV/EBITDA)

Difficulty: Intermediate


Earnings before Interest, Tax, Depreciation and Amortization (EBITDA)

Comcast Corp., EBITDA calculation

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Net income attributable to Comcast Corporation hidden hidden hidden hidden hidden
Add: Net income attributable to noncontrolling interest hidden hidden hidden hidden hidden
Add: Income tax expense hidden hidden hidden hidden hidden
Earnings before tax (EBT) hidden hidden hidden hidden hidden
Add: Interest expense hidden hidden hidden hidden hidden
Earnings before interest and tax (EBIT) hidden hidden hidden hidden hidden
Add: Depreciation, amortization and other operating gains hidden hidden hidden hidden hidden
Earnings before interest, tax, depreciation and amortization (EBITDA) hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-12).

Item Description The company
EBITDA To calculate EBITDA analysts start with net earnings. To that earnings number, interest, taxes, depreciation, and amortization are added. EBITDA as a pre-interest number is a flow to all providers of capital. Comcast Corp.'s EBITDA increased from 2015 to 2016 and from 2016 to 2017.

Enterprise Value to EBITDA Ratio, Current

Comcast Corp., current EV/EBITDA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Selected Financial Data (USD $ in millions)
Enterprise value (EV) hidden
Earnings before interest, tax, depreciation and amortization (EBITDA) hidden
Ratio
EV/EBITDA hidden
Benchmarks
EV/EBITDA, Competitors
Charter Communications Inc. hidden
Twenty-First Century Fox Inc. hidden
Walt Disney Co. hidden
EV/EBITDA, Sector
Media hidden
EV/EBITDA, Industry
Consumer Services hidden

Based on: 10-K (filing date: 2018-01-31).

If company EV/EBITDA is lower then the EV/EBITDA of benchmark then company is relatively undervalued.

Otherwise, if company EV/EBITDA is higher then the EV/EBITDA of benchmark then company is relatively overvalued.


Enterprise Value to EBITDA Ratio, Historical

Comcast Corp., historical EV/EBITDA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Enterprise value (EV)1 hidden hidden hidden hidden hidden
Earnings before interest, tax, depreciation and amortization (EBITDA)2 hidden hidden hidden hidden hidden
Ratio
EV/EBITDA3 hidden hidden hidden hidden hidden
Benchmarks
EV/EBITDA, Competitors
Charter Communications Inc. hidden hidden hidden hidden hidden
Twenty-First Century Fox Inc. hidden hidden hidden hidden hidden
Walt Disney Co. hidden hidden hidden hidden hidden
EV/EBITDA, Sector
Media hidden hidden hidden hidden hidden
EV/EBITDA, Industry
Consumer Services hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-01-31), 10-K (filing date: 2017-02-03), 10-K (filing date: 2016-02-05), 10-K (filing date: 2015-02-27), 10-K (filing date: 2014-02-12).

2017 Calculations

3 EV/EBITDA = EV ÷ EBITDA
= hidden ÷ hidden = hidden

Ratio Description The company
EV/EBITDA EV/EBITDA is a valuation indicator for the overall company rather than common stock. Comcast Corp.'s EV/EBITDA ratio increased from 2015 to 2016 and from 2016 to 2017.