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.

Total margin ratio is found by dividing net income by total revenue, then multiplying by 100. This ratio aids investors in assessing a company's profitability from its total revenues. Using this ...

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