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


Common Stock Valuation Ratios (Price Multiples)

Difficulty: Beginner


Current Valuation Ratios

Comcast Corp., current price multiples

Microsoft Excel LibreOffice Calc
Comcast Corp. Charter Communications Inc. Twenty-First Century Fox Inc. Walt Disney Co. Media Consumer Services
Selected Financial Data
Current share price (P) $ hidden
No. shares of common stock outstanding hidden
Growth rate (g) hidden
 
Earnings per share (EPS) $ hidden
Next year expected EPS $ hidden
Operating profit per share $ hidden
Sales per share $ hidden
Book value per share (BVPS) $ hidden
Ratios (Price Multiples)
Price to earnings (P/E) hidden hidden hidden hidden hidden hidden
Price to next year expected earnings hidden hidden hidden hidden hidden hidden
Price-earnings-growth (PEG) hidden hidden hidden hidden hidden hidden
Price to operating profit (P/OP) hidden hidden hidden hidden hidden hidden
Price to sales (P/S) hidden hidden hidden hidden hidden hidden
Price to book value (P/BV) hidden hidden hidden hidden hidden hidden

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

If company price multiple is lower then the price multiple of benchmark then company stock is relatively undervalued.

Otherwise, if company price multiple is higher then the price multiple of benchmark then company stock is relatively overvalued.


Historical Valuation Ratios (Summary)

Comcast Corp., historical price multiples

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Price to earnings (P/E) hidden hidden hidden hidden hidden
Price to operating profit (P/OP) hidden hidden hidden hidden hidden
Price to sales (P/S) hidden hidden hidden hidden hidden
Price to book value (P/BV) 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).

Ratio Description The company
P/E ratio The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. Comcast Corp.'s P/E ratio increased from 2015 to 2016 but then declined significantly from 2016 to 2017.
P/OP ratio Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. Comcast Corp.'s P/OP ratio increased from 2015 to 2016 and from 2016 to 2017.
P/S ratio An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. Comcast Corp.'s P/S ratio increased from 2015 to 2016 and from 2016 to 2017.
P/BV ratio The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company's required rate of return and its actual rate of return. Comcast Corp.'s P/BV ratio increased from 2015 to 2016 but then slightly declined from 2016 to 2017 not reaching 2015 level.

Price to Earnings (P/E)

Comcast Corp., historical P/E calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Net income attributable to Comcast Corporation (in millions) hidden hidden hidden hidden hidden
Earnings per share (EPS)3 hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden
Ratio
P/E ratio4 hidden hidden hidden hidden hidden
Benchmarks
P/E Ratio, 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
P/E Ratio, Sector
Media hidden hidden hidden hidden hidden
P/E Ratio, 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).

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Comcast Corp.'s Annual Report.

2017 Calculations

3 EPS = Net income attributable to Comcast Corporation ÷ No. shares of common stock outstanding
= hidden ÷ hidden = hidden

4 P/E ratio = Share price ÷ EPS
= hidden ÷ hidden = hidden

Ratio Description The company
P/E ratio The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. Comcast Corp.'s P/E ratio increased from 2015 to 2016 but then declined significantly from 2016 to 2017.

Price to Operating Profit (P/OP)

Comcast Corp., historical P/OP calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Operating income (in millions) hidden hidden hidden hidden hidden
Operating profit per share3 hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden
Ratio
P/OP ratio4 hidden hidden hidden hidden hidden
Benchmarks
P/OP Ratio, 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
P/OP Ratio, Sector
Media hidden hidden hidden hidden hidden
P/OP Ratio, 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).

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Comcast Corp.'s Annual Report.

2017 Calculations

3 Operating profit per share = Operating income ÷ No. shares of common stock outstanding
= hidden ÷ hidden = hidden

4 P/OP ratio = Share price ÷ Operating profit per share
= hidden ÷ hidden = hidden

Ratio Description The company
P/OP ratio Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. Comcast Corp.'s P/OP ratio increased from 2015 to 2016 and from 2016 to 2017.

Price to Sales (P/S)

Comcast Corp., historical P/S calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Revenue (in millions) hidden hidden hidden hidden hidden
Sales per share3 hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden
Ratio
P/S ratio4 hidden hidden hidden hidden hidden
Benchmarks
P/S Ratio, 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
P/S Ratio, Sector
Media hidden hidden hidden hidden hidden
P/S Ratio, 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).

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Comcast Corp.'s Annual Report.

2017 Calculations

3 Sales per share = Revenue ÷ No. shares of common stock outstanding
= hidden ÷ hidden = hidden

4 P/S ratio = Share price ÷ Sales per share
= hidden ÷ hidden = hidden

Ratio Description The company
P/S ratio An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. Comcast Corp.'s P/S ratio increased from 2015 to 2016 and from 2016 to 2017.

Price to Book Value (P/BV)

Comcast Corp., historical P/BV calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
No. shares of common stock outstanding1 hidden hidden hidden hidden hidden
Selected Financial Data (USD $)
Total Comcast Corporation shareholders' equity (in millions) hidden hidden hidden hidden hidden
Book value per share (BVPS)3 hidden hidden hidden hidden hidden
Share price1, 2 hidden hidden hidden hidden hidden
Ratio
P/BV ratio4 hidden hidden hidden hidden hidden
Benchmarks
P/BV Ratio, 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
P/BV Ratio, Sector
Media hidden hidden hidden hidden hidden
P/BV Ratio, 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).

1 Data adjusted for splits and stock dividends.

2 Close price on the filing date of Comcast Corp.'s Annual Report.

2017 Calculations

3 BVPS = Total Comcast Corporation shareholders' equity ÷ No. shares of common stock outstanding
= hidden ÷ hidden = hidden

4 P/BV ratio = Share price ÷ BVPS
= hidden ÷ hidden = hidden

Ratio Description The company
P/BV ratio The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company's required rate of return and its actual rate of return. Comcast Corp.'s P/BV ratio increased from 2015 to 2016 but then slightly declined from 2016 to 2017 not reaching 2015 level.