- Qintar
- Calculators
- Price move calculator for a gold shop's stock
Price move calculator for a gold shop's stock
Every time the price moves, the value of the gold in the shop moves with it. This sheet works out that effect for a move you type, up or down. This calculator is the same as the "The price moved: how much did my stock gain or lose?" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "The price moved: how much did my stock gain or lose?" sheet, made for goldsmiths and shop owners. A sheet that works out the effect of a price move on a shop's stock: for each karat, the pure gold and its value before and after the move, and the difference. The move is a figure you type, up or down.
The question it answers: If the 24K gram price rises or falls by a given amount, how much does the value of my gold change?
How to use it
- The price: Today's buying price for one gram of 24K.
- The move: How many pounds up or down.
- The stock: Each item with its karat and weight.
- The calculation: The pure gold and the value before and after.
- The effect: The difference in pounds and as a percentage.
Worked example
Buying price, 1 g of 24K today (example): 7,009.37 · Move in the 24K gram price, EGP, minus if it falls (example): −100.00
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| Result | Value |
|---|---|
| Total pure gold (g) | 1,447.268 |
| Value before | 10,154,587.98 |
| Difference | −144,871.62 |
| Difference % | −1.43% |
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.
- Value = pure gold ÷ 0.999 × the 24K gram price (before and after the move).
- Difference = pure gold ÷ 0.999 × the move. At the buying price, without the making charge.
Terms used on this sheet
- Stock
- All the gold the shop holds: jewelry on display, bars, and scrap waiting to be sold or refined.
- 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. The sheet values the stock at this price, as it is what the gold would fetch.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: How a gold price move hits a shop's stock: work it out.
Frequently asked questions
Is the move a forecast?
No. You type the figure to see its effect. Try several figures.
Why work in pure gold?
So that every karat is moved by the same amount: the 21K and 18K prices move in proportion to their purity.
Does it include the making charge?
No. The making charge does not move with the gold price, so the calculation covers the gold only.
Does the result change my profit?
Not by itself. It is the change in the value of the gold you hold on paper. It becomes real when you buy or sell at the new price.
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?