a. Calculate cash flows from assets, cash flows to creditors, and cash flows to shareholders for 2019. b. Create a statement of cash flow (accounting statement) for 2019. c. Calculate cash cycle. d. Conduct a thorough financial ratio analysis. e. Use the percent-of-sales formula to calculate the amount of external financing needed for year 2020. (Assumptions: Sales are expected to grow by 8 percent in year 2020, the net profit margin is expected to be 12 percent, and the dividend payout ratio is 35 percent. The fixed assets are currently being used at full capacity.) September 28, 2019 Years ended September 29, 2018 September 30, 2017 $ $ $ Net sales: Products Services Total net sales 213,883 46,291 260,174 225,847 39,748 265,595 196,534 32,700 229,234 Cost of sales: Products Services Total cost of sales Gross margin 144,996 16,786 161.782 98,392 148,164 15,592 163,756 101,839 126,337 14,711 141,048 88,186 Operating expenses: Research and development Selling, general and administrative Total operating expenses 16,217 18,245 34,462 14,236 16,705 30,941 11,581 15,261 26,842 Operating income Other Income (expense), net Income before provision for income taxes Provision for Income taxes Net Income 63,930 1,807 65,737 10,481 55,256 70,898 2,005 72,903 13,372 59,531 61,344 2,745 64,089 15.738 48,351 $ $ $ Earnings por share: Basic Diluted 12.01 11.97 11.89 $ $ $ $ $ 9.27 9.21 11.91 Shares used in computing earings per share: Basic Diluted 4,617,834 4,648,913 4,955,377 5,000,109 5.217.242 5.251,692 September 23, 2010 September 23, 2015 ASSETS: $ 25,913 rent assets: Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets 48,844 $ 51,713 22.926 4.106 22,878 12352 162,819 23.156 3.956 25,809 12.087 131,339 170,799 41,304 on-current assets: Marketable securities Property, plant and equipment, not Other non-current assets Total non-current assets Total assets 105,341 37,378 32,978 175,697 338.516 $ 234,385 365725 $ LIABILITIES AND SHAREHOLDERS' EQUITY: $ 55.888 5.900 Current liabilities: Accounts payable Other current labilities Deferred revenue Commercial paper Term debit Total current liabilities 46.238 37.720 5.522 5.980 10.250 105,718 8.734 115.929 91 302 53.735 Non-current abilities: Term debt Other non-current abilities Total non-current liabilities Total liabilities 50 503 142.310 o RI 99. SUS home 163 18 19 fo $ 96 5 & 7 6 8 3 9 F IR T Y U Shareholders' equity: Common stock and additional paid-n capital, 50.00001 par value: 12,600,000 shares authorized: 4,443,236 and 4,754,988 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive Income (loss) Total shareholders' equity Total abilities and shareholders' equity 45,174 45,898 (584) 90,488 338,516 40,201 70,400 (3.454) 107,147 365.725 $ a. Calculate cash flows from assets, cash flows to creditors, and cash flows to shareholders for 2019. b. Create a statement of cash flow (accounting statement) for 2019. c. Calculate cash cycle. d. Conduct a thorough financial ratio analysis. e. Use the percent-of-sales formula to calculate the amount of external financing needed for year 2020. (Assumptions: Sales are expected to grow by 8 percent in year 2020, the net profit margin is expected to be 12 percent, and the dividend payout ratio is 35 percent. The fixed assets are currently being used at full capacity.) September 28, 2019 Years ended September 29, 2018 September 30, 2017 $ $ $ Net sales: Products Services Total net sales 213,883 46,291 260,174 225,847 39,748 265,595 196,534 32,700 229,234 Cost of sales: Products Services Total cost of sales Gross margin 144,996 16,786 161.782 98,392 148,164 15,592 163,756 101,839 126,337 14,711 141,048 88,186 Operating expenses: Research and development Selling, general and administrative Total operating expenses 16,217 18,245 34,462 14,236 16,705 30,941 11,581 15,261 26,842 Operating income Other Income (expense), net Income before provision for income taxes Provision for Income taxes Net Income 63,930 1,807 65,737 10,481 55,256 70,898 2,005 72,903 13,372 59,531 61,344 2,745 64,089 15.738 48,351 $ $ $ Earnings por share: Basic Diluted 12.01 11.97 11.89 $ $ $ $ $ 9.27 9.21 11.91 Shares used in computing earings per share: Basic Diluted 4,617,834 4,648,913 4,955,377 5,000,109 5.217.242 5.251,692 September 23, 2010 September 23, 2015 ASSETS: $ 25,913 rent assets: Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets 48,844 $ 51,713 22.926 4.106 22,878 12352 162,819 23.156 3.956 25,809 12.087 131,339 170,799 41,304 on-current assets: Marketable securities Property, plant and equipment, not Other non-current assets Total non-current assets Total assets 105,341 37,378 32,978 175,697 338.516 $ 234,385 365725 $ LIABILITIES AND SHAREHOLDERS' EQUITY: $ 55.888 5.900 Current liabilities: Accounts payable Other current labilities Deferred revenue Commercial paper Term debit Total current liabilities 46.238 37.720 5.522 5.980 10.250 105,718 8.734 115.929 91 302 53.735 Non-current abilities: Term debt Other non-current abilities Total non-current liabilities Total liabilities 50 503 142.310 o RI 99. SUS home 163 18 19 fo $ 96 5 & 7 6 8 3 9 F IR T Y U Shareholders' equity: Common stock and additional paid-n capital, 50.00001 par value: 12,600,000 shares authorized: 4,443,236 and 4,754,988 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive Income (loss) Total shareholders' equity Total abilities and shareholders' equity 45,174 45,898 (584) 90,488 338,516 40,201 70,400 (3.454) 107,147 365.725 $