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

Income Statement
For the Fiscal Period Ending | 12 months Dec-31-2003 | 12 months Dec-31-2004 | 12 months Dec-31-2005 | Reclassified 12 months Dec-31-2006 | 12 months Dec-31-2007 | 12 months Dec-31-2008 | 12 months Dec-31-2009 | 12 months Dec-31-2010 | Press Release 12 months Dec-31-2011
Currency | USD | USD | USD | USD | USD | USD | USD | USD | USD
Revenue | 34.97466 | 43.380648 | 49.946374 | 56.862992 | 63.173005 | 68.719012 | 59.148547 | 63.148933 | 73.302
Other Revenue | - | - | - | - | - | - | - | - | -
Total Revenue | 34.97466 | 43.380648 | 49.946374 | 56.862992 | 63.173005 | 68.719012 | 59.148547 | 63.148933 | 73.302
Cost Of Goods Sold | 21.841901 | 23.728118 | 27.591685 | 32.280219 | 36.680075 | 41.062125 | 37.07506 | 39.783509 | 46.977
Gross Profit | 13.132759 | 19.65253 | 22.354689 | 24.582773 | 26.49293 | 27.656887 | 22.073487 | 23.365424 | 26.325
Selling General & Admin Exp. | 10.646395 | 14.162082 | 15.512488 | 18.069753 | 19.741166 | 20.778093 | 19.046864 | 20.385268 | 22.04
R & D Exp. | - | - | - | - | - | - | - | - | -
Depreciation & Amort. | - | - | - | - | - | - | - | - | -
Other Operating Expense/(Income) | - | - | - | - | - | - | - | - | -
Other Operating Exp., Total | 10.646395 | 14.162082 | 15.512488 | 18.069753 | 19.741166 | 20.778093 | 19.046864 | 20.385268 | 22.04
Operating Income | 2.486364 | 5.490448 | 6.842201 | 6.51302 | 6.751764 | 6.878794 | 3.026623 | 2.980156 | 4.285
Interest Expense | -0.2 | -0.2 | -0.2 | -0.6 | -0.7 | -0.5 | -0.2 | -0.3 | -0.4
Interest and Invest. Income | - | - | - | - | - | 0.10176 | 0.129334 | 0.159555 | 0.15
Net Interest Exp. | -0.2 | -0.2 | -0.2 | -0.6 | -0.7 | -0.4 | 0 | -0.1 | -0.3
Currency Exchange Gains (Loss) | 0.105984 | -0.1 | -0.4 | 0.149791 | 0.159877 | -0.1 | 0 | -0.1 | -
Other Non-Operating Inc. (Exp.) | 0.160188 | 0.117722 | 0.056268 | 0.101766 | 0.04648 | 0.02921 | 0.487524 | 0.131432 | 0
[NAME]. Unusual Items | 2.517271 | 5.340316 | 6.266066 | 6.149077 | 6.302675 | 6.411101 | 3.452954 | 2.910847 | 4.026
Restructuring Charges | - | - | - | - | - | - | - | - | -
Impairment of Goodwill | - | - | - | - | - | - | - | - | -
Gain (Loss) On Sale Of Assets | - | - | - | - | - | 0.265 | - | - | -
Legal Settlements | -0.2 | - | - | 0.2 | - | - | - | - | -
Other Unusual Items | - | - | -1.5 | - | - | - | - | - | -
[NAME]. Unusual Items | 2.342271 | 5.340316 | 4.766066 | 6.349077 | 6.302675 | 6.676101 | 3.452954 | 2.910847 | 4.026
Income Tax Expense | 1.12044 | 2.101911 | 1.828756 | 2.463415 | 2.280417 | 2.20903 | 0.610867 | 0.337883 | 1.215
Earnings from Cont. Ops. | 1.221831 | 3.238405 | 2.93731 | 3.885662 | 4.022258 | 4.467071 | 2.842087 | 2.572964 | 2.811
Earnings of Discontinued Ops. | - | - | - | - | - | - | - | - | -
Extraord. Item & Account. Change | - | - | - | - | - | - | - | - | -
Net Income to Company | 1.221831 | 3.238405 | 2.93731 | 3.885662 | 4.022258 | 4.467071 | 2.842087 | 2.572964 | 2.811
Minority Int. in Earnings | - | - | - | - | - | - | - | - | -
Net Income | 1.221831 | 3.238405 | 2.93731 | 3.885662 | 4.022258 | 4.467071 | 2.842087 | 2.572964 | 2.811
Pref. Dividends and [NAME]. | - | - | - | - | - | - | - | - | -
NI to Common Incl Extra Items | 1.221831 | 3.238405 | 2.93731 | 3.885662 | 4.022258 | 4.467071 | 2.842087 | 2.572964 | 2.811
NI to [NAME]. Extra Items | 1.221831 | 3.238405 | 2.93731 | 3.885662 | 4.022258 | 4.467071 | 2.842087 | 2.572964 | 2.811
Per Share Items
Basic EPS | 0.368 | 0.963 | 0.837 | 1.112 | 1.138 | 1.281 | 0.864 | 0.822 | 0.907
Basic EPS Excl. Extra Items | 0.368328 | 0.962655 | 0.837071 | 1.11183 | 1.137617 | 1.281295 | 0.864153 | 0.822424 | 0.906774
Weighted Avg. Basic Shares Out. | 3.317231 | 3.364033 | 3.509031 | 3.494833 | 3.535687 | 3.48637 | 3.288867 | 3.128509 | 3.1
Diluted EPS | 0.34 | 0.85 | 0.78 | 1.05 | 1.09 | 1.24 | 0.85 | 0.81 | 0.91
Diluted EPS Excl. Extra Items | 0.34 | 0.85 | 0.779999 | 1.05 | 1.09 | 1.24 | 0.85 | 0.809999 | 0.91
Weighted Avg. Diluted Shares Out. | 3.557894 | 3.807028 | 3.788944 | 3.71205 | 3.696842 | 3.611873 | 3.352788 | 3.194314 | 3.1
Normalized Basic EPS | 0.474 | 0.992 | 1.116 | 1.1 | 1.114 | 1.149 | 0.656 | 0.582 | 0.812
Normalized Diluted EPS | 0.442198 | 0.87672 | 1.03361 | 1.035323 | 1.06555 | 1.109379 | 0.643672 | 0.569536 | 0.811693
Dividends per Share | NA | 0.06 | 0.11 | 0.12 | 0.16 | 0.18 | 0.2 | 0.22 | NA
[NAME] | NA | 0.044159 | 0.129703 | 0.110388 | 0.131599 | 0.133114 | 0.233119 | 0.254893 | NA
Supplemental Items
EBITDA | 2.923153 | 5.99918 | 7.494973 | 7.348148 | 7.623012 | 7.886764 | 3.944512 | 3.850312 | 5.242333
EBITA | 2.489508 | 5.506819 | 6.884464 | 6.547699 | 6.811442 | 6.987622 | 3.14061 | 3.094978 | 4.285
EBIT | 2.486364 | 5.490448 | 6.842201 | 6.51302 | 6.751764 | 6.878794 | 3.026623 | 2.980156 | 4.285
EBITDAR | 3.175447 | 6.308287 | 7.827617 | 7.875356 | 8.196202 | 8.529926 | 4.612809 | 4.475046 | NA
Effective Tax Rate % | 0.478356 | 0.393593 | 0.383703 | 0.387995 | 0.361817 | 0.330886 | 0.176911 | 0.116077 | 0.301788
Current Domestic Taxes | 0.57984 | 1.926383 | 2.05388 | 1.501256 | 1.639655 | 1.619999 | 0.274965 | 0.114352 | NA
Current Foreign Taxes | NA | 0.232486 | 0.237497 | 0.540103 | 0.54373 | 0.813298 | 0.6305 | 0.59411 | NA
Total Current Taxes | 0.57984 | 2.158869 | 2.291377 | 2.041359 | 2.183385 | 2.433297 | 0.905465 | 0.708462 | -
Deferred Domestic Taxes | 0.560699 | -0.1 | -0.5 | 0.44263 | 0.104907 | -0.2 | -0.3 | -0.4 | NA
Deferred Foreign Taxes | 0 | 0.009081 | NA | 0 | 0 | 0 | 0 | 0 | NA
Total Deferred Taxes | 0.5406 | -0.1 | -0.5 | 0.422056 | 0.097032 | -0.2 | -0.3 | -0.4 | -
Normalized Net Income | 1.573294 | 3.337698 | 3.916291 | 3.843173 | 3.939172 | 4.006938 | 2.158096 | 1.819279 | 2.51625
NI per SFAS 123 (after Options) | 1.136846 | 3.161476 | 2.664406 | NA | NA | NA | NA | NA | NA
Interest on Long Term Debt | NA | NA | NA | NA | NA | 0.497308 | 0.155008 | 0.301304 | NA
Non-Cash Pension Expense | 0.064604 | 0.023553 | 0.01912 | 0.054604 | 0.039277 | 0.052833 | 0.233693 | 0.190703 | -
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 | NC | NC | NC | RC | NC | NC | NC | O | P
Calculation Type | REP | REP | REP | REP | REP | REP | REP | REP | REP
Supplemental Operating Expense Items
Advertising Exp. | 0.669065 | 1.109217 | 1.252366 | 1.29225 | 1.060523 | 1.159462 | 1.06686 | 1.039302 | NA
Selling and Marketing Exp. | NA | NA | 1.252366 | 1.29225 | 1.060523 | 1.159462 | 1.06686 | 1.039302 | NA
R&D Exp. | 0.34713 | 0.456905 | 0.244904 | 0.306422 | 0.236064 | 0.529685 | 0.440378 | 0.486778 | NA
Net Rental Exp. | 0.252294 | 0.309107 | 0.332644 | 0.527208 | 0.57319 | 0.643162 | 0.668297 | 0.624734 | NA
Imputed Oper. Lease Interest Exp. | 0.094457 | 0.122303 | 0.178034 | 0.328316 | 0.294468 | 0.233617 | 0.079404 | 0.132813 | -
Imputed Oper. Lease Depreciation | 0.157837 | 0.186804 | 0.15461 | 0.198892 | 0.278722 | 0.409545 | 0.588893 | 0.491921 | -
Stock-Based Comp., [NAME] | - | - | - | 0.27554 | 0.330859 | 0.277577 | 0.308377 | 0.385732 | -
Stock-Based Comp., Total | - | - | - | 0.27554 | 0.330859 | 0.277577 | 0.308377 | 0.385732 | -
Note: For multiple class companies, per share items are primary class equivalent, and for foreign companies listed as primary ADRs, per share items are ADR-equivalent.