2 3 4 5 6 7 CO 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 B Formula: Divide; Cell Referencing A Using Excel to Perform Vertical Analysis PROBLEM Data from the comparative balance sheets of Rollaird Company is presented here. Accounts receivable (net) Inventory Total assets December 31, 2022 $ D December 31, 2021 460,000 $ 780,000 3,164,000 400,000 650,000 2,800,000 E

Data from the comnarative halance sheets of Rollaird Companv is Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area. Using these data from the comparative balance sheets of Rollaird Company, perform vertical analysis. \begin{tabular}{|l|c|c|c|c|c|} \hline & & & \\ & \multicolumn{2}{|c|}{ December 31, 2022 } & \multicolumn{2}{c|}{ December 31, 2021} \\ \hline & Amount & Percent & Amount & Percent \\ \hline Accounts receivable (net) & $460,000 & & $ & 400,000 & \\ \hline Inventory & 780,000 & & & 650,000 & \\ \hline Total assets & 3,164,000 & & & 2,800,000 & \\ \hline \end{tabular}