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} Oct. 03, Sep. 28, Consolidated Balance Sheets - USD ($) $ in Millions Sep. 29, 2018 2020 2019 Assets Cash and cash equivalents $ 1,420 $ 484 $ 270 Accounts receivable, net 1,952 2,173 1,723 Inventories 3,859 4,108 3,513 Other current assets 367 404 182 Total Current Assets 7,598 7,169 5,688 Net Property, Plant and Equipment 7,596 7,282 6,169 Goodwill 10,899 10,844 9,739 Intangible Assets, net 6,774 7,037 5,759 Other Assets 1,589 765 754 Total Assets 34,456 33,097 29,109 Liabilities and Shareholders' Equity Current debt 548 2,102 1,911 Accounts payable 1,876 1,926 1,694 Other current liabilities 1,810 1,485 1,426 Total Current Liabilities 4,234 5,513 5,031 Long-Term Debt 10,791 9,830 7,962 Deferred Income Taxes 2,317 2,356 2,107 Other Liabilities 1,728 1,172 1,198 Commitments and Contingencies (Note 20) Shareholders' Equity: Capital in excess of par value 4,433 4,378 4,387 Retained earnings 15,100 13,787 12,329 Accumulated other comprehensive gain (loss) (179) (117) (15 Treasury stock, at cost - 82 million shares at September 28, 2019 and (4,145) (4,011) (3,943) September 29, 2018 Total Tyson Shareholders' Equity 15,254 14,082 12,803 Noncontrolling Interests 132 144 Total Shareholders' Equity 15,386 14,226 12,811 Total Liabilities and Shareholders' Equity 34,456 33,097 29,109 Class A [Member] Shareholders' Equity: Common stock ($0.10 par value): 38 38 38 Total Tyson Shareholders' Equity 38 38 38 Convertible Class B [Member] Shareholders' Equity: Common stock ($0.10 par value): 7 7 7 Total Tyson Shareholders' Equity $7 57
