Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area.

* AutoSave 0 A BETA Gradable: Excel Brief Exercise 13.5 Divide 1 evalresponse.xlsx - Excel Search (Alt+O) Similoluwa Oyinkolade 50 File Home Incert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share 2 Liberation Sans v 12 ~ A A == SA 2 Wrap Text Custom II 47 @ Analyze Data Paste BI UBA CA A Merge Center Sensitivity PA IDA Conditional Formatos Cell Formatting Table Styles Styles Insert Delete Format $ %) V Sort & Fird & Filter Select Unde Cupboard Fort 5 Alignment Number Cells Editing Analysis Sensitivity 01B fx B 1 Formula: Divide; Cell Referencing : ; A D E F G H K L M N 0 R. s T U. 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 Excel to Perform Vertical Analysis PROBLEM Data from the comparative balance sheets of Rollaird Company is 6 presented here. 7 6 December 31, December 31, 9 2022 2021 10 Accounts receivable (net) S 460,000 $ 400.000 11 Inventory 780,000 650,000 12 Total assets 3,164,000 2.800.000 13 14 15 16 Using these data from the comparative balance sheets of Rollaird Company, perform vertical analysis. 1 December 31, 2022 Amount Percent Accounts receivable (net) $ 460,000 1453.9% December 31, 2021 Amount Percent $ 400,000 1428.6% Inventory 780,000 2465.296 650,000 2321,4% Total assets 3,164,000 100.0% % 2.800,000 100.0% 18 19 20 21 22 23 24 25 26 27 28 Summary Enter Answer Ready + 100%