Microsoft Excel LibreOffice Calc

Coca-Cola Co. (KO)

Long-term (Investment) Activity Analysis
Quarterly Data

Difficulty: Beginner

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

Ratios (Summary)

Coca-Cola Co., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 31, 2017 Sep 29, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jul 1, 2016 Apr 1, 2016 Dec 31, 2015 Oct 2, 2015 Jul 3, 2015 Apr 3, 2015 Dec 31, 2014 Sep 26, 2014 Jun 27, 2014 Mar 28, 2014 Dec 31, 2013 Sep 27, 2013 Jun 28, 2013 Mar 29, 2013
Net fixed asset turnover 4.36 4.31 4.25 4.32 4.49 4.48 4.18 3.94 3.80 3.42 3.48 3.52 3.58 3.18 3.22 3.14 3.13 3.10 3.12 3.13 – – –
Total asset turnover 0.37 0.37 0.36 0.40 0.41 0.43 0.45 0.48 0.45 0.46 0.48 0.49 0.49 0.49 0.51 0.50 0.48 0.48 0.51 0.52 – – –
Equity turnover 1.77 1.81 1.73 2.07 1.69 1.77 1.78 1.82 1.63 1.62 1.76 1.73 1.73 1.61 1.60 1.52 1.38 1.36 1.42 1.41 – – –

Based on: 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-23), 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-24), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-29), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-25), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-30), 10-Q (filing date: 2014-04-24), 10-K (filing date: 2014-02-27), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-04-25).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Coca-Cola Co.'s net fixed asset turnover improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Coca-Cola Co.'s total asset turnover improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Coca-Cola Co.'s equity turnover improved from Q1 2018 to Q2 2018 but then slightly deteriorated from Q2 2018 to Q3 2018 not reaching Q1 2018 level.

Net Fixed Asset Turnover

Coca-Cola Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 31, 2017 Sep 29, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jul 1, 2016 Apr 1, 2016 Dec 31, 2015 Oct 2, 2015 Jul 3, 2015 Apr 3, 2015 Dec 31, 2014 Sep 26, 2014 Jun 27, 2014 Mar 28, 2014 Dec 31, 2013 Sep 27, 2013 Jun 28, 2013 Mar 29, 2013
Selected Financial Data (USD $ in millions)
Net operating revenues 8,245  8,927  7,626  7,512  9,078  9,702  9,118  9,409  10,633  11,539  10,282  10,000  11,427  12,156  10,711  10,872  11,976  12,574  10,576  11,040  12,030  12,749  11,035 
Property, plant and equipment, less accumulated depreciation 7,404  7,688  7,977  8,203  8,306  8,672  9,746  10,635  11,172  12,663  12,613  12,571  12,615  14,365  14,346  14,633  14,738  14,918  14,860  14,967  14,548  14,549  14,543 
Ratio
Net fixed asset turnover1 4.36 4.31 4.25 4.32 4.49 4.48 4.18 3.94 3.80 3.42 3.48 3.52 3.58 3.18 3.22 3.14 3.13 3.10 3.12 3.13 – – –

Based on: 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-23), 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-24), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-29), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-25), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-30), 10-Q (filing date: 2014-04-24), 10-K (filing date: 2014-02-27), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-04-25).

Q3 2018 Calculations

1 Net fixed asset turnover = (Net operating revenuesQ3 2018 + Net operating revenuesQ2 2018 + Net operating revenuesQ1 2018 + Net operating revenuesQ4 2017) ÷ Property, plant and equipment, less accumulated depreciation
= (8,245 + 8,927 + 7,626 + 7,512) ÷ 7,404 = 4.36

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Coca-Cola Co.'s net fixed asset turnover improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Total Asset Turnover

