Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Used gold calculator: the price you paid per pure gram

Used gold calculator: the price you paid per pure gram

On average, what did I pay today for each gram of pure gold in the used gold I bought?

Every day a shop buys used gold from customers, in different karats and at different prices. This sheet turns it all into one figure: what you paid per gram of pure gold, and how far that is below or above today's price. This calculator is the same as the "Buying used gold from customers: a daily log" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

PieceKaratWeight (g)Price paid per gramPure gold (g)PaidPrice per gram of pure goldDelete

Result

Who this calculator is for

This is the online version of the "Buying used gold from customers: a daily log" sheet, made for goldsmiths and shop owners. A log of every piece of used gold you buy from a customer: the karat, the weight and the price you paid per gram. It works out the pure gold in each piece, the price you really paid per gram of pure gold, and compares it with today's pure-gold price.

The question it answers: On average, what did I pay today for each gram of pure gold in the used gold I bought?

How to use it

  1. Today's price: Today's buying price for one gram of 24K.
  2. The pieces: One line per piece, with its karat, weight and the price you paid.
  3. Pure gold: The sheet works out the pure gold in each piece.
  4. The average: The average price you paid per gram of pure gold.
  5. The gap: The difference between the pure gold at today's price and what you paid.

Worked example

Buying price, 1 g of 24K today (example): 7,009.37

With the example figures in the table above (the rows marked "Example"), the calculator gives:

ResultValue
Total weight (g)31.200
Total pure gold (g)25.975
Total paid180,214.00
Average price you paid per gram of pure gold6,937.98
Today's price per gram of pure gold7,016.39
Gap on all the gold bought (today's value − paid)2,036.64

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

The calculation

Terms used on this sheet

Used gold
Jewelry and pieces a shop buys back from customers (الكسر, literally "broken"). It is valued by the pure gold it holds.
Pure gold
Weight × purity: 21K is 0.875 pure, 18K is 0.75 pure, and Qintar counts 24K as 0.999.
Buying price
The price at which a shop buys gold, lower than the selling price it charges customers.
Bangle
A rigid bracelet (غويشة), one of the most common pieces of Egyptian 21K jewelry.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Buying used gold from customers: was the price right?.

Frequently asked questions

Why work in pure gold?

So that 21K and 18K pieces add up to one figure and can be compared with each other and with today's price.

Is the gap my profit?

No. It is the margin before the cost of refining, reworking or reselling, and before any loss. Your real profit shows once you sell or refine.

What do I do with the scrap afterward?

If you send it for refining, the scrap and refining sheet works out how much pure gold comes back after refining.

Why do Egyptian shops buy back gold at all?

In Egypt people sell old jewelry back to gold shops for cash, or trade it in for a new piece. So buying is a daily part of a shop's work, not an exception.

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling.

Related calculators

All calculators · All free sheets