Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Gold savings goal: how much to put aside each month

Gold savings goal: how much to put aside each month

Free sheet for individuals · I want to reach a set number of grams in a set time. How much should I save each month?

Saving with no target is hard to keep up. Pick a number of grams and a deadline instead, and this sheet tells you how much to put aside each month. You can try more than one gram price on separate lines and see how much the monthly amount moves.

Download PDF133 KBDownload Excel60 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 "Gold savings goal: how much to put aside each month" sheet, with the table and the worked example

How to use it

  1. What you own: The grams of gold you already have.
  2. The goal: How many grams, and in how many months.
  3. The price: The gram price you want to work with: today's price or a scenario of your own.
  4. The fee: The fee per gram (a bar fee or a making charge) and its VAT.
  5. The result: The total amount needed and the amount per month.

Example The calculation with numbers

Grams you already own (example): 5.000 · VAT on the fee (example 14%): 14%

ScenarioGoal (g)Time (months)Gram price you work withGrams still neededAmount neededAmount per month
Example: 50 g in 2 years at today's price50.000247,032.3745.000321,073.6513,378.07
Example: same goal if the price is 7,50050.000247,500.0045.000342,117.0014,254.88
Example: 20 g in 1 year20.000127,032.3715.000107,195.558,932.96

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

Selling price
The price at which a shop sells you a gram of gold. You pay it when you buy, so the plan uses it.
Bar fee
The fee per gram on a gold bar (مصنعية السبيكة), lower per gram on heavier bars. Jewelry has a making charge instead.
VAT on the fee
In Egypt VAT of 14% is charged on the fee or making charge only, not on the gold itself.

Read more

Frequently asked questions

Will the price stay where it is?

No one knows. Prices change, which is why the sheet lets you type several prices on several lines. It does not forecast anything.

What fee per gram should I type?

The bar fee or making charge you will actually pay. The usual bar fees (published figures on 3 November 2026) run from EGP 210 a gram on a 1 g bar down to EGP 35 on the largest bars; the current figures are in Qintar's calculators.

Is this advice to save in gold?

No. The sheet works out a plan you chose. The decision is yours.

Which price should I type, the buying or the selling price?

The selling price: the price a shop charges you when you buy. That is the price you will pay each month, plus the fee and its VAT.

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