Coca-Cola Co., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 31, 2017 Sep 29, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jul 1, 2016 Apr 1, 2016 Dec 31, 2015 Oct 2, 2015 Jul 3, 2015 Apr 3, 2015 Dec 31, 2014 Sep 26, 2014 Jun 27, 2014 Mar 28, 2014 Dec 31, 2013 Sep 27, 2013 Jun 28, 2013 Mar 29, 2013
Selected Financial Data (USD $ in millions)
Net operating revenues 8,245  8,927  7,626  7,512  9,078  9,702  9,118  9,409  10,633  11,539  10,282  10,000  11,427  12,156  10,711  10,872  11,976  12,574  10,576  11,040  12,030  12,749  11,035 
Total assets 86,877  89,593  93,282  87,896  90,515  91,146  91,201  87,270  93,927  94,094  91,263  90,093  93,008  93,538  91,016  92,023  96,314  95,489  91,289  90,055  89,432  89,511  88,450 
Ratio
Total asset turnover1 0.37 0.37 0.36 0.40 0.41 0.43 0.45 0.48 0.45 0.46 0.48 0.49 0.49 0.49 0.51 0.50 0.48 0.48 0.51 0.52 – – –

Based on: 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-23), 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-24), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-29), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-25), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-30), 10-Q (filing date: 2014-04-24), 10-K (filing date: 2014-02-27), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-04-25).

Q3 2018 Calculations

1 Total asset turnover = (Net operating revenuesQ3 2018 + Net operating revenuesQ2 2018 + Net operating revenuesQ1 2018 + Net operating revenuesQ4 2017) ÷ Total assets
= (8,245 + 8,927 + 7,626 + 7,512) ÷ 86,877 = 0.37

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Coca-Cola Co.'s total asset turnover improved from Q1 2018 to Q2 2018 and from Q2 2018 to Q3 2018.

Equity Turnover

Coca-Cola Co., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Sep 28, 2018 Jun 29, 2018 Mar 30, 2018 Dec 31, 2017 Sep 29, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jul 1, 2016 Apr 1, 2016 Dec 31, 2015 Oct 2, 2015 Jul 3, 2015 Apr 3, 2015 Dec 31, 2014 Sep 26, 2014 Jun 27, 2014 Mar 28, 2014 Dec 31, 2013 Sep 27, 2013 Jun 28, 2013 Mar 29, 2013
Selected Financial Data (USD $ in millions)
Net operating revenues 8,245  8,927  7,626  7,512  9,078  9,702  9,118  9,409  10,633  11,539  10,282  10,000  11,427  12,156  10,711  10,872  11,976  12,574  10,576  11,040  12,030  12,749  11,035 
Equity attributable to shareowners of The Coca-Cola Company 18,264  18,323  19,610  17,072  22,119  22,001  22,876  23,062  26,076  26,637  24,914  25,554  26,049  28,418  28,837  30,320  33,429  34,071  32,654  33,173  32,132  32,223  32,480 
Ratio
Equity turnover1 1.77 1.81 1.73 2.07 1.69 1.77 1.78 1.82 1.63 1.62 1.76 1.73 1.73 1.61 1.60 1.52 1.38 1.36 1.42 1.41 – – –

Based on: 10-Q (filing date: 2018-10-30), 10-Q (filing date: 2018-07-26), 10-Q (filing date: 2018-05-01), 10-K (filing date: 2018-02-23), 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-24), 10-Q (filing date: 2016-10-27), 10-Q (filing date: 2016-07-28), 10-Q (filing date: 2016-04-28), 10-K (filing date: 2016-02-25), 10-Q (filing date: 2015-10-28), 10-Q (filing date: 2015-07-29), 10-Q (filing date: 2015-04-30), 10-K (filing date: 2015-02-25), 10-Q (filing date: 2014-10-29), 10-Q (filing date: 2014-07-30), 10-Q (filing date: 2014-04-24), 10-K (filing date: 2014-02-27), 10-Q (filing date: 2013-10-24), 10-Q (filing date: 2013-07-25), 10-Q (filing date: 2013-04-25).

Q3 2018 Calculations

1 Equity turnover = (Net operating revenuesQ3 2018 + Net operating revenuesQ2 2018 + Net operating revenuesQ1 2018 + Net operating revenuesQ4 2017) ÷ Equity attributable to shareowners of The Coca-Cola Company
= (8,245 + 8,927 + 7,626 + 7,512) ÷ 18,264 = 1.77

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Coca-Cola Co.'s equity turnover improved from Q1 2018 to Q2 2018 but then slightly deteriorated from Q2 2018 to Q3 2018 not reaching Q1 2018 level.