- Qintar
- Calculators
- Monthly gold savings plan calculator
Monthly gold savings plan calculator
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. This calculator is the same as the "Monthly gold savings plan" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "Monthly gold savings plan" sheet, made for individuals. A month-by-month log for saving in gold: the amount, the gram price and the fee on the day you bought, the grams you got, the running totals, the average cost per gram, and their value at today's buying price.
The question it answers: If I put a fixed amount into gold every month, how many grams do I build up, and what is my average cost?
How to use it
- Record the month: The selling price per gram on the day, the fee per gram and the amount.
- The grams: The sheet works out the grams you got after the fee and its VAT.
- The average: Total paid ÷ total grams.
- The value: Type today's buying price for the same karat.
- Follow up: Compare your average cost with the buying price.
Worked example
VAT on the fee (example 14%): 14% · Today's buying price per gram, same karat (example): 7,009.37
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| 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 |
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
- 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.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Saving in gold every month: your average cost per gram.
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.
Related calculators
- Shabka budget calculatorWith this shabka budget, which pieces can I buy, and how many grams?
- Gold savings goal calculator: the monthly amountI want to reach a set number of grams in a set time. How much should I save each month?
- Family gold register: pieces and value per personHow many grams of gold does the family own, who holds them, and what are they worth?
- Inherited gold calculator: value of each shareIf the shares are known from the official document, what is each person's share of the gold's value worth?
- Entry cost compared: bar, gold pound or jewelryFor which option must the price rise the least before I get my money back?