Type the following formula into any Excel cell. This is the percentage of money that the company makes from selling goods or services after subtracting the costs of producing them. One can find a Gross profit figure on the firms profit and loss statement and the same can also be calculated by subtracting the COGS that is the cost of goods sold from sales or revenue.
This is called the gross profit.
If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of. Firstly note the total sales of the company which is easily available as a line item in the income statement. This percentage shows the amount of revenue that. Limitation of the calculated.