- Qintar
- Calculators
- What if it had been gold? Comparison calculator
What if it had been gold? Comparison calculator
A question people ask often: what if I had put that money into gold? This sheet answers it in figures for a past period: each amount at its own day's price, and what that gold is worth today. This calculator is the same as the "What if it had been gold? Comparing in figures" sheet. It runs in your browser and saves no data.
Result
Who this calculator is for
This is the online version of the "What if it had been gold? Comparing in figures" sheet, made for individuals. A sheet that takes each amount on its date, works out how many grams it would have bought at that day's price (which you type) with the fee and its VAT, and compares their value at today's buying price with the amount itself.
The question it answers: The amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?
How to use it
- The amounts: Each amount with its date.
- That day's price: From your own source, such as Qintar's price map.
- The fee: The fee per gram and its VAT.
- Today's price: The buying price for the same karat.
- The difference: The value compared with the amount.
Worked example
VAT on the fee (example 14%): 14% · Today's buying price, same karat (example): 7,009.37
With the example figures in the table above (the rows marked "Example"), the calculator gives:
| Result | Value |
|---|---|
| Total amounts | 60,000.00 |
| Would have bought (g) | 10.313 |
| Worth today | 72,285.88 |
| Difference | 12,285.88 |
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 = amount ÷ (selling price that day + fee × (1 + VAT)).
- Value today = grams × today's buying price.
- Difference = value − amount. This looks back at a past period and says nothing about the future.
Terms used on this sheet
- Selling price
- The price at which a shop sells you gold. A purchase in the past would have been made at this price.
- Buying price
- The price at which a shop buys gold from you. Today's value is counted at this price.
- Fee per gram
- The bar fee or making charge added to each gram, with VAT of 14% on the fee only.
Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: What if the money had been gold? Doing the sum right.
Frequently asked questions
Does this mean gold is always better?
No. The calculation covers a past period only. Prices can rise and fall, and the sheet makes no forecast.
Why is the value at the buying price?
Because that is the price a shop would pay you if you sold today.
Where do I find past prices?
From any source you trust. The price map in the Qintar app shows prices by month and by year.
Why does the sheet add a fee to each purchase?
Because in Egypt you cannot buy gold at the bare gram price. A bar or a coin carries a fee per gram, with 14% VAT on the fee, and leaving it out makes gold look better than it was.
Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling.
Related calculators
- Entry cost compared: bar, gold pound or jewelryFor which option must the price rise the least before I get my money back?
- Gold trade journal: realized and on paperHow much did I gain or lose on each gold trade I closed? And what are the ones I still hold worth?
- Local versus world gold price calculatorBy what percentage is the gold price in Egypt above the world price?
- Gold bar price comparison: price per gram and premiumBars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?
- Buying at price levels: your average costIf I split my buying over several prices, what will my average cost be?