please include worked solution / show work

Sedona Corporation declared and paid a cash dividend of $7,600 in the current year. Its comparative financial statements, prepared at December 31, reported the following summarized information: Current Year Previous Year $ 160,000 72,000 88,000 46,000 5,000 37,000 11,100 $ 25,900 $ 139,000 68,000 71,000 41,000 5,000 25,000 7,500 $ 17,500 Income Statement Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses Interest Expense Income before Income Tax Expense Income Tax Expense (30%) Net Income Balance Sheet Cash Accounts Receivable, Net Inventory Property and Equipment, Net Total Assets Accounts Payable Income Tax Payable Notes Payable (long-term) Total Liabilities Common Stock (par $10) Retained Earnings Total Liabilities and Stockholders' Equity ' $ 82,550 27,000 35,000 105,000 $ 249,550 $ 52,000 1,250 50,000 103, 250 96,000 50,300 $ 249,550 $ 28,000 22,000 48,000 115,000 $ 213,000 $ 34,000 1,000 50,000 85,000 96,000 32,000 $ 213,000 5. Net property and equipment totaled $120,000 at the beginning of the previous year. Compute the fixed asset turnover ratios for the current and previous years. Are the current-year results better, or worse, than those for the previous year? 6. Compute the debt-to-assets ratios for the current and previous years. Is debt providing financing for a larger or smaller proportion of the company's asset growth? 7. Compute the times interest earned ratios for the current and previous years. Are the current-year results better, or worse, than those for the previous year? 8. After Sedona Corporation released its current year's financial statements, the company's stock was trading at $28. After the release of its previous year's financial statements, the company's stock price was $25 per share. Compute the P/E ratios for both years. Does it appear that investors have become more or less) optimistic about Sedona's future success? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required B 5-a. Net property and equipment totaled $120,000 at the beginning of the previous year. Compute the fixed asset ratios for the current and previous years. (Round your answers to 2 decimal places.) 5-b. Are the current-year results better, or worse, than those for the previous year? 5-a. Current Year 5-a. Previous Year 5-b. Current year fixed asset turnover? Better Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 6-a. Compute the debt-to-assets ratios for the current and previous years. (Round your answers to 2 decimal plac 6-b. Is debt providing financing for a larger or smaller proportion of the company's asset growth? 6-a. Current Year 6-a. Previous Year 6-b. Current year debt-to-assets ratio? Larger Proportion Required 1 Required 2 Required 3 3 Required 4 Required 5 Required 6 6 Required 7 Required B 7-a. Compute the times interest earned ratios for the current and previous years. (Round your answers to 1 decim 7-b. Are the current-year results better, or worse, than those for the previous year? 7-a. Current Year 7-a. Previous Year 7-a. b. ? 7-b. Current year times interest earned ratio? 7.4 5.0 Better Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Required 7 Required 8 B-a. After Sedona Corporation released its current year's financial statements, the company's stock was trading at $28. After the release of its previous year's financial statements, the company's stock price was $25 per share. Compute the P/E ratios for both years. (Round your intermediate calculations to 2 decimal places and final answers to 1 decimal place.) 8-b. Does it appear that investors have become more (or less) optimistic about Sedona's future success? Show less 8-a Current Year 8-a. Previous Year 8-b. Current year P/E ratio? Less Optimistic