Excel SIM: Perform Vertical Analysis

1. Use vertical analysis to compare profitability.

All answers must be entered as a formula. Click OK to begin. 2 The income statement for each product line appears below. 19 Required: 20 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns 21 for both product lines above. Express each amount as a percentage of net sales. 22 Note: You should use absolute references in the divisors of all formulas. 23 2. Use the Excel IF function and the completed vertical analysis above to answer each of the questions below: Which product line has the highest gross profit \%? Which product line has the highest net income %