Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Monthly gold savings plan

Monthly gold savings plan

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

Saving a fixed amount every month means buying at a different price each time. This sheet records every month, works out the grams you have built up and your average cost per gram, and what they are worth today at the price a goldsmith would pay you.

Download PDF141 KBDownload Excel61 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 "Monthly gold savings plan" sheet, with the table and the worked example

How to use it

  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.

Example The calculation with numbers

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.

The calculation

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.

Read more

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.

More free sheets

All free sheets