How to calculate profit margin

Profit margin shows how much of your revenue you keep as profit after covering costs. Calculating profit margin helps you understand pricing, cost control, and overall business performance. Once you know your margin, you can compare results across time, benchmark against peers, and spot where profitability is slipping.

What is profit margin?

Profit margin is the percentage of your revenue that remains after subtracting costs. It shows how efficiently you turn sales into profit and is a core metric for pricing, planning, and performance tracking.

You track profit margins to:

• Compare performance over time
• Benchmark against competitors
• Identify where cost control or pricing improvements are needed

Tracking margin consistently helps you catch problems early, whether that's rising input costs, pricing that hasn't kept up with inflation, or operating expenses growing faster than revenue.

Profit margin formula

The core profit margin formula divides your profit by revenue and converts the result into a percentage:

Profit margin (%) = (Net income / Revenue) * 100

Here's how to calculate it step by step:

1. Find your total revenue for the period you want to measure
2. Subtract all expenses (COGS, operating expenses, interest, and taxes) to get net income
3. Divide net income by revenue to get a decimal
4. Multiply by 100 to convert the decimal to a percentage

For example, say your business generates $500,000 in revenue and has $450,000 in total expenses:

• Net income = $500,000 – $450,000 = $50,000
• Profit margin = ($50,000 / $500,000) * 100 = 10%

That means you keep 10 cents of every dollar in revenue as profit.

Types of profit margins

There are different ways to calculate profit margin depending on which costs you include. Each type answers a different question about your profitability.

Gross profit margin

Gross profit margin measures how much of your revenue remains after subtracting the cost of goods sold (COGS), such as materials and direct labor. It shows how efficiently you produce or deliver your product or service.

Gross profit margin = (Revenue – COGS) / Revenue * 100

Use gross profit margin to evaluate pricing, sourcing, and production efficiency before accounting for overhead or administrative costs. If your revenue is $500,000 and COGS is $300,000, your gross profit margin is 40%.

Operating profit margin

Operating profit margin goes a step further by subtracting operating expenses, such as salaries, rent, and marketing, from gross profit. It reflects how well you manage day-to-day business costs but excludes interest and taxes.

Operating profit margin = Operating income / Revenue * 100

Service-based businesses often report stronger operating margins, while capital-intensive industries like manufacturing and logistics tend to operate with tighter margins due to higher overhead.

Net profit margin

Net profit margin is the bottom-line profitability metric. It shows what you keep after every expense, including COGS, operating costs, interest, taxes, and one-time charges.

Net profit margin = Net income / Revenue * 100

Because it captures every cost, net profit margin is the most comprehensive view of how profitable your business actually is.

What is the difference between margin and markup?

Margin and markup describe the same dollar of profit but from different angles. Margin is profit as a percentage of the selling price, while markup is profit as a percentage of cost. Confusing the two leads to pricing mistakes.

Take a product that costs you $60 to make and sells for $100:

• Margin = ($100 – $60) / $100 * 100 = 40%
• Markup = ($100 – $60) / $60 * 100 = 66.7%

Same $40 in profit, two very different percentages. Markup always looks larger because it's calculated against a smaller base.

When to use margin

Use margin for financial reporting, comparing profitability across products or time periods, and analyzing how much of each sale becomes profit. It's the right metric when you're evaluating overall business performance.

When to use markup

Use markup when you're setting prices. It's the practical lever for figuring out what to charge based on your cost and the profit you want to earn on each unit sold.

What is a good profit margin?

A good profit margin depends on your industry, business model, and growth stage. Comparing your margin to a generic benchmark can be misleading. The better question is whether your margin is improving over time and how it stacks up against peers in your sector—which you can assess through a profitability analysis.

Good profit margins by industry

Service businesses typically post higher margins than retail or manufacturing because their direct costs are lower. Asset-heavy industries with significant inventory or equipment costs usually run leaner. Here's a general sense of how margins tend to compare across sectors:

