- Qintar
- Free sheets
- What if it had been gold? Comparing in figures
What if it had been gold? Comparing in figures
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.
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
- 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.
Example The calculation with numbers
VAT on the fee (example 14%): 14% · Today's buying price, same karat (example): 7,009.37
| Date | Amount | Selling price per gram that day | Would have bought (g) | Worth today | Difference from the amount |
|---|---|---|---|---|---|
| Example: January | 20,000.00 | 5,200.00 | 3.772 | 26,437.48 | 6,437.48 |
| Example: April | 20,000.00 | 5,750.00 | 3.417 | 23,953.01 | 3,953.01 |
| Example: July | 20,000.00 | 6,300.00 | 3.124 | 21,895.39 | 1,895.39 |
| Result | Value |
|---|---|
| Total amounts | 60,000.00 |
| Would have bought (g) | 10.313 |
| Worth today | 72,285.88 |
| Difference | 12,285.88 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
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.
Read more
- What if the money had been gold? Doing the sum rightA step-by-step guide with a worked example.
- What if it had been gold? Comparison calculatorThe same sheet online, with today's prices.
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. 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
- Gold savings goal: how much to put aside each monthI want to reach a set number of grams in a set time. How much should I save each month?
- 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?