Microsoft Excel LibreOffice Calc

Comcast Corp. (CMCSA)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

Comcast Corp., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Net fixed asset turnover 2.32 2.25 2.16 2.13 2.22 2.22 2.22 2.20 2.21 2.26 2.24 2.22 2.21 2.18 2.21 2.21 2.27 2.25 2.22 2.22 — — —
Total asset turnover 0.42 0.40 0.38 0.38 0.44 0.46 0.46 0.45 0.45 0.46 0.45 0.45 0.44 0.44 0.44 0.45 0.46 0.45 0.44 0.43 — — —
Equity turnover 1.39 1.35 1.32 1.32 1.24 1.24 1.25 1.23 1.51 1.53 1.49 1.49 1.47 1.43 1.43 1.43 1.41 1.36 1.33 1.30 — — —

Based on: 10-Q (filing date: 2019-10-24), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Comcast Corp.’s net fixed asset turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Comcast Corp.’s total asset turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Comcast Corp.’s equity turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Net Fixed Asset Turnover

Comcast Corp., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Revenue 26,827  26,858  26,859  27,846  22,135  21,735  22,791  21,915  20,983  21,165  20,463  21,025  21,319  19,269  18,790  19,245  18,669  18,743  17,853  17,732  16,791  16,844  17,408 
Property and equipment, net of accumulated depreciation 46,790  46,047  45,721  44,437  39,855  39,355  39,068  38,470  37,856  37,171  36,626  36,253  35,656  34,896  34,122  33,665  32,170  31,572  31,127  30,953  30,362  29,970  29,588 
Long-term Activity Ratio
Net fixed asset turnover1 2.32 2.25 2.16 2.13 2.22 2.22 2.22 2.20 2.21 2.26 2.24 2.22 2.21 2.18 2.21 2.21 2.27 2.25 2.22 2.22 — — —
Benchmarks
Net Fixed Asset Turnover, Competitors2
Charter Communications Inc. 1.32 1.30 1.27 1.24 1.24 1.24 1.24 1.23 1.24 1.24 1.12 0.88 0.65 0.41 1.20 1.17 1.16 1.14 1.12 1.09 — — —
Walt Disney Co. 2.06 1.93 1.99 2.01 1.97 1.95 1.95 1.94 2.00 2.03 2.04 2.03 2.08 2.08 2.13 2.08 2.10 2.13 2.11 2.09 — — —

Based on: 10-Q (filing date: 2019-10-24), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q3 2019 Calculation
Net fixed asset turnover = (RevenueQ3 2019 + RevenueQ2 2019 + RevenueQ1 2019 + RevenueQ4 2018) ÷ Property and equipment, net of accumulated depreciation
= (26,827 + 26,858 + 26,859 + 27,846) ÷ 46,790 = 2.32

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Comcast Corp.’s net fixed asset turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Total Asset Turnover

Comcast Corp., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Revenue 26,827  26,858  26,859  27,846  22,135  21,735  22,791  21,915  20,983  21,165  20,463  21,025  21,319  19,269  18,790  19,245  18,669  18,743  17,853  17,732  16,791  16,844  17,408 
Total assets 256,374  256,555  256,189  251,684  200,635  191,248  190,876  186,949  185,301  183,031  182,479  180,500  177,924  171,985  170,599  166,574  158,958  159,674  158,757  159,339  159,237  157,459  157,773 
Long-term Activity Ratio
Total asset turnover1 0.42 0.40 0.38 0.38 0.44 0.46 0.46 0.45 0.45 0.46 0.45 0.45 0.44 0.44 0.44 0.45 0.46 0.45 0.44 0.43 — — —
Benchmarks
Total Asset Turnover, Competitors2
Charter Communications Inc. 0.31 0.31 0.30 0.30 0.29 0.29 0.29 0.28 0.28 0.28 0.25 0.19 0.14 0.09 0.24 0.25 0.26 0.55 0.38 0.37 — — —
Walt Disney Co. 0.31 0.28 0.59 0.60 0.59 0.58 0.57 0.58 0.60 0.60 0.60 0.60 0.62 0.61 0.60 0.59 0.59 0.59 0.57 0.58 — — —

Based on: 10-Q (filing date: 2019-10-24), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q3 2019 Calculation
Total asset turnover = (RevenueQ3 2019 + RevenueQ2 2019 + RevenueQ1 2019 + RevenueQ4 2018) ÷ Total assets
= (26,827 + 26,858 + 26,859 + 27,846) ÷ 256,374 = 0.42

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Comcast Corp.’s total asset turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.

Equity Turnover

Comcast Corp., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015 Dec 31, 2014 Sep 30, 2014 Jun 30, 2014 Mar 31, 2014
Selected Financial Data (US$ in millions)
Revenue 26,827  26,858  26,859  27,846  22,135  21,735  22,791  21,915  20,983  21,165  20,463  21,025  21,319  19,269  18,790  19,245  18,669  18,743  17,853  17,732  16,791  16,844  17,408 
Total Comcast Corporation shareholders’ equity 78,144  76,850  74,959  71,613  71,523  70,694  69,482  68,606  55,427  55,005  55,059  53,943  53,481  53,098  52,642  52,269  51,716  52,400  52,171  52,711  53,298  51,971  51,268 
Long-term Activity Ratio
Equity turnover1 1.39 1.35 1.32 1.32 1.24 1.24 1.25 1.23 1.51 1.53 1.49 1.49 1.47 1.43 1.43 1.43 1.41 1.36 1.33 1.30 — — —
Benchmarks
Equity Turnover, Competitors2
Charter Communications Inc. 1.37 1.27 1.24 1.20 1.16 1.14 1.09 1.06 1.24 1.11 0.92 0.72 0.53 0.34 — — 160.03 — 120.36 62.38 — — —
Walt Disney Co. 0.72 0.66 1.18 1.22 1.26 1.26 1.29 1.33 1.30 1.27 1.28 1.29 1.27 1.24 1.24 1.18 1.10 1.10 1.13 1.09 — — —

Based on: 10-Q (filing date: 2019-10-24), 10-Q (filing date: 2019-07-25), 10-Q (filing date: 2019-04-25), 10-K (filing date: 2019-01-31), 10-Q (filing date: 2018-10-25), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-04-25), 10-K (filing date: 2018-01-31), 10-Q (filing date: 2017-10-26), 10-Q (filing date: 2017-07-27), 10-Q (filing date: 2017-04-27), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-10-26), 10-Q (filing date: 2016-07-27), 10-Q (filing date: 2016-04-27), 10-K (filing date: 2016-02-05), 10-Q (filing date: 2015-10-27), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-05-04), 10-K (filing date: 2015-02-27), 10-Q (filing date: 2014-10-23), 10-Q (filing date: 2014-07-24), 10-Q (filing date: 2014-04-22).

1 Q3 2019 Calculation
Equity turnover = (RevenueQ3 2019 + RevenueQ2 2019 + RevenueQ1 2019 + RevenueQ4 2018) ÷ Total Comcast Corporation shareholders’ equity
= (26,827 + 26,858 + 26,859 + 27,846) ÷ 78,144 = 1.39

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Comcast Corp.’s equity turnover ratio improved from Q1 2019 to Q2 2019 and from Q2 2019 to Q3 2019.