Paying users zone. Data is covered by hidden.

  • Get to Coca-Cola Co. for $19.99, or

  • get to whole website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Analysis of Equity Method Investment

Difficulty: Advanced


Selected Financial Data

Coca-Cola Co.'s selected financial data

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Equity income, net hidden hidden hidden hidden hidden
Equity method investments hidden hidden hidden hidden hidden
ROA (equity method investments only)1 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

2017 Calculations

1 ROA (equity method investments only) = 100 × Equity income, net ÷ Equity method investments
= 100 × hidden ÷ hidden = hidden

Item Description The company
Equity income, net This item represents the entity's proportionate share for the period of the net income (loss) of its investee (such as unconsolidated subsidiaries and joint ventures) to which the equity method of accounting is applied. Such amount typically reflects adjustments similar to those made in preparing consolidated statements, including adjustments to eliminate intercompany gains and losses, and to amortize, if appropriate, any difference between cost and underlying equity in net assets of the investee at the date of investment. Coca-Cola Co.'s equity income, net increased from 2015 to 2016 and from 2016 to 2017.
Equity method investments This item represents the carrying amount on the entity's balance sheet of its investment in common stock of an equity method investee. This is not an indicator of the fair value of the investment, rather it is the initial cost adjusted for the entity's share of earnings and losses of the investee, adjusted for any distributions (dividends) and other than temporary impairment losses recognized. Coca-Cola Co.'s equity method investments increased from 2015 to 2016 and from 2016 to 2017.
ROA (equity method investments only) A profitability ratio calculated as equity income, net divided by equity method investments. Coca-Cola Co.'s ROA of equity method investments improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017.

Summarized Financial Information

Summarized financial information for Coca-Cola Co.'s affiliates, subsidiaries, associates, and joint ventures

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Current assets hidden hidden hidden hidden hidden
Noncurrent assets hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden
Current liabilities hidden hidden hidden hidden hidden
Noncurrent liabilities hidden hidden hidden hidden hidden
Total liabilities hidden hidden hidden hidden hidden
Equity attributable to shareowners of investees hidden hidden hidden hidden hidden
Equity attributable to noncontrolling interests hidden hidden hidden hidden hidden
Total equity hidden hidden hidden hidden hidden
Total liabilities and equity hidden hidden hidden hidden hidden
Net operating revenues hidden hidden hidden hidden hidden
Cost of goods sold hidden hidden hidden hidden hidden
Gross profit hidden hidden hidden hidden hidden
Operating income hidden hidden hidden hidden hidden
Consolidated net income hidden hidden hidden hidden hidden
Net income attributable to noncontrolling interests hidden hidden hidden hidden hidden
Net income attributable to common shareowners hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

Item Description The company
Equity attributable to shareowners of investees Amount of equity, excluding noncontrolling interest, attributable to the equity method investment of the entity. Equity attributable to shareowners of investees of Coca-Cola Co.'s affiliates, subsidiaries, associates, and joint ventures increased from 2015 to 2016 and from 2016 to 2017.
Net income attributable to common shareowners The amount of net income (loss) reported by an equity method investment of the entity. Net income attributable to common shareowners of Coca-Cola Co.'s affiliates, subsidiaries, associates, and joint ventures increased from 2015 to 2016 and from 2016 to 2017.

Adjustments to Financial Data: Proportionate Consolidation

Recognition of Coca-Cola Co.'s proportionate share of affiliates, subsidiaries, associates, and joint ventures assets and liabilities instead of net equity.

Coca-Cola Co., adjustments to financial data

