4. Financial Analysis: a. Using Excel formulas. calculate the Dollar Change between each year [all tabs}. I]. Using Excel formulas. calculate the Percent Change between each year {all tabs}. c. Using Excel formulas. calculate the Common Size Percents: i. Use Total Assets as the base amount for the Balance Sheet. ii. Use Sales as the base amount for the Income Statement. iii. No Common Size Percents must be calculated for the Statement of Cash Flows. d. Using Excel formulas calculate the following ratios for EAL'H of the three years presented: i. Current ratio ii. Acid'test ratio iii. Accounts receivable turnover [for two most recent years only. not required for third year] iv. Inventory turnover {for two most recent years only, not required for third year} v. Days' sales uncollected vi. Total asset turnover {for two most reoent years only, not required for third year} vii. Debt-to-equity ratio viii. Profit l'vla rgin ix. Return on total assets [for two most recent yea rs only, not required for third year} x. Earnings per share {may be obtained from 10K} Sep. 28, Sep. 29, Consolidated Statements Of Cash Flows $ in Millions Oct. 03, 2020USD ($) 2019USD 2018USD (S) (5) Statement of Cash Flows [Abstract] Restricted Cash $ 46 50 50 Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents 1,466 484 270 Cash Flows From Operating Activities: Net Income 2,071 1,993 2,973 Adjustments to reconcile net income to cash provided by operating activities: Depreciation 900 819 723 Amortization 292 279 220 Deferred income taxes 18 77 (874 Gain on dispositions of businesses 0 17 42 Impairment of assets 48 94 175 Stock-based compensation expense 89 77 69 Other, net (124) (20) (58) Increase) decrease in accounts receivable 191 (226) (2) (Increase) decrease in inventories 86 (157 144) ncrease (decrease) in accounts payable (64) (55 (44) Increase (decrease) in income taxes payable/receivable 62 (254) 111 Increase (decrease) in interest payable (41) 47 (3 Jet changes in other operating assets and liabilities 346 (144) 141 Cash Provided by Operating Activities 3,874 2,513 2,963 Cash Flows from Investing Activities: Additions to property, plant and equipment (1,199) (1,259) (1,200) Purchases of marketable securities (105 (64) 42) Proceeds from sale of marketable securities 87 63 37 Acquisitions, net of cash acquired 0 (2,462) (1,474) Proceeds from sale of businesses 29 170 797 Payments to Acquire Equity Method Investments 183 Other, net (52 88 (24) Cash Used for Investing Activities (1,423) (3,464) (1,906) Cash Flows from Financing Activities: Proceeds from issuance of debt 1,609 4,634 1,148 Payments on debt 1,212 3,208 1,307 Borrowings on revolving credit facility 1,210 1,135 1,755 Payments on revolving credit facility (1,280) (1,065) (1,755) Proceeds from issuance of commercial paper 14,272 17,722 21,024 Repayments of commercial paper (15,271) (17,327) (21,197 Purchases of Tyson Class A common stock (207) (252) (427 Dividends (601) (537) (431) Stock options exercised 30 99 102 Other, net (18) (30) (14) Cash Provided by (Used for) Financing Activities (1,468) 1,171 (1, 102) Effect of Exchange Rate Change on Cash (1) (6) (3) Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase 982 214 (48) Decrease), Including Exchange Rate Effect Cash and Cash Equivalents and Restricted Cash at Beginning of Year 484 270 Cash and Cash Equivalents at End of Year $ 1,420 $ 484 $ 270