# Inherited gold: split the value by the shares you type

> Free Excel and PDF calculator that splits the estimated value of inherited gold by shares you type from the official document. Not a fatwa or legal advice.

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

---

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 KB](https://qintar.app/en/sheets/inherited-gold-split.pdf)[Download Excel61 KB](https://qintar.app/en/sheets/inherited-gold-split.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/inherited-gold-split.html).

![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](https://qintar.app/en/sheets/inherited-gold-split.png)

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

| Name | Share: numerator (from the document) | Share: denominator (from the document) | Share | Value of the share (estimate) | Equals 21K (g) |
| --- | --- | --- | --- | --- | --- |
| Example: heir 1 | 1 | 8 | 0.1250 | 120,886.71 | 19.624 |
| Example: heir 2 | 7 | 24 | 0.2917 | 282,069.00 | 45.789 |
| Example: heir 3 | 7 | 24 | 0.2917 | 282,069.00 | 45.789 |
| Example: heir 4 | 7 | 24 | 0.2917 | 282,069.00 | 45.789 |

| Result | Value |
| --- | --- |
| Estimated value of all the gold | 967,093.70 |
| Sum of the shares | 1.0000 |
| Check | The shares add up to 1 |
| Sum of the share values | 967,093.70 |

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

## The calculation

- Estimated value = weight of each karat × today's buying price per gram (no making charge).
- Share = numerator ÷ denominator, exactly as written in the official document.
- Value of a share = share × estimated value; equals 21K = value ÷ price of 1 g of 21K. The sheet does not decide shares.

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

- [Inherited gold: working out each share's value](https://qintar.app/en/articles/inherited-gold-calculator.html)A step-by-step guide with a worked example.
- [Inherited gold calculator: value of each share](https://qintar.app/en/tools/inherited-gold-split.html)The same sheet online, with today's prices.

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

[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

- [Buying gold at several price levels](https://qintar.app/en/sheets/buy-sell-levels-plan.html)If I split my buying over several prices, what will my average cost be?
- [Comparing suppliers: which making charge is cheaper?](https://qintar.app/en/sheets/shop-supplier-compare.html)For an order of a given weight, which supplier has the lowest real making charge after the discount?
- [Order production tracker: which stage ran late?](https://qintar.app/en/sheets/workshop-production-tracker.html)How many days did each order spend in each stage, and is it late against what was agreed?

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