Calculating Operating Profit Margin in Excel

Operating profit margin shows the ratio of operating profit to sales revenue. To calculate operating profit margin open your income statement and divide operating profit with revenue