Data from the comparative balance sheets of Roiland Company are presented here.

E F B 1 Formula: Divide; Cell Referencing 2 3 Using Excel to Perform Vertical Analysis 4 PROBLEM 5 Data from the comparative balance sheets of Rollaird Company 6 are presented here. 7 December 31, December 9 2020 31, 2019 10 Accounts receivable (net) $ 460,000 $ 400,000 11 Inventory 780.000 650,000 12 Total assets 3,164,000 2,800,000 13 2 14 15 16 17 18 19 20 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area Perform vertical analysis. December 31, 2020 Amount Percent Accounts receivable (net) $ 460,000 December 31, 2019 Amount Percent $ 400,000 Inventory 780,000 650.000 Total assets 3,164,000 2,800,000