Markup Calculator
Markup Calculator
Profit, Margin & Selling Price
Markup vs. Margin: This is a common point of confusion in retail. Markup is the percentage of profit added to the Cost. Margin is the percentage of profit in the final Selling Price.
For example, if you buy an item for $50 and sell it for $100, your profit is $50.
Your Markup is 100% ($50 profit / $50 cost), but your Margin is 50% ($50 profit / $100 price).
Formulas: Markup = (Profit / Cost) × 100. Margin = (Profit / Revenue) × 100.
Pricing a product involves more than adding a few dollars to its cost. A business needs to understand how much it earns on each sale, whether its prices cover operating expenses, and how its pricing compares with competitors. A markup calculator simplifies this process by calculating the selling price from the cost and desired markup percentage.
Whether you run a retail store, sell products online, offer professional services, or manage wholesale inventory, a markup calculator can help you make consistent pricing decisions. It can also help you work backward from an existing selling price to determine the markup you are earning.
What Is a Markup Calculator?
A markup calculator is a pricing tool that calculates how much to add to a product or service's cost to establish a selling price. It expresses the difference between cost and selling price as a percentage of cost.
For example, suppose a product costs ₹800 and you want to apply a 25% markup. The markup amount is ₹200, making the selling price ₹1,000 before applicable taxes.
The calculator can help you determine:
- Markup amount: The monetary amount added to the original cost.
- Selling price: The price charged to the customer before applicable sales taxes.
- Profit per unit: The difference between selling price and the cost included in the calculation.
- Markup percentage: The markup amount expressed as a percentage of cost.
- Profit margin: Profit expressed as a percentage of the selling price.
These results are useful for evaluating prices, planning promotions, and maintaining consistent pricing across a product range.
Markup Calculator Formula
The standard markup formula compares the difference between selling price and cost price with the original cost.
1. Markup amount
2. Markup percentage\\text{Markup %}= \\frac{\\text{Selling Price}-\\text{Cost Price}} {\\text{Cost Price}}\\times100
3. Selling price from cost and markup\\text{Selling Price}= \\text{Cost Price}\\times \\left(1+\\frac{\\text{Markup %}}{100}\\right)
4. Cost price from selling price and markup\\text{Cost Price}= \\frac{\\text{Selling Price}} {1+\\frac{\\text{Markup %}}{100}}
The formulas work with any currency. You can use rupees, dollars, pounds, euros, or another currency as long as the cost and selling price use the same currency.
How to Calculate Markup
Suppose a retailer purchases a product for ₹1,200 and plans to sell it for ₹1,500.
First, calculate the markup amount:
Next, divide the markup by the cost price and multiply by 100:
The retailer's markup is 25%, and the gross profit before other expenses is ₹300 per unit.
| Item | Amount |
|---|---|
| Cost price | ₹1,200 |
| Selling price | ₹1,500 |
| Markup amount | ₹300 |
| Markup percentage | 25% |
| Gross profit per unit before other expenses | ₹300 |
Notice that the 25% is calculated on the ₹1,200 cost, not on the ₹1,500 selling price. That distinction is important when setting prices and evaluating profitability.
Markup vs. Profit Margin: What Is the Difference?
Markup and profit margin both describe the relationship between cost, selling price, and profit. However, they use different reference amounts.
- Markup measures profit relative to cost.
- Profit margin measures profit relative to selling price.
Consider a product that costs ₹100 and sells for ₹150. Its profit is ₹50.
The markup is:
The profit margin is:
The product therefore has a 50% markup but a 33.33% gross profit margin. Both figures are correct; they simply answer different questions.
Markup and margin comparison table
| Markup | Equivalent profit margin |
|---|---|
| 10% | 9.09% |
| 20% | 16.67% |
| 25% | 20.00% |
| 30% | 23.08% |
| 40% | 28.57% |
| 50% | 33.33% |
| 75% | 42.86% |
| 100% | 50.00% |
| 150% | 60.00% |
| 200% | 66.67% |
To convert markup to margin:\\text{Margin %}= \\frac{\\text{Markup %}}{100+\\text{Markup %}}\\times100
To calculate the markup needed to achieve a target margin:\\text{Markup %}= \\frac{\\text{Margin %}}{100-\\text{Margin %}}\\times100
For instance, if you want a 40% margin, you need a markup of approximately 66.67%. Simply adding 40% to the cost would not achieve that margin.
How to Set a Selling Price for a Target Profit Margin
Sometimes a business has a target profit margin rather than a target markup. In that situation, use a different formula.\\text{Selling Price}= \\frac{\\text{Cost Price}} {1-\\frac{\\text{Target Margin %}}{100}}
Suppose a product costs ₹600 and you want a 40% gross profit margin.
The required selling price is ₹1,000, producing ₹400 in gross profit and a 40% margin.
If you instead added a 40% markup, the selling price would be ₹840. That would generate ₹240 in gross profit and a margin of approximately 28.57%, not 40%.
This difference matters whenever your business plans prices around a required margin, revenue target, or profitability benchmark.
What is a good markup percentage?
There is no universal ideal markup. It depends on the industry, product category, operating expenses, sales volume, competition, and customer expectations. A suitable markup should support the business's margin goals while keeping the price competitive.
How do I calculate a 20% markup?
Multiply the cost price by 1.20. For example, a product costing ₹500 would have a selling price of ₹600 at a 20% markup. The markup amount is ₹100.
Is a 50% markup the same as a 50% profit margin?
No. A 50% markup means the profit is half the cost. A 50% profit margin means the profit is half the selling price. A 50% markup corresponds to a 33.33% margin, while a 50% margin requires a 100% markup.
Can markup be greater than 100%?
Yes. If a product costs ₹100 and sells for ₹250, the markup is 150%. The gross profit is ₹150 per unit. Markup can exceed 100% because it is calculated as a percentage of cost.
Can markup be negative?
Yes. If the selling price is below cost, the calculation produces a negative markup, indicating a loss relative to the cost used. For example, selling a ₹500 item for ₹450 results in a markup of −10%.
Should I include shipping and labour in the cost price?
Include them when they are relevant to the pricing decision. For a more realistic product price, businesses often consider the purchase cost plus directly attributable expenses such as inbound freight, production labour, and packaging. Ongoing overhead and selling expenses may require a separate allowance.
How is markup calculated in Excel?
If cell A2 contains the cost price and B2 contains the selling price, use:
=(B2-A2)/A2*100
To calculate a selling price from a cost in A2 and a markup percentage in B2, use:
=A2*(1+B2/100)
Make sure the cells contain numeric values and that the cost is greater than zero when calculating markup percentage.
Does a higher markup always mean higher profit?
Not necessarily. A higher markup increases the amount earned per unit before other expenses, assuming the cost remains unchanged and the item sells at that price. However, a higher price may reduce demand or sales volume. Total profit depends on units sold and all relevant expenses.