1. Provide horizontal analysis of your companys income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas).

Format Example:

Data:

1 2 3 Kraft Foods Group, Inc. Consolidated Statements of Earnings (in millions of U.S. dollars) 4 For the Years Ended Common Size Analysis Horizontal Analysis 2013 $ 5 6 Net revenues 7 Cost of sales 8 Gross profit 9 Selling, general and administrative expenses LO Asset impairment and exit costs 11 Operating income 12 Interest and other expense, net 13 Royalty income from Mondelez International 14 Earnings before income taxes 15 ovision for income taxes 16 Net earnings December 27, 2014 December 28, 2013 $ 18,205 $ 18,218 13,360 11,395 4,845 6,823 2,956 2,124 (1) 108 1,890 4,591 (484) (501) 2014 100.00% 73.39% 26.61% 16.24% -0.01% 10.38% -2.66% 0.00% 7.72% 1.99% 5.73% 100.00% 62.55% 37.45% 11.66% 0.59% 25.20% -2.75% 0.00% 22.45% 7.55% 14.90% $ Change (13) 1,965 (1,978) 832 (109) (2,701) 17 % Change -0.07% 17.24% -28.99% 39.17% -100.93% -58.83% -3.39% 4,090 1,406 363 1,043 $ 1,375 2,715 (2,684) (1,012) (1,672) -65.62% -73.60% -61.58% $ $ (In millions except per share data) 2019 2018 2017 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 37,266 $ 14,619 22,647 12,103 458 10,086 563 34,300 $ 13,067 21,233 11,002 1,079 9,152 689 36,212 13,721 22,491 12,834 1,902 7,755 679 Interest expense 946 950 853 Equity income (loss) net Other income (loss) net Income Before Income Taxes 1,049 34 1,008 (1,674) 8,225 1,749 6,476 10,786 1,801 8,985 1,072 (1,763) 6,890 5,607 1,283 35 Income taxes 65 42 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 $ 8,920 $ 6,434 $ 1,248 $ 2.09 $ 1.51 $ 0.29 Diluted Net Income Per Sharel $ 2.07 $ 1.50 $ 0.29 4,276 Average Shares Outstanding Basic Effect of dilutive securities Average Shares Outstanding Diluted 4,259 40 4,272 52 38 4,314 4,299 4,324