Spreadsheet: 144764d1331130918-changing-table-array-size-in-vlookup-automatically-ef-sample
Sheet: Balance Sheet

Balance Sheet
Balance Sheet as of: | Restated Dec-31-2003 | Restated Dec-31-2004 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | Press Release Dec-31-2011
Currency | USD | USD | USD | USD | USD | USD | USD | USD | USD
ASSETS
Cash And Equivalents | 1.390641 | 1.88851 | 1.076489 | 3.838172 | 4.987991 | 5.224564 | 6.519065 | 6.601416 | 7.853
Total Cash & ST Investments | 1.390641 | 1.88851 | 1.076489 | 3.838172 | 4.987991 | 5.224564 | 6.519065 | 6.601416 | 7.853
Accounts Receivable | 6.795212 | 8.884807 | 9.391546 | 10.852037 | 12.726647 | 10.564097 | 10.703433 | 12.330665 | 12.904
Total Receivables | 6.795212 | 8.884807 | 9.391546 | 10.852037 | 12.726647 | 10.564097 | 10.703433 | 12.330665 | 12.904
Inventory | 8.179081 | 8.389228 | 12.530454 | 15.677294 | 18.934977 | 21.769304 | 17.40027 | 22.292909 | 24.495
Prepaid Exp. | 0.259972 | 0.484532 | 0.541991 | 0.84564 | 1.149417 | 0.879222 | 0.952946 | 1.195613 | 1.27
Deferred Tax Assets, Curr. | 0.286213 | 0.279201 | 0.324919 | 0.273919 | 0.061127 | 0.209172 | 0.180241 | 0.206732 | -
Other Current Assets | - | - | - | - | - | - | - | - | -
Total Current Assets | 16.911119 | 19.926278 | 23.865399 | 31.487062 | 37.860159 | 38.646359 | 35.755955 | 42.627335 | 46.522
Gross Property, Plant & Equipment | 8.650906 | 9.14878 | 9.631091 | 9.94272 | 11.196674 | 10.137306 | 10.899873 | 11.503153 | -
Accumulated Depreciation | -6.3 | -6.9 | -6.8 | -7.4 | -8.7 | -7.9 | -8.8 | -9.3 | -
Net Property, Plant & Equipment | 2.384791 | 2.295431 | 2.78604 | 2.540045 | 2.479358 | 2.269443 | 2.088168 | 2.215756 | 2.506
Goodwill | 0.088828 | 0.088828 | 0.088828 | 0.088828 | 0.088828 | - | - | - | -
Other Intangibles | 0.358272 | 0.656182 | 0.857612 | 0.877796 | 1.65888 | 1.845391 | 1.863648 | 1.866231 | -
Loans Receivable Long-Term | - | - | - | - | - | 2 | 1.891604 | 1.839262 | -
Deferred Tax Assets, LT | - | - | 0.596087 | 0.027235 | 0.135168 | 0.574051 | 0.62127 | 0.943606 | -
Other Long-Term Assets | - | - | - | - | - | 0.088828 | 0.088828 | 0.088828 | 6.194
Total Assets | 19.74301 | 22.966719 | 28.193966 | 35.020966 | 42.222393 | 45.424072 | 42.309473 | 49.581018 | 55.222
LIABILITIES
Accounts Payable | 1.742655 | 2.31648 | 2.174051 | 2.357715 | 4.575118 | 3.668689 | 3.546139 | 5.67891 | 4.935
Accrued Exp. | 2.214605 | 4.68236 | 5.35625 | 3.660252 | 3.907194 | 5.15799 | 3.257062 | 3.538649 | -
Short-term Borrowings | 0.141113 | - | - | - | - | - | - | - | -
Curr. Port. of LT Debt | 2.035349 | - | 0.01 | 0.008517 | - | - | - | - | -
Other Current Liabilities | - | - | - | - | - | - | - | - | 3.77
Total Current Liabilities | 6.133722 | 6.99884 | 7.540301 | 6.026484 | 8.482312 | 8.826679 | 6.803201 | 9.217559 | 8.705
Long-Term Debt | 2.75196 | 1.433936 | 5.577382 | 10.217931 | 10.186721 | 11.719 | 9.154 | 13.522 | 17.568
Pension & Other Post-Retire. Benefits | - | - | - | - | - | 0.077833 | 0.258693 | 0.215703 | -
Def. Tax Liability, Non-Curr. | 0.155829 | 0.131228 | 0.140774 | - | - | - | - | - | -
Other Non-Current Liabilities | 0.522875 | 0.420251 | 0.870515 | 0.645192 | 0.506617 | 1.912897 | 1.552329 | 1.273945 | 1.174
Total Liabilities | 9.564386 | 8.984255 | 14.128972 | 16.889607 | 19.17565 | 22.536409 | 17.768223 | 24.229207 | 27.447
Common Stock | 9.13203 | 9.62378 | 10.40456 | 10.48206 | 10.668185 | 10.732555 | 10.782555 | 10.935676 | 27.775
Additional Paid In Capital | 2.028574 | 2.231003 | 2.623887 | 3.013667 | 3.550053 | 3.906 | 4.208112 | 4.603194 | -
[NAME] | 2.010274 | 5.033879 | 7.546559 | 11.01545 | 14.472662 | 18.319191 | 20.507878 | 22.398714 | -
Treasury Stock | -1.6 | -1.9 | -5.4 | -5.4 | -5.9 | -8.4 | -10.1 | -11.7 | -
Comprehensive Inc. and Other | -1.4 | -1 | -1.1 | -0.9 | 0.285842 | -1.7 | -0.8 | -0.9 | -
Total Common Equity | 10.178624 | 13.982464 | 14.064994 | 18.131359 | 23.046743 | 22.887663 | 24.54125 | 25.351811 | 27.775
Total Equity | 10.178624 | 13.982464 | 14.064994 | 18.131359 | 23.046743 | 22.887663 | 24.54125 | 25.351811 | 27.775
Total Liabilities And Equity | 19.74301 | 22.966719 | 28.193966 | 35.020966 | 42.222393 | 45.424072 | 42.309473 | 49.581018 | 55.222
Supplemental Items
Total Shares Out. on Filing Date | 3.340551 | 3.577671 | 3.484833 | 3.538833 | 3.552883 | 3.343368 | 3.157859 | 3.069837 | 3.125
Total Shares Out. on Balance Sheet Date | 3.265551 | 3.413421 | 3.482833 | 3.513833 | 3.552883 | 3.343368 | 3.157859 | 3.069337 | 3.125
Book Value/Share | 3.12 | 4.1 | 4.04 | 5.16 | 6.49 | 6.85 | 7.77 | 8.26 | 8.89
Tangible Book Value | 9.731524 | 13.237454 | 13.118554 | 17.164735 | 21.299035 | 21.042272 | 22.677602 | 23.48558 | 27.775
Tangible Book Value/Share | 2.98 | 3.88 | 3.77 | 4.88 | 5.99 | 6.29 | 7.18 | 7.65 | 8.89
Total Debt | 4.928422 | 1.433936 | 5.587382 | 10.226448 | 10.186721 | 11.719 | 9.154 | 13.522 | 17.568
Net Debt | 3.537781 | -0.5 | 4.510893 | 6.388276 | 5.19873 | 6.494436 | 2.634935 | 6.920584 | 9.715
[NAME]. of Unfunded Proj. Benefit Obligation | 0.109526 | 0.028938 | 0.545815 | 0.417246 | 0.287134 | 1.38089 | 1.308655 | 1.164217 | NA
Debt Equivalent Oper. Leases | 2.018352 | 2.472856 | 2.661152 | 4.217664 | 4.58552 | 5.145296 | 5.346376 | 4.997872 | NA
Inventory Method | FIFO | FIFO | FIFO | FIFO | FIFO | FIFO | FIFO | FIFO | NA
Raw Materials Inventory | 0.807171 | 0.558422 | 0.72274 | 0.905201 | 0.75319 | 0.923436 | 0.965939 | 1.012282 | NA
Work in Progress Inventory | 0.119796 | 0.091697 | 0.116377 | 0.062675 | 0.112727 | 0.021151 | 0.097297 | 0.171673 | NA
Finished Goods Inventory | 7.252114 | 7.739109 | 11.691337 | 14.709418 | 18.06906 | 20.824717 | 16.337034 | 21.108954 | NA
Land | 0.234866 | 0.250692 | 0.152363 | 0.158902 | 0.17484 | 0.167003 | 0.17166 | 0.160405 | NA
Buildings | 2.643608 | 2.796286 | 2.953515 | 2.777599 | 2.971451 | 2.515641 | 2.558572 | 2.438073 | NA
Machinery | 5.772432 | 6.101802 | 6.525213 | 7.006219 | 8.050383 | 7.454662 | 8.169641 | 8.904675 | NA
Full Time Employees | 90 | 103 | 116 | 120 | 126 | 137 | 134 | 132 | NA
Accum. Allowance for Doubtful Accts | 0.199102 | 0.210914 | 0.13605 | 0.116811 | 0.089856 | 0.064105 | 0.071629 | 0.057125 | NA
Filing Date | 2006-03-16 00:00:00 | 2007-03-15 00:00:00 | 2008-03-12 00:00:00 | 2009-03-10 00:00:00 | 2009-03-10 00:00:00 | 2010-03-09 00:00:00 | 2011-03-11 00:00:00 | 2011-03-11 00:00:00 | 2012-03-01 00:00:00
Restatement Type | RS | RS | NC | NC | NC | NC | NC | O | P
Calculation Type | RUP | RUP | RUP | RUP | REP | REP | REP | REP | REP
Note: For multiple class companies, total share counts are primary class equivalent, and for foreign companies listed as primary ADRs, total share counts are ADR-equivalent.
Financial data provided by