Microsoft Excel LibreOffice Calc

Comcast Corp. (CMCSA)


Analysis of Profitability Ratios

Beginner level


Profitability Ratios (Summary)

Comcast Corp., profitability ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Return on Sales
Gross profit margin 68.58% 69.97% 69.57% 69.74% 69.59%
Operating profit margin 20.11% 21.28% 20.97% 21.47% 21.67%
Net profit margin 12.41% 26.87% 10.81% 10.96% 12.18%
Return on Investment
Return on equity (ROE) 16.38% 33.11% 16.12% 15.62% 15.90%
Return on assets (ROA) 4.66% 12.15% 4.82% 4.90% 5.26%

Based on: 10-K (filing date: 2019-01-31), 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).

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Comcast Corp.’s gross profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Comcast Corp.’s operating profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Comcast Corp.’s net profit margin ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Comcast Corp.’s ROE improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.
ROA A profitability ratio calculated as net income divided by total assets. Comcast Corp.’s ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Gross Profit Margin

Comcast Corp., gross profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Gross profit 64,815  59,142  55,940  51,960  47,863 
Revenue 94,507  84,526  80,403  74,510  68,775 
Profitability Ratio
Gross profit margin1 68.58% 69.97% 69.57% 69.74% 69.59%
Benchmarks
Gross Profit Margin, Competitors2
Charter Communications Inc. 36.15% 36.17% 35.68% 34.12% 34.42%
Walt Disney Co. 44.94% 45.04% 46.09% 45.94% 45.88%

Based on: 10-K (filing date: 2019-01-31), 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).

1 2018 Calculation
Gross profit margin = 100 × Gross profit ÷ Revenue
= 100 × 64,815 ÷ 94,507 = 68.58%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Gross profit margin Gross profit margin indicates the percentage of revenue available to cover operating and other expenditures. Comcast Corp.’s gross profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Operating Profit Margin

Comcast Corp., operating profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Operating income 19,009  17,987  16,859  15,998  14,904 
Revenue 94,507  84,526  80,403  74,510  68,775 
Profitability Ratio
Operating profit margin1 20.11% 21.28% 20.97% 21.47% 21.67%
Benchmarks
Operating Profit Margin, Competitors2
Charter Communications Inc. 11.97% 9.87% 8.47% 11.42% 10.66%
Walt Disney Co. 24.91% 24.98% 25.53% 25.10% 23.35%
Operating Profit Margin, Sector
Media 19.76% 19.79% 20.31% 22.15% 21.53%
Operating Profit Margin, Industry
Consumer Services 8.01% 8.35% 8.49% 8.65% 8.19%

Based on: 10-K (filing date: 2019-01-31), 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).

1 2018 Calculation
Operating profit margin = 100 × Operating income ÷ Revenue
= 100 × 19,009 ÷ 94,507 = 20.11%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Operating profit margin A profitability ratio calculated as operating income divided by revenue. Comcast Corp.’s operating profit margin ratio improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

Net Profit Margin

Comcast Corp., net profit margin calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Net income attributable to Comcast Corporation 11,731  22,714  8,695  8,163  8,380 
Revenue 94,507  84,526  80,403  74,510  68,775 
Profitability Ratio
Net profit margin1 12.41% 26.87% 10.81% 10.96% 12.18%
Benchmarks
Net Profit Margin, Competitors2
Charter Communications Inc. 2.82% 23.80% 12.14% -2.78% -2.01%
Walt Disney Co. 21.20% 16.29% 16.88% 15.98% 15.37%
Net Profit Margin, Sector
Media 12.94% 22.95% 13.09% 11.90% 12.39%
Net Profit Margin, Industry
Consumer Services 5.21% 6.13% 5.59% 4.91% 4.57%

Based on: 10-K (filing date: 2019-01-31), 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).

1 2018 Calculation
Net profit margin = 100 × Net income attributable to Comcast Corporation ÷ Revenue
= 100 × 11,731 ÷ 94,507 = 12.41%

2 Click competitor name to see calculations.

Profitability ratio Description The company
Net profit margin An indicator of profitability, calculated as net income divided by revenue. Comcast Corp.’s net profit margin ratio improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Return on Equity (ROE)

Comcast Corp., ROE calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Net income attributable to Comcast Corporation 11,731  22,714  8,695  8,163  8,380 
Total Comcast Corporation shareholders’ equity 71,613  68,606  53,943  52,269  52,711 
Profitability Ratio
ROE1 16.38% 33.11% 16.12% 15.62% 15.90%
Benchmarks
ROE, Competitors2
Charter Communications Inc. 3.39% 25.32% 8.77% -125.34%
Walt Disney Co. 25.83% 21.74% 21.71% 18.83% 16.68%
ROE, Sector
Media 16.31% 27.91% 15.73% 16.82% 16.05%
ROE, Industry
Consumer Services 22.00% 25.70% 22.46% 20.77% 17.69%

Based on: 10-K (filing date: 2019-01-31), 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).

1 2018 Calculation
ROE = 100 × Net income attributable to Comcast Corporation ÷ Total Comcast Corporation shareholders’ equity
= 100 × 11,731 ÷ 71,613 = 16.38%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROE A profitability ratio calculated as net income divided by shareholders’ equity. Comcast Corp.’s ROE improved from 2016 to 2017 but then slightly deteriorated from 2017 to 2018 not reaching 2016 level.

Return on Assets (ROA)

Comcast Corp., ROA calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (US$ in millions)
Net income attributable to Comcast Corporation 11,731  22,714  8,695  8,163  8,380 
Total assets 251,684  186,949  180,500  166,574  159,339 
Profitability Ratio
ROA1 4.66% 12.15% 4.82% 4.90% 5.26%
Benchmarks
ROA, Competitors2
Charter Communications Inc. 0.84% 6.75% 2.36% -0.69% -0.75%
Walt Disney Co. 12.78% 9.37% 10.20% 9.51% 8.91%
ROA, Sector
Media 5.15% 9.69% 5.13% 5.53% 5.86%
ROA, Industry
Consumer Services 6.25% 8.02% 7.28% 6.91% 6.46%

Based on: 10-K (filing date: 2019-01-31), 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).

1 2018 Calculation
ROA = 100 × Net income attributable to Comcast Corporation ÷ Total assets
= 100 × 11,731 ÷ 251,684 = 4.66%

2 Click competitor name to see calculations.

Profitability ratio Description The company
ROA A profitability ratio calculated as net income divided by total assets. Comcast Corp.’s ROA improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.