# Entry cost compared: bar, gold pound or jewelry

> Free Excel and PDF sheet comparing the cost of buying gold as a bar, a gold pound or jewelry, and the price rise needed for each to break even.

Source: https://qintar.app/en/sheets/gold-entry-cost-compare.html
Language: English
قنطار (Qintar)، qintar.app

---

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 KB](https://qintar.app/en/sheets/gold-entry-cost-compare.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/gold-entry-cost-compare.xlsx)

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](https://qintar.app/en/tools/gold-entry-cost-compare.html).

![Preview of the first page of the "Entry cost compared: bar, gold pound or jewelry" sheet, with the table and the worked example](https://qintar.app/en/sheets/gold-entry-cost-compare.png)

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

| Option | Weight (g) | Total cost | You get back if you sell today | Gap | Rise needed in the buying price, per gram | Rise needed % |
| --- | --- | --- | --- | --- | --- | --- |
| Example: 1 g 24K bar | 1.000 | 7,271.77 | 7,009.37 | 262.40 | 262.40 | 3.7% |
| Example: 10 g 24K bar | 10.000 | 71,349.70 | 70,093.70 | 1,256.00 | 125.60 | 1.8% |
| Example: gold pound (8 g of 21K) | 8.000 | 49,989.20 | 49,282.00 | 707.20 | 88.40 | 1.4% |
| Example: 21K chain | 10.000 | 63,512.50 | 60,986.48 | 2,526.03 | 255.15 | 4.1% |

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

## The calculation

- Cost = weight × (selling price + fee per gram × (1 + VAT)).
- You get back = weight × buying price × (1 − deduction).
- Rise needed per gram = (cost − what you get back) ÷ (weight × (1 − deduction)).

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

- [The entry cost of gold: why the price must rise first](https://qintar.app/en/articles/gold-entry-cost.html)A step-by-step guide with a worked example.
- [Entry cost compared: bar, gold pound or jewelry](https://qintar.app/en/tools/gold-entry-cost-compare.html)The same sheet online, with today's prices.

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

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

## More free sheets

- [End-of-day cash close for a gold shop](https://qintar.app/en/sheets/shop-cash-close.html)Does the cash in the drawer match what should be there, or is there a gap?
- [Credit sales book: what each customer owes](https://qintar.app/en/sheets/shop-credit-book.html)How much does each customer owe, how much have they paid, and what is left?
- [Scrap gold and refining: from scrap to pure gold](https://qintar.app/en/sheets/shop-scrap-refining.html)How many grams of pure gold are in my scrap, and how much comes back after refining?

[All free sheets](https://qintar.app/en/sheets/)
