Earnings in (Thousands) |
|||||||||||||||||||||||||||||||||||||||||
$2,000,000 $1,500,000 $1,000,000 $500,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
($500,000) ($1,000,000) ($1,500,000) |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | -7 | -21 | -6 | -57 |
| Days inventory outstanding | 10 | 0 | 0 | 0 |
| Days payable outstanding | 53 | 51 | 37 | 92 |
| Days sales outstanding | 36 | 30 | 32 | 35 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.47 | 1.56 | 1.39 | 0.52 |
| Acid test | 0.76 | 0.91 | 0.58 | 0.28 |
| Acid test (liberal) | 1.38 | 1.56 | 1.39 | 0.52 |
| Debt to equity ratio (Adjusted) | 0.43 | 0.55 | 0.86 | 90.54 |
| Interest coverage ratio (Adjusted) | 3.64 | 4.69 | 2.71 | 0.47 |
| Fixed charges coverage ratio (Adjusted) | 2.27 | 3.16 | 2.71 | 0.47 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $1,835,911 | $1,144,671 | $815,941 | $574,329 |
| Expenses | $1,779,589 | $1,015,871 | $839,036 | $716,409 |
| Net income | $122,154 | $204,681 | $56,414 | ($95,818) |
| Earnings before interest and taxes (EBIT) | $205,421 | $211,520 | $156,070 | $47,381 |
| Adjusted EBIT | $225,083 | $223,707 | $156,070 | $47,381 |
| Free cash flow to firm | ($1,154,653) | $37,945 | $19,261 | $44,157 |
| Free cash flow to equity | ($1,196,383) | $86,245 | ($25,771) | ($82,459) |
| Operating lease expense and debt conversion in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $37,242 | $23,158 | ||
| Year one | $38,747 | $24,089 | ||
| Year two | $40,174 | $25,171 | ||
| Year three | ||||
| Year four | ||||
| Post year four | ||||
| Total | $116,163 | $72,418 | ||
| Debt value | $70,320 | $43,885 | ||
| Depreciation | $17,580 | $10,971 |
Past growth rates |
|||||||||||||||||
120 % 100 % 80 % 60 % 40 % 20 % |
|
|
|
|
|
||||||||||||
-20 % -40 % -60 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Thousands) |
||||||||||||||||||||||||||
$400,000 $200,000 |
|
|
|
|
|
|
||||||||||||||||||||
($200,000) ($400,000) ($600,000) ($800,000) ($1,000,000) ($1,200,000) |
|
|
|
|
|
|||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | $1,119,341 | ($42,213) | $64,123 | |
| + Fixed Capital investment | $406,384 | $235,634 | $86,222 | $43,377 |
| + Acquisitions | ||||
| - R&D amortized | ||||
| - Fixed capital depreciation | $207,188 | $74,985 | $68,160 | $56,736 |
| - Operating lease depreciation | $17,580 | $10,971 | ||
| = Reinvested | $1,300,957 | $107,465 | $82,185 | ($13,359) |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $225,083 | $223,707 | $156,070 | $47,381 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $146,304 | $145,409 | $101,446 | $30,798 |
| Reinvestment expense (gain) | $1,300,957 | $107,465 | $82,185 | ($13,359) |
| Free cash flow to firm (FCFF) | ($1,154,653) | $37,945 | $19,261 | $44,157 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 481.56 % | 348.04 % | 250.19 % |
| Working capital investment | 368.02 % | 266.42 % | 199.81 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 0.00 % | 0.00 % | 0.00 % |
| Net capital investments | 219.91 % | 174.94 % | 166.41 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 0.61 % | 17.11 % | 36.84 % |
| Profit | -50.50 % | 25.73 % | 111.63 % |
| Revenue | 46.38 % | 40.30 % | 37.64 % |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $319,063 | $11,826 | $23,865 | $60,486 |
| Short term investments | $2,512 | $222,209 | $103,624 | $60,575 |
| Accounts receivable | $181,371 | $95,625 | $70,921 | $55,634 |
| Inventory | $36,107 | |||
| Deferred taxes | $36,053 | $39,271 | $34,313 | $33,647 |
| Prepaid expenses | $13,962 | $8,310 | $4,801 | $4,561 |
| Other assets | $32,213 | $24,244 | $69,322 | $13,769 |
| Total assets | $621,281 | $401,485 | $306,846 | $228,672 |
| Accounts payable | $188,626 | $106,212 | $56,818 | $100,920 |
| Debt payments | $7,774 | $44,961 | $235,146 | |
| Accrued Expenses | $54,846 | $30,578 | $12,649 | $36,439 |
| Tax payable | $20,734 | $10,878 | $14,617 | $19,772 |
| Other liabilities | $150,973 | $109,429 | $92,442 | $47,092 |
| Total liabilities | $422,953 | $257,097 | $221,487 | $439,369 |
| Working capital | $198,328 | $144,388 | $85,359 | ($210,697) |
| Non cash working capital | ($115,473) | ($89,647) | $2,831 | ($96,612) |
| Investment in working capital | $1,119,341 | ($42,213) | $64,123 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $1,835,911 | $1,144,671 | $815,941 | $574,329 |
| Expenses | $1,779,589 | $1,015,871 | $839,036 | $716,409 |
| Net income | $122,154 | $204,681 | $56,414 | ($95,818) |
| Earnings before interest and taxes (EBIT) | $205,421 | $211,520 | $156,070 | $47,381 |
| Adjusted EBIT | $225,083 | $223,707 | $156,070 | $47,381 |
| Free cash flow to firm | ($1,154,653) | $37,945 | $19,261 | $44,157 |
| Free cash flow to equity | ($1,196,383) | $86,245 | ($25,771) | ($82,459) |
| Adjusted debt | $691,263 | $465,168 | $313,108 | $330,554 |
| Adjusted equity | $1,623,707 | $839,057 | $364,989 | $3,651 |
| Adjusted depreciation | $224,768 | $85,956 | $68,160 | $56,736 |
| Total reinvestment | $1,300,957 | $107,465 | $82,185 | ($13,359) |
| Adjusted EBIT | $225,083 | $223,707 | $156,070 | $47,381 |
| Adjusted EBIT(1 - t) | $146,304 | $145,409 | $101,446 | $30,798 |
| FCFF | ($1,154,653) | $37,945 | $19,261 | $44,157 |
| FCFE | ($1,196,383) | $86,245 | ($25,771) | ($82,459) |
| Cash conversion cycle | -7 | -21 | -6 | -57 |
| Days inventory outstanding | 10 | 0 | 0 | 0 |
| Days payable outstanding | 53 | 51 | 37 | 92 |
| Days sales outstanding | 36 | 30 | 32 | 35 |
| Acid test | 0.76 | 0.91 | 0.58 | 0.28 |
| liberal acid test | 1.38 | 1.56 | 1.39 | 0.52 |
| Current ratio | 1.47 | 1.56 | 1.39 | 0.52 |
| Fixed charges coverage ratio | 2.07 | 2.99 | 2.71 | 0.47 |
| Interest coverage ratio | 3.32 | 4.44 | 2.71 | 0.47 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $319,063 | $11,826 | $23,865 | $60,486 |
| Short term investments | $2,512 | $222,209 | $103,624 | $60,575 |
| Accounts receivable | $181,371 | $95,625 | $70,921 | $55,634 |
| Inventory | $36,107 | |||
| Deferred taxes | $36,053 | $39,271 | $34,313 | $33,647 |
| Prepaid expenses | $13,962 | $8,310 | $4,801 | $4,561 |
| Other assets | $32,213 | $24,244 | $69,322 | $13,769 |
| Total assets | $621,281 | $401,485 | $306,846 | $228,672 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $188,626 | $106,212 | $56,818 | $100,920 |
| Debt payments | $7,774 | $44,961 | $235,146 | |
| Accrued Expenses | $54,846 | $30,578 | $12,649 | $36,439 |
| Tax payable | $20,734 | $10,878 | $14,617 | $19,772 |
| Other liabilities | $150,973 | $109,429 | $92,442 | $47,092 |
| Total liabilities | $422,953 | $257,097 | $221,487 | $439,369 |
| Working capital | $198,328 | $144,388 | $85,359 | ($210,697) |
| Non cash working capital | ($115,473) | ($89,647) | $2,831 | ($96,612) |
| Investment in working capital | $1,119,341 | ($42,213) | $64,123 | |