Financial Statement Analysis
 Profitability Ratios
 Profitability Ratios Formula
 Common Size Income Statement
 Vertical Analysis of Income Statement
 Profit Margin
 Profit Margin Formula
 Profit Percentage Formula
 Profit Formula
 Gross Profit Margin Formula
 Gross Profit Percentage
 Operating Profit Margin Formula
 EBIT Margin Formula
 Operating Income Formula
 Net Profit Margin Formula
 EBITDA Margin
 Degree of Operating Leverage Formula (DOL)
 NOPAT Formula
 OIBDA
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Equity Ratio
 Return on Capital Employed (ROCE)
 ROCE Formula (Return on Capital Employed)
 Return on Invested Capital (ROIC)
 Return On Investment (ROI)
 Rate of Return on Investment
 Return on Sales
 ROIC Formula (Return on Invested Capital)
 Return on Investment Formula (ROI)
 ROIC vs ROCE
 ROE vs ROA
 CFROI
 Cash on Cash Return
 Return on Total Assets (ROA)
 Return on Total Assets Formula
 Return on Average Capital Employed
 Capital employed Employed
 Return on Average Assets (ROAA)
 Return on Average Equity (ROAE)
 Return on Assets Formula
 Return on Equity Formula
 DuPont Formula
 Net Interest Margin Formula
 Earnings Per Share Formula
 Diluted EPS Formula
 Contribution Margin Formula
 Unit Contribution Margin
 Revenue Per Employee Ratio
 Operating Leverage
 EBIT vs EBITDA
 EBITDAR
 Capital Gains Yield
 Tax Equivalent Yield
 LTM Revenue
 Operating Expense Ratio Formula
 Overhead Ratio Formula
 Variable Costing Formula
 Capitalization Rate
 Cap Rate Formula
 Comparative Income Statement
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Markup
 Markup Percentage Formula
 Ratio Analysis (17+)
 Liquidity Ratios (29+)
 Turnover Ratios (17+)
 Efficiency Ratios (7+)
 Dividend Ratios (9+)
 Debt Ratios (26+)
Related Courses
Net Profit Margin Formula
Net profit margin Formula is a significant profitability ratio. Every investor uses net profit margin ratio to find out how much percentage of net profit a company has earned at the end of the year.
Let’s have a look at the net profit margin formula.
Example of Net Profit Margin Formula
Let’s take a Net profit margin example to illustrate this.
Uno Company has the following information –
4.9 (1,067 ratings)
 Gross Sales – $250,000
 Sales Return – $5000
 Net Profit for the year – $30,000
Find out the net margin of Uno Company.
 We know the gross sales, i.e. $250,000.
 The sales return is $5000.
 The net sales is = (Gross Sales – Sales Return) = ($250,000 – $5000) = $245,000.
 The net profit is also given, i.e. $30,000.
Using the formula of net margin, we get –
 Net Margin Formula = Net Profit / Net Sales * 100
 Or, Net Margin = $30,000 / $245,000 * 100 = 12.25%.
From the net profit margin example, we can find that the net margin of Uno Company is 12.25%. If we compare this net margin with the net margin of companies under similar industry, we will be able to make an interpretation about whether the net margin of Uno Company is good enough.
Recommended Courses
Net Profit Margin of Colgate
Below is the snapshot of Colgate’s Income Statement from 2007 to 2015.
 Net margin is calculated for Colgate by dividing Net Profit by Sales.
 We note that Net Margin for Colgate has been in the range of 12.5% – 15%.
 However, it decreased substantially in 2015 to 8.6% primarily due to CP Venezuela Accounting changes.
Explanation of Net Profit Margin Formula
In the Net Profit Margin ratio formula, we have taken “net profit” as numerator because we want to focus on “net profit”. And we are dividing “net profit” by “net sales” because we are finding the proportion of “net profit” to “net sales”
For example, if we have a net profit of $10 and the net sales are $100; then the net margin would be = ($10 / $100 * 100) = 10%.
 To find out the “net profit”, every investor needs to look at the income statement of a company. At the end of the income statement, the investor will find the “net profit”.
 And to find the “net sales”, you also need to look at the income statement. To find out the “net sales”, we need to deduct any sales discount or sales return from the gross sales.
Use of Net Profit Margin Formula
 By using the net margin formula, the investors are able to understand how much a firm has been profiting from its revenue.
 If the proportion of net profit is less compared to the net sales of the company, then the investors would enquire why it is so and may find other important details about the company.
 Similarly, if the net margin is too much, then also the investors need to see through other details to find out why the net margin is too good to be true.
 Plus if they know the net margin formula, it also tells them how much net profit a firm can extract out of their net revenue.
 However, if the investors think that the net profit would increase proportionately along with the net sales, the idea is false; because there can be expenses that are longterm and will serve the company for the long period of time and as a result, maybe the net profit would shrink. That’s why it is important to look at all of the figures before ever judging the performance of a company only through net profit margin formula.
Net Profit Margin Calculator
You can use the following Net Profit Margin Calculator.
Net Profit  
Net Sales  
Net Profit Margin Formula =  
Net Profit Margin Formula == 



Net Profit Margin Formula in Excel (with excel template)
Let us now do the same example of Net Profit Margin formula in Excel. This is very simple. You need to provide the two inputs of Net Profit and Net Sales.
You can easily calculate the Net Profit margin ratio in the template provided.
Net Profit Margin – Video
Recommended Articles –
This has been a guide to Net Profit Margin formula, its uses along with Net Profit Margin example. Here we also provide you with Net Profit Margin Calculator with downloadable excel template. Learn more from the following articles –