Open calculator ↗

Physical bullion versus fund cost of ownership · Calculation guide

Compare net sale proceeds for physical bullion and a fund.

Calculation guide

Both start with the same cash and follow the same annual metal return. A dealer premium reduces metal purchased. Physical storage is paid separately at a fixed annual amount; a fund expense ratio reduces value annually. Ignore tax, distributions and tracking error.

difference = cash*((1+growth/100)*(1-expense/100))^years-(cash/(1+premium/100)*(1+growth/100)^years*(1-sale/100)-storage*years); physical = cash/(1+premium/100)*(1+growth/100)^years*(1-sale/100)-storage*years; fund = cash*((1+growth/100)*(1-expense/100))^years

Inputs

Starting cash

Example entry 10000 (in the selected currency).

Dealer buying premium over spot

Example entry 10 %. Allowed range 0 to 100.

Dealer selling discount to spot

Example entry 2 %. Allowed range 0 to 100.

Annual physical storage cost

Example entry 50 (in the selected currency).

Annual fund expense ratio

Example entry 1 %. Allowed range 0 to 100.

Annual metal return (%)

Example entry 0.

Holding years

Example entry 2. Allowed range 0 to 100. Use whole numbers.

Worked example

InputValue
Starting cash10,000
Dealer buying premium over spot10%
Dealer selling discount to spot2%
Annual physical storage cost50
Annual fund expense ratio1%
Annual metal return (%)0
Holding years2
ResultValue
Fund advantage over bullion991.909091
Net bullion proceeds after storage8,809.090909
Net fund proceeds9,801

Calculation steps

Fund advantage over bullion = ((Starting cash × (((1 + (Annual metal return (%) ÷ 100)) × (1 − (Annual fund expense ratio ÷ 100))) ^ Holding years)) − ((((Starting cash ÷ (1 + (Dealer buying premium over spot ÷ 100))) × ((1 + (Annual metal return (%) ÷ 100)) ^ Holding years)) × (1 − (Dealer selling discount to spot ÷ 100))) − (Annual physical storage cost × Holding years)))

((10,000 × (((1 + (0 ÷ 100)) × (1 − (1 ÷ 100))) ^ 2)) − ((((10,000 ÷ (1 + (10 ÷ 100))) × ((1 + (0 ÷ 100)) ^ 2)) × (1 − (2 ÷ 100))) − (50 × 2))) = 991.909091

Net bullion proceeds after storage = ((((Starting cash ÷ (1 + (Dealer buying premium over spot ÷ 100))) × ((1 + (Annual metal return (%) ÷ 100)) ^ Holding years)) × (1 − (Dealer selling discount to spot ÷ 100))) − (Annual physical storage cost × Holding years))

((((10,000 ÷ (1 + (10 ÷ 100))) × ((1 + (0 ÷ 100)) ^ 2)) × (1 − (2 ÷ 100))) − (50 × 2)) = 8,809.090909

Net fund proceeds = (Starting cash × (((1 + (Annual metal return (%) ÷ 100)) × (1 − (Annual fund expense ratio ÷ 100))) ^ Holding years))

(10,000 × (((1 + (0 ÷ 100)) × (1 − (1 ÷ 100))) ^ 2)) = 9,801

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Starting cash10,00011,000Fund advantage over bullion991.9090911,081.1
Dealer buying premium over spot10%11%Fund advantage over bullion991.9090911,072.171171
Dealer selling discount to spot2%3%Fund advantage over bullion991.9090911,082.818182
Annual physical storage cost5055Fund advantage over bullion991.9090911,001.909091
Annual fund expense ratio1%2%Fund advantage over bullion991.909091794.909091
Annual metal return (%)01Fund advantage over bullion991.9090911,009.836464
Holding years23Fund advantage over bullion991.909091943.899091
Physical bullion versus fund cost of ownership →