​
Task

In Part 2 of this exercise, we’ll work with the output from Part 1. If you’re up for it, save the table from Part 1 as a table with the Output action and input it in a new model.

The objective is to create a table identical to the one below. It showing each year as a row with a Gross Profit Margin and an Operating Profit Margin.

We did it in 20 new actions. You might want to take a look at the Transpose and Compare action.

​
Metric Definitions

These are the definitions for the metrics you will create.

  • Gross Profit Margin: ((sales - cost of sales)/sales)*100
  • Operating Profit Margin: (EBIT/sales)*100

​
Hints

​
Solution File

Download the solution file for the task here. See how to import it below. Remember to import it in a new model.