Please include formulas for the cells please and thank you.

Games Galore has provided its condensed financial statements for the year ended December 31 . The Controller has asked you to calculate liquidi 2 solvency, and profitability ratios that management can use in decision making. \begin{tabular}{|l|l|l|l|} \hline 38 & Required: \\ \hline 39 & 1. Compute the following liquidity ratios for Year 3. \\ \hline 40 & Note: Round to the required number of decimal places using the Excel =ROUND function \\ \hline 41 & Current ratio (rounded to one decimal place) \\ \hline 42 & Accounts receivable turnover (rounded to two decimal places) \\ \hline 43 & Days' sales uncollected (rounded to the nearest whole day) \\ \hline 44 & Inventory turnover (rounded to two decimal places) \\ \hline 45 & Days' sales in inventory (rounded to the nearest whole day) \\ \hline 46 & & dimes \\ \hline 47 & 2. Compute the following solvency ratios for Year 3. \\ \hline 48 & Note: Round to the required number of decimal places using the Excel =ROUND function \\ \hline 49 & Debt ratio ("\%" format, rounded to one decimal place) \\ \hline 50 & Times interest earned (rounded to one decimal place) \\ \hline 51 & \\ \hline \end{tabular} 52 3. Compute the following profitability ratios for Year 3. 53 Note: Round to the required number of decimal places using the Excel =ROUND function 54 Net margin ratio ("\%" format, rounded to one decimal place) 55 Return on investment ratio ("\%" format, rounded to one decimal place) 56 57 58