Reverse Margin Calculator​

Businesses make profit when they buy at the right price, not only when they sell.
Many businesses buy products first and hope customers will pay enough to cover the cost and leave a profit, this often creates pricing problems later.
The Reverse Margin Calculator uses a different method. It starts with the market price and works backward, shows the highest amount you can pay a supplier and still reach your profit goal.
The calculator also includes extra costs such as shipping, taxes & future discounts that can reduce your profit.

Enter Pricing & Margin Data

Pricing Targets



Cost Adjustments






What Is Reverse Margin (Target Costing)?

Retailers and manufacturers usually use two methods to set prices.

  • Cost-Plus Pricing: In this method, you calculate your total cost and add your profit on top of it.
    Risk: The problem starts when the final price goes above what customers want to pay.
  • Reverse Margin or Target Costing: In this method, you start with the market price. You look at what customers already pay for similar products. Then, you subtract your target profit to find the highest amount you can spend on the product.
    Reverse margin works backward from the selling price to find your cost limit. It helps you answer an important question in purchasing: “What is the highest price I can pay and still make a profit?”

The Core Formula

Reverse margin uses the opposite approach of the standard margin formula.

Target Cost = Selling Price × (1 − Desired Margin %)

A Simple Example:

  • Suppose you want to sell a wireless mouse.
  • Other sellers on Amazon already sell similar products for $20. You know customers will not pay more than that price.
  • You want a 40% profit margin for your business.
  • So, the calculation becomes:
  • Cost=20×(1−0.40)=20×0.60=12
  • Your maximum cost is $12.

Now imagine a supplier offers the mouse for $13. You can quickly see that the price does not match your profit target. The numbers help you make the decision without guesswork.


How Does the Calculator Work?

This calculator does more than basic percentage math. It includes three important checks that many new sellers forget.

Tax Stripping (The Government’s Cut)

When you sell a product for $110, you may not keep the full amount. If the price includes a 10% sales tax, the government takes $10, and you keep $100. The calculator removes the tax before it calculates your profit. This step helps you avoid counting tax money as income.

Discount Buffering (The Sale Strategy)

Most retailers do not sell every product at full price. At some point, many businesses offer discounts during sales events or clearance periods. The calculator includes a planned discount field. If you expect to offer a 20% discount later, the calculator lowers your maximum cost now — this step helps you protect your profit even after the discount.

Freight & Duty (The Landed Cost)

The supplier price is not your total cost — you still need to pay shipping (Freight) fees and import (Duty) charges. The calculator subtracts these costs from your budget using the “Freight” field.

  • For example, suppose your maximum cost is $12, and shipping costs $2. The calculation becomes: 12−2=10
  • In this case, you can pay the supplier a maximum of $10 for the product itself based on the Free on Board (FOB)

Important Facts About Target Costing

It forces market discipline

Customers do not care about your production costs, shipping fees, or rising rent — they care about whether the product feels worth the price. Reverse Margin forces you to accept the market price as the limit and build your costs around it. Instead of raising prices to protect profit, you improve operations and reduce expenses to stay competitive.

Margins shrink as products age

In most industries, prices drop over time. Suppose, a TV that sold for $1,000 last year may sell for $800 today. Smart buyers plan for that shift early — they calculate target costs based on future market prices instead of current ones. That helps them protect profit margins as competition grows and prices fall.

Landed cost is the only cost that matters

Many businesses focus too much on the FOB price and ignore the total landed cost.

  • FOB: The amount the factory charges for the product.
  • Landed: The full cost after shipping, insurance, customs, and local delivery.

A low factory price does not guarantee a profitable deal. If freight and import costs rise, your margins can disappear fast. Always calculate the full landed cost before you approve a purchase order.


When to Use This Calculator?

Scenario 1: Buying Products From Alibaba or Faire

Suppose you find a leather bag on Alibaba. The supplier asks for $40 per bag.

  • You check the US market: Similar bags sell for $100.
  • You need a 60% Margin for fashion items.
  • Input: Price $100, Margin 60%.
  • Result: Max Cost is $40.
  • The Catch: You forgot shipping! You estimate shipping is $5 per bag.
  • Re-Calc: Input Freight $5.
  • New Result: Max Product Cost is $35.

The supplier still wants $40. That price does not fit your target profit. You now know that you need to negotiate the price down to $35 or stop the deal.

Scenario 2: Private Label Manufacturing

Suppose you plan to launch your own vitamin brand. You want to sell the product as a mid-range option for $25.

  • Retailers usually demand a 50% margin to stock your product.
  • Input: Price $25, Margin 50%.
  • Result: Your “Wholesale Price” must be $12.50.
  • Now you have to make a profit too! If you need a 40% margin on your wholesale sales.
  • Input: Price $12.50, Margin 40%.
  • Result: Your manufacturing cost must be $7.50.

This process is called chaining. Move backward through each step of the supply chain until you reach your target cost.


Frequently Asked Questions

Why does the calculator remove tax?

Sales tax, VAT, and GST do not count as business income. That money comes from the customer and goes directly to the government. Since you never keep it as profit, you should not include it in your margin calculations. If you calculate margins using prices that include tax, you overstate your revenue and risk overspending on inventory.

What is a good profit margin?

The right margin depends on your industry.

  • Grocery/Electronics: 15% – 30% (High volume, low margin).
  • Apparel/Fashion: 50% – 70% (Low volume, high risk of unsold stock).
  • Cosmetics/Jewelry: 60% – 80% (Brand value dominates cost).

Every industry works differently — you should research your market before you set a target margin.

What should you do if the maximum cost is too low?

If the calculator shows a maximum product cost of $5, but suppliers charge at least $8, your numbers do not support a profitable business. In that situation, you have three options:

  • Increase the selling price: You may need to position the product as a premium item with a higher price.
  • Reduce the product cost: Get a lower price if you place larger orders.
  • Skip the product: Sometimes the smartest decision is to avoid a product that cannot meet your profit target.

Is margin the same as markup?

No. Margin and markup are different, and many people confuse them.

  • Markup adds profit to the Cost. (Cost $10 + 50% = $15 Price).
  • Margin subtracts profit from the Price. (Price $15 – 33% Margin = $10 Cost).

This difference matters because a 50% markup does not create a 50% margin — to reach 50% of margin, you need a 100% markup.

Excel Insider
Logo