How to Get Gross Margin in Excel. Gross margin constitutes the percent of sales that is applied to profit. As an example, if you had a 50 percent gross margin, half of the sale is profit; the ...

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.

How to Calculate Contribution Margin in a Camera Company Using Income Statements. When operating a camera business it is important to know how much of your sales actually contributes to your profit.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.