Earnings in (Thousands) |
|||||||||||||||||||||||||||||||||||||||||||||||||
$18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
($2,000,000) ($4,000,000) |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Cash conversion cycle | 35 | 27 | 25 | 36 | -80 |
| Days inventory outstanding | 0 | 0 | 0 | 0 | 0 |
| Days payable outstanding | 15 | 18 | 16 | 8 | 138 |
| Days sales outstanding | 51 | 46 | 41 | 44 | 59 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Current ratio | 8.49 | 10.00 | 12.08 | 7.91 | 2.38 |
| Acid test | 6.98 | 8.62 | 10.78 | 6.26 | 1.42 |
| Acid test (liberal) | 8.49 | 10.00 | 12.08 | 7.91 | 2.38 |
| Debt to equity ratio (Adjusted) | 0.05 | 0.04 | 0.04 | 0.05 | 0.18 |
| Interest coverage ratio (Adjusted) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Fixed charges coverage ratio (Adjusted) | 43.92 | 66.54 | 56.68 | 49.06 | 58.32 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $16,593,986 | $10,604,917 | $6,138,560 | $3,189,223 |
| Expenses | $12,979,846 | $7,988,515 | $4,797,562 | $2,800,146 |
| Net income | $4,203,720 | $3,077,446 | $1,465,397 | $399,119 |
| Earnings before interest and taxes (EBIT) | $5,673,980 | $4,011,040 | $2,141,677 | $650,234 |
| Adjusted EBIT | $7,447,533 | $5,113,423 | $2,521,316 | $1,045,193 |
| Free cash flow to firm | ($2,829,056) | ($853,382) | $591,153 | $63,557 |
| Free cash flow to equity | ($1,862,254) | ($74,128) | $752,852 | ($44,046) |
| Operating lease expense and debt conversion in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $169,574 | $76,850 | $44,482 | $21,306 |
| Year one | $185,157 | $79,435 | $62,000 | $27,334 |
| Year two | $174,194 | $73,923 | $65,777 | $29,611 |
| Year three | $159,764 | $70,620 | $65,892 | $29,654 |
| Year four | $149,767 | $68,096 | $63,869 | $28,917 |
| Post year four | $1,446,525 | $839,131 | $386,628 | $98,976 |
| Total | $2,284,981 | $1,208,055 | $688,648 | $235,798 |
| Debt value | $1,321,450 | $643,333 | $432,011 | $157,986 |
| Depreciation | $110,121 | $42,889 | $43,201 | $22,569 |
Past growth rates |
|||||||||||||||||
60 % 55 % 50 % 45 % 40 % 35 % 30 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Thousands) |
|||||||||||||||||||||||||||||||
$8,000,000 $6,000,000 $4,000,000 $2,000,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||
($2,000,000) ($4,000,000) |
|
|
|
|
|
|
|||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $2,119,985 | $1,228,589 | $483,978 | $225,632 |
| + Working capital investment | $543,577 | $269,906 | $640 | $230,736 |
| + Fixed Capital investment | $2,402,840 | $1,902,798 | $838,217 | $318,995 |
| + Acquisitions | $3,927,300 | $1,473,300 | $130,500 | $21,957 |
| - R&D amortized | $405,885 | $160,168 | $105,620 | $30,409 |
| - Fixed capital depreciation | $807,743 | $494,430 | $256,812 | $128,523 |
| - Operating lease depreciation | $110,121 | $42,889 | $43,201 | $22,569 |
| = Reinvested | $7,669,953 | $4,177,107 | $1,047,702 | $615,818 |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $7,447,533 | $5,113,423 | $2,521,316 | $1,045,193 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $4,840,896 | $3,323,725 | $1,638,855 | $679,376 |
| Reinvestment expense (gain) | $7,669,953 | $4,177,107 | $1,047,702 | $615,818 |
| Free cash flow to firm (FCFF) | ($2,829,056) | ($853,382) | $591,153 | $63,557 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 142.06 % | 116.02 % | 103.79 % |
| Working capital investment | 9.67 % | 6.46 % | 10.67 % |
| R&D investment | 40.38 % | 36.76 % | 35.22 % |
| Acquisitions | 62.73 % | 44.47 % | 28.42 % |
| Net capital investments | 53.44 % | 52.68 % | 53.64 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 37.16 % | 48.99 % | 54.67 % |
| Profit | 30.94 % | 46.96 % | 58.77 % |
| Revenue | 44.04 % | 47.04 % | 51.59 % |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $6,081,593 | $3,544,671 | $3,877,174 | $426,873 |
| Short term investments | $8,137,020 | $7,699,243 | $4,157,073 | $1,705,424 |
| Accounts receivable | $2,307,774 | $1,322,340 | $687,976 | $382,345 |
| Inventory | ||||
| Deferred taxes | $68,538 | $29,713 | $49,341 | $19,463 |
| Prepaid expenses | $694,213 | $443,880 | $229,507 | $159,360 |
| Other assets | ||||
| Total assets | $17,289,138 | $13,039,847 | $9,001,071 | $2,693,465 |
| Accounts payable | $282,106 | $211,169 | $115,575 | $32,672 |
| Debt payments | ||||
| Accrued Expenses | $1,575,423 | $987,907 | $528,936 | $269,286 |
| Tax payable | $375 | $27,774 | ||
| Other liabilities | $178,073 | $105,136 | $73,099 | $38,410 |
| Total liabilities | $2,035,602 | $1,304,587 | $745,384 | $340,368 |
| Working capital | $15,253,536 | $11,735,260 | $8,255,687 | $2,353,097 |
| Non cash working capital | $1,034,923 | $491,346 | $221,440 | $220,800 |
| Investment in working capital | $543,577 | $269,906 | $640 | $230,736 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Revenue | $16,593,986 | $10,604,917 | $6,138,560 | $3,189,223 | $961,874 |
| Expenses | $12,979,846 | $7,988,515 | $4,797,562 | $2,800,146 | $860,416 |
| Net income | $4,203,720 | $3,077,446 | $1,465,397 | $399,119 | $105,648 |
| Earnings before interest and taxes (EBIT) | $5,673,980 | $4,011,040 | $2,141,677 | $650,234 | $346,654 |
| Adjusted EBIT | $7,447,533 | $5,113,423 | $2,521,316 | $1,045,193 | $430,252 |
| Free cash flow to firm | ($2,829,056) | ($853,382) | $591,153 | $63,557 | $55,221 |
| Free cash flow to equity | ($1,862,254) | ($74,128) | $752,852 | ($44,046) | ($42,575) |
| Adjusted debt | $1,321,450 | $643,333 | $432,011 | $157,986 | $105,057 |
| Adjusted equity | $24,477,321 | $17,759,060 | $9,705,408 | $3,020,284 | $588,770 |
| Adjusted depreciation | $1,323,749 | $697,486 | $405,633 | $181,502 | $58,859 |
| Total reinvestment | $7,669,953 | $4,177,107 | $1,047,702 | $615,818 | $224,443 |
| Adjusted EBIT | $7,447,533 | $5,113,423 | $2,521,316 | $1,045,193 | $430,252 |
| Adjusted EBIT(1 - t) | $4,840,896 | $3,323,725 | $1,638,855 | $679,376 | $279,664 |
| FCFF | ($2,829,056) | ($853,382) | $591,153 | $63,557 | $55,221 |
| FCFE | ($1,862,254) | ($74,128) | $752,852 | ($44,046) | ($42,575) |
| Cash conversion cycle | 35 | 27 | 25 | 36 | -80 |
| Days inventory outstanding | 0 | 0 | 0 | 0 | 0 |
| Days payable outstanding | 15 | 18 | 16 | 8 | 138 |
| Days sales outstanding | 51 | 46 | 41 | 44 | 59 |
| Acid test | 6.98 | 8.62 | 10.78 | 6.26 | 1.42 |
| liberal acid test | 8.49 | 10.00 | 12.08 | 7.91 | 2.38 |
| Current ratio | 8.49 | 10.00 | 12.08 | 7.91 | 2.38 |
| Fixed charges coverage ratio | 33.46 | 52.19 | 48.15 | 30.52 | 46.98 |
| Interest coverage ratio | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
|   | |||||
| Current Assets | |||||
| Cash and equivalent | $6,081,593 | $3,544,671 | $3,877,174 | $426,873 | $148,995 |
| Short term investments | $8,137,020 | $7,699,243 | $4,157,073 | $1,705,424 | $185,723 |
| Accounts receivable | $2,307,774 | $1,322,340 | $687,976 | $382,345 | $154,690 |
| Inventory | |||||
| Deferred taxes | $68,538 | $29,713 | $49,341 | $19,463 | $22,105 |
| Prepaid expenses | $694,213 | $443,880 | $229,507 | $159,360 | $48,721 |
| Other assets | |||||
| Total assets | $17,289,138 | $13,039,847 | $9,001,071 | $2,693,465 | $560,234 |
|   | |||||
| Current Liabilities | |||||
| Accounts payable | $282,106 | $211,169 | $115,575 | $32,672 | $46,175 |
| Debt payments | |||||
| Accrued Expenses | $1,575,423 | $987,907 | $528,936 | $269,286 | $148,605 |
| Tax payable | $375 | $27,774 | $20,705 | ||
| Other liabilities | $178,073 | $105,136 | $73,099 | $38,410 | $19,967 |
| Total liabilities | $2,035,602 | $1,304,587 | $745,384 | $340,368 | $235,452 |
| Working capital | $15,253,536 | $11,735,260 | $8,255,687 | $2,353,097 | $324,782 |
| Non cash working capital | $1,034,923 | $491,346 | $221,440 | $220,800 | ($9,936) |
| Investment in working capital | $543,577 | $269,906 | $640 | $230,736 | |