heres the link for the data, cant change to picture

https://investors.coca-colacompany.com/filings-reports/annual-filings-10-k/content/0000021344-20-000006/a2019123110-k.htm?TB_iframe=true&height=auto&width=auto&preload=false#sE778A104C15F56A2890CA00A097BA059

Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents We classify time deposits and other investments that are highly liquid and have maturities of three months or less at the date of purchase as cash equivalents or restricted cash equivalents, as applicable. Restricted cash and restricted cash equivalents generally consist of amounts held by our captive insurance companies, which are included in the line item other assets on our consolidated balance sheets, and amounts classified in assets held for sale. We manage our exposure to counterparty credit risk through specific minimum credit standards, diversification of counterparties and procedures to monitor our concentrations of credit risk. The following table provides a summary of cash, cash equivalents, restricted cash and restricted cash equivalents that constitute the total amounts shown in the consolidated statements of cash flows (in millions): December 31, Cash and cash equivalents $ 6,480 $ 9,077 $ 6,102 Cash and cash equivalents included in assets held for sale 13 Cash and cash equivalents included in other assets 257 241 258 Cash, cash equivalents, restricted cash and restricted cash equivalents $ 6,737 $ 9,318 $ 6,373 Amounts represent cash and cash equivalents in our solvency capital portfolio set aside primarily to cover pension obligations in certain of our European and Canadian pension plans. Refer to Note 4. 2019 2018 2017 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (In millions except per share data) 2019 2018 2017 S 37,266 14,619 22,647 12,103 34,300 $ 13,067 21,233 11,002 1,079 9,152 689 950 36,212 13,721 22,491 12,834 1,902 7,755 458 10,086 563 679 946 853 1,049 Year Ended December 31, Net Operating Revenues Cost of goods sold Gross Profit Selling, general and administrative expenses Other operating charges Operating Income Interest income Interest expense Equity income (loss) net Other income (loss) net Income Before Income Taxes Income taxes Consolidated Net Income Less: Net income (loss) attributable to noncontrolling interests Net Income Attributable to Shareowners of The Coca-Cola Company Basic Net Income Per Sharel Diluted Net Income Per Sharel Average Shares Outstanding Basic Effect of dilutive securities Average Shares Outstanding Diluted 34 1,008 (1,674) 8,225 10,786 1,072 (1,763) 6,890 5,607 1,283 1,749 1,801 8,985 65 6,476 42 6,434 $ 35 S 8,920 S 1,248 S 2.09 S 1.51 S 0.29 S 2.07 1.50 $ 0.29 4,276 4,259 40 4,272 52 38 4,314 4,299 4,324 Calculated based on net income attributable to shareowners of The Coca-Cola Company. Refer to Notes to Consolidated Financial Statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In millions) 2019 2018 2017 S 8,985 S 6,476 $ 1,283 74 861 (54) Year Ended December 31, Consolidated Net Income Other comprehensive income: Net foreign currency translation adjustments Net gains (losses) on derivatives Net change in unrealized gains (losses) on available-for-sale securities Net change in pension and other benefit liabilities Total Comprehensive Income Less: Comprehensive income attributable to noncontrolling interests Total Comprehensive Income Attributable to Shareowners of The Coca-Cola Company 18 (2,035) (7) (34) 29 4,429 95 (159) (433) 188 322 2,221 73 8,864 110 S 8,754 S 4,334 S 2,148 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions except par value) December 31, 2019 2018 ASSETS S S Current Assets Cash and cash equivalents Short-term investments Total Cash, Cash Equivalents and Short-Term Investments Marketable securities Trade accounts receivable, less allowances of $524 and $501, respectively Inventories Prepaid expenses and other assets Total Current Assets Equity method investments Other investments Other assets Deferred income tax assets Property, plant and equipment net Trademarks with indefinite lives Bottlers' franchise rights with indefinite lives Goodwill Other intangible assets Total Assets 6,480 1,467 7,947 3,228 3,971 3,379 1,886 20,411 19,025 854 9,077 2,025 11,102 5,013 3,685 3,071 2,059 24,930 19,412 867 6,075 2,412 10,838 9,266 109 4,148 2,674 9,598 6,682 51 16,764 627 14,109 745 S 86,381 S 83,216 LIABILITIES AND EQUITY S 11,312 S 9,533 10,994 4,253 13,835 5,003 411 414 26,973 27,516 8,510 2,284 28,782 25,376 7,646 2,354 Current Liabilities Accounts payable and accrued expenses Loans and notes payable Current maturities of long-term debt Accrued income taxes Total Current Liabilities Long-term debt Other liabilities Deferred income tax liabilities The Coca-Cola Company Shareowners' Equity Common stock, $0.25 par value; authorized 11,200 shares; issued 7,040 shares Capital surplus Reinvested earnings Accumulated other comprehensive income (loss) Treasury stock, at cost 2,760 and 2,772 shares, respectively Equity Attributable to Shareowners of The Coca-Cola Company Equity attributable to noncontrolling interests Total Equity Total Liabilities and Equity 1,760 17,154 65,855 (13,544) (52,244) 18,981 2,117 21,098 1,760 16,520 63,234 (12,814) (51,719) 16,981 2,077 19,058 83,216 S 86,381 S Refer to Notes to Consolidated Financial Statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) 2019 2018 2017 S $ S 8,985 1,365 201 (280) (421) 91 (467) 127 6.476 1,086 225 (413) (457) (50) 743 558 699 1.283 1.260 219 (1,252) (628) 292 1,459 1.218 (252) 3,442 7,041 504 366 (1,240) 7,627 10,471 Year Ended December 31, Operating Activities Consolidated net income Depreciation and amortization Stock-based compensation expense Deferred income taxes Equity (income) loss net of dividends Foreign currency adjustments Significant (gains) losses net Other operating charges Other items Net change in operating assets and liabilities Net Cash Provided by Operating Activities Investing Activities Purchases of investments Proceeds from disposals of investments Acquisitions of businesses, equity method investments and nonmarketable securities Proceeds from disposals of businesses, equity method investments and nonmarketable securities Purchases of property, plant and equipment Proceeds from disposals of property, plant and equipment Other investing activities Net Cash Provided by (Used in) Investing Activities Financing Activities Issuances of debt Payments of debt Issuances of stock Purchases of stock for treasury Dividends Other financing activities (4,704) 6,973 (5,542) 429 (2,054) 978 (56) (3,976) (7,789) 14,977 (1,263) 1.362 (1,548) 248 (60) 5,927 (17.296) 16.694 (3,809) 3.821 (1,750) 108 (80) (2,312) 23,009 (24,850) 1,012 (1,103) (6,845) (227) 27,605 (30,600) 1.476 (1,912) (6,644) (272) 29.926 (28,871) 1,595 (3,682) (6,320) (95) (95) (227) (9,004) (272) (10,347) (7,447) (72) (262) 241 Other financing activities Net Cash Provided by (Used in) Financing Activities Effect of Exchange Rate Changes on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Net increase (decrease) in cash, cash equivalents, restricted cash and restricted cash equivalents during the year Cash, cash equivalents, restricted cash and restricted cash equivalents at beginning of year Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents at End of Year Less: Restricted cash and restricted cash equivalents at end of year Cash and Cash Equivalents at End of Year 2.945 6.373 (2,477) 8.850 (2,581) 9,318 6,737 257 9,318 241 6,373 271 S 6,480 $ 9,077 $ 6,102 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY (In millions except per share data) 2019 2018 2017 4,268 33 4.259 48 4.288 53 (82) 4.259 (21) 4,280 (39) 4.268 1,760 $ 1.760 $ 1,760 16,520 15.864 433 467 201 Year Ended December 31, Equity Attributable to Shareowners of The Coca-Cola Company Number of Common Shares Outstanding Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Common Stock Capital Surplus Balance at beginning of year Stock issued to employees related to stock-based compensation plans Stock-based compensation expense Other activities Balance at end of year Reinvested Earnings Balance at beginning of year Adoption of accounting standards Net income attributable to shareowners of The Coca-Cola Company Dividends (per share $1.60, $1.56 and $1.48 in 2019, 2018 and 2017, respectively) Balance at end of year Accumulated Other Comprehensive Income (Loss) Balance at beginning of year Adoption of accounting standards1 Net other comprehensive income (loss) Balance at end of year 225 (36) 16.520 14,993 655 219 (3) 15.864 17,154 65,502 63,234 546 8,920 (6,845) 65,855 60,430 3,014 6,434 (6,644) 63,234 1.248 (6,320) 60,430 (11,205) (12,814) (564) (166) (13,544) (10,305) (409) (2,100) (12,814) 900 (10,305) (13,544) (12,814) (10,305) (51,719) 501 (1,026) (52,244) 18,981 (50,677) 704 (1,746) (51,719) 16,981 (47,988) 909 (3,598) (50,677) 17,072 S $ $ S 2,077 $ 1.905 Balance at end of year Treasury Stock Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Total Equity Attributable to Shareowners of The Coca-Cola Company Equity Attributable to Noncontrolling Interests Balance at beginning of year Net income attributable to noncontrolling interests Net foreign currency translation adjustments Dividends paid to noncontrolling interests Acquisition of interests held by noncontrolling owners Contributions by noncontrolling interests Business combinations Deconsolidation of certain entities Other activities Total Equity Attributable to Noncontrolling Interests 65 42 158 35 38 (15) 45 (48) 53 (31) (84) 3 59 101 1,805 (157) 41 7 S 2,117 2,077 $ 1,905 Refer to Note 1, Note 3, Note 4, Note 6 and Note 16. (2) What items were included under cash and cash equivalents (Hint: look in the summary of major accounting policies in the notes to the financial statements)? (3) What was the $value of gross trade receivables for 2019 and 2018? (4) What was the receivables turnover for 2019? (5) Compute the changes in cash, cash equivalents and receivables from 2018 to 2019. Do you think Coca Cola's condition in these assets had improved or worsened? Please explain why you think it had improved or worsened. (6) What was the valuation basis that Coca Cola used to report trade accounts receivable (See notes to the financial statements)? (7) What factors did Coca Cola consider in the estimation of bad debts expenses (See notes to the financial statements)? (8) What was the $value of trade receivables written off in 2019 and 2018 (See notes to the financial statements) Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents We classify time deposits and other investments that are highly liquid and have maturities of three months or less at the date of purchase as cash equivalents or restricted cash equivalents, as applicable. Restricted cash and restricted cash equivalents generally consist of amounts held by our captive insurance companies, which are included in the line item other assets on our consolidated balance sheets, and amounts classified in assets held for sale. We manage our exposure to counterparty credit risk through specific minimum credit standards, diversification of counterparties and procedures to monitor our concentrations of credit risk. The following table provides a summary of cash, cash equivalents, restricted cash and restricted cash equivalents that constitute the total amounts shown in the consolidated statements of cash flows (in millions): December 31, Cash and cash equivalents $ 6,480 $ 9,077 $ 6,102 Cash and cash equivalents included in assets held for sale 13 Cash and cash equivalents included in other assets 257 241 258 Cash, cash equivalents, restricted cash and restricted cash equivalents $ 6,737 $ 9,318 $ 6,373 Amounts represent cash and cash equivalents in our solvency capital portfolio set aside primarily to cover pension obligations in certain of our European and Canadian pension plans. Refer to Note 4. 2019 2018 2017 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (In millions except per share data) 2019 2018 2017 S 37,266 14,619 22,647 12,103 34,300 $ 13,067 21,233 11,002 1,079 9,152 689 950 36,212 13,721 22,491 12,834 1,902 7,755 458 10,086 563 679 946 853 1,049 Year Ended December 31, Net Operating Revenues Cost of goods sold Gross Profit Selling, general and administrative expenses Other operating charges Operating Income Interest income Interest expense Equity income (loss) net Other income (loss) net Income Before Income Taxes Income taxes Consolidated Net Income Less: Net income (loss) attributable to noncontrolling interests Net Income Attributable to Shareowners of The Coca-Cola Company Basic Net Income Per Sharel Diluted Net Income Per Sharel Average Shares Outstanding Basic Effect of dilutive securities Average Shares Outstanding Diluted 34 1,008 (1,674) 8,225 10,786 1,072 (1,763) 6,890 5,607 1,283 1,749 1,801 8,985 65 6,476 42 6,434 $ 35 S 8,920 S 1,248 S 2.09 S 1.51 S 0.29 S 2.07 1.50 $ 0.29 4,276 4,259 40 4,272 52 38 4,314 4,299 4,324 Calculated based on net income attributable to shareowners of The Coca-Cola Company. Refer to Notes to Consolidated Financial Statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (In millions) 2019 2018 2017 S 8,985 S 6,476 $ 1,283 74 861 (54) Year Ended December 31, Consolidated Net Income Other comprehensive income: Net foreign currency translation adjustments Net gains (losses) on derivatives Net change in unrealized gains (losses) on available-for-sale securities Net change in pension and other benefit liabilities Total Comprehensive Income Less: Comprehensive income attributable to noncontrolling interests Total Comprehensive Income Attributable to Shareowners of The Coca-Cola Company 18 (2,035) (7) (34) 29 4,429 95 (159) (433) 188 322 2,221 73 8,864 110 S 8,754 S 4,334 S 2,148 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In millions except par value) December 31, 2019 2018 ASSETS S S Current Assets Cash and cash equivalents Short-term investments Total Cash, Cash Equivalents and Short-Term Investments Marketable securities Trade accounts receivable, less allowances of $524 and $501, respectively Inventories Prepaid expenses and other assets Total Current Assets Equity method investments Other investments Other assets Deferred income tax assets Property, plant and equipment net Trademarks with indefinite lives Bottlers' franchise rights with indefinite lives Goodwill Other intangible assets Total Assets 6,480 1,467 7,947 3,228 3,971 3,379 1,886 20,411 19,025 854 9,077 2,025 11,102 5,013 3,685 3,071 2,059 24,930 19,412 867 6,075 2,412 10,838 9,266 109 4,148 2,674 9,598 6,682 51 16,764 627 14,109 745 S 86,381 S 83,216 LIABILITIES AND EQUITY S 11,312 S 9,533 10,994 4,253 13,835 5,003 411 414 26,973 27,516 8,510 2,284 28,782 25,376 7,646 2,354 Current Liabilities Accounts payable and accrued expenses Loans and notes payable Current maturities of long-term debt Accrued income taxes Total Current Liabilities Long-term debt Other liabilities Deferred income tax liabilities The Coca-Cola Company Shareowners' Equity Common stock, $0.25 par value; authorized 11,200 shares; issued 7,040 shares Capital surplus Reinvested earnings Accumulated other comprehensive income (loss) Treasury stock, at cost 2,760 and 2,772 shares, respectively Equity Attributable to Shareowners of The Coca-Cola Company Equity attributable to noncontrolling interests Total Equity Total Liabilities and Equity 1,760 17,154 65,855 (13,544) (52,244) 18,981 2,117 21,098 1,760 16,520 63,234 (12,814) (51,719) 16,981 2,077 19,058 83,216 S 86,381 S Refer to Notes to Consolidated Financial Statements. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) 2019 2018 2017 S $ S 8,985 1,365 201 (280) (421) 91 (467) 127 6.476 1,086 225 (413) (457) (50) 743 558 699 1.283 1.260 219 (1,252) (628) 292 1,459 1.218 (252) 3,442 7,041 504 366 (1,240) 7,627 10,471 Year Ended December 31, Operating Activities Consolidated net income Depreciation and amortization Stock-based compensation expense Deferred income taxes Equity (income) loss net of dividends Foreign currency adjustments Significant (gains) losses net Other operating charges Other items Net change in operating assets and liabilities Net Cash Provided by Operating Activities Investing Activities Purchases of investments Proceeds from disposals of investments Acquisitions of businesses, equity method investments and nonmarketable securities Proceeds from disposals of businesses, equity method investments and nonmarketable securities Purchases of property, plant and equipment Proceeds from disposals of property, plant and equipment Other investing activities Net Cash Provided by (Used in) Investing Activities Financing Activities Issuances of debt Payments of debt Issuances of stock Purchases of stock for treasury Dividends Other financing activities (4,704) 6,973 (5,542) 429 (2,054) 978 (56) (3,976) (7,789) 14,977 (1,263) 1.362 (1,548) 248 (60) 5,927 (17.296) 16.694 (3,809) 3.821 (1,750) 108 (80) (2,312) 23,009 (24,850) 1,012 (1,103) (6,845) (227) 27,605 (30,600) 1.476 (1,912) (6,644) (272) 29.926 (28,871) 1,595 (3,682) (6,320) (95) (95) (227) (9,004) (272) (10,347) (7,447) (72) (262) 241 Other financing activities Net Cash Provided by (Used in) Financing Activities Effect of Exchange Rate Changes on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents Net increase (decrease) in cash, cash equivalents, restricted cash and restricted cash equivalents during the year Cash, cash equivalents, restricted cash and restricted cash equivalents at beginning of year Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents at End of Year Less: Restricted cash and restricted cash equivalents at end of year Cash and Cash Equivalents at End of Year 2.945 6.373 (2,477) 8.850 (2,581) 9,318 6,737 257 9,318 241 6,373 271 S 6,480 $ 9,077 $ 6,102 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY (In millions except per share data) 2019 2018 2017 4,268 33 4.259 48 4.288 53 (82) 4.259 (21) 4,280 (39) 4.268 1,760 $ 1.760 $ 1,760 16,520 15.864 433 467 201 Year Ended December 31, Equity Attributable to Shareowners of The Coca-Cola Company Number of Common Shares Outstanding Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Common Stock Capital Surplus Balance at beginning of year Stock issued to employees related to stock-based compensation plans Stock-based compensation expense Other activities Balance at end of year Reinvested Earnings Balance at beginning of year Adoption of accounting standards Net income attributable to shareowners of The Coca-Cola Company Dividends (per share $1.60, $1.56 and $1.48 in 2019, 2018 and 2017, respectively) Balance at end of year Accumulated Other Comprehensive Income (Loss) Balance at beginning of year Adoption of accounting standards1 Net other comprehensive income (loss) Balance at end of year 225 (36) 16.520 14,993 655 219 (3) 15.864 17,154 65,502 63,234 546 8,920 (6,845) 65,855 60,430 3,014 6,434 (6,644) 63,234 1.248 (6,320) 60,430 (11,205) (12,814) (564) (166) (13,544) (10,305) (409) (2,100) (12,814) 900 (10,305) (13,544) (12,814) (10,305) (51,719) 501 (1,026) (52,244) 18,981 (50,677) 704 (1,746) (51,719) 16,981 (47,988) 909 (3,598) (50,677) 17,072 S $ $ S 2,077 $ 1.905 Balance at end of year Treasury Stock Balance at beginning of year Treasury stock issued to employees related to stock-based compensation plans Purchases of stock for treasury Balance at end of year Total Equity Attributable to Shareowners of The Coca-Cola Company Equity Attributable to Noncontrolling Interests Balance at beginning of year Net income attributable to noncontrolling interests Net foreign currency translation adjustments Dividends paid to noncontrolling interests Acquisition of interests held by noncontrolling owners Contributions by noncontrolling interests Business combinations Deconsolidation of certain entities Other activities Total Equity Attributable to Noncontrolling Interests 65 42 158 35 38 (15) 45 (48) 53 (31) (84) 3 59 101 1,805 (157) 41 7 S 2,117 2,077 $ 1,905 Refer to Note 1, Note 3, Note 4, Note 6 and Note 16. (2) What items were included under cash and cash equivalents (Hint: look in the summary of major accounting policies in the notes to the financial statements)? (3) What was the $value of gross trade receivables for 2019 and 2018? (4) What was the receivables turnover for 2019? (5) Compute the changes in cash, cash equivalents and receivables from 2018 to 2019. Do you think Coca Cola's condition in these assets had improved or worsened? Please explain why you think it had improved or worsened. (6) What was the valuation basis that Coca Cola used to report trade accounts receivable (See notes to the financial statements)? (7) What factors did Coca Cola consider in the estimation of bad debts expenses (See notes to the financial statements)? (8) What was the $value of trade receivables written off in 2019 and 2018 (See notes to the financial statements)