Earnings in (Thousands) |
|||||||||||||||||||||||||||||||||||||||||
$900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
($100,000) |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | 53 | 56 | 62 | 54 |
| Days inventory outstanding | 19 | 16 | 21 | 18 |
| Days payable outstanding | 24 | 28 | 25 | 27 |
| Days sales outstanding | 58 | 67 | 66 | 64 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.54 | 2.34 | 2.66 | 1.96 |
| Acid test | 0.52 | 0.67 | 1.35 | 0.46 |
| Acid test (liberal) | 1.40 | 2.14 | 2.47 | 1.83 |
| Debt to equity ratio (Adjusted) | 0.50 | 0.95 | 0.67 | 0.66 |
| Interest coverage ratio (Adjusted) | 11.08 | 6.21 | 3.78 | 4.89 |
| Fixed charges coverage ratio (Adjusted) | 1.51 | 0.87 | 0.70 | 1.24 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $850,617 | $832,215 | $666,934 | $637,413 |
| Expenses | $833,850 | $841,155 | $668,594 | $641,679 |
| Net income | $27,104 | ($1,768) | ($604) | $27,224 |
| Earnings before interest and taxes (EBIT) | $41,539 | $14,410 | $8,880 | $37,883 |
| Adjusted EBIT | $60,211 | $34,024 | $19,474 | $51,003 |
| Free cash flow to firm | $43,839 | ($43,877) | $46,321 | $55,839 |
| Free cash flow to equity | $16,068 | ($81,607) | $20,848 | $32,347 |
| Operating lease expense and debt conversion in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $34,410 | $33,460 | $22,805 | $30,684 |
| Year one | $27,846 | $28,324 | $22,903 | $32,015 |
| Year two | $20,952 | $23,767 | $19,598 | $28,169 |
| Year three | $17,258 | $18,481 | $16,521 | $23,616 |
| Year four | $13,921 | $15,669 | $13,608 | $17,456 |
| Post year four | $93,153 | $132,881 | $133,895 | $159,398 |
| Total | $207,540 | $252,582 | $229,330 | $291,338 |
| Debt value | $124,374 | $148,044 | $134,325 | $175,643 |
| Depreciation | $15,547 | $14,804 | $12,211 | $17,564 |
Past growth rates |
|||||||||||||||||
250 % 200 % 150 % 100 % 50 % |
|
|
|
|
|
||||||||||||
-50 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Thousands) |
||||||||||||||||||||||||||
$80,000 $60,000 $40,000 $20,000 |
|
|
|
|
|
|
||||||||||||||||||||
($20,000) ($40,000) ($60,000) ($80,000) ($100,000) |
|
|
|
|
|
|||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $958 | |||
| + Working capital investment | ($6,668) | $44,161 | ($35,551) | |
| + Fixed Capital investment | $20,756 | $28,668 | $39,724 | $17,962 |
| + Acquisitions | $25,791 | $32,923 | $3,500 | |
| - R&D amortized | $192 | |||
| - Fixed capital depreciation | $28,843 | $25,913 | $25,625 | $26,585 |
| - Operating lease depreciation | $15,547 | $14,804 | $12,211 | $17,564 |
| = Reinvested | ($4,702) | $65,993 | ($33,663) | ($22,687) |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $60,211 | $34,024 | $19,474 | $51,003 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $39,137 | $22,115 | $12,658 | $33,152 |
| Reinvestment expense (gain) | ($4,702) | $65,993 | ($33,663) | ($22,687) |
| Free cash flow to firm (FCFF) | $43,839 | ($43,877) | $46,321 | $55,839 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 143.19 % | 6.81 % | -12.00 % |
| Working capital investment | 91.32 % | -32.74 % | -24.55 % |
| R&D investment | 2.17 % | 1.44 % | 1.08 % |
| Acquisitions | 107.38 % | 71.59 % | 56.33 % |
| Net capital investments | 91.33 % | 165.50 % | 137.67 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 55.58 % | 53.74 % | 10.24 % |
| Profit | 227.91 % | 168.05 % | -1.17 % |
| Revenue | 2.19 % | 11.73 % | 10.78 % |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $64,941 | $42,986 | $96,839 | $51,557 |
| Short term investments | $38,805 | $42,628 | $90,675 | $20,371 |
| Accounts receivable | $134,489 | $153,016 | $120,450 | $111,857 |
| Inventory | $28,789 | $25,591 | $25,957 | $20,559 |
| Deferred taxes | ||||
| Prepaid expenses | $43,198 | $22,030 | ||
| Other assets | $36,697 | $36,074 | $81,925 | |
| Total assets | $310,222 | $300,918 | $369,995 | $308,299 |
| Accounts payable | $36,136 | $43,333 | $31,089 | $31,638 |
| Debt payments | $75,923 | $1,017 | $252 | $200 |
| Accrued Expenses | $89,214 | $83,494 | $104,342 | $87,550 |
| Tax payable | ||||
| Other liabilities | $683 | $3,417 | $37,999 | |
| Total liabilities | $201,273 | $128,527 | $139,100 | $157,387 |
| Working capital | $108,949 | $172,391 | $230,895 | $150,912 |
| Non cash working capital | $81,126 | $87,794 | $43,633 | $79,184 |
| Investment in working capital | ($6,668) | $44,161 | ($35,551) |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $850,617 | $832,215 | $666,934 | $637,413 |
| Expenses | $833,850 | $841,155 | $668,594 | $641,679 |
| Net income | $27,104 | ($1,768) | ($604) | $27,224 |
| Earnings before interest and taxes (EBIT) | $41,539 | $14,410 | $8,880 | $37,883 |
| Adjusted EBIT | $60,211 | $34,024 | $19,474 | $51,003 |
| Free cash flow to firm | $43,839 | ($43,877) | $46,321 | $55,839 |
| Free cash flow to equity | $16,068 | ($81,607) | $20,848 | $32,347 |
| Adjusted debt | $126,209 | $224,536 | $209,853 | $251,443 |
| Adjusted equity | $251,437 | $236,748 | $311,773 | $379,941 |
| Adjusted depreciation | $44,581 | $40,717 | $37,836 | $44,149 |
| Total reinvestment | ($4,702) | $65,993 | ($33,663) | ($22,687) |
| Adjusted EBIT | $60,211 | $34,024 | $19,474 | $51,003 |
| Adjusted EBIT(1 - t) | $39,137 | $22,115 | $12,658 | $33,152 |
| FCFF | $43,839 | ($43,877) | $46,321 | $55,839 |
| FCFE | $16,068 | ($81,607) | $20,848 | $32,347 |
| Cash conversion cycle | 53 | 56 | 62 | 54 |
| Days inventory outstanding | 19 | 16 | 21 | 18 |
| Days payable outstanding | 24 | 28 | 25 | 27 |
| Days sales outstanding | 58 | 67 | 66 | 64 |
| Acid test | 0.52 | 0.67 | 1.35 | 0.46 |
| liberal acid test | 1.40 | 2.14 | 2.47 | 1.83 |
| Current ratio | 1.54 | 2.34 | 2.66 | 1.96 |
| Fixed charges coverage ratio | 1.04 | 0.37 | 0.32 | 0.92 |
| Interest coverage ratio | 7.65 | 2.63 | 1.72 | 3.63 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $64,941 | $42,986 | $96,839 | $51,557 |
| Short term investments | $38,805 | $42,628 | $90,675 | $20,371 |
| Accounts receivable | $134,489 | $153,016 | $120,450 | $111,857 |
| Inventory | $28,789 | $25,591 | $25,957 | $20,559 |
| Deferred taxes | ||||
| Prepaid expenses | $43,198 | $22,030 | ||
| Other assets | $36,697 | $36,074 | $81,925 | |
| Total assets | $310,222 | $300,918 | $369,995 | $308,299 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $36,136 | $43,333 | $31,089 | $31,638 |
| Debt payments | $75,923 | $1,017 | $252 | $200 |
| Accrued Expenses | $89,214 | $83,494 | $104,342 | $87,550 |
| Tax payable | ||||
| Other liabilities | $683 | $3,417 | $37,999 | |
| Total liabilities | $201,273 | $128,527 | $139,100 | $157,387 |
| Working capital | $108,949 | $172,391 | $230,895 | $150,912 |
| Non cash working capital | $81,126 | $87,794 | $43,633 | $79,184 |
| Investment in working capital | ($6,668) | $44,161 | ($35,551) | |