Ratio Analysis Tutorials
 Ratio Analysis of Financial Statements (Formula, Types, Excel)
 Ratio Analysis
 Liquidity Ratios
 Turnover Ratios
 Profitability Ratios
 Profit Margin
 Gross Profit Margin Formula
 Operating Profit Margin Formula
 Net Profit Margin Formula
 EBIDTA Margin
 Earnings Per Share
 Basic EPS
 Diluted EPS
 Basic EPS vs Diluted EPS
 Return on Equity (ROE)
 Return on Capital Employed (ROCE)
 Return on Invested Capital (ROIC)
 Return on Total Assets (ROA)
 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
 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
 Capacity Utilization Rate Formula
 Total Expense Ratio Formula
 Efficiency Ratios
 Dividend Ratios
 Debt Ratios
 Debt to Equity Ratio
 Debt Coverage Ratio
 Debt Ratio
 Debt to Income Ratio Formula (DTI)
 Capital Gearing Ratio
 Capitalization Ratio
 Interest Coverage Ratio
 Times Interest Earned Ratio
 Debt Service Coverage Ratio (DSCR)
 Financial Leverage Ratio
 Net Debt Formula
 Leverage Ratios
 Operating Leverage vs Financial Leverage
 Current Yield
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 –
 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.
You can download this net profit margin ratio template here – Net Profit Margin Excel Template
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.
 Income Statement Template
 Balance Sheet vs Income Statement
 Profit Margin
 Dupont ROE vs ROE
 Return on Total Assets Ratio
Leave a Reply