Calculate gross profit, net profit margin, markup percentage, and GST-adjusted profit in rupees. Includes Excel formulas, break-even calculator, bulk pricing tool, and industry benchmark margins for India.
Enter cost price and selling price in rupees. Get profit amount, gross margin %, markup %, and GST-adjusted figures instantly.
For every cost price, the selling price needed to achieve different profit margins and corresponding markup percentages. A quick reference for pricing decisions.
| Cost Price | 10% Margin SP | Markup |
20% Margin SP | Markup |
30% Margin SP | Markup |
40% Margin SP | Markup |
50% Margin SP | Markup |
|---|---|---|---|---|---|
| ₹100 | ₹111 | 11.1% | ₹125 | 25% | ₹143 | 42.9% | ₹167 | 66.7% | ₹200 | 100% |
| ₹250 | ₹278 | 11.1% | ₹313 | 25% | ₹357 | 42.9% | ₹417 | 66.7% | ₹500 | 100% |
| ₹500 | ₹556 | 11.1% | ₹625 | 25% | ₹714 | 42.9% | ₹833 | 66.7% | ₹1,000 | 100% |
| ₹800 | ₹889 | 11.1% | ₹1,000 | 25% | ₹1,143 | 42.9% | ₹1,333 | 66.7% | ₹1,600 | 100% |
| ₹1,000 | ₹1,111 | 11.1% | ₹1,250 | 25% | ₹1,429 | 42.9% | ₹1,667 | 66.7% | ₹2,000 | 100% |
| ₹2,000 | ₹2,222 | 11.1% | ₹2,500 | 25% | ₹2,857 | 42.9% | ₹3,333 | 66.7% | ₹4,000 | 100% |
| ₹5,000 | ₹5,556 | 11.1% | ₹6,250 | 25% | ₹7,143 | 42.9% | ₹8,333 | 66.7% | ₹10,000 | 100% |
| ₹10,000 | ₹11,111 | 11.1% | ₹12,500 | 25% | ₹14,286 | 42.9% | ₹16,667 | 66.7% | ₹20,000 | 100% |
| ₹50,000 | ₹55,556 | 11.1% | ₹62,500 | 25% | ₹71,429 | 42.9% | ₹83,333 | 66.7% | ₹100,000 | 100% |
| ₹100,000 | ₹111,111 | 11.1% | ₹125,000 | 25% | ₹142,857 | 42.9% | ₹166,667 | 66.7% | ₹200,000 | 100% |
Orange = Selling Price | Green = Markup % on cost. Key insight: 30% margin requires 42.9% markup, not 30% markup. If you mark up by 30% on cost, your margin is only 23.1%, not 30%. This confusion causes businesses to underprice. Formula: SP = Cost / (1 - Margin%). Markup = Margin / (1 - Margin%). Always verify whether a quoted "30%" is margin (on SP) or markup (on cost) before using it for pricing decisions.
If your selling price includes GST, your actual revenue is lower. This table shows net revenue, real profit, and true margin after removing GST at each slab for ₹1,000 MRP.
| GST Slab | MRP (incl. GST) | GST Amount | Net Revenue to you |
If Cost = ₹600 True Profit |
True Margin on Net Rev. |
Apparent Margin on MRP (wrong) |
|---|---|---|---|---|---|---|
| Exempt (0%) | ₹1,000 | ₹0.00 | ₹1,000.00 | ₹400.00 | 40% | 40% (misleading) |
| 5% GST | ₹1,000 | ₹47.62 | ₹952.38 | ₹352.38 | 37% | 40% (misleading) |
| 12% GST | ₹1,000 | ₹107.14 | ₹892.86 | ₹292.86 | 32.8% | 40% (misleading) |
| 18% GST | ₹1,000 | ₹152.54 | ₹847.46 | ₹247.46 | 29.2% | 40% (misleading) |
| 28% GST | ₹1,000 | ₹218.75 | ₹781.25 | ₹181.25 | 23.2% | 40% (misleading) |
MRP = ₹1,000 includes GST. Cost = ₹600. "Apparent margin" (40%) is misleading because it treats collected GST as your income — it is not. GST belongs to the government. True margin is always on net revenue (ex-GST). At 28% GST: Net revenue = ₹781 on ₹1,000 MRP. True profit = ₹181. True margin = 23.2% — not 40%. Always use net revenue (ex-GST) as the denominator for all profit margin calculations. Excel formula: =Net_Revenue/(1+GST_Rate) to get ex-GST revenue.
Copy these Excel formulas directly. Assumes: A = Cost Price, B = Selling Price, C = GST Rate (as decimal like 0.18).
Excel tip: Use conditional formatting to highlight negative margins in red. Formula for conditional formatting rule: =(B2-A2)/B2 < 0. Apply red fill colour. For a full P&L dashboard in Excel: Column A = Cost, B = Revenue, C = Operating Expenses, D = GST Rate, E = Fixed Costs. Derive all margin and profit metrics from these 5 inputs using the formulas above. Use SUMIF for category-wise margin analysis across multiple products.
Typical net profit margin ranges by industry. Compare your business margin against industry benchmarks to identify improvement areas.
These are net profit margins (after all expenses including tax). Gross margins are significantly higher — FMCG gross margins are 30-50% but net margins are 5-15% after distribution, marketing, and admin costs. Software/SaaS has the highest margins because incremental cost of serving one more customer is near zero. E-commerce in India still struggles with profitability due to heavy discounting, logistics costs, and customer acquisition expenses. Compare your gross margin first (before overheads) and then track net margin improvement as you scale.
Most businesses focus on revenue. Smart businesses focus on margin. These four strategies improve profitability without necessarily growing sales.
Most searched profit margin and pricing questions India 2026.
=B2-A2=(B2-A2)/B2*100=(B2-A2)/A2*100=A2/(1-D2/100)=B2/(1+C2)=(B2/(1+C2)-A2)/(B2/(1+C2))*100=E2/(B2-F2)Understanding your profit margins is just the start. Vikash Royal will analyse your business financials — product-level margins, break-even analysis, cash flow gaps, and tax-efficient profit extraction strategies. Whether you're a trader, retailer, manufacturer, or service business, a clear financial picture leads to better pricing, smarter cost decisions, and higher profitability. SEBI-Registered. ARN: ARN-356458
💬 Get My Business Financial Analysis on WhatsApp