# Monthly gold savings plan | Free sheet

> Free Excel and PDF sheet for a monthly gold savings plan: amount, price and fee each month, grams built up, average cost and today's value.

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

---

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

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

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

| Month | Selling price per gram on the day | Fee per gram (making charge / bar) | Amount paid | Grams bought | Total grams | Average cost per gram |
| --- | --- | --- | --- | --- | --- | --- |
| Example: August | 6,650.00 | 100.00 | 10,000.00 | 1.478 | 1.478 | 6,764.00 |
| Example: September | 6,890.00 | 100.00 | 10,000.00 | 1.428 | 2.906 | 6,881.91 |
| Example: October | 7,150.00 | 100.00 | 10,000.00 | 1.377 | 4.283 | 7,004.73 |
| Example: November | 7,032.37 | 100.00 | 10,000.00 | 1.399 | 5.682 | 7,039.61 |

| Result | Value |
| --- | --- |
| Total grams | 5.682 |
| Total paid | 40,000.00 |
| Average cost per gram | 7,039.61 |
| Value at today's buying price | 39,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

- Grams this month = amount ÷ (selling price + fee per gram × (1 + VAT)).
- Average cost = total paid ÷ total grams.
- Value = total grams × today's buying price. Paper gain = value − total paid.

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

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

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

[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

- [End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?

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