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	$55.36	Wartime Nickel (1942-1945)	0.06	$0.76
5	Quarter Eagle ($2.50)	0.12	$138.40	Dime	0.07	$0.98
6	Three Dollar ($3.00)	0.15	$166.05	Quarter	0.18	$2.38
7	Half Eagle	0.24	$276.80	Half Dollar	0.36	$4.92
8	Eagle	0.48	$553.54	Half Dollar (40% 1965-1970)	0.15	$2.01
9	Double Eagle	0.97	$1,107.07	Silver Dollar	0.77	$10.51
10				Silver Eagle	1.00	$13.65
11	US GOLD BULLION	OUNCES	VALUE
12	5.00	0.10	$114.43	CANADA SILVER COINS	OUNCES	VALUE
13	10.00	0.25	$286.06	Dime (1920-1967)	0.06	$0.81
14	20.00	0.50	$572.13	Dime (1967)	0.04	$10.72
15	50.00	1.00	$1,144.25	Quarter (1920-1967)	0.15	$2.04
16				Quarter (1967-1968)	0.09	$1.27
17	CANADA GOLD COINS	OUNCES	VALUE	Half Dollar (1920-1967)	0.30	$4.08
18	5.00	0.24	$276.80	Dollar (1935-1967)	0.60	$8.12
19	10.00	0.48	$553.60
20	20.00 (1967)	0.53	$604.92	UK pre-1920 SILVER COINS	OUNCES	VALUE
21	100.00 (1976 = 14kt)	0.25	$286.07	Sixpence	0.08	$1.14
22	100.00 (1976 = 24kt)	0.50	$572.32	Shilling	0.17	$2.29
23				Florin	0.34	$4.57
24	CANADA GOLD BULLION	OUNCES	VALUE	Halfcrown	0.42	$5.71
25	1.00	0.05	$57.21
26	2.00	0.07	$76.15	UK post-1920 SILVER COINS	OUNCES	VALUE
27	5.00	0.10	$115.19	Sixpence	0.05	$0.62
28	10.00	0.25	$286.84	Shilling	0.09	$1.24
29	20.00	0.50	$572.99	Florin	0.18	$2.47
30	50.00	1.00	$1,145.98	Halfcrown	0.23	$3.09
31
32	UK GOLD COINS	OUNCES	VALUE
33	Half Sovereign	0.12	$135.03	Silver (AMEX:SLV)	SLV	$13.59
34	Sovereign	0.24	$268.90	GOLD ETF (NYSE:GLD)	GLD	$113.65
35	Double Sovereign	0.47	$538.95	GOLD ETF (AMEX:IAU)	IAU	$11.52
36	Five Pounds	1.18	$1,351.45	AVERAGE		$114.43
37				TIMES 10		$1,144.25
38
39	Bob Johnson
40	http://www.coinsheetlinks.com			ETFS trade at a discount to spot
41				Estimated values are lower than melt
42
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
97