uestion30 xIsx_1_evalresp.. V Search File Home Insert Page Layout Formulas Chanel Jones () Data Review View Help Liberation Sans - 12 ~ A" A " Com Custom Insert ~ Paste E BI U - - -A AY E ~ % " Conditional Format as Cell Delete Formatting ~ Sort & Find & Table ~ Styles Add-ins Clipboard Font Format ~ Filter ~ Select ~ Alignment Number Styles Cells Editing Add-ins F21 v :XVfx A B D E| F G H K M IN O 1 Formula: Divide; Cell Referencing P Q 2 3 Using Excel to Perform Vertical Analysis Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical 5 Data from the comparative balance sheets of Rollaird Company is formulas with cell references to this work area. 6 presented here. Using these data from the comparative balance sheets of Rollaird Company, perform 8 December 31, December 2022 31, 2021 vertical analysis. 10 Accounts receivable (net) $ 460,000 $ 400,000 December 31, 2022 December 31, 2021 11 Inventory 780,000 650,000 Percent Total assets 2,800,000 Amount Percent Amount 3,164,000 Accounts receivable (net) $ 460,000 1453.9% $ 400,000 1428.6% 12 13 2465.2% 2321.4% Inventory 780,000 650,000 14 15 3, 164,000 100.0% 2,800,000 100.0% 16 Total assets 17 18 19 + 20 21 9:43 Summary Enter Answer X 6/2/2 Ready Accessibility: Investigate G Q Search 60 F Clear