Markup Calculator with Bulk Price Lists

Work out a selling price from cost and markup, convert between markup and margin in either direction, or price a whole product list at once. Paste lines of product and cost, choose a target markup or margin and a rounding style such as .99, and copy or download the finished price list. Everything runs in your browser. Nothing you type is sent to We.Inc or anyone else.

How it works

  1. Single item: enter the cost and the markup you want. You get the selling price, the profit and the margin that price gives.
  2. Converter: type a markup to see the matching margin, or a margin to see the matching markup. Both boxes update each other.
  3. Bulk list: paste one product per line as name, cost. Commas, tabs from a spreadsheet and semicolons all work, and a header row is skipped.
  4. Choose whether the target is a markup or a margin, and pick a rounding style. Rounding always goes up, so no product ends below your target.
  5. Check the table, which shows the final price, profit and actual margin for each line and flags any line it could not read. Copy it or download it as a CSV for your store or spreadsheet.

Worked example: a gift shop price list

A gift shop pastes three lines: Ceramic mug at $6.80, Tote bag at $4.15 and Greeting card at $1.10. With a 120% markup the raw prices are $14.96, $9.13 and $2.42. With .99 rounding they become $14.99, $9.99 and $2.99.

The table shows the real margin after rounding: 54.6% on the mug, 58.5% on the tote and 63.2% on the card. The card gains most from rounding, which is worth knowing before you print the price tags.

Markup or margin as the target

If you set a target margin instead, say 55%, each cost is divided by 0.45: the mug becomes $15.11 raw and $15.99 rounded. Targeting a margin keeps your share of each sale steady across cheap and expensive products, which makes monthly planning easier.

Tips

  • Decide which number your business talks in. Retailers often quote markup, accountants usually quote margin. The converter keeps both in view.
  • A 100% markup (doubling the cost) is a 50% margin. A 50% margin needs a 100% markup.
  • Round with care on cheap items. Rounding $1.12 up to $1.99 adds 78% to the price.
  • Build payment and marketplace fees into the cost column so the list price covers them.
  • Re-run the list whenever supplier prices change. Keep your cost sheet as the source and regenerate the prices.

Frequently asked questions

How do I calculate markup?

Subtract the cost from the selling price, divide by the cost and multiply by 100. A $20 item sold for $32 has a $12 profit and a 60% markup.

How do I convert markup to margin?

Divide the markup by 100 plus the markup. A 60% markup is 60 divided by 160, which is a 37.5% margin. To go the other way, divide the margin by 100 minus the margin: a 37.5% margin is 37.5 divided by 62.5, a 60% markup.

What format does the bulk price list need?

One product per line with the name, then the cost, separated by a comma, tab or semicolon. Put names that contain commas in double quotes. A first line with the word cost or price is treated as a header and skipped.

How does .99 rounding work?

Each price is raised to the next price ending in .99. $18.25 becomes $18.99 and $19.00 becomes $19.99. The tool never rounds down, so the margin on each line stays at or above your target.

How many products can I paste?

Up to 2,000 lines. It all runs in your browser, so larger lists work but are easier to check in smaller batches.

Is the markup calculator free?

Yes, with no signup. Your costs stay in your browser.

Related: Margin Calculator, Etsy Fee Calculator, Payment Processing Fee Calculator, Break-Even Calculator, Website builder.

Turn this result into your website or see the We.Inc website builder. The free plan gives you up to 3 template sites on a we.inc address, with no AI credits and no custom domain. Paid plans are Starter at $20 a month, Pro at $49 and Max at $99. See pricing.

More in Free Tools

Product

Who It's For

Features

Resources

Company

View Sitemap