Gross Profit Percentage Total Sales Cost of Sale Total Sales 100. Profit Margin Formula in Excel calculation 120200100 to produce a 60 percent profit margin result. Revenue Cost Gross profit Revenue refers to the amount of money you generated when a client customer or other consumer purchased your product or service from you for.
I am trying to enter cost and sell price and the outcome be the gross profit percentage I am making.
Here is the overall picture of these two concepts. The formula I am entering sum A1B1-1 is giving me a negative -3333. Gross Profit Percentage Total Sales Cost of Sale Total Sales 100. Gross profit is equal to net sales minus cost of goods sold.