- Qintar
- Calculators
- Used gold calculator: the price you paid per pure gram
Used gold calculator: the price you paid per pure gram
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.
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
- Today's price: Today's buying price for one gram of 24K.
- The pieces: One line per piece, with its karat, weight and the price you paid.
- Pure gold: The sheet works out the pure gold in each piece.
- The average: The average price you paid per gram of pure gold.
- 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:
| Result | Value |
|---|---|
| Total weight (g) | 31.200 |
| Total pure gold (g) | 25.975 |
| Total paid | 180,214.00 |
| Average price you paid per gram of pure gold | 6,937.98 |
| Today's price per gram of pure gold | 7,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
- Pure gold = weight × karat purity (24K: 0.999, 21K: 0.875, 18K: 0.75).
- Paid = weight × price paid per gram.
- Price per gram of pure gold = paid ÷ pure gold. Today's pure-gold price = the 24K buying price ÷ 0.999.
- Gap = pure gold × today's pure-gold price − paid: your margin before refining or resale costs.
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
- Cash close calculator: count the drawer and compareDoes the cash in the drawer match what should be there, or is there a gap?
- Credit book: each customer's balance after every entryHow much does each customer owe, how much have they paid, and what is left?
- Scrap and refining calculator: how much pure gold?How many grams of pure gold are in my scrap, and how much comes back after refining?
- Wholesaler account: balance in pure gold and making chargeHow many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- Gold shop monthly profit calculatorHow much did the shop make this month after expenses?