How to Find the Gross Margin in Excel. The term "gross margin" describes the profit achieved on sales, expressed as a percentage of the total revenue generated by the sales. Gross margin omits ...

The difference is your overall profit, in this example the formula result would be $17. Input a formula in the final column to calculate the profit margin on the sale.

Find out more about the forward price to earnings ratio and how to calculate the forward price to earnings ratios of companies in Microsoft Excel.

Profit margins vary by industry and should only be compared to those of similar companies. You can use computer software, such as Microsoft Excel, to quickly calculate profit margins.