# Buying at price levels: your average cost

> Calculator for buying gold at several price levels: the cost of each level with the fee and VAT, the running totals and your average cost per gram.

Source: https://qintar.app/en/tools/buy-sell-levels-plan.html
Language: English
قنطار (Qintar)، qintar.app

---

If I split my buying over several prices, what will my average cost be?

Instead of buying all at once, you can split your buying over more than one price. This sheet works out your average cost if you buy at the levels you set. This calculator is the same as the ["Buying gold at several price levels" sheet](https://qintar.app/en/sheets/buy-sell-levels-plan.html). It runs in your browser and saves no data.

## Who this calculator is for

This is the online version of the "Buying gold at several price levels" sheet, made for individuals. A sheet for a buying plan split over price levels you choose: the grams at each level, the cost including the fee and its VAT, the running totals, the average cost per gram, and a comparison with today's price.

The question it answers: If I split my buying over several prices, what will my average cost be?

## How to use it

1. **Fee and price:** The fee per gram, its VAT and today's price.
2. **The levels:** Each price and how many grams you would buy at it.
3. **The cost:** The sheet works out the cost of each level.
4. **The average:** The average cost per gram up to each level.
5. **Compare:** The difference from today's price.

## Worked example

Fee per gram (example): 90.00 · VAT on the fee (example 14%): 14% · Today's selling price per gram (example): 7,032.37

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

| Result | Value |
| --- | --- |
| Total grams | 20.000 |
| Total cost | 137,425.15 |
| Average cost per gram | 6,871.26 |

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

- Cost of a level = grams × (price at the level + fee × (1 + VAT)).
- Average cost up to a level = cost so far ÷ grams so far.
- You type the levels and their prices: a scenario for the arithmetic, not a forecast of the price.

## Terms used on this sheet

- **Price level:** A price you decide in advance to buy at, with a set number of grams.
- **Average cost:** Everything you paid, fees and VAT included, divided by all the grams you bought.
- **Bar fee:** The fee per gram a shop charges on a gold bar, with 14% VAT on the fee only.
- **Selling price:** The price at which a shop sells you a gram of gold. It is above the price the shop pays when it buys from you.

Want to keep your work? [Download the sheet as Excel or PDF](https://qintar.app/en/sheets/buy-sell-levels-plan.html). For a step-by-step explanation: [Buying gold at price levels: your average cost per gram](https://qintar.app/en/articles/gold-buy-levels.html).

## Frequently asked questions

**Does the sheet tell me the price will fall?**

No. The levels are a scenario you type to see the arithmetic. They are not a forecast.

**What if the price never reaches a level?**

Then that level is not bought. Delete the line, or keep it and set its grams to zero.

**Can I get an alert at a price?**

Yes. In the Qintar app you can set an alert for when the price reaches a figure you choose.

**Why is the fee counted with VAT?**

In Egypt, VAT of 14% is charged on the fee or making charge, not on the gold. The fee and its VAT are part of what each gram really costs you.

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling.

## Related calculators

- [Entry cost compared: bar, gold pound or jewelry](https://qintar.app/en/tools/gold-entry-cost-compare.html)For which option must the price rise the least before I get my money back?
- [Gold trade journal: realized and on paper](https://qintar.app/en/tools/gold-trade-journal.html)How much did I gain or lose on each gold trade I closed? And what are the ones I still hold worth?
- [Local versus world gold price calculator](https://qintar.app/en/tools/local-premium-tracker.html)By what percentage is the gold price in Egypt above the world price?
- [Gold bar price comparison: price per gram and premium](https://qintar.app/en/tools/bar-prices-compare.html)Bars of the same weight: which offer is cheapest per gram, and which has the smallest buy-back gap?
- [What if it had been gold? Comparison calculator](https://qintar.app/en/tools/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 calculators](https://qintar.app/en/tools/) · [All free sheets](https://qintar.app/en/sheets/)
