1. Projected Financial Information: Compute the projected sales, cost of products sold, gross profit, and gross margin (gross profit as a percentage of sales) of each firm for Year +1 through Year +5. Using the table below or a similar spreadsheet is recommended.

C. Projected Financial Information: Compute the projected sales, cost of products sold, gross profit, and gross margin (gross profit as a percentage of sales) of each firm for Year +1 through Year +5. Using the table below or a similar spreadsheet is recommended. Year +1 Year +2 Year +5 Year +3 4042 Year +4 5217 AK Steel Sales Less Cost of Product Sold: Variable Cost (0.568 of Sales) Fixed Costs Total Costs of Products Sold Gross Profit Gross Margin % 3887 155 4554 663 12.7 3.8 Nucor Year +1 Year +2 Year +5 Year +3 6266 Year +4 11377 Sales Less Cost of Product Sold: Variable Cost (0.613 of Sales) Fixed Costs Total Costs of Products Sold Gross Profit Gross Margin % 5997 239 4.3 9129 2248 19.8 D. Gross Margin Comparison: In one to two paragraphs, explain why the levels and variability of the gross margin percentages differ for these two firms for Year +1 through Year +5. Provide an example comparing the effect of the change in gross margin. (For example, if gross margin changed from 25% to 35%, what would it mean for each company?)