i need the correct formulas for table 5.13 risk ratios that are highlighted all the information needed is there balance sheet income statement etc. can you also please attached a separate document with the formulas used. i will also attach the same tables with solutions for year 2 & 3. also answer the following questions:

1.assess the changes in the short term liquidity risk for Hasbro between year 2 and year 4 and the level of that risk at the end of year 4.

2. assess the changes in the long term solvency risk of Hasbro between year 2 and year 4 and the level of that risk at the end of year 4.

please do not utilize outside sources. everything needed is attached. i will submit this to turnit in to confirmed no plagiarism.

\fAssets Cash Accounts Receivable Inventories Prepayments Other Assets Hasbro Balance Sheet 31-Dec Year 4 $ 725.00 $ 579.00 $ 195.00 $ 219.00 Total Current Assets $ 1,718.00 $ 1,316.00 Total Assets $ 3,241.00 Liabilitites and Shareholder's equity Accounts payable Short-term borrowing Other current liabilitites Total current liabilitites Long-term debt Other noncurrent liabilities Total Liabilitites Common stock Additional paid-in capital Retained earnings Accumulated other Comprehensive income (loss) Treasury stock Total shareholder's equity Total liabilitites and Shareholder's equity Year3 $ 521.00 $ 607.00 $ 169.00 $ 212.00 $ 1,509.00 $ 1,454.00 $ 3,163.00 Year2 $ 496.00 $ 555.00 $ 190.00 $ 191.00 $ 1,432.00 $ 1,498.00 $ 3,143.00 Year 1 $ 233.00 $ 572.00 $ 217.00 $ 346.00 $ 1,368.00 $ 1,765.00 $ 3,369.00 $ 168.00 $ 159.00 $ 166.00 $ 342.00 $ 24.00 $ 223.00 $ 639.00 $ 747.00 $ 578.00 $ 1,149.00 $ 930.00 $ 967.00 $ 303.00 $ 687.00 $ 857.00 $ 149.00 $ 141.00 $ 128.00 $ 1,601.00 $ 1,758.00 $ 1,952.00 $ 105.00 $ 105.00 $ 105.00 $ 381.00 $ 398.00 $ 458.00 $ 1,721.00 $ 1,567.00 $ 1,430.00 $ 123.00 $ 36.00 $ 599.00 $ 758.00 $ 1,166.00 $ 92.00 $ 2,016.00 ### $ 455.00 $ 1,622.00 $ 82.00 $ 30.00 $ (47.00) $ (68.00) $ (649.00) $ (695.00) $ (755.00) $ (761.00) $ 1,640.00 $ 1,405.00 $ 1,191.00 $ 1,353.00 $ 3,241.00 $ 3,163.00 $ 3,143.00 $ 3,369.00 Hasbro Income Statement for the year ended December 31 Year 4 Year3 year2 Year1 Sales Cost of goods sold Selling and administrative expenses Advertising Research and development Royalty expense other selling and administrative Interest expense Income Tax expense Net Income $ 2,998.00 $ 3,139.00 $ 2,816.00 $ (1,252.00) $ (1,288.00) $ (1,099.00) $ $ $ $ $ $ $ (387.00) (157.00) (223.00) (687.00) (32.00) (64.00) 196.00 $ $ $ $ $ $ $ (364.00) (143.00) (248.00) (799.00) (53.00) (69.00) 175.00 $ $ $ $ $ $ $ (297.00) (154.00) (296.00) (788.00) (78.00) (29.00) 75.00 Hasbro Statements of Cash Flows For the year ended December 31 Operations Net Income Depreciation and amortization Addbacks and substractions, net (Increase) Decrease in accounts receivable (Increase) Decrease in inventories (Increase) Decrease in prepayments Increase (Decrease) in accounts payable and other current liabilities Cash Flow operations Investing Property, plant, and equipment acquired Other investing trasnsactions Cash Flow from investing Financing Increase in common stock Decrease in short-term borrowing Decrease in long-term borrowing Acquisition of common stock Dividends Other financing transactions Cash Flow from Financing Change in Cash Cash-beginning of year Cash-End of year Year4 $ 196.00 $ 146.00 $ 17.00 $ 76.00 $ (16.00) $ 29.00 $ (90.00) $ 358.00 Year3 $ 175.00 $ 164.00 $ 68.00 $ (13.00) $ 35.00 $ 8.00 $ 17.00 $ 454.00 Year2 $ 75.00 $ 184.00 $ (67.00) $ 34.00 $ 39.00 $ 185.00 $ 23.00 $ 473.00 $ (79.00) $ (63.00) $ (59.00) $ (6.00) $ (2.00) $ (3.00) $ (85.00) $ (65.00) $ (62.00) $ 3.00 $ 40.00 $ (7.00) $ (58.00) $ (389.00) $ (3.00) $ (37.00) $ (21.00) $ 7.00 $ 9.00 $ (69.00) $ (364.00) $ 204.00 $ 25.00 $ 521.00 $ 496.00 $ 725.00 $ 521.00 $ 3.00 $ (15.00) $ (127.00) $ (21.00) $ 12.00 $ (148.00) $ 263.00 $ 233.00 $ 496.00 Risk Ratios for Hasbro Year4 Current ratio Year3 1.5 Year2 1.6 1.5 Accounts receivable turnover year 4 $ 593 Average 5.06 AR Turnover year 2 $ year 3 $ 563.5 Average AR 5.00 AR turnover 581.00 Average AR 5.40 AR turnover operating cash flow year 2 862.5 Average current liabilitie year 3 948.5 Average current liabilitie year 4 1039.5 Average current liabilitie OCF=Total liabilties year 2 1984 Average total liabilities year 3 1855 Average total liabilities Quick Ratio Operating cash flow to current liabilities ratio Days accounts receivable outstanding Days inventory held Days accounts payable outstanding Net days of working capital financing needed Liabilitites to assets ratio Liabiltities to shareholder's equity ratio Long-term debt to long-term capital ratio Long-term debt to shareholders' equity ratio Operating cash flow to total liabilities ratio Interest coverage ratio 1.4 0.344 72 0.494 0.976 0.156 0.185 0.213 1.2 0.479 68 0.556 1.251 0.328 0.489 0.245 1.3 0.548 73 0.621 1.639 0.418 0.720 0.238 year4 1679.5 Average total liabilities Inventory Turnover year 2 203.5 Average inventories $ (5.40) year 3 179.5 Average inventories $ (7.18) Year 4 182 Average inventories Accounts payable Turnover year 2 144.5 year 3 162.5 Year4 163.5 ceivable turnover AR Turnover Average AR AR turnover Average AR AR turnover Average current liabilities Average current liabilities Average current liabilities Average total liabilities Average total liabilities Average total liabilities Average inventories Average inventories Average inventories le Turnover