| Author |
 Topic  |
|
|
the_cent_guy
Penny Pincher Member
USA
114 Posts |
 Posted - 07/03/2008 : 17:38:03
|
Does anyone know the calculations for copper content of a Canadian cent?
If you go on Coinflation, it'll show US calculations, but not Canadian.. This will be very useful to me as I'm keeping an inventory on an excel sheet.
Thanks in advance!
Also, if anyone is interested in looking at the sheet after it's done, let me know. I'll either post a link or send it via email.
|
"It's funny,you know me and the boys are talking about what to do with all this extra coin. And I was like.. I'm renting a clown.. Ha, and I did! Bobo here.. And uh.. I really underestimated the creepiness.."
http://www.youtube.com/watch?v=gdfvWAp5GUw
Copper Cents For Sale:
http://tinyurl.com/5ec4mp |
|
|
jorhyne
Penny Pincher Member
174 Posts |
|
|
the_cent_guy
Penny Pincher Member
USA
114 Posts |
Posted - 07/03/2008 : 18:10:47
|
Maybe I should have been more specific, I need the calculations to find the value of the content, not the content itself. For example, the calculators on Coinflation.. When the guy who runs the site updates the PM price, the value changes. That's what I want to do with my excel sheet.
if you go here:
You must be logged in to see this link.
it shows how he breaks it down.
THAT'S what I'm looking for, but Canadian style.
Oh, and Jordan, you can't trust wikipedia
|
"It's funny,you know me and the boys are talking about what to do with all this extra coin. And I was like.. I'm renting a clown.. Ha, and I did! Bobo here.. And uh.. I really underestimated the creepiness.."
http://www.youtube.com/watch?v=gdfvWAp5GUw
Copper Cents For Sale:
http://tinyurl.com/5ec4mp |
 |