USD $ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Weighted average percentage interest in affiliates hidden hidden hidden hidden hidden
Adjustment to Current Assets
Current assets (as reported) hidden hidden hidden hidden hidden
Add: Current assets of affiliates (adjustment) hidden hidden hidden hidden hidden
Current assets (adjusted) hidden hidden hidden hidden hidden
Adjustment to Total Assets
Total assets (as reported) hidden hidden hidden hidden hidden
Less: Equity method investments (adjustment) hidden hidden hidden hidden hidden
Add: Total assets of affiliates (adjustment) hidden hidden hidden hidden hidden
Total assets (adjusted) hidden hidden hidden hidden hidden
Adjustment to Current Liabilities
Current liabilities (as reported) hidden hidden hidden hidden hidden
Add: Current liabilities of affiliates (adjustment) hidden hidden hidden hidden hidden
Current liabilities (adjusted) hidden hidden hidden hidden hidden
Adjustment to Total Liabilities
Total liabilities (as reported) hidden hidden hidden hidden hidden
Add: Total liabilities of affiliates (adjustment) hidden hidden hidden hidden hidden
Total liabilities (adjusted) hidden hidden hidden hidden hidden
Adjustment to Equity Attributable To Noncontrolling Interests
Equity attributable to noncontrolling interests (as reported) hidden hidden hidden hidden hidden
Add: Equity attributable to noncontrolling interests of affiliates (adjustment) hidden hidden hidden hidden hidden
Equity attributable to noncontrolling interests (adjusted) hidden hidden hidden hidden hidden
Adjustment to Net Operating Revenues
Net operating revenues (as reported) hidden hidden hidden hidden hidden
Add: Net operating revenues of affiliates (adjustment) hidden hidden hidden hidden hidden
Net operating revenues (adjusted) hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).


Coca-Cola Co., Financial Data: Reported vs. Adjusted


Adjusted Ratios: Proportionate Consolidation (Summary)

Coca-Cola Co., adjusted ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Current Ratio
Reported current ratio hidden hidden hidden hidden hidden
Adjusted current ratio hidden hidden hidden hidden hidden
Net Profit Margin
Reported net profit margin hidden hidden hidden hidden hidden
Adjusted net profit margin hidden hidden hidden hidden hidden
Total Asset Turnover
Reported total asset turnover hidden hidden hidden hidden hidden
Adjusted total asset turnover hidden hidden hidden hidden hidden
Financial Leverage
Reported financial leverage hidden hidden hidden hidden hidden
Adjusted financial leverage hidden hidden hidden hidden hidden
Return on Assets (ROA)
Reported ROA hidden hidden hidden hidden hidden
Adjusted ROA hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

Ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. Coca-Cola Co.'s adjusted current ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.
Adjusted net profit margin An indicator of profitability, calculated as net income divided by adjusted revenue. Coca-Cola Co.'s adjusted net profit margin deteriorated from 2015 to 2016 and from 2016 to 2017.
Adjusted total asset turnover An activity ratio calculated as adjusted total revenue divided by adjusted total assets. Coca-Cola Co.'s adjusted total asset turnover deteriorated from 2015 to 2016 and from 2016 to 2017.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Coca-Cola Co.'s adjusted financial leverage increased from 2015 to 2016 and from 2016 to 2017.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Coca-Cola Co.'s adjusted ROA deteriorated from 2015 to 2016 and from 2016 to 2017.

Coca-Cola Co., Ratios: Reported vs. Adjusted


Adjusted Current Ratio

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Selected Financial Data (USD $ in millions)
Current assets hidden hidden hidden hidden hidden
Current liabilities hidden hidden hidden hidden hidden
Ratio
Current ratio1 hidden hidden hidden hidden hidden
Adjusted: from Equity Method to Proportionate Consolidation
Selected Financial Data (USD $ in millions)
Adjusted current assets hidden hidden hidden hidden hidden
Adjusted current liabilities hidden hidden hidden hidden hidden
Ratio
Adjusted current ratio2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= hidden ÷ hidden = hidden

2 Adjusted current ratio = Adjusted current assets ÷ Adjusted current liabilities
= hidden ÷ hidden = hidden

Ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by adjusted current liabilities. Coca-Cola Co.'s adjusted current ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.

