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

Monthly silver savings plan

Free sheet for individuals · 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.

Download PDF136 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 silver savings plan" sheet, with the table and the worked example

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.

Example The calculation with numbers

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

MonthPrice of 1 g of 999 on the dayAmountGrams boughtPure silver (g)Worth today
Example: September79.503,000.0034.74634.7123,060.46
Example: October84.203,000.0032.95332.9202,902.46
Example: November88.083,000.0031.60631.5742,783.82
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

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

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.

Read more

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. 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