Saving in gold every month: your average cost per gram
When you buy with a fixed amount every month, the months when the price is lower give you more grams and the months when it is higher give you fewer. That is why the figure that matters is your average cost per gram.
The grams are not just the amount divided by the price: there is a fee per gram (a making charge or a bar fee) and VAT on that fee. The sheet takes them out before it works out the grams.
The value of what you hold is counted at the "buying" price, the one a goldsmith pays you, not the selling price. The gap between the two is normal and has to be counted.
The sheet shows you the figures, but it does not predict prices. Saving is your decision, and the amount should fit your circumstances.
Two prices, and why both matter
Egyptian gold prices are quoted in pairs: a selling price, which you pay when you buy, and a buying price, which you get when you sell. On top of the selling price you pay a fee per gram, with 14% VAT on the fee only.
So on the day you buy, your gold is already worth a little less than you paid. A savings plan only shows a paper gain once the buying price climbs above your average cost.
The example in plain words
The saver puts in EGP 10,000 a month for four months, at selling prices of EGP 6,650, 6,890, 7,150 and 7,032.37 a gram, with a fee of EGP 100 a gram. Each month buys 1.478 g, 1.428 g, 1.377 g and 1.399 g.
After EGP 40,000 the saver holds 5.682 g at an average cost of EGP 7,039.61 a gram. At a buying price of EGP 7,009.37 that gold is worth EGP 39,828.18, a paper loss of EGP 171.82, because the average cost is still above today's buying price.
The calculation
- Grams this month = amount ÷ (selling price + fee per gram × (1 + VAT)).
- Average cost = total paid ÷ total grams.
- Value = total grams × today's buying price. Paper gain = value − total paid.
Example A worked example
VAT on the fee (example 14%): 14% · Today's buying price per gram, same karat (example): 7,009.37
| Month | Selling price per gram on the day | Fee per gram (making charge / bar) | Amount paid | Grams bought | Total grams | Average cost per gram |
|---|---|---|---|---|---|---|
| Example: August | 6,650.00 | 100.00 | 10,000.00 | 1.478 | 1.478 | 6,764.00 |
| Example: September | 6,890.00 | 100.00 | 10,000.00 | 1.428 | 2.906 | 6,881.91 |
| Example: October | 7,150.00 | 100.00 | 10,000.00 | 1.377 | 4.283 | 7,004.73 |
| Example: November | 7,032.37 | 100.00 | 10,000.00 | 1.399 | 5.682 | 7,039.61 |
| Result | Value |
|---|---|
| Total grams | 5.682 |
| Total paid | 40,000.00 |
| Average cost per gram | 7,039.61 |
| Value at today's buying price | 39,828.18 |
| Paper gain / loss | −171.82 |
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
- Selling price
- The price at which a shop sells you a gram of gold. It is always above the buying price.
- Buying price
- The price at which a shop buys gold from you. Your holdings are valued at this price.
- Bar fee
- The fee per gram on a gold bar, smaller per gram on heavier bars. Jewelry has a making charge instead.
- Average cost
- Everything you paid divided by all the grams you hold.
Step by step with the sheet
- Record the month: The selling price per gram on the day, the fee per gram and the amount.
- The grams: The sheet works out the grams you got after the fee and its VAT.
- The average: Total paid ÷ total grams.
- The value: Type today's buying price for the same karat.
- Follow up: Compare your average cost with the buying price.
The sheet is free: Monthly gold savings plan (Excel and PDF), or try it online with today's prices.
Frequently asked questions
Is this advice to buy every month?
No. The sheet records your plan and does the arithmetic. Whether to save, and how much, is your decision, and prices can go up or down.
Why is the value at the buying price and not the selling price?
Because the buying price is what a goldsmith would pay you if you sold. That is what your gold is really worth to you today.
What does "fee per gram" mean?
The making charge or the bar fee you pay on each gram. VAT is charged on that fee only, not on the gold.
Why can the example show a small loss even though prices rose?
Each purchase paid the selling price plus a fee and its VAT, while the value is counted at the lower buying price. Prices have to rise by more than that gap before the paper result turns positive.
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.