Formula: Divide; Cell Referencing $$ Some cells are merged. Using Excel to Perform Vertical Analysis $$ PROBLEM$$ Data from the comparative balance sheets of Rollaird Company is presented here.

$$ December $31,2022$ December $31,2021$

Accounts receivable $($net$)$$$460,000$$$400,000$

Inventory$780,000650,000$

Total assets $3,164,0002,800,000$

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.

December $31,2022$

$$Amount$$Percent$$

Accounts receivable $($net$)$$$460,000$

Inventory $780,000$

Total assets $3,164,000$

December $31,2021$

$$Amount$$Percent$$

Accounts receivable $($net$)$$$400,00$

Inventory $650,000$

Total assets $2,800,00$