Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Entry cost compared: bar, gold pound or jewelry

Entry cost compared: bar, gold pound or jewelry

Free sheet for individuals · For which option must the price rise the least before I get my money back?

Every way of buying gold has an entry cost: the fee per gram and its VAT, the gap between the selling and buying prices, and sometimes a deduction when you sell. This sheet puts them side by side and shows how far the price must rise for each option before you are back where you started.

Download PDF138 KBDownload Excel60 KB

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.

Preview of the first page of the "Entry cost compared: bar, gold pound or jewelry" sheet, with the table and the worked example

How to use it

  1. The options: Type each option with its weight, selling price and fee per gram.
  2. The buying price: The price a goldsmith would pay you today.
  3. The deduction: If the goldsmith deducts a percentage when buying back, type it.
  4. The gap: The cost minus what you would get back if you sold at once.
  5. Rise needed: How far the price must rise for you to break even.

Example The calculation with numbers

VAT on the fee (example 14%): 14%

OptionWeight (g)Total costYou get back if you sell todayGapRise needed in the buying price, per gramRise needed %
Example: 1 g 24K bar1.0007,271.777,009.37262.40262.403.7%
Example: 10 g 24K bar10.00071,349.7070,093.701,256.00125.601.8%
Example: gold pound (8 g of 21K)8.00049,989.2049,282.00707.2088.401.4%
Example: 21K chain10.00063,512.5060,986.482,526.03255.154.1%

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

The calculation

Terms used on this sheet

Entry cost
What you lose if you buy and sell straight away: the fee and its VAT plus the gap between selling and buying prices.
Gold pound
A coin of 8 g of 21K gold (جنيه ذهب).
Bar fee
The fee per gram on a gold bar. In the usual figures it is higher per gram on small bars than on large ones.
Deduction
A percentage some goldsmiths take off when they buy back jewelry.

Read more

Frequently asked questions

Are the bar fees in the example fixed?

No. They are the usual figures used across Qintar's sheets (3 November 2026); current figures are in the calculators. Type the fee the goldsmith quotes you.

Is there always a deduction when you sell?

It differs from shop to shop and from piece to piece. If there is none, leave it at zero.

Does the sheet tell me what to buy?

No. It only shows the entry cost. Other things, such as whether you will wear it, and how easy it is to sell, are your decision.

What is a gold pound?

A gold coin of 8 g of 21K, sold in Egypt alongside bars and jewelry. It is one of the options in the example.

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

All free sheets