Pep income and balance sheet is above. i need the financial answers below. i needed 6 years of income and balance sheet so you can calculate 5 years worth of financial ratios (some ratios you need the 6th year to figure out.) can you please show work. thank you so much
Done Pepsi Consolidated Statements of Income and Balance Sheet (7 of 12) r 12 Months Ended Consolidated Statement of Inceme USD (5) shares in Millions, S in Millions Dec. 29, 2018 Dec. 30, 2017 31, 2016 Dec. 26, 2015 Dec 27.2014 Dec. 28, 2013 Income Statement [Abstractl 64661 Selling, general and administrative expenses Amortization of intangible assets Net Periodie Defined Benefits Expense (Reversal of Expense),Excluding Service Cost Income before income tases (Benefit from) provision for income taxes (See Note 5 Net Income (Loss),Including Pertion Attributable to Noncontrolling Interest Net income attributable to noncontrolling interests Net Income Attributable to PepsiCo Net Income Attributable to PepsiCe per Cemmen Share Cash dividends declared per common shane 2.5325 Consolidated Balaace Sheet- USD (S) S in Millions ASSETS Cash and cash equivalets Short-term Inveuments Restricted Cash Accounts and notes receivable, net Dec. 29. 2018 Dee. 30, 2017 Dec. 31,2016 Dec.26, 2015 Dec. 27, 2014 Dec. 28, 2013 8721 272 1997 7142 3128 6967 2913 6437 2720 1865 6651 Prepaid expenses and other curen assets Assets, Current Property, Plant and Equipment, net Amortizable letangible Assets, net 1546 31027 17240 1268 14744 12570 27314 1547 2162 22203 18575 16317 1270 17389 17244 1237 4430 16613 14401 Indefinne-lived Intanpible Assets (Excluding Goodwill 4181 11811 12639 27604 31014 Equity Method Investments Deferred Income Tax Assets, Net Other Asscts Total Assets LIABILITIES AND EQUITY 2409 2042 1425 129 13507 17.578 Accounts payable and other current liabilities Liabilities, Current Long-Term Debt Obligations Deferred Income Tax Liabillities, Net Other Liabulities, Noncurrent 12533 17839 24333 22138 33796 3242 1283 304 5744 493 3089 62930 Preferred Slock, no par value Stockholders Equity Amibutable to Parent PepsiCo Common Shareholders'Equity Common stock, par value 123e per share (authorized 3,600 shares, issued, net of repurchased common stock 11246 12068 Common stock, par value 12/3g per share (authorized 3,600 shares,issued, net of repurchased common stock at par value: 1,409 and 1,420 shares, respectively) Common stock, par value 12/3e per share (authorized 3,600 shares, issued, net of repurchased common stock ar par value: 1,428 and 1,448 shares, respectively) Common Stock, Value, Issued Additional Paid in Capital Common Stock Retained Eamings (Accumulated Deficit) Accumulated Other Comprehensive Income (Loss), Net of Tax Stockholders Equity Attributable to Parent Stockholders Equity Attibutable to Noncontrolling Interest Total Equity Liabilities and Equity Preferred Stock PepsiCe Commen Shareholders Equity Stockholders Equity Atthbutable to Parent Additional Paid-in Capital |Member 24 3953 2839 13057 4091 2518 13919 S119 14518 84 14602 13319 10669 17578 12030 69667 10981 11199 192 186 Stockholders Equity Retained Eamings[Member PepsiCe Common Shareholders Equity Stockholders Equity Attributable to Parent OCT Attibutable to Parent[Member Attnibutable to Parent 4091 Equity Attnibutable to 5119 13919 13319 Treasury Stock [Member PepsiCe Common Shareholders Equity Stockholders' Equity Attnibutable to Parent Commen Stock PepsiCe Common Shareholders Equity Stockholders' Equity Attributable to Parent Treasury Stock, Value Treasury Stock, Value 31468 21004 Summary of Ratios for Pepsi 2014 2015 2016 2017 2018 5-Yr Avg Current Ratios Quick Ratios Interest Coverage (TIE) Days sales in Inventory Inventory Turnover Days sales in Receivable Receivable Turnover Return on Assets Depont ROE Profit Margin Total Asset Turnover Equity Multiplien