Margin Calculator
Calculate profit margin, markup, and selling price for your products or services. Understand the relationship between cost, revenue, and profit to make informed pricing decisions.
Enter cost and selling price to calculate your profit margin:
Enter cost and desired margin to calculate selling price:
Enter selling price and margin to find maximum cost:
Price Breakdown
Visual representation of cost vs profit in selling price
Quick Margin Reference
Understanding Profit Margin: A Complete Guide
Profit margin is one of the most important financial metrics for any business. It tells you how much of each dollar in sales your company actually keeps as profit after accounting for costs. Understanding and optimizing your profit margins is essential for business success and long-term sustainability.
What is Profit Margin?
Profit margin is the percentage of revenue that remains as profit after subtracting costs. It's calculated by dividing profit by revenue and multiplying by 100. There are several types of profit margins:
- Gross Profit Margin: Revenue minus cost of goods sold (COGS), divided by revenue
- Operating Profit Margin: Operating income divided by revenue
- Net Profit Margin: Net income (after all expenses, taxes, and interest) divided by revenue
Margin Formulas
Margin (%) = ((Selling Price - Cost) / Selling Price) x 100
Profit Amount:
Profit = Selling Price - Cost
Selling Price from Margin:
Selling Price = Cost / (1 - Margin%)
Cost from Margin:
Cost = Selling Price x (1 - Margin%)
Margin vs. Markup: Understanding the Difference
One of the most common confusions in business is between margin and markup. While related, they are different calculations:
| Concept | Margin | Markup |
|---|---|---|
| Base | Percentage of selling price | Percentage of cost |
| Formula | (Price - Cost) / Price | (Price - Cost) / Cost |
| Example: $30 profit on $100 sale | 30% margin | 42.86% markup |
| Maximum Value | Less than 100% | Unlimited |
| Used For | Financial reporting, investors | Pricing decisions, retail |
Conversion Example
If you have a product that costs $70 and sells for $100:
- Profit: $100 - $70 = $30
- Margin: $30 / $100 = 30%
- Markup: $30 / $70 = 42.86%
Converting Between Margin and Markup
Markup = Margin / (1 - Margin)
Markup to Margin:
Margin = Markup / (1 + Markup)
Example: 30% margin
Markup = 0.30 / (1 - 0.30) = 0.30 / 0.70 = 42.86%
Common Margin/Markup Equivalents
| Margin | Markup | Multiplier |
|---|---|---|
| 10% | 11.11% | 1.111x |
| 15% | 17.65% | 1.176x |
| 20% | 25% | 1.25x |
| 25% | 33.33% | 1.333x |
| 30% | 42.86% | 1.429x |
| 33.33% | 50% | 1.5x |
| 40% | 66.67% | 1.667x |
| 50% | 100% | 2x |
What is a Good Profit Margin?
Good profit margins vary significantly by industry. Here are some general benchmarks:
- 5% Net Margin: Generally considered low, but acceptable in high-volume, low-margin industries like grocery retail
- 10% Net Margin: Considered okay for most businesses
- 20%+ Net Margin: Considered excellent and indicates a healthy, profitable business
Industry Benchmarks
| Industry | Typical Gross Margin | Typical Net Margin |
|---|---|---|
| Software/SaaS | 70-90% | 15-25% |
| Financial Services | 60-80% | 15-30% |
| Healthcare | 50-70% | 10-20% |
| Retail - Apparel | 40-60% | 5-15% |
| Manufacturing | 25-40% | 5-10% |
| Grocery Retail | 20-30% | 1-3% |
| Restaurants | 60-70% | 3-9% |
How to Improve Profit Margins
- Increase Prices: If market conditions allow, even small price increases can significantly impact margins
- Reduce Costs: Negotiate with suppliers, optimize operations, reduce waste
- Improve Product Mix: Focus on selling higher-margin products or services
- Increase Volume: Spread fixed costs over more units to reduce per-unit costs
- Add Value: Bundle products or add services to justify higher prices
- Reduce Discounting: Minimize unnecessary promotions and discounts
Calculating Margin in Excel
Profit: =B1-A1
Margin %: =(B1-A1)/B1*100
Markup %: =(B1-A1)/A1*100
To calculate selling price from cost and margin:
=A1/(1-margin/100)
Frequently Asked Questions
Q: Can profit margin exceed 100%?
No. Since margin is calculated as profit divided by selling price, and profit is always less than selling price (assuming positive cost), margin is always less than 100%. However, markup can exceed 100% - for example, selling something at twice its cost is a 100% markup but only a 50% margin.
Q: What's the difference between gross and net margin?
Gross margin only considers the direct cost of goods sold (COGS), while net margin accounts for all expenses including operating costs, taxes, interest, and overhead. Net margin is always lower than gross margin.
Q: How do I calculate the selling price for a 20% margin?
Divide the cost by (1 - 0.20) = 0.80. For example, if cost is $80: Selling Price = $80 / 0.80 = $100.
Q: Is higher margin always better?
Not necessarily. Higher margins may mean fewer sales if prices are too high. The optimal strategy balances margin with volume to maximize total profit. Some successful businesses operate on very low margins but high volumes (like Walmart or Amazon).