Qintar logoQintar
  1. Qintar
  2. Guides
  3. A gold savings goal: working out the monthly amount

A gold savings goal: working out the monthly amount

I want to reach a set number of grams in a set time. How much should I save each month?

A clear goal makes saving easier. "50 grams in two years" is far easier to act on than "I will save in gold". Once the goal is set, the amount you need each month follows from it.

The arithmetic: take the grams you still need, multiply by the gram price plus the fee per gram and its VAT, then divide by the number of months.

Nobody knows the future price. So the sheet lets you write more than one scenario: one at today's price, one at a higher price, and so on, and you see how much the monthly amount changes with each.

Grams you already own count toward the goal. If you have 5 g today, the sheet only plans for the rest.

When you actually start buying, record each month in the monthly gold savings plan sheet, so you know your real average cost per gram.

Why the fee and its VAT belong in the plan

In Egypt a gram of gold is never sold at the bare gram price. On a bar you pay a fee per gram, and on jewelry a making charge per gram, and VAT of 14% is added to that fee only, not to the gold.

If you divide your savings by the gram price alone, the plan comes up short every month. The sheet adds the fee and its VAT to every gram, so the amount it gives you is the amount you will actually spend.

The example in plain words

The saver already owns 5 g and wants 50 g in 24 months, so 45 g are still needed. At a gram price of EGP 7,032.37 and a fee of EGP 90 a gram plus VAT, the total comes to EGP 321,073.65, or EGP 13,378.07 a month.

If the price were EGP 7,500 instead, the same goal would need EGP 342,117.00 in total, or EGP 14,254.88 a month. That is not a forecast; it only shows how sensitive the plan is to the price.

A smaller goal of 20 g in 12 months, with a fee of EGP 100 a gram, needs 15 g more: EGP 107,195.55 in total, or EGP 8,932.96 a month.

The calculation

Example A worked example

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. Type your own figures in the sheet or the calculator.

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.

Step by step with the sheet

  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.

The sheet is free: Gold savings goal: how much to put aside each month (Excel and PDF), or try it online with today's prices.

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.