Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Buying gold at several price levels

Buying gold at several price levels

Free sheet for individuals · If I split my buying over several prices, what will my average cost be?

Instead of buying all at once, you can split your buying over more than one price. This sheet works out your average cost if you buy at the levels you set.

Download PDF133 KBDownload Excel60 KB

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. Or try it online without downloading.

Preview of the first page of the "Buying gold at several price levels" sheet, with the table and the worked example

How to use it

  1. Fee and price: The fee per gram, its VAT and today's price.
  2. The levels: Each price and how many grams you would buy at it.
  3. The cost: The sheet works out the cost of each level.
  4. The average: The average cost per gram up to each level.
  5. Compare: The difference from today's price.

Example The calculation with numbers

Fee per gram (example): 90.00 · VAT on the fee (example 14%): 14% · Today's selling price per gram (example): 7,032.37

LevelPrice at this levelGramsCostGrams so farAverage cost per gram
Example: today7,032.375.00035,674.855.0007,134.97
Example: if it falls 3%6,821.405.00034,620.0010.0007,029.49
Example: if it falls 6%6,610.4310.00067,130.3020.0006,871.26
ResultValue
Total grams20.000
Total cost137,425.15
Average cost per gram6,871.26

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

The calculation

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.

Read more

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.

More free sheets

All free sheets