Stock Analysis on Net
Stock Analysis on Net
Microsoft Excel LibreOffice Calc

Coca-Cola Co. (NYSE:KO)

Analysis of Operating Leases

Advanced level

An operating lease is treated like a rental contract. Neither the leased asset nor the associated liability is reported on the lessee balance sheet, but the rights may be very similar to the rights of an owner. The lessee only records the lease payments as a rental expense in income statement.

Present Value of Future Operating Lease Payments (before Adoption of FASB Topic 842)

Coca-Cola Co., future operating lease payments (before adoption of FASB Topic 842)

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Total undiscounted future operating lease payments — 500  542  683  716 
Discount rate1 — 2.11% 1.69% 1.46% 1.35%
 
Total present value of future operating lease payments — 467  510  645  679 

Based on: 10-K (filing date: 2020-02-24), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25).

1 Weighted-average interest rate for Coca-Cola Co.’s debt

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 2.11%
2019 144  2019 144  141 
2020 84  2020 84  81 
2021 70  2021 70  66 
2022 60  2022 60  55 
2023 42  2023 42  38 
2024 and thereafter 100  2024 42  37 
2025 42  36 
2026 16  14 
Total: 500  500  467 

Based on: 10-K (filing date: 2019-02-21).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 1.69%
2018 130  2018 130  128 
2019 85  2019 85  82 
2020 69  2020 69  66 
2021 59  2021 59  55 
2022 52  2022 52  48 
2023 and thereafter 147  2023 52  47 
2024 52  46 
2025 43  38 
Total: 542  542  510 

Based on: 10-K (filing date: 2018-02-23).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 1.46%
2017 176  2017 176  173 
2018 98  2018 98  95 
2019 78  2019 78  75 
2020 64  2020 64  60 
2021 54  2021 54  50 
2022 and thereafter 213  2022 54  50 
2023 54  49 
2024 54  48 
2025 51  45 
Total: 683  683  645 

Based on: 10-K (filing date: 2017-02-24).

Year Future operating lease payments (as reported) Year Future operating lease payments (estimated) Present value at 1.35%
2016 171  2016 171  169 
2017 109  2017 109  106 
2018 89  2018 89  85 
2019 68  2019 68  64 
2020 59  2020 59  55 
2021 and thereafter 220  2021 59  54 
2022 59  54 
2023 59  53 
2024 43  38 
Total: 716  716  679 

Based on: 10-K (filing date: 2016-02-25).

Adjustments to Financial Statements for Operating Leases

Coca-Cola Co., adjustments to financial statements

US$ in millions

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Adjustment to Total Assets
Total assets (as reported) 86,381  83,216  87,896  87,270  90,093 
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 —  467  510  645  679 
Total assets (adjusted) 86,381  83,683  88,406  87,915  90,772 
Adjustment to Total Debt
Total debt (as reported) 42,763  43,555  47,685  45,709  44,213 
Add: Operating lease liability (before adoption of FASB Topic 842)2 —  467  510  645  679 
Add: Current portion of operating lease liabilities (recorded in Accounts payable and accrued expenses) 281  —  —  —  — 
Add: Noncurrent portion of operating lease liabilities (recorded in Other liabilities) 1,111  —  —  —  — 
Total debt (adjusted) 44,155  44,022  48,195  46,354  44,892 

Based on: 10-K (filing date: 2020-02-24), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25).

1, 2 Equal to total present value of future operating lease payments.

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

Adjusted Financial Ratios for Operating Leases (Summary)

Coca-Cola Co., adjusted financial ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
Total Asset Turnover1
Reported total asset turnover 0.43 0.38 0.40 0.48 0.49
Adjusted total asset turnover 0.43 0.38 0.40 0.48 0.49
Debt to Equity2
Reported debt to equity 2.25 2.56 2.79 1.98 1.73
Adjusted debt to equity 2.33 2.59 2.82 2.01 1.76
Return on Assets3 (ROA)
Reported ROA 10.33% 7.73% 1.42% 7.48% 8.16%
Adjusted ROA 10.33% 7.69% 1.41% 7.42% 8.10%

Based on: 10-K (filing date: 2020-02-24), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25).

