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} Consolidated Statements Of Income - USD ($) shares in Oct. 03, 2020 Sep. 28, Sep. 29, Millions, $ in Millions 2019 2018 Sales $ 43,185 $ 42,405 $ 40,052 Cost of Sales 37,801 37,383 34,956 Gross Profit 5,384 5,022 5,096 Operating Expenses: Selling, General and 2,376 2,195 2,127 Administrative Operating Income 3,008 2,827 2,969 Other (Income) Expense: Interest income (10) (11) (7) Interest expense 485 462 350 Other, net (131) (55) (56) Total Other (Income) Expense 344 396 287 Income before Income Taxes 2,664 2,431 2,682 Income Tax Expense (Benefit) 593 396 (291) Net Income 2,071 2,035 2,973 Less: Net Income Attributable to 10 13 3 Noncontrolling Interests Net Income Attributable to Tyson $ 2,061 $ 2,022 $ 2,970 Weighted Average Shares Outstanding: Diluted, Shares 365 366 369 Net Income Per Share Attributable to Tyson: Diluted (USD per share) $ 5.64 $ 5.52 $ 8.04 Class A [Member] Weighted Average Shares Outstanding: Basic, Shares 293 293 295 Net Income Per Share Attributable to Tyson: Basic (USD per share) $ 5.79 $ 5.67 $ 8.29 Class B [Member] Weighted Average Shares Outstanding: Basic, Shares 70 70 70 Net Income Per Share Attributable to Tyson: Basic (USD per share) $ 5.21 $ 5.10 $ 7.46
