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

Monthly silver savings plan calculator

If I put an amount into silver every month, how much pure silver do I build up, and what is my average cost?

Saving small amounts in silver every month needs clear arithmetic, because the making charge is a large part of the price. This sheet records every month and works out your average cost and what your silver is worth. This calculator is the same as the "Monthly silver 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.

MonthPrice of 1 g of 999 on the dayFineness per thousandMaking charge per gramAmountGrams boughtPure silver (g)Worth todayDelete

Result

Who this calculator is for

This is the online version of the "Monthly silver savings plan" sheet, made for individuals. A month-by-month log for saving in silver: the amount, the price of 1 g of 999, the fineness, the making charge and its VAT, the grams and the pure silver, the totals and the average cost, and the value at today's buying price.

The question it answers: If I put an amount into silver every month, how much pure silver do I build up, and what is my average cost?

How to use it

  1. The month: The price, the fineness, the making charge and the amount.
  2. The grams: After the making charge and its VAT.
  3. Pure silver: The pure silver you hold.
  4. The average: Total paid ÷ grams.
  5. The value: At today's buying price.

Worked example

VAT on the making charge, as on your invoice (example): 14% · Today's buying price, 1 g of 999 silver (example): 88.08

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

ResultValue
Total grams99.304
Total pure silver99.205
Total paid9,000.00
Average cost per gram90.63
Value at today's buying price8,746.74
Paper gain / loss−253.26

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

999 silver
Silver of 999 parts per thousand, almost pure. Bars are usually 999.
Fineness
The silver content in parts per thousand; 925 means 92.5% silver.
Making charge
The fee per gram for the work (مصنعية). On silver it is a large share of the price.
Buying price
The price at which a shop buys silver from you. Your silver is valued at this price.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Saving in silver monthly: average cost and making charge.

Frequently asked questions

Why does the making charge matter so much on silver?

Because a gram of silver is cheap, the making charge per gram is a large share of its price. Bars carry a lower making charge than jewelry.

Is this advice to save in silver?

No. The sheet works out a plan you chose. Prices go up and down.

What VAT rate do I type?

The one on your invoice. The 14% in the example is an illustration.

Why can the example show a loss even though prices rose?

Each purchase paid the making charge and its VAT on top of the silver, while the value is counted at the buying price of the metal alone. The price has to rise by more than that 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