Lake Athletics has provided you with the Income Statements for two of its product lines for the year ended December 31. The Controller has asked you to perform the vertical analysis of the product lines and compare the two products. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.

Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, =B9 was entered, the formula would output the result from cell B9, or $3,150,000 in this example.

Please give the exact formula used for each cell. Thank you!