Adjusted Net Profit Margin

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Selected Financial Data (USD $ in millions)
Net income attributable to shareowners of The Coca-Cola Company hidden hidden hidden hidden hidden
Net operating revenues hidden hidden hidden hidden hidden
Ratio
Net profit margin1 hidden hidden hidden hidden hidden
Adjusted: from Equity Method to Proportionate Consolidation
Selected Financial Data (USD $ in millions)
Net income attributable to shareowners of The Coca-Cola Company hidden hidden hidden hidden hidden
Adjusted net operating revenues hidden hidden hidden hidden hidden
Ratio
Adjusted net profit margin2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Net profit margin = 100 × Net income attributable to shareowners of The Coca-Cola Company ÷ Net operating revenues
= 100 × hidden ÷ hidden = hidden

2 Adjusted net profit margin = 100 × Net income attributable to shareowners of The Coca-Cola Company ÷ Adjusted net operating revenues
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as net income divided by adjusted revenue. Coca-Cola Co.'s adjusted net profit margin deteriorated from 2015 to 2016 and from 2016 to 2017.

Adjusted Total Asset Turnover

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Selected Financial Data (USD $ in millions)
Net operating revenues hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden
Ratio
Total asset turnover1 hidden hidden hidden hidden hidden
Adjusted: from Equity Method to Proportionate Consolidation
Selected Financial Data (USD $ in millions)
Adjusted net operating revenues hidden hidden hidden hidden hidden
Adjusted total assets hidden hidden hidden hidden hidden
Ratio
Adjusted total asset turnover2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Total asset turnover = Net operating revenues ÷ Total assets
= hidden ÷ hidden = hidden

2 Adjusted total asset turnover = Adjusted net operating revenues ÷ Adjusted total assets
= hidden ÷ hidden = hidden

Ratio Description The company
Adjusted total asset turnover An activity ratio calculated as adjusted total revenue divided by adjusted total assets. Coca-Cola Co.'s adjusted total asset turnover deteriorated from 2015 to 2016 and from 2016 to 2017.

Adjusted Financial Leverage

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Selected Financial Data (USD $ in millions)
Total assets hidden hidden hidden hidden hidden
Equity attributable to shareowners of The Coca-Cola Company hidden hidden hidden hidden hidden
Ratio
Financial leverage1 hidden hidden hidden hidden hidden
Adjusted: from Equity Method to Proportionate Consolidation
Selected Financial Data (USD $ in millions)
Adjusted total assets hidden hidden hidden hidden hidden
Equity attributable to shareowners of The Coca-Cola Company hidden hidden hidden hidden hidden
Ratio
Adjusted financial leverage2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

2017 Calculations

1 Financial leverage = Total assets ÷ Equity attributable to shareowners of The Coca-Cola Company
= hidden ÷ hidden = hidden

2 Adjusted financial leverage = Adjusted total assets ÷ Equity attributable to shareowners of The Coca-Cola Company
= hidden ÷ hidden = hidden

Ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Coca-Cola Co.'s adjusted financial leverage increased from 2015 to 2016 and from 2016 to 2017.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Selected Financial Data (USD $ in millions)
Net income attributable to shareowners of The Coca-Cola Company hidden hidden hidden hidden hidden
Total assets hidden hidden hidden hidden hidden
Ratio
ROA1 hidden hidden hidden hidden hidden
Adjusted: from Equity Method to Proportionate Consolidation
Selected Financial Data (USD $ in millions)
Net income attributable to shareowners of The Coca-Cola Company hidden hidden hidden hidden hidden
Adjusted total assets hidden hidden hidden hidden hidden
Ratio
Adjusted ROA2 hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25), 10-K (filing date: 2015-02-25), 10-K (filing date: 2014-02-27).

1 ROA = 100 × Net income attributable to shareowners of The Coca-Cola Company ÷ Total assets
= 100 × hidden ÷ hidden = hidden

2 Adjusted ROA = 100 × Net income attributable to shareowners of The Coca-Cola Company ÷ Adjusted total assets
= 100 × hidden ÷ hidden = hidden

Ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Coca-Cola Co.'s adjusted ROA deteriorated from 2015 to 2016 and from 2016 to 2017.