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

Entry cost compared: bar, gold pound or jewelry

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. This calculator is the same as the "Entry cost compared: bar, gold pound or jewelry" sheet. It runs in your browser and saves no data.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

OptionWeight (g)Selling price per gramFee per gramToday's buying price per gramDeduction when selling % (%)Total costYou get back if you sell todayGapRise needed in the buying price, per gramRise needed %Delete

Who this calculator is for

This is the online version of the "Entry cost compared: bar, gold pound or jewelry" sheet, made for individuals. A sheet that compares ways of buying gold (bars of different weights, the gold pound, jewelry): the cost including the fee and its VAT, what you would get back if you sold today, and how much the price must rise for you to break even.

The question it answers: For which option must the price rise the least before I get my money back?

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.

Worked example

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

With the example figures in the table above (the rows marked "Example"), the calculator gives:

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%

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

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: The entry cost of gold: why the price must rise first.

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.

Related calculators

All calculators · All free sheets