- Qintar
- Free sheets
- Gold savings goal: how much to put aside each month
Gold savings goal: how much to put aside 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.
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.

How to use it
- What you own: The grams of gold you already have.
- The goal: How many grams, and in how many months.
- The price: The gram price you want to work with: today's price or a scenario of your own.
- The fee: The fee per gram (a bar fee or a making charge) and its VAT.
- 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%
| Scenario | Goal (g) | Time (months) | Gram price you work with | Grams still needed | Amount needed | Amount per month |
|---|---|---|---|---|---|---|
| Example: 50 g in 2 years at today's price | 50.000 | 24 | 7,032.37 | 45.000 | 321,073.65 | 13,378.07 |
| Example: same goal if the price is 7,500 | 50.000 | 24 | 7,500.00 | 45.000 | 342,117.00 | 14,254.88 |
| Example: 20 g in 1 year | 20.000 | 12 | 7,032.37 | 15.000 | 107,195.55 | 8,932.96 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Grams still needed = goal − the grams you own.
- Amount needed = grams still needed × (gram price + fee × (1 + VAT)).
- Amount per month = amount needed ÷ months. You type the price: it is a scenario, not a forecast.
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
- A gold savings goal: working out the monthly amountA step-by-step guide with a worked example.
- Gold savings goal calculator: the monthly amountThe same sheet 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.
More free sheets
- Family gold register: every piece and who owns itHow many grams of gold does the family own, who holds them, and what are they worth?
- Comparing gold bar prices between sellersBars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?
- What if it had been gold? Comparing in figuresThe amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?