- Qintar
- Calculators
- Family gold register: pieces and value per person
Family gold register: pieces and value per person
Gold in a family home is usually spread across several people, and often there is no paperwork. This sheet puts it all in one register: the piece, its owner, its weight, whether it has an invoice, and what it is worth at today's price. This calculator is the same as the "Family gold register: every piece and who owns it" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "Family gold register: every piece and who owns it" sheet, made for individuals. A register of all the gold in the home: who owns each piece, a description, the karat, the weight, whether there is an invoice, the pure gold, the value at today's buying price, and a running total for each person.
The question it answers: How many grams of gold does the family own, who holds them, and what are they worth?
How to use it
- The prices: The buying price per gram for each karat.
- The pieces: Each piece with its owner, karat and weight.
- The invoice: Type Yes or No.
- The value: The sheet works out the pure gold and the value.
- Per person: Each owner's total.
Worked example
Buying price, 1 g of 24K (example): 7,009.37 · Buying price, 1 g of 21K (example): 6,160.25 · Buying price, 1 g of 18K (example): 5,259.00
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| Result | Value |
|---|---|
| Total weight (g) | 43.700 |
| Total pure gold (g) | 38.578 |
| Value at the buying price | 271,205.13 |
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).
- Value = weight × today's buying price per gram for that karat (without the making charge).
- Owner's total = the sum of the values of that owner's pieces, from the top of the register to this line.
Terms used on this sheet
- Buying price
- The price at which a shop buys gold from you. It is lower than the selling price, and it is what your pieces would fetch today.
- Hallmark
- The stamp on a piece that shows its karat (الدمغة). Together with the invoice, it makes a piece easier to sell.
- Shabka
- The gold jewelry an Egyptian groom gives his bride at the engagement (الشبكة). It is often the largest set of gold in a home.
- Pure gold
- The gold inside an alloy: weight × purity. 21K is 0.875 pure and 18K is 0.75 pure.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A family gold register: all the home's gold and its value.
Frequently asked questions
Why record whether there is an invoice?
The invoice and the hallmark make a difference on the day you sell. The register reminds you which pieces still need their invoice found.
Does the value include the making charge?
No. The value uses the buying price of the gold only, which is roughly what you would get if you sold.
Does this register decide who owns what?
No. It is for keeping things in order only, and it is not a legal document.
Why do 21K and 18K pieces have their own prices?
Egyptian shops quote a separate gram price for each karat, because each holds a different share of pure gold. The sheet values each piece at the price for its own karat.
Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling.
Related calculators
- Monthly gold savings plan calculatorIf I put a fixed amount into gold every month, how many grams do I build up, and what is my average cost?
- Shabka budget calculatorWith this shabka budget, which pieces can I buy, and how many grams?
- Gold savings goal calculator: the monthly amountI want to reach a set number of grams in a set time. How much should I save each month?
- Inherited gold calculator: value of each shareIf the shares are known from the official document, what is each person's share of the gold's value worth?
- Entry cost compared: bar, gold pound or jewelryFor which option must the price rise the least before I get my money back?