Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Monthly gold savings plan calculator

Monthly gold savings plan calculator

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. This calculator is the same as the "Monthly gold savings plan" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

MonthSelling price per gram on the dayFee per gram (making charge / bar)Amount paidGrams boughtTotal gramsTotal paidAverage cost per gramDelete

Result

Who this calculator is for

This is the online version of the "Monthly gold savings plan" sheet, made for individuals. A month-by-month log for saving in gold: the amount, the gram price and the fee on the day you bought, the grams you got, the running totals, the average cost per gram, and their value at today's buying price.

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

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.

Worked example

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

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

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Saving in gold every month: your average cost per gram.

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.

Related calculators

All calculators · All free sheets