Please need help ASAP. Please solve with formula and explanation :)

Use the balance sheet and selected income statement balances (additional information) of Spruce Company to perform a horizontal analysis and vertical analysis. Also, calculate the following ratios for 2019 (round to the nearest hundredths). Spruce Company Balance Sheet December 31, 2019 and 2018 Horizontal Vertical 20192018 \$Change \% Change \% 2019%2018 Assets Liabilities and Equity Additional Information: Net Sales COGS Net Income Dividends for 20192.50 Market price at 12/31/19 25.00 Current ratio Acid-test ratio Accounts receivable turnover Inventory turnover Days' sales uncollected Days' sales in inventory Total asset turnover Debt ratio Equity ratio Debt-to-equity ratio Profit margin ratio Gross margin ratio Return on total assets Dividend yield \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular}