A gold shop's position: finding net gold and net cash
A shop owner deals in two currencies: gold and money. Looking at only one of them gives half the picture.
The position is everything you hold or are owed minus everything you owe, for each currency on its own. Gold is counted in grams of pure gold, cash in Egyptian pounds.
Value the net gold at today's price and add the net cash, and you know the shop's total, and the share of it that is gold.
That share matters: a shop with a high share of gold feels price moves more. The price move sheet completes the picture.
Why gold and cash are kept apart
In the Egyptian trade much of what a shop owes is owed in gold. A wholesaler supplies jewelry and is often settled in gold of the same pure weight, with the making charge paid in cash. A craftsman holds the shop's gold while he works on it.
If you turn every gram into pounds at once, the account changes every time the price moves. Keeping gold in grams and cash in pounds gives two stable figures; the price only enters at the end.
The example in plain words
The shop holds 1,347.2 g of pure gold on display and in bars, 105 g in scrap, and 131.25 g with the craftsman. It owes the wholesaler 219.5 g of pure gold and EGP 11,800 of making charge. It has EGP 185,000 in the safe and the bank and is owed EGP 17,800 by customers.
So its net gold is 1,363.95 g of pure gold and its net cash is EGP 191,000.00. At a 24K buying price of EGP 7,009.37 the gold is worth EGP 9,570,000.21, for a total of EGP 9,761,000.21. Gold makes up 98.0% of it, so the shop's worth follows the gold price almost entirely.
The calculation
- Net gold = total pure gold you hold or are owed − pure gold you owe.
- Net cash = cash you hold or are owed − cash you owe.
- Total = net gold ÷ 0.999 × the 24K buying price + net cash.
Example A worked example
Buying price, 1 g of 24K (example): 7,009.37
| Item | Gold you hold or are owed (g pure) | Gold you owe (g pure) | Cash you hold or are owed | Cash you owe | Net of the item, EGP |
|---|---|---|---|---|---|
| Example: display and bars (from the stock count) | 1,347.200 | 9,452,475.74 | |||
| Example: scrap in the shop | 105.000 | 736,720.57 | |||
| Example: gold with the craftsman | 131.250 | 920,900.71 | |||
| Example: owed to the wholesaler (gold and making charge) | 219.500 | 11,800.00 | −1,551,896.81 | ||
| Example: safe and bank | 185,000.00 | 185,000.00 | |||
| Example: credit owed by customers | 17,800.00 | 17,800.00 |
| Result | Value |
|---|---|
| Net gold (g pure) | 1,363.950 |
| Net cash | 191,000.00 |
| Net gold in EGP | 9,570,000.21 |
| Total in EGP | 9,761,000.21 |
| Gold as a share of the total | 98.0% |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.
Terms used on this sheet
- Position
- What a shop holds and is owed, minus what it owes, kept separately for gold and for cash.
- Pure gold
- Weight × purity: 21K is 0.875 pure, 18K is 0.75 pure. Turning everything into pure gold lets karats add up.
- Wholesaler
- The trader or workshop that supplies jewelry to shops (تاجر الجملة). Shops often owe it gold as well as the making charge in cash.
Step by step with the sheet
- The items: Everything you hold, are owed or owe, one line each.
- The gold: In grams of pure gold.
- The cash: In Egyptian pounds.
- The price: Today's buying price for 24K.
- The net: Net gold, net cash and the total.
The sheet is free: Gold position: is the shop long in gold or in cash? (Excel and PDF), or try it online with today's prices.
Frequently asked questions
Why work in pure gold?
So that gold of different karats adds up to one figure.
Is this the shop's balance sheet?
No. It is a summary of the position only, not financial statements. See your accountant for anything official.
Where do the figures come from?
From the stock count, craftsman, wholesaler, credit book and cash sheets.
Why does the gold share matter?
The higher the share of gold in the total, the more a move in the gold price changes what the shop is worth. The price move sheet shows by how much.
Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.
Live prices in the app. The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.