Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Gold savings goal calculator: the monthly amount

Gold savings goal calculator: the monthly amount

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. This calculator is the same as the "Gold savings goal: how much to put aside each month" sheet. It runs in your browser and saves no data.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

ScenarioGoal (g)Time (months)Gram price you work withFee per gramGrams still neededAmount neededAmount per monthDelete

Who this calculator is for

This is the online version of the "Gold savings goal: how much to put aside each month" sheet, made for individuals. A sheet that works out the monthly amount that gets you to a goal in grams within the time you choose, at a gram price that you type (not a forecast), with the fee per gram and its VAT, and counting the grams you already own.

The question it answers: I want to reach a set number of grams in a set time. How much should I save each month?

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.

Worked example

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

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

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A gold savings goal: working out the monthly amount.

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.

Related calculators

All calculators · All free sheets