Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Inherited gold: split the value by the shares you type

Inherited gold: split the value by the shares you type

Free sheet for individuals · If the shares are known from the official document, what is each person's share of the gold's value worth?

Once the shares are known from the official document, one arithmetic question remains: what is each person's share of the gold worth? This sheet works that out, and nothing more.

Important: this sheet is only a calculator. It does not decide who inherits or anyone's share, and it is not a fatwa or legal advice. Type the shares exactly as they appear in the official document (the heirs' certificate or a court ruling) or as set by a competent authority. The actual division of the pieces is made by agreement among the heirs or by a court ruling, and the value at today's buying price is an estimate.

Download PDF141 KBDownload Excel61 KB

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.

Preview of the first page of the "Inherited gold: split the value by the shares you type" sheet, with the table and the worked example

How to use it

  1. The gold: The weight of each karat and today's buying price per gram.
  2. The shares: Each name with its share as a numerator and denominator, from the official document.
  3. The value: The sheet works out the value of each share.
  4. The equivalent: How many grams of 21K each share is worth.
  5. The check: The shares must add up to 1.

Example The calculation with numbers

24K gold weight, g (example): 10.000 · 21K gold weight, g (example): 120.000 · 18K gold weight, g (example): 30.000 · Buying price, 1 g of 24K (example): 7,009.37 · Buying price, 1 g of 21K (example): 6,160.25 · Buying price, 1 g of 18K (example): 5,259.00

NameShare: numerator (from the document)Share: denominator (from the document)ShareValue of the share (estimate)Equals 21K (g)
Example: heir 1180.1250120,886.7119.624
Example: heir 27240.2917282,069.0045.789
Example: heir 37240.2917282,069.0045.789
Example: heir 47240.2917282,069.0045.789
ResultValue
Estimated value of all the gold967,093.70
Sum of the shares1.0000
CheckThe shares add up to 1
Sum of the share values967,093.70

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

The calculation

Terms used on this sheet

Heirs' certificate
The official document in Egypt that names the heirs and their shares (إعلام الوراثة). The shares in the sheet come from it, or from a court ruling.
Share
The fraction of the estate a person receives, written as a numerator over a denominator, such as 1/8.
Buying price
The price at which a shop buys gold. It is used here as an estimate of what the gold would fetch today.

Read more

Frequently asked questions

Does the sheet work out what each heir gets?

No. The sheet does not decide who inherits or anyone's share. You type the shares from the heirs' certificate, a court ruling or a competent authority.

Is this a fatwa or legal advice?

No. It is a calculator that divides a figure by shares you type. For any religious question, ask a fatwa authority you trust; for any legal question, ask a lawyer.

Why value the gold at the buying price?

Because it is the closest price to what the gold would fetch if it were sold today. The actual division of the pieces is agreed among the heirs.

What if the shares do not add up to 1?

The check line says so. Go back to the document and compare each share as you typed it; a numerator or denominator typed wrongly is the usual reason.

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.

More free sheets

All free sheets