Qintar logoQintar
  1. Qintar
  2. Guides
  3. Saving in gold every month: your average cost per gram

Saving in gold every month: your average cost per gram

If I put a fixed amount into gold every month, how many grams do I build up, and what is my average cost?

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

Example A worked example

VAT on the fee (example 14%): 14% · Today's buying price per gram, same karat (example): 7,009.37

MonthSelling price per gram on the dayFee per gram (making charge / bar)Amount paidGrams boughtTotal gramsAverage cost per gram
Example: August6,650.00100.0010,000.001.4781.4786,764.00
Example: September6,890.00100.0010,000.001.4282.9066,881.91
Example: October7,150.00100.0010,000.001.3774.2837,004.73
Example: November7,032.37100.0010,000.001.3995.6827,039.61
ResultValue
Total grams5.682
Total paid40,000.00
Average cost per gram7,039.61
Value at today's buying price39,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

  1. Record the month: The selling price per gram on the day, the fee per gram and the amount.
  2. The grams: The sheet works out the grams you got after the fee and its VAT.
  3. The average: Total paid ÷ total grams.
  4. The value: Type today's buying price for the same karat.
  5. 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.