Buying gold at price levels: your average cost per gram
Splitting a purchase over more than one price is a method many people use instead of putting the whole amount in at once.
What matters is knowing your average cost: each level at its full cost, including the fee and its VAT, and the average = the total cost ÷ the grams.
The levels are figures you choose. The sheet does not predict that the price will reach them, and if it does not, that level is simply not bought.
Price alerts in the Qintar app can tell you when the price reaches a level you have set.
What each gram really costs in Egypt
When you buy gold in Egypt you pay the selling price per gram, plus a fee per gram on a bar (or a making charge on jewelry), plus 14% VAT on that fee only. So the cost per gram is always a little above the quoted price.
That is why the sheet adds the fee and its VAT to every level before it works out the average. An average based on the quoted prices alone would look better than the truth.
The example in plain words
Today's selling price in the example is EGP 7,032.37 a gram, with a fee of EGP 90 a gram. Buying 5 g today costs EGP 35,674.85, an average of EGP 7,134.97 a gram once the fee and VAT are counted.
If the price were 3% lower, at EGP 6,821.40, another 5 g would cost EGP 34,620.00, and the average for 10 g would drop to EGP 7,029.49. At 6% lower, EGP 6,610.43, buying 10 g more costs EGP 67,130.30.
If all three levels were bought, you would hold 20 g for EGP 137,425.15, an average of EGP 6,871.26 a gram. These are figures for a scenario you chose; the price may never reach the lower levels.
The calculation
- Cost of a level = grams × (price at the level + fee × (1 + VAT)).
- Average cost up to a level = cost so far ÷ grams so far.
- You type the levels and their prices: a scenario for the arithmetic, not a forecast of the price.
Example A worked example
Fee per gram (example): 90.00 · VAT on the fee (example 14%): 14% · Today's selling price per gram (example): 7,032.37
| Level | Price at this level | Grams | Cost | Grams so far | Average cost per gram |
|---|---|---|---|---|---|
| Example: today | 7,032.37 | 5.000 | 35,674.85 | 5.000 | 7,134.97 |
| Example: if it falls 3% | 6,821.40 | 5.000 | 34,620.00 | 10.000 | 7,029.49 |
| Example: if it falls 6% | 6,610.43 | 10.000 | 67,130.30 | 20.000 | 6,871.26 |
| Result | Value |
|---|---|
| Total grams | 20.000 |
| Total cost | 137,425.15 |
| Average cost per gram | 6,871.26 |
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
- Price level
- A price you decide in advance to buy at, with a set number of grams.
- Average cost
- Everything you paid, fees and VAT included, divided by all the grams you bought.
- Bar fee
- The fee per gram a shop charges on a gold bar, with 14% VAT on the fee only.
- Selling price
- The price at which a shop sells you a gram of gold. It is above the price the shop pays when it buys from you.
Step by step with the sheet
- Fee and price: The fee per gram, its VAT and today's price.
- The levels: Each price and how many grams you would buy at it.
- The cost: The sheet works out the cost of each level.
- The average: The average cost per gram up to each level.
- Compare: The difference from today's price.
The sheet is free: Buying gold at several price levels (Excel and PDF), or try it online with today's prices.
Frequently asked questions
Does the sheet tell me the price will fall?
No. The levels are a scenario you type to see the arithmetic. They are not a forecast.
What if the price never reaches a level?
Then that level is not bought. Delete the line, or keep it and set its grams to zero.
Can I get an alert at a price?
Yes. In the Qintar app you can set an alert for when the price reaches a figure you choose.
Why is the fee counted with VAT?
In Egypt, VAT of 14% is charged on the fee or making charge, not on the gold. The fee and its VAT are part of what each gram really costs you.
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.