please show your work and make sure to create a table thats looks organized. thank you!

Calla Canoe Company wants to invest some of its excess cash in trading securities and is considering two investments, The Water Company (WC) and Flashy Life Vests (FLV). The income statement balance sheet, and other data for both companies follow for 2019 and 2018, as well as selected data for 2017 (Click the icon to view the data.) Read the requirements Requirement 1. Compute each ratio for both companies for 2019 and 2018. Assume all sales are credit sales Round all ratios to two decimal places a. Current ratio Begin by selecting the correct formula Current ratio Total current assets - Total current liabilities Now, compute the ratio for both companies for both years. (Round your answers to two decimal places, XXX) Ratio Year WC FLV Current 2019 Current 2018 C. e. . Using the financial statements given, compute the following ratios for both companies for 2019 and 2018. Assume all sales are credit sales. Round all ratios to two decimal places. a. Current ratio b. Cash ratio Inventory turnover d. Accounts receivable turnover Gross profit percentage f. Debt ratio g. Debt to equity ratio h. Profit margin ratio i. Asset turnover ratio j. Rate of return on common stockholders' equity k. Earnings per share I. Pricelearnings ratio m. Dividend yield Dividend payout 2. Compare the companies' performance for 2019 and 2018. Make a recommendation to Calla Canoe Company about investing in these companies. Which company would be a better investment, The Water Company or Flashy Life Vests? Base your answer on ability to pay current liabilities, ability to sell merchandise and collect receivables, ability to pay long-term debt, profitability, and attractiveness as an investment n. The Water Company Comparative Financial Statements Years Ended December 31, 2019 2018 2017 Flashy Life Vests Comparative Financial Statements Years Ended December 31, 2019 2018 2017 Income Statement Net Sales Revenue S 430,642 5 258,392 425 060 256,392 410.290 S 383,290 299 230 280.780 172 250 153,220 168,668 151,792 111,060 78.490 102,510 70,490 Cost of Goods Sold Gross Profit Operating Expenses Operating Income Interest Expense Income before Income Tax Income Tax Expense 19,030 860 16,876 785 32,570 2770 32.020 2,960 18.170 5.159 16,091 5,010 29,800 8.810 29.060 8,680 Net Income $ 13,011 $ 11,081 $ 20.990 S 20,380 Balance Sheet $ $ 68,510 $ 44,800 70 377 44,430 $ 44 120 65 129 $ 39,890 68 560 24,861 55 250 38,690 $ 65,300 37.460 36,490 59.920 76,360 79.920 16,080 66,300 16,793 198.440 209 310 90,014 197 900 90,490 196 700 116.366 116.800 $ 299,3245 288,390 $ $ 276 012 315.240 S 313,066 S 310,690 Assets Cash and Cash Equivalents Accounts Receivable Merchandise Inventory Other Current Assets Total Current Assets Long-term Assets Total Assets Liabilities Current Liabilities Long-term Liabilties Total Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and $ $ 69,560 $ 31.680 60230 29.960 90.830 5 96 270 90,070 105,830 101 240 90 190 187,100 195 950 72.800 125 284 80.820 117 380 111.430 16,660 102 420 14696 198,084 198 200 128.140 197 670 117,116 103 900 Stockholders' Equity $ 299, 324 $ 288.390 $ 315 240 $ 313,066 Other Data 21.38 $ 33.32 45.92 $ 51.44 Market price per share Annual dividend per share Weighted average number of shares outstanding 0.37 0.34 0.45 0.38 9,500 9,000 9,500 9,000