5. Prepare a vertical analysis of same size income statement and balance sheet for Pepsi and Coca Cola for 2016 and 2017. Write a paragraph highlighting what you learn from the percentages of sales or total assets calculated from the financial statements. Write also about the comparison between 2016 and 2017 and between Coke and Pepsi. 6. Compare Pepsi's income statement for 2016 with their income statement for 2017 - calculate the change in dollars and percent for all of the revenues and expenses. What do the changes indicate about Pepsi's success in 2016 relative to 2017? Do the same comparison for Coke's income statement. What do the changes indicate about Coke's improvement or lack thereof between 2016 and 2017? With this comparison of both companies over time now compare Coke vs. Pepsi and explain why one company is better than the other. 7. Based on all of your calculations and observations described above, make a recommendation as to which company would be a better investment. Give the reasons for your conclusion. Consolidated Statement of Income PepsiCo, Inc. and Subsidiaries Fiscal years ended December 30, 2017, December 31, 2016 and December 26, 2015 (in millions except per share amounts) 2017 63,525 28,785 34,740 24,231 2016 $ 62,799 $ 28,209 34,590 24,805 2015 63,056 28,731 34,325 24,613 1,359 9,785 (1,342) Net Revenue Cost of sales Gross profit Selling, general and administrative expenses Venezuela impairment charges Operating Profit Interest expense Interest income and other Income before income taxes Provision for income taxes (See Note 5) Net income Less: Net income attributable to noncontrolling interests Net Income Attributable to PepsiCo Net Income Attributable to PepsiCo per Common Share Basic Diluted Weighted average common shares outstanding Basic Diluted Cash dividends declared per common share 10,509 (1,151) 244 9,602 4,694 4.908 110 8,553 2,174 6,379 (970) 59 7,442 1,941 5,501 49 5,452 SO $ 4,857 $ 6,329 $ $ 3.40 $ 3.38 $ 4.39 $ 4.36 $ 3.71 3.67 $ 1,425 1,438 3.1675 $ 1,4391 ,469 1,452 1,485 2.96 $ 2.7625 $ Consolidated Balance Sheet PepsiCo, Inc. and Subsidiaries December 30, 2017 and December 31, 2016 (in millions except per share amounts) 2017 2016 $ $ ASSETS Current Assets Cash and cash equivalents Short-term investments Accounts and notes receivable, net Inventories Prepaid expenses and other current assets Total Current Assets Property, Plant and Equipment, net Amortizable Intangible Assets, net Goodwill Other nonamortizable intangible assets Nonamortizable Intangible Assets Investments in Noncontrolled Amiliates Other Assets Total Assets 10,610 8,900 7,024 2,947 1,546 31.027 17,240 1,268 14,744 12,570 27,314 2,042 913 79,804 9,158 6,967 6,694 2,723 908 26,450 16,591 1,237 14,430 12.196 26,626 1.950 636 73,490 $ $ $ 5,485 15.017 20,502 33,796 11,283 3.242 68,823 6,892 14.243 21,135 30.053 6,669 4,434 62,291 41 LIABILITIES AND EQUITY Current Liabilities Short-term debt obligations Accounts payable and other current liabilities Total Current Liabilities Long-Term Debt Obligations Other Liabilities Deferred Income Taxes Total Liabilities Commitments and contingencies Preferred Stock, no par value Repurchased Preferred Stock PepsiCo Common Shareholders' Equity Common stock, par value 1/c per share (authorized 3.600 shares, issued, net of repurchased common stock at par value: 1.420 and 1.428 shares, respectively) Capital in excess of par value Retained earnings Accumulated other comprehensive loss Repurchased common stock, in excess of par value (446 and 438 shares, respectively) Total PepsiCo Common Shareholders' Equity Noncontrolling interests Total Equity Total Liabilities and Equity 41 (197) (192) 24 3.996 52,839 (13,057) (32,757) 11,045 92 4,091 52,518 (13,919) (31,468) 11,246 104 11,199 73,490 10.981 79,804 $ $ THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS 2017 2016 $ 6,006 9,352 15,358 SIT 8.555 9,595 18,150 4,051 3856 2.675 2,481 2,797 2685 2.000 7399 36,545 20,856 1,096 S60 34,010 16.260 999 434 10,635 6,097 3,676 10,629 729 9,401 726 $ 87,896 $ 87,270 December 31 (in millions except par value) ASSETS CURRENT ASSETS Cash and cash equivalents Short-term investments TOTAL CASH, CASH EQUIVALENTS AND SHORFTERM INVESTMENTS Markete securities Trade accounts receivable, less allowances of $477 and $466, respectively Inventories Prepaid expenses and other assets Aucts held for sale Assets held for sale-discontinued operations TOTAL CURRENT ASSETS EQUITY METHOD INVESTMENTS OTTER INVESTMENIS OTHER ASSETS PROPERTY, PLANT AND EQUIPMENT-net TRADEMARKS WITH INDEFINITE LIVES BOTTLERS' FRANCHISE RIGHTS WITH INDEFINITE LIVES GOODWILL OTHER INTANGIBLE ASSETS TOTAL ASSETS LIABILITIES AND EQUITY CURRENT LIABILITIES Accounts payable and accrued expenses Loans and notes payable Current maturities of long-term debt Accrued income taxes Liabilities held for sale Liabilities held for sale - discontinued operations TOTAL CURRENT LIABILITIES LONG-TERM DEBT OTHER LIABILITIES DEFERRED INCOME TAXES THE COCA-COLA COMPANY SHAREOWNERS BOUITY Common stock, 0.25 par values Authorired -11,200 shares Iwwe-7,040 and 700 shares, respectively Capital surplus Reinvested earnings Accumulated other comprehensive income (los) Treasury stock, alc 2 781 and 2,752 shares, respectively EQUITY ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY EQUITY ATTRIBUTABLE TO NONCONTROLLING INTERESTS TOTAL FOUITY TOTAL LIABILITIES AND EQUITY $ $ 8,748 13.205 9,490 12,498 2527 207 710 1.496 27,194 31,182 8,021 2.522 26-532 29,684 4,081 1,760 604 (10,305) (50,677) 17,072 1,760 14.993 65.502 (11,205) 47,988) 23,062 18,977 $ 87,896 23.220 $ 87,270