Solve the following with steps :

1. calculate the profit margin in cell E5 and apply the formula to entire column E.

2. Calculate the % of return in cell H5 and apply the formula to entire column H.

3. apply condition to Market Award is given to a group that has a Profit Margin of 50% or more for $300,000 land if be less $1.10 for each 2017 Return.

4. An Market Audit will be scheduled if Profit Margin is less than 45%. Showing that by "YES".

5. Apply the A Market Allowance based on the Performance Score. The rebate is the amount found in the table in columns O and P and is for each 2017 Package.

6. Returns Clawback is charged to a Market manager for excessive returns. The clawback is $1.20 for each 2017 Return up to 15,000 units and $2.54 for each 2017 Return that is in excess of (more than) 15,000.

7. Apply a Conditional Format in cells E5 to E9 - Shade cell Red if margin is less than 40%, Yellow if it is between 40% and 50% and Green if it is more than 50%.