A&E 6

Please include Excel functions/formulas to yield appropriate answers

1. Use vertical analysis to compare profitability. 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. 22 Note: You should use absolute references in the divisors of all formulas. 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 % ? \begin{tabular}{|} \hline \\ \hline \\ \hline \end{tabular} 31