Please use cell references according to excel and the proper input of these equations to get correct decimal awnsers
* 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% AutoSave H Excelproblems Question 11 (1).xlsx - Excel A O Search (Alt+a) Similoluwa Oyinkolade 50 File Home Insert Draw Page Layout Formulas Data Reviow View Help Acrobat Comments Share 2 Liberation Sans v 12 - A A == BA 29 Wrap Text Custom II LE 47 @ Paste BIU Merge Center A +38- $ - %) Sensitivity Conditional Format as Call Formatting Table Styles Insert Delete Format Sort & Find & Filter Select Analyze Data Alignment Number Styles Cells Editing Analysis F o R. S T U G H J K L M N 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. December 31, 2022 Amount Percent Accounts receivable (net) $ 460,000 December 31, 2021 Amount Percent $ 400,000 Inventory 780,000 650.000 1 Unda Clipboard Fort 1111 fx B D E PROBLEM 5 Data from the comparative balance sheets of Rollaird Company is 6 presented here. 7 8 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 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Enter Answer + Select destination and press ENTER or choose Paste Total assets 3,164,000 2,800,000 1004
