Lake Athletics sells two distinct product lines: Apparel and Equipment. The income statement for each product line appears below. Required: 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales. 2. Use the completed vertical analysis above to answer each of the questions below: Which product line has the highest gross profit percent? 27 Which product line has the highest net income percent