1 See details »

2 See details »

3 See details »

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Coca-Cola Co.’s adjusted total asset turnover ratio deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.
Adjusted debt to equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. Coca-Cola Co.’s adjusted debt to equity ratio improved from 2017 to 2018 and from 2018 to 2019.
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Coca-Cola Co.’s adjusted ROA improved from 2017 to 2018 and from 2018 to 2019.

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

Adjusted Total Asset Turnover

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Selected Financial Data (US$ in millions)
Net operating revenues 37,266  31,856  35,410  41,863  44,294 
Total assets 86,381  83,216  87,896  87,270  90,093 
Activity Ratio
Total asset turnover1 0.43 0.38 0.40 0.48 0.49
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net operating revenues 37,266  31,856  35,410  41,863  44,294 
Adjusted total assets 86,381  83,683  88,406  87,915  90,772 
Activity Ratio
Adjusted total asset turnover2 0.43 0.38 0.40 0.48 0.49

Based on: 10-K (filing date: 2020-02-24), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25).

2019 Calculations

1 Total asset turnover = Net operating revenues ÷ Total assets
= 37,266 ÷ 86,381 = 0.43

2 Adjusted total asset turnover = Net operating revenues ÷ Adjusted total assets
= 37,266 ÷ 86,381 = 0.43

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Coca-Cola Co.’s adjusted total asset turnover ratio deteriorated from 2017 to 2018 but then improved from 2018 to 2019 exceeding 2017 level.

Adjusted Debt to Equity

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Selected Financial Data (US$ in millions)
Total debt 42,763  43,555  47,685  45,709  44,213 
Equity attributable to shareowners of The Coca-Cola Company 18,981  16,981  17,072  23,062  25,554 
Solvency Ratio
Debt to equity1 2.25 2.56 2.79 1.98 1.73
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Adjusted total debt 44,155  44,022  48,195  46,354  44,892 
Equity attributable to shareowners of The Coca-Cola Company 18,981  16,981  17,072  23,062  25,554 
Solvency Ratio
Adjusted debt to equity2 2.33 2.59 2.82 2.01 1.76

Based on: 10-K (filing date: 2020-02-24), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25).

2019 Calculations

1 Debt to equity = Total debt ÷ Equity attributable to shareowners of The Coca-Cola Company
= 42,763 ÷ 18,981 = 2.25

2 Adjusted debt to equity = Adjusted total debt ÷ Equity attributable to shareowners of The Coca-Cola Company
= 44,155 ÷ 18,981 = 2.33

Solvency ratio Description The company
Adjusted debt-to-equity A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity. Coca-Cola Co.’s adjusted debt-to-equity ratio improved from 2017 to 2018 and from 2018 to 2019.

Adjusted Return on Assets (ROA)

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015
As Reported
Selected Financial Data (US$ in millions)
Net income attributable to shareowners of The Coca-Cola Company 8,920  6,434  1,248  6,527  7,351 
Total assets 86,381  83,216  87,896  87,270  90,093 
Profitability Ratio
ROA1 10.33% 7.73% 1.42% 7.48% 8.16%
Adjusted for Operating Leases
Selected Financial Data (US$ in millions)
Net income attributable to shareowners of The Coca-Cola Company 8,920  6,434  1,248  6,527  7,351 
Adjusted total assets 86,381  83,683  88,406  87,915  90,772 
Profitability Ratio
Adjusted ROA2 10.33% 7.69% 1.41% 7.42% 8.10%

Based on: 10-K (filing date: 2020-02-24), 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-23), 10-K (filing date: 2017-02-24), 10-K (filing date: 2016-02-25).

2019 Calculations

1 ROA = 100 × Net income attributable to shareowners of The Coca-Cola Company ÷ Total assets
= 100 × 8,920 ÷ 86,381 = 10.33%

2 Adjusted ROA = 100 × Net income attributable to shareowners of The Coca-Cola Company ÷ Adjusted total assets
= 100 × 8,920 ÷ 86,381 = 10.33%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as net income divided by adjusted total assets. Coca-Cola Co.’s adjusted ROA improved from 2017 to 2018 and from 2018 to 2019.