1. Analyze the financial statements using horizontal analysis. 2. Explain what t
ID: 2424391 • Letter: 1
Question
1. Analyze the financial statements using horizontal analysis.
2. Explain what the ratio is saying for the given companies.
3. Decide which company is better based on the chosen ratio and explain why.
Note: I decided to go with horizontal analysis, but I think ratio analysis would have been better, but I'm eveb more confused about how to use that one.
THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME 2014 2013 Year Ended December 31, (In millions except per share data) 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 attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY BASIC NET INCOME PER SHARE DILUTED NET INCOME PER SHARE AVERAGE SHARES OUTSTANDING Effect of dilutive securities AVERAGE SHARES OUTSTANDING ASSUMING DILUTION 2012 45,998 46,854 $ 48,017 17,88918,42 19,05 28,109 28,433 28,964 17,218 17,310 17,738 447 1,183 895 594 483 769 (1,263) 9,708 10,228 10,779 471 397 819 137 534 463 602 576 2,201 7,124 26 9,32511,477 11,809 2,851 2,723 9,086 67 8,626 42 $ 7,098 8,584 $ 9,019 $ 1.62 1.94 2.00 $ 1.60 1.90 1.97 4,3874,4344,504 80 63 75 4,450 4,509 4,584 Calculated based on net income attributable to shareowners of The Coca-Cola Company.Explanation / Answer
Coca cola Pepsi Amount % Amount % 2014 2013 variance variance 2014 2013 variance variance Net operating revenue 45,998.00 46,854.00 (856.00) -1.83% 66,683.00 66,415.00 268.00 0.40% cost of goods sold 17,889.00 18,421.00 (532.00) -2.89% 30,884.00 31,243.00 (359.00) -1.15% grossprofit 28,109.00 28,433.00 (324.00) -1.14% 35,799.00 35,172.00 627.00 1.78% selling exp 17,218.00 17,310.00 (92.00) -0.53% 26,126.00 23,357.00 2,769.00 11.86% Amortization of intangible 92.00 110.00 (18.00) -16.36% operating charges 1,183.00 895.00 288.00 32.18% 9,581.00 9,705.00 (124.00) -1.28% operating income 9,708.00 10,228.00 (520.00) -5.08% interest income 594.00 534.00 60.00 11.24% 85.00 97.00 (12.00) -12.37% interest exp 483.00 463.00 20.00 4.32% (909.00) (911.00) 2.00 -0.22% Equity income 769.00 602.00 167.00 27.74% Other incoem (1,263.00) 576.00 (1,839.00) -319.27% income before taxes 9,325.00 11,477.00 (2,152.00) -18.75% 8,757.00 8,891.00 (134.00) -1.51% income tax 2,201.00 2,851.00 (650.00) -22.80% 2,199.00 2,104.00 95.00 4.52% consolidated net income 7,124.00 8,626.00 (1,502.00) -17.41% 6,558.00 6,787.00 (229.00) -3.37% less: net income 26.00 42.00 (16.00) -38.10% 45.00 47.00 (2.00) -4.26% net income to Cocacola 7,098.00 8,584.00 (1,486.00) -17.31% 6,513.00 6,740.00 (227.00) -3.37% basic net incomer per share 1.62 1.94 (0.32) -16.49% 4.31 4.37 (0.06) -1.37% diluted net income 1.60 1.90 (0.30) -15.79% 4.27 4.32 (0.05) -1.16% Average share oustanding 4,387.00 4,434.00 (47.00) -1.06% 1,509.00 1,541.00 (32.00) -2.08% Effiect on dilutive securities 63.00 75.00 (12.00) -16.00% 1,527.00 1,560.00 (33.00) -2.12% Average share oustanding dilution 4,450.00 4,509.00 (59.00) -1.31% 2.53 2.24 0.29 12.95% gross profit ratio 61% 61% 54% 53% Net profit ratio 15% 18% 10% 10% Coca cola is better as its gross profit and net profit margins are better in both years
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.