Formula: Divide; Cell Referencing Using Excel to Perform Vertical Analysis PROBLEM Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area. Data from the comparative balance sheets of Rollaird Company is presented here. Using these data from the comparative balance sheets of Rollaird Company, perform vertical analysis. December 31, December 31. 2022 2021 Accounts receivable (net) 2$ 460,000 $ 780,000 3,164,000 400,000 650,000 2,800,000 December 31, 2022 Amount $ 460,000 December 31, 2021 Inventory Total assets Percent Amount Percent Accounts receivable (net) $ 400,000 Inventory 780,000 650,000 Total assets 3,164,000 2,800,000

Market efficiency refers to the market's ability to provide investors with all available information about investment options for buying and selling securities. Market efficiency reflects the true value of securities without undervaluing or overvaluing t…