# What if the money had been gold? Doing the sum right

> How to work out what cash savings would be worth had you bought gold at the time: grams at each day's price with fee and VAT, and today's value.

Source: https://qintar.app/en/articles/if-it-were-gold.html
Language: English
قنطار (Qintar)، qintar.app

---

The amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?

This comparison is often done wrong. People divide the amount by the gram price alone, forget the fee and its VAT, and value the gold at the selling price instead of the buying price.

The right way: divide each amount, on its own date, by that day's selling price plus the fee and its VAT. Then value the grams at today's buying price.

The result tells you what happened in one particular period, nothing more. Another period could give a different answer, and the sheet says nothing about what comes next.

You type the old prices from a source you trust. The price map in Qintar shows them by month and by year.

## Two prices on every day

Egyptian gold prices come in pairs: the selling price, which you pay, and the buying price, which you get when you sell. A fair look back buys at the first and values at the second.

On top of the selling price comes a fee per gram, with VAT of 14% on the fee only. That is why the sheet asks for the fee on every line: each purchase would have paid it.

## The example in plain words

Three amounts of EGP 20,000 were saved in January, April and July, when the selling price was EGP 5,200, 5,750 and 6,300 a gram, with a fee of EGP 90 a gram plus VAT. They would have bought 3.772 g, 3.417 g and 3.124 g.

At today's buying price of EGP 7,009.37, those grams are worth EGP 26,437.48, 23,953.01 and 21,895.39. Together, the EGP 60,000 would have bought 10.313 g, now worth EGP 72,285.88: EGP 12,285.88 more than the cash.

Note that the later the purchase, the smaller the difference. A period in which prices fell would show the opposite, which is why this is a record of the past and not a guide to the future.

## 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.

## Example A worked example

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. Type your own figures in the sheet or the calculator.

## 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.

## Step by step with the sheet

1. **The amounts:** Each amount with its date.
2. **That day's price:** From your own source, such as Qintar's price map.
3. **The fee:** The fee per gram and its VAT.
4. **Today's price:** The buying price for the same karat.
5. **The difference:** The value compared with the amount.

**The sheet is free:** [What if it had been gold? Comparing in figures](https://qintar.app/en/sheets/gold-vs-cash-log.html) (Excel and PDF), or [try it online](https://qintar.app/en/tools/gold-vs-cash-log.html) 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.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)
