# Monthly silver savings plan | Free sheet

> Free Excel and PDF monthly silver savings sheet: amount, 999 price, fineness and making charge each month, grams, pure silver, average cost and value.

Source: https://qintar.app/en/sheets/silver-savings-plan.html
Language: English
قنطار (Qintar)، qintar.app

---

# 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 KB](https://qintar.app/en/sheets/silver-savings-plan.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/silver-savings-plan.xlsx)

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](https://qintar.app/en/tools/silver-savings-plan.html).

![Preview of the first page of the "Monthly silver savings plan" sheet, with the table and the worked example](https://qintar.app/en/sheets/silver-savings-plan.png)

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

| Month | Price of 1 g of 999 on the day | Amount | Grams bought | Pure silver (g) | Worth today |
| --- | --- | --- | --- | --- | --- |
| Example: September | 79.50 | 3,000.00 | 34.746 | 34.712 | 3,060.46 |
| Example: October | 84.20 | 3,000.00 | 32.953 | 32.920 | 2,902.46 |
| Example: November | 88.08 | 3,000.00 | 31.606 | 31.574 | 2,783.82 |

| Result | Value |
| --- | --- |
| Total grams | 99.304 |
| Total pure silver | 99.205 |
| Total paid | 9,000.00 |
| Average cost per gram | 90.63 |
| Value at today's buying price | 8,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

- Grams this month = amount ÷ (price of 1 g of 999 × fineness ÷ 999 + making charge × (1 + VAT)).
- Pure silver = grams × fineness ÷ 1000.
- Value today = grams × fineness ÷ 999 × today's buying price of 1 g of 999.

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

- [Saving in silver monthly: average cost and making charge](https://qintar.app/en/articles/silver-monthly-savings.html)A step-by-step guide with a worked example.
- [Monthly silver savings plan calculator](https://qintar.app/en/tools/silver-savings-plan.html)The same sheet online, with today's prices.

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

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Buying gold at several price levels](https://qintar.app/en/sheets/buy-sell-levels-plan.html)If I split my buying over several prices, what will my average cost be?
- [Comparing suppliers: which making charge is cheaper?](https://qintar.app/en/sheets/shop-supplier-compare.html)For an order of a given weight, which supplier has the lowest real making charge after the discount?
- [Order production tracker: which stage ran late?](https://qintar.app/en/sheets/workshop-production-tracker.html)How many days did each order spend in each stage, and is it late against what was agreed?

[All free sheets](https://qintar.app/en/sheets/)
