Calculating Return on Sales in Excel

Return on sales indicates how much net profit an entity makes after paying for variable costs of production such as wages, raw materials, advertising etc. To calculate return on sales open your income statement and divide profit before tax with revenue