Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Gold position calculator: net gold and net cash

Gold position calculator: net gold and net cash

After everything owed to me and everything I owe, what is my net gold and net cash?

A shop has gold in the window and with the craftsman, owes gold to the wholesaler, holds cash and owes cash. This sheet adds it all up and shows the net. This calculator is the same as the "Gold position: is the shop long in gold or in cash?" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

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

ItemGold you hold or are owed (g pure)Gold you owe (g pure)Cash you hold or are owedCash you oweNet of the item, EGPDelete

Result

Who this calculator is for

This is the online version of the "Gold position: is the shop long in gold or in cash?" sheet, made for goldsmiths and shop owners. A sheet that brings every item together: gold you hold or are owed (stock, with a craftsman, with customers), gold you owe (to the wholesaler, to customers), and cash both ways. It shows the net pure gold, the net cash, and the total at today's price.

The question it answers: After everything owed to me and everything I owe, what is my net gold and net cash?

How to use it

  1. The items: Everything you hold, are owed or owe, one line each.
  2. The gold: In grams of pure gold.
  3. The cash: In Egyptian pounds.
  4. The price: Today's buying price for 24K.
  5. The net: Net gold, net cash and the total.

Worked example

Buying price, 1 g of 24K (example): 7,009.37

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

ResultValue
Net gold (g pure)1,363.950
Net cash191,000.00
Net gold in EGP9,570,000.21
Total in EGP9,761,000.21
Gold as a share of the total98.0%

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

Position
What a shop holds and is owed, minus what it owes, kept separately for gold and for cash.
Pure gold
Weight × purity: 21K is 0.875 pure, 18K is 0.75 pure. Turning everything into pure gold lets karats add up.
Wholesaler
The trader or workshop that supplies jewelry to shops (تاجر الجملة). Shops often owe it gold as well as the making charge in cash.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A gold shop's position: finding net gold and net cash.

Frequently asked questions

Why work in pure gold?

So that gold of different karats adds up to one figure.

Is this the shop's balance sheet?

No. It is a summary of the position only, not financial statements. See your accountant for anything official.

Where do the figures come from?

From the stock count, craftsman, wholesaler, credit book and cash sheets.

Why does the gold share matter?

The higher the share of gold in the total, the more a move in the gold price changes what the shop is worth. The price move sheet shows by how much.

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