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.
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
| Input | Value |
|---|---|
| Starting cash | 10,000 |
| Dealer buying premium over spot | 10% |
| Dealer selling discount to spot | 2% |
| Annual physical storage cost | 50 |
| Annual fund expense ratio | 1% |
| Annual metal return (%) | 0 |
| Holding years | 2 |
| Result | Value |
|---|---|
| Fund advantage over bullion | 991.909091 |
| Net bullion proceeds after storage | 8,809.090909 |
| Net fund proceeds | 9,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.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Starting cash | 10,000 | 11,000 | Fund advantage over bullion | 991.909091 | 1,081.1 |
| Dealer buying premium over spot | 10% | 11% | Fund advantage over bullion | 991.909091 | 1,072.171171 |
| Dealer selling discount to spot | 2% | 3% | Fund advantage over bullion | 991.909091 | 1,082.818182 |
| Annual physical storage cost | 50 | 55 | Fund advantage over bullion | 991.909091 | 1,001.909091 |
| Annual fund expense ratio | 1% | 2% | Fund advantage over bullion | 991.909091 | 794.909091 |
| Annual metal return (%) | 0 | 1 | Fund advantage over bullion | 991.909091 | 1,009.836464 |
| Holding years | 2 | 3 | Fund advantage over bullion | 991.909091 | 943.899091 |
