melt - Google Sheets

	C	D	E	I	J	K
1
2
3	US GOLD COINS	OUNCES	VALUE	US SILVER COINS	OUNCES	VALUE
4	Dollar ($1.00)	0.05	$194.65	Wartime Nickel (1942-1945)	0.06	$2.76
5	Quarter Eagle ($2.50)	0.12	$486.63	Dime	0.07	$3.55
6	Three Dollar ($3.00)	0.15	$583.83	Quarter	0.18	$8.58
7	Half Eagle	0.24	$973.25	Half Dollar	0.36	$17.73
8	Eagle	0.48	$1,946.27	Half Dollar (40% 1965-1970)	0.15	$7.25
9	Double Eagle	0.97	$3,892.54	Silver Dollar	0.77	$37.92
10				Silver Eagle	1.00	$49.22
11	US GOLD BULLION	OUNCES	VALUE
12	5.00	0.10	$402.33	CANADA SILVER COINS	OUNCES	VALUE
13	10.00	0.25	$1,005.82	Dime (1920-1967)	0.06	$2.94
14	20.00	0.50	$2,011.63	Dime (1967)	0.04	$1.84
15	50.00	1.00	$4,023.26	Quarter (1920-1967)	0.15	$7.35
16				Quarter (1967-1968)	0.09	$4.59
17	CANADA GOLD COINS	OUNCES	VALUE	Half Dollar (1920-1967)	0.30	$14.70
18	5.00	0.24	$973.25	Dollar (1935-1967)	0.60	$29.28
19	10.00	0.48	$1,946.50
20	20.00 (1967)	0.53	$2,126.95	UK pre-1920 SILVER COINS	OUNCES	VALUE
21	100.00 (1976 = 14kt)	0.25	$1,005.85	Sixpence	0.08	$4.12
22	100.00 (1976 = 24kt)	0.50	$2,012.33	Shilling	0.17	$8.25
23				Florin	0.34	$16.49
24	CANADA GOLD BULLION	OUNCES	VALUE	Halfcrown	0.42	$20.61
25	1.00	0.05	$201.14
26	2.00	0.07	$267.76	UK post-1920 SILVER COINS	OUNCES	VALUE
27	5.00	0.10	$405.00	Sixpence	0.05	$2.23
28	10.00	0.25	$1,008.56	Shilling	0.09	$4.46
29	20.00	0.50	$2,014.67	Florin	0.18	$8.91
30	50.00	1.00	$4,029.34	Halfcrown	0.23	$11.14
31
32	UK GOLD COINS	OUNCES	VALUE
33	Half Sovereign	0.12	$474.78	Silver (AMEX:SLV)	SLV	$45.30
34	Sovereign	0.24	$945.47	GOLD ETF (NYSE:GLD)	GLD	$374.27
35	Double Sovereign	0.47	$1,894.98	GOLD ETF (AMEX:IAU)	IAU	$76.61
36	Five Pounds	1.18	$4,751.78
37				((GLD10)+(IAU50))/2		$3,786.60
38
39	Bob Johnson
40	http://www.coinsheetlinks.com			ETFs trade at a discount to spot
41				Added to SLV for better estimate	8.22%	49.02
42				Added to GLD for better estimate	6.25%	4023.26
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96