|
|
jadedragon
Administrator
Canada
3788 Posts |
Posted - 07/03/2008 : 18:52:46
|
First I assume you only care about the Canadian Copper Pennies.
The calculation is just like the Coinflation one for US Coppers. In fact, there is a page that shows the Canadian Penny (and other coin) values at Coinflation.com/canada. I believe the reasons the site does not show the same detailed calculation is that you must factor in a currency conversion factor to come up with a percentage of face - and the creater did not put in that extra step - just left the values in US$. Second reason is that there are multiple compositions of Cdn pennies and each takes a slightly differant calculation so he did not put up so many pages to support each date range.
$3.9844 = copper price / pound on Jul 03, 2008.
.98 = copper % (forget the near worthless tin/zinc 2%)
3.24 g (up to 1979 anyway... newer pennies are lighter so substitute the correct values
.00220462262 = pound/gram conversion factor
Calculate 98% copper value (forget the tin/zinc value):
(3.9844 ื .00220462262 ื 3.24 ื .98) = $0.0278912691 = current copper melt value of a 3.24 g 98% Cu Cdn penny
At today's Cu price Coinflation lists $0.0279745 and $0.0279046 reflecting the value of the tin/zinc in the pre 1980 pennies.
And in this case the wikipedia info matches my Huxby book for the copper years (actually it looks like its based on Huxby) so it should be ok to use. The 2000+ info is correct for the Plated steel pennies but misses the fact that many pennies are actually zinc based even in 2008. The Canadian Nickel wiki page has a similar problem in the 2000+ composition. |
The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. George Bernard Shaw.
Why Copper Bullion ~~~ Interview with Silver Bullion Producer Market Harmony
Passive Income blog |
|
|
|
the_cent_guy
Penny Pincher Member
USA
114 Posts |
Posted - 07/03/2008 : 19:17:21
|
Thanks for your help!
Yes, that is exactly what I'm looking for, and I understand the 4 different year types based on the composition.. So the calculation you provided, is that only for the 42-77? I took it as if you were saying that it goes for the 78-79 as well, but Coinflation shows a slight difference.
Anyway to find the exact calculation for each year so I can do some copy and paste action? I'm pretty lazy after work and going through as many pennies as I did this week.. I just want to watch my PayPal account grow! Hahaha |
"It's funny,you know me and the boys are talking about what to do with all this extra coin. And I was like.. I'm renting a clown.. Ha, and I did! Bobo here.. And uh.. I really underestimated the creepiness.."
http://www.youtube.com/watch?v=gdfvWAp5GUw
Copper Cents For Sale:
http://tinyurl.com/5ec4mp |
|
|
|
the_cent_guy
Penny Pincher Member
USA
114 Posts |
Posted - 07/03/2008 : 19:19:13
|
So if you know the EXACT calculations for the copper ones quote this with an edit to show the break down..
1942-1977:
1978-1979:
1980-1981:
1982-1996:
Thanks again to anyone/everyone who helps! |
"It's funny,you know me and the boys are talking about what to do with all this extra coin. And I was like.. I'm renting a clown.. Ha, and I did! Bobo here.. And uh.. I really underestimated the creepiness.."
http://www.youtube.com/watch?v=gdfvWAp5GUw
Copper Cents For Sale:
http://tinyurl.com/5ec4mp |
|
|
|
jorhyne
Penny Pincher Member
174 Posts |
Posted - 07/03/2008 : 21:57:55
|
Lol Zach,
Thats exactly what everyone tells me about Wikipedia, yet I've never found anything to be inaccurate on there!
Anywho, check your PMs...I've been shopping around for deals on coin bags. |
Pennies For Sale: http://tiny.cc/jorhynespennies |
|
|
|
jadedragon
Administrator
Canada
3788 Posts |
Posted - 07/04/2008 : 02:01:48
|
From wikipedia:
19821996 2.5 g 19.1 mm, 12-sided 98% copper, 1.75% tin, 0.25% zinc
19801981 2.8 g 19.0 mm, round 98% copper, 1.75% tin, 0.25% zinc
19781979 3.24 g 19.05 mm, round 98% copper, 1.75% tin, 0.25% zinc
19421977 3.24 g 19.05 mm, round 98% copper, 0.5% tin, 1.5% zinc
19201941 3.24 g 19.05 mm, round 95.5% copper, 3% tin, 1.5% zinc
Example formula: (3.9844 ื .00220462262 ื 3.24 ื .98) = $0.0278912691 = current copper melt value of a 3.24 g 98% Cu Cdn penny
Where:
Current Copper Price = 3.9844 per pound
X .00220462262 (pound to gram conversion factor always this number)
X Weight of 1 penny (3.24 or 2.8 or 2.5g depending on year)
X %pureCu (either .98 for 1942-1996 or .955 for 1920-1941)
= current melt value per specified penny
Today Coinflation lists Canadian pennies as:
1942 - 1977 Cent $0.0279745
1978 - 1979 Cent $0.0279046 exact same Cu value as 42-77
1980 - 1981 Cent $0.0241150
1982 - 1996 Cent $0.0215311
1997 - 1999 Cent $0.0041413 basically Zinc value only so ignore
With a note that they exclude tin values.
I just showed you how to calculate 1920 - 1941 as well and to combine the 1942-1977 and the 1978-1979 together.
Things to remember:
1. Cu price is variable - I used today's value but you want to be able to put the current CU price in one cell and referance that one cell with all your calculations.
2. Coinflation calculates the value of the zinc but ignores the tin. Note the amount of tin increased while zinc content decreased in 1978, but Copper % and total weight stayed the same. Therefore Coinflation figures that the 1978 penny is worth a little less then the 1977 penny due to less zinc content.
My example calculation ignores both the tin and the zinc value since tin and zinc are worth so little in a 98% Cu penny and the zinc is really a contaminate to remove/burn off. Therefore for our purposes the 1942-1979 pennies are all worth the same. |
The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man. George Bernard Shaw.
Why Copper Bullion ~~~ Interview with Silver Bullion Producer Market Harmony
Passive Income blog |
|
|
| |
Topic |
|
Canadian Calculations
Forum Locked
