Price to Sales (P/S) since 2005
Difficulty: Beginner
Calculation
Comcast Corp., P/S, long-term trends, calculation
| P/S | = | Share price1, 2, 3 | ÷ | Sales per share1 | Sales per share1 | = | Revenue1 (in millions) |
÷ | No. shares of common stock outstanding2 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Dec 31, 2005 | 2.55 | = | 8.84 | ÷ | 3.47 | 3.47 | = | 22,255 | ÷ | 6,415,858,822 |
| Dec 31, 2006 | 3.31 | = | 13.24 | ÷ | 4.00 | 4.00 | = | 24,966 | ÷ | 6,239,054,684 |
| Dec 31, 2007 | 1.96 | = | 10.08 | ÷ | 5.13 | 5.13 | = | 30,895 | ÷ | 6,022,069,966 |
| Dec 31, 2008 | 1.08 | = | 6.42 | ÷ | 5.95 | 5.95 | = | 34,256 | ÷ | 5,761,276,598 |
| Dec 31, 2009 | 1.28 | = | 8.07 | ÷ | 6.30 | 6.30 | = | 35,756 | ÷ | 5,675,147,612 |
| Dec 31, 2010 | 1.85 | = | 12.63 | ÷ | 6.83 | 6.83 | = | 37,937 | ÷ | 5,552,998,340 |
| Dec 31, 2011 | 1.44 | = | 14.91 | ÷ | 10.32 | 10.32 | = | 55,842 | ÷ | 5,411,867,382 |
| Dec 31, 2012 | 1.69 | = | 20.04 | ÷ | 11.85 | 11.85 | = | 62,570 | ÷ | 5,278,984,946 |
| Dec 31, 2013 | 2.23 | = | 27.62 | ÷ | 12.40 | 12.40 | = | 64,657 | ÷ | 5,213,099,376 |
| Dec 31, 2014 | 2.19 | = | 29.69 | ÷ | 13.53 | 13.53 | = | 68,775 | ÷ | 5,082,134,148 |
| Dec 31, 2015 | 1.95 | = | 29.71 | ÷ | 15.25 | 15.25 | = | 74,510 | ÷ | 4,884,796,726 |
| Dec 31, 2016 | 2.22 | = | 37.63 | ÷ | 16.92 | 16.92 | = | 80,403 | ÷ | 4,751,603,386 |
| Dec 31, 2017 | 2.34 | = | 42.53 | ÷ | 18.20 | 18.20 | = | 84,526 | ÷ | 4,644,508,017 |
1 USD $
2 Data adjusted for splits and stock dividends.
3 Close price on the filing date of Comcast Corp.'s Annual Report.
Source: Based on data from Comcast Corp. Annual Reports
Comparison to Competitors
Comcast Corp., P/S, long-term trends, comparison to competitors
| Comcast Corp. | Charter Communications Inc. | Time Warner Inc. | Twenty-First Century Fox Inc. | Walt Disney Co. | |
|---|---|---|---|---|---|
| Dec 31, 2005 | 2.55 | – | 1.79 | 2.21 | 1.55 |
| Dec 31, 2006 | 3.31 | – | 1.86 | 2.31 | 1.99 |
| Dec 31, 2007 | 1.96 | – | 1.27 | 2.23 | 1.69 |
| Dec 31, 2008 | 1.08 | – | 0.56 | 1.08 | 0.92 |
| Dec 31, 2009 | 1.28 | – | 1.31 | 0.97 | 1.59 |
| Dec 31, 2010 | 1.85 | 0.84 | 1.55 | 1.13 | 1.83 |
| Dec 31, 2011 | 1.44 | 0.98 | 1.26 | 1.33 | 1.47 |
| Dec 31, 2012 | 1.69 | 1.15 | 1.72 | 1.64 | 2.04 |
| Dec 31, 2013 | 2.23 | 1.63 | 1.94 | 2.62 | 2.70 |
| Dec 31, 2014 | 2.19 | 2.19 | 2.50 | 2.46 | 3.12 |
| Dec 31, 2015 | 1.95 | 1.86 | 1.87 | 2.10 | 3.74 |
| Dec 31, 2016 | 2.22 | 3.01 | 2.56 | 1.78 | 2.81 |
| Dec 31, 2017 | 2.34 | 2.22 | 2.35 | 1.83 | 2.81 |
Source: Based on data from Comcast Corp. Annual Reports
Comparison to Media Sector
Comcast Corp., P/S, long-term trends, comparison to Media sector
| Comcast Corp. | Media | |
|---|---|---|
| Dec 31, 2005 | 2.55 | 1.95 |
| Dec 31, 2006 | 3.31 | 2.27 |
| Dec 31, 2007 | 1.96 | 1.72 |
| Dec 31, 2008 | 1.08 | 0.88 |
| Dec 31, 2009 | 1.28 | 1.30 |
| Dec 31, 2010 | 1.85 | 1.57 |
| Dec 31, 2011 | 1.44 | 1.38 |
| Dec 31, 2012 | 1.69 | 1.75 |
| Dec 31, 2013 | 2.23 | 2.33 |
| Dec 31, 2014 | 2.19 | 2.53 |
| Dec 31, 2015 | 1.95 | 2.44 |
| Dec 31, 2016 | 2.22 | 2.46 |
| Dec 31, 2017 | 2.34 | 2.37 |
Source: Based on data from Comcast Corp. Annual Reports
Comparison to Consumer Services Industry
Comcast Corp., P/S, long-term trends, comparison to Consumer Services industry
| Comcast Corp. | Consumer Services | |
|---|---|---|
| Dec 31, 2005 | 2.55 | 1.16 |
| Dec 31, 2006 | 3.31 | 1.13 |
| Dec 31, 2007 | 1.96 | 0.94 |
| Dec 31, 2008 | 1.08 | 0.66 |
| Dec 31, 2009 | 1.28 | 0.74 |
| Dec 31, 2010 | 1.85 | 0.87 |
| Dec 31, 2011 | 1.44 | 0.83 |
| Dec 31, 2012 | 1.69 | 0.95 |
| Dec 31, 2013 | 2.23 | 1.17 |
| Dec 31, 2014 | 2.19 | 1.19 |
| Dec 31, 2015 | 1.95 | 1.29 |
| Dec 31, 2016 | 2.22 | 1.32 |
| Dec 31, 2017 | 2.34 | 1.48 |
Source: Based on data from Comcast Corp. Annual Reports