# Comparing gold bar prices between sellers | Free sheet

> Free Excel and PDF sheet to compare gold bar offers: price per gram, the premium over today's 24K price, and the buy-back gap where it is published.

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

---

# Comparing gold bar prices between sellers

Free sheet for individuals · Bars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?

You can find the same 10 g bar at several prices. This sheet puts the offers side by side: the price per gram, how far it is above today's price, and the gap if you sold it back to the same seller.

[Download PDF131 KB](https://qintar.app/en/sheets/bar-prices-compare.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/bar-prices-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/bar-prices-compare.html).

![Preview of the first page of the "Comparing gold bar prices between sellers" sheet, with the table and the worked example](https://qintar.app/en/sheets/bar-prices-compare.png)

## How to use it

1. **The reference price:** Today's selling price for one gram of 24K.
2. **The offers:** The seller, the weight and the total price.
3. **Buy-back:** If the seller publishes a buy-back price.
4. **Compare:** The price per gram and the premium.
5. **The gap:** The gap between the selling and the buy-back price.

## Example The calculation with numbers

Selling price, 1 g of 24K today (example): 7,032.37

| Seller / shop | Weight (g) | Total price quoted | Price per gram | Above today's gram price | Premium % | Gap between selling and buy-back, per gram |
| --- | --- | --- | --- | --- | --- | --- |
| Example: Offer A | 10.000 | 72,400.00 | 7,240.00 | 207.63 | 3.0% | 230.63 |
| Example: Offer B | 10.000 | 73,100.00 | 7,310.00 | 277.63 | 3.9% | 290.00 |
| Example: Offer C | 10.000 | 71,950.00 | 7,195.00 | 162.63 | 2.3% |  |

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

## The calculation

- Price per gram = total price ÷ weight.
- Premium = price per gram − today's 24K selling price per gram (and as a percentage).
- Gap = price per gram − the published buy-back price: what you would lose if you sold straight back.

## Terms used on this sheet

- **Premium:** How far the price per gram of a bar is above the day's 24K gram price. It mostly reflects the bar fee and its VAT.
- **Buy-back price:** The price per gram at which a seller says it will buy its own bars back.
- **Bar fee:** The fee per gram on a gold bar. In the usual figures (3 November 2026) it is EGP 90 a gram on a 10 g bar, and higher on smaller bars.

## Read more

- [Comparing gold bar offers: which one is really cheaper](https://qintar.app/en/articles/compare-gold-bar-offers.html)A step-by-step guide with a worked example.
- [Gold bar price comparison: price per gram and premium](https://qintar.app/en/tools/bar-prices-compare.html)The same sheet online, with today's prices.

## Frequently asked questions

**Does the sheet compare quality or the hallmark?**

No. It compares the figures only. Check the hallmark, the invoice and the seller's reputation yourself.

**Why is there a premium at all?**

The total price includes the bar fee and its VAT, and sometimes other charges. A premium over the gram price is normal; what matters is comparing it.

**What if the seller doesn't publish a buy-back price?**

Leave the cell empty. The sheet then compares the price per gram and the premium only.

**Is a lower price per gram always the better deal?**

Not on its own. An offer with no published buy-back price may cost more to sell later. The sheet shows both figures so you can weigh them.

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

- [Gold savings goal: how much to put aside each month](https://qintar.app/en/sheets/gold-goal-planner.html)I 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 it](https://qintar.app/en/sheets/family-gold-register.html)How many grams of gold does the family own, who holds them, and what are they worth?
- [What if it had been gold? Comparing in figures](https://qintar.app/en/sheets/gold-vs-cash-log.html)The amounts I saved in cash: had I bought gold with them at the time, what would they be worth today?

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