Net Profit Margin Template
This Net Profit Margin template will show you how to calculate the net profit margin using a company’s income statement line items.
Here is a screenshot of the template:

Download the Free Template
Enter your name and email in the form below and download the free template now!
What is Net Profit Margin?
Net Profit Margin (also known as “Profit Margin” or “Net Profit Margin Ratio”) is a financial ratioFinancial RatiosFinancial ratios are created with the use of numerical values taken from financial statements to gain meaningful information about a company. The numbers found on a company’s financial statements – balance sheet, income statement, and cash flow statement are used to perform quantitative analysis and assess a company's liquidity, leverage, growth used to calculate the percentage of profit a company produces from its total revenue. It measures the amount of net profit a company obtains per dollar of revenue gained. The net profit margin is equal to net profit (also known as net income)Net IncomeNet Income is a key line item, not only in the income statement, but in all three core financial statements. While it is arrived at through the income statement, the net profit is also used in both the balance sheet and the cash flow statement. divided by total revenueSales RevenueSales revenue is the income received by a company from its sales of goods or the provision of services. In accounting, the terms "sales" and "revenue" can be, and often are, used interchangeably, to mean the same thing. Revenue does not necessarily mean cash received., expressed as a percentage.
Net Profit Margin Formula
Net Profit margin = Net Profit ⁄ Total revenue x 100
Net profitNet IncomeNet Income is a key line item, not only in the income statement, but in all three core financial statements. While it is arrived at through the income statement, the net profit is also used in both the balance sheet and the cash flow statement. is calculated by deducting all company expenses from its total revenue. The result of the profit margin calculation is a percentage – for example, a 10% profit marginProfit MarginIn accounting and finance, profit margin is a measure of a company's earnings relative to its revenue. The three main profit margin metrics are gross profit (total revenue minus cost of goods sold (COGS) ), operating profit (revenue minus COGS and operating expenses), and net profit (revenue minus all expenses) means for each $1 of revenue the company earns $0.10 in net profit. Revenue represents the total sales of the company in a period.
More Free Templates
For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation and Word document templates.
- Excel Modeling TemplatesExcel & Financial Model TemplatesDownload free financial model templates - CFI's spreadsheet library includes a 3 statement financial model template, DCF model, debt schedule, depreciation schedule, capital expenditures, interest, budgets, expenses, forecasting, charts, graphs, timetables, valuation, comparable company analysis, more Excel templates
- PowerPoint Presentation Templates
- Transaction Document TemplatesTemplatesFree business templates to use in your personal or professional life. Templates include Excel, Word, and PowerPoint. These can be used for transactions, legal, financial modeling, financial analysis, business planning and business analysis.