• Software and SaaS: Generally higher margins, since the cost to deliver each additional unit is low
• Professional services and consulting: Higher margins driven by labor rather than physical inputs
• Retail and e-commerce: Lower margins due to inventory, fulfillment, and competitive pricing pressure
• Manufacturing: Lower margins reflecting higher capital and labor costs
• Grocery and food service: Among the thinnest margins because of high competition and low-cost inputs

Benchmark against averages relevant to your sector rather than chasing a universal number. A 10% margin can be excellent in one industry and concerning in another.

How to calculate profit margin percentage in Excel

Excel makes it easy to calculate margin once you know the formula. The basic formula is:

=(Revenue Cell – Cost Cell) / Revenue Cell

Then format the cell as a percentage. Here's how to build a simple margin calculator in four steps:

1. Step 1: Enter your revenue in one cell (for example, B2)
2. Step 2: Enter your total costs in another cell (for example, B3)
3. Step 3: In a third cell, enter the formula
4. Step 4: Format that cell as a percentage

From there, you can link the spreadsheet to accounting exports so revenue and expense data update automatically. That keeps margin calculations accurate as the numbers change.

How to improve your profit margin

Calculating margin is just the starting point. Improving it comes from a mix of better data, smarter pricing, and tighter cost control, not blanket cost cutting.

1. Track income and expenses consistently

You can't improve what you don't measure. Consistent expense tracking is the foundation for any margin improvement effort because it shows you exactly where revenue is going.

Inconsistent categorization, missing receipts, and delayed reporting all distort your margin numbers. Clean, current data lets you spot cost creep before it eats into profitability.

2. Automate financial processes

Manual processes waste time and introduce errors that compound over the course of a year. Automating expense categorization, receipt collection, and accounting workflows frees your finance team to focus on analysis instead of data entry.

Automation also gives you faster visibility into spending. When transactions are coded in real time, you don't have to wait until month-end close to see how margins are trending.

3. Reduce operating costs

Review recurring expenses regularly to find savings that don't hurt output. Renegotiating supplier contracts, eliminating redundant software, and consolidating tools can all trim overhead.

Pay close attention to underused subscriptions and shadow IT spending. These quietly drain margins without anyone noticing until you do a full audit.

4. Optimize your pricing strategy

Use margin calculations to make sure your pricing covers costs and delivers the profitability you need. If you have a target margin in mind, you can reverse-engineer the right price using this formula:

Price = Cost / (1 – Target margin)

For example, if a product costs $60 and you want a 40% margin, divide $60 by 0.60 to get a selling price of $100. Test price changes gradually to balance margin gains against any impact on demand.

Track profit margins in real time with Ramp's automated expense categorization and reporting

Calculating profit margins accurately requires clean expense data, but manual categorization and scattered receipts create opportunities for error. Ramp's accounting automation software eliminates the guesswork by coding every transaction automatically, collecting receipts in real time, and syncing everything to your ERP so you always know where your money goes.

Ramp's AI learns your chart of accounts and applies the right GL codes, departments, classes, and locations to every expense as it posts. You get complete visibility into cost centers and spending patterns without chasing down receipts or fixing miscoded transactions after the fact. When expenses land in the right categories from day one, you can calculate margins with confidence and spot trends before they impact profitability.

Here's how Ramp helps you track and improve margins:

• AI-powered coding: Ramp codes transactions across all required fields in real time, so expenses are categorized correctly and margins reflect actual costs
• Automated receipt collection: Ramp texts employees for missing receipts and matches them to transactions automatically, eliminating the manual work that slows down reporting
• Real-time spend visibility: Track expenses by department, project, or cost center as they happen, so you can identify margin erosion early and adjust spending before it's too late
• Seamless ERP sync: Ramp syncs coded transactions to your accounting system automatically, so financial reports are always current and margin calculations are based on complete data

Try a demo to see how Ramp gives you the clean expense data you need to calculate and improve profit margins.