I need the statments to be fixed.
ACC 3300 - Spring 2020 - Excel Assignment - Instructions (Protected Vien) . Word (Unlicensed Product Mailings Review View Help Tell me what you want to do references 1. Prepare Excel spreadsheets for the following: The Coca-Cola Company and Subsidiaries Consolidated Statements of income, Consolidated Balance Sheets, and Consolidated Statements of Cash Flows. (The financial statements are located in Appendix Cof the textbook or e-book.) (Omit footnotes or any reference to the Notes to Consolidated Financial Statements.) 2. Your spreadsheets should include formulas for the following: (not hard keyed numbers) a. Income Statement i. Gross Profit ii. Income from Continuing Operations before Income Taxes iii. Net Income from Continuing Operations iv. Consolidated Net Income V. Net Income Attributable to Shareowners of the Coca-Cola Company vi. Basic net income per share from continuing operations vii. Basic net income per share from discontinued operations viii. Basic Net Income Per Share ix. Diluted net income per share from continuing operations Diluted net income per share from discontinued operations xl Diluted Net Income Per Share b. Balance Sheet Total Cash, Cash Equivalents and Short-Term Investments iiTotal Current Assets iii. Total Assets iv. Total Current Liabilities v. Total Liabilities (You will need to Insert a row in the appropriate place.) vi Equity Attributable to Shareowners of the Coca-Cola Company vil. Total Equity vill. Total Liabilities and Equity c. Statement of Cash Flows 1. Consolidated net income (Link to Income Statement) (hp) MUU (VIDEO Product es Mailings Review View Help Tell me what you want to do VI Equy moteus owners or FREECOM Company vii. Total Equity viii. Total Liabilities and Equity c. Statement of Cash Flows 1. Consolidated net income (Link to Income Statement) IL (Income) loss from discontinued operations (link to Income Statement) Ill. Net income from continuing operations (Link to Income Statement) iv. Net cash provided by operating activities v. Net cash provided by (used in) investing activities vi. Net cash provided by (used in) financing activities vil. Net cash provided by (used in) discontinued operations vili. Net increase (decrease) during the year IX. Balance at beginning of year (2017 only) (Link to Balance Sheet) X. Balance at end of year (DO NOT link to Balance Sheet. This number should match the amount on the Balance Sheet. If it does not, then there's an error in your spreadsheet that you will need to find and correct before submitting.) 3. Each financial statement should be on a separate worksheet that is named to indicate the appropriate financial statement. 4. On a separate worksheet within the same workbook, compute all of the financial ratios from Appendix 5A, illustration 5A.1, for 2017. (hp) Specimen Financial Statements: The Coca-Cola Company The Coca-Cola Company is the world's largest beverage company. It owns or licenses and markets more than 500 nonalcoholic beverage brands. primarily sparkling beverages, but also a variety of still beverages such as waters, enhanced waters, Juices and juice drinks, ready. to-drink teas and coffees, and energy and sports drinks. Finished beverage products bearing Coca-Cola trademarks, sold in the United States since 1886, are now available in more than 200 countries THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME 2017 2016 Year Ended December 31. (in millions except per share data) NET OPERATING REVENUES Cost of poods sold GROSS PROFIT Selling general and administrative expenses Other operating charges OPERATING INCOME Interest income Interest expense Equity income (loss) - net $35.410 13,256 22,154 12,496 2.157 7.501 541,363 16,465 25.393 15.262 1.510 8,626 $44.294 17,482 26,812 16,427 1.657 8.728 1,071 (1,656) 631 Other 733 835 (1,234) 8,136 5 .550 6 7.366 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Income taxes from continuing operations NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operations (net of income taxes of $47. SO and $0, respectively) CONSOLIDATED NET INCOME Less: Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY 5.500 1,182 101 1.283 6.550 7,366 2315 35 $ 1.248 $ 6.527 $ 7,351 $ $ 1.51 $ 1.69 0.28 002 0.19 0.27 $ $ $ $ 1.51 1.49 $ $ 1.69 1.67 Basic net income per share from continuing operations Basie net income per share from discontinued operations BASIC NET INCOME PER SHARE Diluted set income per share from continuing operations! Diluted net income per share from discontinued operations DILUTED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING-BASIC Effect of dilutive securities AVERAGE SHARES OUTSTANDING DILUTED $ $ 0.19 $ 4,2724 $ 2 4.334 1.49 ,317 50 4367 1.67 4.352 $3 4.405 Calculated based on net income from continuing operations less net income from continuing operations attributable to socontrolling Interests Calculated based on net income from discontinued operations less net income from discontinued operations attributable to controlling interests Per share amounts do not add due to rounding. Refer to Notes to Consolidated Financial Statements. C-2 APPENDIX C Specimen Financial Statements: The Coca-Cola Company THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Twarded De BLY 2016 2015 SLS 30 31 361 CONSOLIDATED NET INCOME Other comprehensive Net foreign curr e nt Mer i vatives Net wereld i s before were Ne sha a dather lates TOTAL COMPREHENSIVE INCOME LOSSI Low Compreh ensilabe able to strenger TOTAL COMPREHENSIVE INCOME LOSS ATTRIBUTABLE TO SHARE OWNERS i 306 2,051 S 5234 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS ASSETS CURRENT ASSETS Cash and cash equivalent $6,006 8555 TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS 15,358 18.150 Trade O s receivable, less allowances of $177 and S p ecial Prepaid expenses and others Assets held for sale discontinued operations TOTAL CURRENT ASSETS EQUITY METHOD INVESTMENTS M45 34,010 6,729 6,00 9.401 10629 PROPERTY. PLANT AND EQUIPMENT TRADEMARKS WITH INDEFINITE LIVES BOTTLERS FRANCHISE RIGHTS WITH INDEFINITE LIVES GOODWILL OTHER INTANGIBLE ASSETS TOTAL ASSETS LIABILITIES AND EQUITY CURRENT LIABILITIES $ 67,896 5 87.270 $ 8.748 59,490 3.37 Loans and notes payable Curreat maturities of long-term debt Accrued income taxes 27,194 31.12 X2 20,684 1753 1750 Liabilities held for sale discontinued operations TOTAL CURRENT LIABILITIES LONG-TERM DEBT OTHER LIABILITIES DEFERRED INCOME TAXES THE COCA-COLA COMPANY SHAREOWNERS' EQUITY Common stock. $0.25 par valve: Authorized 11,200 shares Issued 7,040 and 7.040 shares, respectively Capital surplus Reinvested earnings Accumulated other comprehensive income (los) Treasury stock, at cost-2.781 and 2.752 shares, respectively EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS TOTAL EQUITY TOTAL LIABILITIES AND EQUITY 1.760 15.864 4.4.30 (1015) 50,677) 17,072 14993 5.502 (11. 5) (47,985) 21.062 $ 87,896 S 57.270 Refer to Notes to Consolidated Financial Statements THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS 2015 $ 1.133 6.550 7366 (101) ,182 6.550 1787 7,366 1.970 1.160 219 (1.256) (49) 158 (137) 1.215 (209) 3529 (224) (157) 6.99$ (15.831) (16.630) 15,911 (2.900) (15.499) 16,624 (838) (2.491) Year Ended December (lamilles OPERATING ACTIVITIES Consolidated net income (come) loss from discontinued operations Net income from continuing operations Deprecated at Stock-based compensation expense Deferred income Equity income ou t of dividends Foreign currency meats Sipificante s sofastset Other operating charges Other items Net changer d es Netcash provided by operating activities INVESTING ACTIVITIES Purchases of investments Proceeds from disposal 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 Net cash provided by (used in financing activities CASH FLOWS FROM DISCONTINUED OPERATIONS Net cash provided by (used in) operating activities from discontinued operations Net cash provided by (used in) investing activities from discontinued operations Net cash provided by (used in) financing activities from discontinued operations Net cash provided by used in discontinued operations EFFECT OF EXCHANGE RATE CHANGES ON CASH AND CASH EQUIVALENTS CASH AND CASH EQUIVALENTS Net increase (decrease) during the war Balance at beginning of year Balance at end of year (2,553) 3,821 (1.675) 104 (126) (2.185) 1.035 (2262) 150 (209) (999) (40) (6186) 29,857 (28,768) 1.595 (3,682) (6,320) 27.281 (25,615) 1.434 (3,681) (6,043) 40,434 (37,738) 1.245 (5,741) (7.409) (6.545) (5.113) (65) (2.549) 1.246 (1.549) 5571098.958 $ 6.006 $ 8.555 $ 7.309 Refer to Notes to Consolidated Financial Statements. DIXC Specimen Financial Statements: The Coca-Cola Company THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY (82) (86) (86) 4.324 1,760 $ 1.760 $ 1,760 14,93 14,016 13.154 532 13094 258 236 219 15.864 14,993 14,016 65.502 1.348 (6,320) 60,41 65 DIN 6.327 (6.043) 65,502 Year Ended December 31 la millis t per share data) EQUITY ATTRIBUTARLE TO SILAREOWNERS OF THE COCA-COLA COMPANY NUMBER OF COMMON SHARES OUTSTANDING Balance at beginning of year Treasury stock issued to employees related to stock compensation plans Purchases of wock for treasury Balance at end of year COMMON STOCK CAPITAL SURPLUS Balance at beginning of year Stock issued to employees related to stock compensation plans The benefit (charge) from stock compensation plans Stock-based compensation expense Other activities Balance at end of year REINVESTED EARNINGS Balance at beginning of year Net income attributable to shareowners of The Coca-Cola Company Dividends (per share - $1.48. $1.40 and $1.32 in 2017, 2016 and 2015, respectively Balance at end of year ACCUMULATED OTHER COMPREHENSIVE INCOME (LOSS) Balance at beginning of year Net other comprehensive income (loss) Balance at end of year TREASURY STOCK Balance at beginning of year Treasury stock issued to employees related to stock compensation plans Purchases of stock for treasury Balanse 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 adjustment Dividends paid to noncontrolling interests Contributions by noncontrolling interests Business combinations Deconsolidation of certain entities Other activities TOTAL EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS 63.400 7351 (5.741 65.018 (11,205) 900 (10,305) (10.174) (1.031) (11.205) (5.777) (4,397) (10,174) (47,958) 909 (3.598) (S04677) 17.072 (45.006) 811 (733) (47,988) $23.0662 (42,225) 696 (3.537) (45,066) S 25,554 $ $ 241 210 23 158 35 38 (15) (25) 1,805 (157) 41 1,995 $ $ 158 $ 210 Refer to Notes to Consolidated Financial Statements. ACC 3300 - Spring 2020 - Excel Assignment - Instructions (Protected Vien) . Word (Unlicensed Product Mailings Review View Help Tell me what you want to do references 1. Prepare Excel spreadsheets for the following: The Coca-Cola Company and Subsidiaries Consolidated Statements of income, Consolidated Balance Sheets, and Consolidated Statements of Cash Flows. (The financial statements are located in Appendix Cof the textbook or e-book.) (Omit footnotes or any reference to the Notes to Consolidated Financial Statements.) 2. Your spreadsheets should include formulas for the following: (not hard keyed numbers) a. Income Statement i. Gross Profit ii. Income from Continuing Operations before Income Taxes iii. Net Income from Continuing Operations iv. Consolidated Net Income V. Net Income Attributable to Shareowners of the Coca-Cola Company vi. Basic net income per share from continuing operations vii. Basic net income per share from discontinued operations viii. Basic Net Income Per Share ix. Diluted net income per share from continuing operations Diluted net income per share from discontinued operations xl Diluted Net Income Per Share b. Balance Sheet Total Cash, Cash Equivalents and Short-Term Investments iiTotal Current Assets iii. Total Assets iv. Total Current Liabilities v. Total Liabilities (You will need to Insert a row in the appropriate place.) vi Equity Attributable to Shareowners of the Coca-Cola Company vil. Total Equity vill. Total Liabilities and Equity c. Statement of Cash Flows 1. Consolidated net income (Link to Income Statement) (hp) MUU (VIDEO Product es Mailings Review View Help Tell me what you want to do VI Equy moteus owners or FREECOM Company vii. Total Equity viii. Total Liabilities and Equity c. Statement of Cash Flows 1. Consolidated net income (Link to Income Statement) IL (Income) loss from discontinued operations (link to Income Statement) Ill. Net income from continuing operations (Link to Income Statement) iv. Net cash provided by operating activities v. Net cash provided by (used in) investing activities vi. Net cash provided by (used in) financing activities vil. Net cash provided by (used in) discontinued operations vili. Net increase (decrease) during the year IX. Balance at beginning of year (2017 only) (Link to Balance Sheet) X. Balance at end of year (DO NOT link to Balance Sheet. This number should match the amount on the Balance Sheet. If it does not, then there's an error in your spreadsheet that you will need to find and correct before submitting.) 3. Each financial statement should be on a separate worksheet that is named to indicate the appropriate financial statement. 4. On a separate worksheet within the same workbook, compute all of the financial ratios from Appendix 5A, illustration 5A.1, for 2017. (hp) Specimen Financial Statements: The Coca-Cola Company The Coca-Cola Company is the world's largest beverage company. It owns or licenses and markets more than 500 nonalcoholic beverage brands. primarily sparkling beverages, but also a variety of still beverages such as waters, enhanced waters, Juices and juice drinks, ready. to-drink teas and coffees, and energy and sports drinks. Finished beverage products bearing Coca-Cola trademarks, sold in the United States since 1886, are now available in more than 200 countries THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME 2017 2016 Year Ended December 31. (in millions except per share data) NET OPERATING REVENUES Cost of poods sold GROSS PROFIT Selling general and administrative expenses Other operating charges OPERATING INCOME Interest income Interest expense Equity income (loss) - net $35.410 13,256 22,154 12,496 2.157 7.501 541,363 16,465 25.393 15.262 1.510 8,626 $44.294 17,482 26,812 16,427 1.657 8.728 1,071 (1,656) 631 Other 733 835 (1,234) 8,136 5 .550 6 7.366 INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Income taxes from continuing operations NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operations (net of income taxes of $47. SO and $0, respectively) CONSOLIDATED NET INCOME Less: Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY 5.500 1,182 101 1.283 6.550 7,366 2315 35 $ 1.248 $ 6.527 $ 7,351 $ $ 1.51 $ 1.69 0.28 002 0.19 0.27 $ $ $ $ 1.51 1.49 $ $ 1.69 1.67 Basic net income per share from continuing operations Basie net income per share from discontinued operations BASIC NET INCOME PER SHARE Diluted set income per share from continuing operations! Diluted net income per share from discontinued operations DILUTED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING-BASIC Effect of dilutive securities AVERAGE SHARES OUTSTANDING DILUTED $ $ 0.19 $ 4,2724 $ 2 4.334 1.49 ,317 50 4367 1.67 4.352 $3 4.405 Calculated based on net income from continuing operations less net income from continuing operations attributable to socontrolling Interests Calculated based on net income from discontinued operations less net income from discontinued operations attributable to controlling interests Per share amounts do not add due to rounding. Refer to Notes to Consolidated Financial Statements. C-2 APPENDIX C Specimen Financial Statements: The Coca-Cola Company THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Twarded De BLY 2016 2015 SLS 30 31 361 CONSOLIDATED NET INCOME Other comprehensive Net foreign curr e nt Mer i vatives Net wereld i s before were Ne sha a dather lates TOTAL COMPREHENSIVE INCOME LOSSI Low Compreh ensilabe able to strenger TOTAL COMPREHENSIVE INCOME LOSS ATTRIBUTABLE TO SHARE OWNERS i 306 2,051 S 5234 THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS ASSETS CURRENT ASSETS Cash and cash equivalent $6,006 8555 TOTAL CASH, CASH EQUIVALENTS AND SHORT-TERM INVESTMENTS 15,358 18.150 Trade O s receivable, less allowances of $177 and S p ecial Prepaid expenses and others Assets held for sale discontinued operations TOTAL CURRENT ASSETS EQUITY METHOD INVESTMENTS M45 34,010 6,729 6,00 9.401 10629 PROPERTY. PLANT AND EQUIPMENT TRADEMARKS WITH INDEFINITE LIVES BOTTLERS FRANCHISE RIGHTS WITH INDEFINITE LIVES GOODWILL OTHER INTANGIBLE ASSETS TOTAL ASSETS LIABILITIES AND EQUITY CURRENT LIABILITIES $ 67,896 5 87.270 $ 8.748 59,490 3.37 Loans and notes payable Curreat maturities of long-term debt Accrued income taxes 27,194 31.12 X2 20,684 1753 1750 Liabilities held for sale discontinued operations TOTAL CURRENT LIABILITIES LONG-TERM DEBT OTHER LIABILITIES DEFERRED INCOME TAXES THE COCA-COLA COMPANY SHAREOWNERS' EQUITY Common stock. $0.25 par valve: Authorized 11,200 shares Issued 7,040 and 7.040 shares, respectively Capital surplus Reinvested earnings Accumulated other comprehensive income (los) Treasury stock, at cost-2.781 and 2.752 shares, respectively EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS TOTAL EQUITY TOTAL LIABILITIES AND EQUITY 1.760 15.864 4.4.30 (1015) 50,677) 17,072 14993 5.502 (11. 5) (47,985) 21.062 $ 87,896 S 57.270 Refer to Notes to Consolidated Financial Statements THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS 2015 $ 1.133 6.550 7366 (101) ,182 6.550 1787 7,366 1.970 1.160 219 (1.256) (49) 158 (137) 1.215 (209) 3529 (224) (157) 6.99$ (15.831) (16.630) 15,911 (2.900) (15.499) 16,624 (838) (2.491) Year Ended December (lamilles OPERATING ACTIVITIES Consolidated net income (come) loss from discontinued operations Net income from continuing operations Deprecated at Stock-based compensation expense Deferred income Equity income ou t of dividends Foreign currency meats Sipificante s sofastset Other operating charges Other items Net changer d es Netcash provided by operating activities INVESTING ACTIVITIES Purchases of investments Proceeds from disposal 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 Net cash provided by (used in financing activities CASH FLOWS FROM DISCONTINUED OPERATIONS Net cash provided by (used in) operating activities from discontinued operations Net cash provided by (used in) investing activities from discontinued operations Net cash provided by (used in) financing activities from discontinued operations Net cash provided by used in discontinued operations EFFECT OF EXCHANGE RATE CHANGES ON CASH AND CASH EQUIVALENTS CASH AND CASH EQUIVALENTS Net increase (decrease) during the war Balance at beginning of year Balance at end of year (2,553) 3,821 (1.675) 104 (126) (2.185) 1.035 (2262) 150 (209) (999) (40) (6186) 29,857 (28,768) 1.595 (3,682) (6,320) 27.281 (25,615) 1.434 (3,681) (6,043) 40,434 (37,738) 1.245 (5,741) (7.409) (6.545) (5.113) (65) (2.549) 1.246 (1.549) 5571098.958 $ 6.006 $ 8.555 $ 7.309 Refer to Notes to Consolidated Financial Statements. DIXC Specimen Financial Statements: The Coca-Cola Company THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF SHAREOWNERS' EQUITY (82) (86) (86) 4.324 1,760 $ 1.760 $ 1,760 14,93 14,016 13.154 532 13094 258 236 219 15.864 14,993 14,016 65.502 1.348 (6,320) 60,41 65 DIN 6.327 (6.043) 65,502 Year Ended December 31 la millis t per share data) EQUITY ATTRIBUTARLE TO SILAREOWNERS OF THE COCA-COLA COMPANY NUMBER OF COMMON SHARES OUTSTANDING Balance at beginning of year Treasury stock issued to employees related to stock compensation plans Purchases of wock for treasury Balance at end of year COMMON STOCK CAPITAL SURPLUS Balance at beginning of year Stock issued to employees related to stock compensation plans The benefit (charge) from stock compensation plans Stock-based compensation expense Other activities Balance at end of year REINVESTED EARNINGS Balance at beginning of year Net income attributable to shareowners of The Coca-Cola Company Dividends (per share - $1.48. $1.40 and $1.32 in 2017, 2016 and 2015, respectively Balance at end of year ACCUMULATED OTHER COMPREHENSIVE INCOME (LOSS) Balance at beginning of year Net other comprehensive income (loss) Balance at end of year TREASURY STOCK Balance at beginning of year Treasury stock issued to employees related to stock compensation plans Purchases of stock for treasury Balanse 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 adjustment Dividends paid to noncontrolling interests Contributions by noncontrolling interests Business combinations Deconsolidation of certain entities Other activities TOTAL EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS 63.400 7351 (5.741 65.018 (11,205) 900 (10,305) (10.174) (1.031) (11.205) (5.777) (4,397) (10,174) (47,958) 909 (3.598) (S04677) 17.072 (45.006) 811 (733) (47,988) $23.0662 (42,225) 696 (3.537) (45,066) S 25,554 $ $ 241 210 23 158 35 38 (15) (25) 1,805 (157) 41 1,995 $ $ 158 $ 210 Refer to Notes to Consolidated Financial Statements
