Calculating Net Profit Margin in Excel

Net profit margin shows the ratio of net profit to sales revenue. To calculate net profit margin open your income statement and divide net profit after tax with revenue