Earnings in (Thousands) |
|||||||||||||||||||||||||||||||||||||||||
$8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | 38 | 43 | 45 | 35 |
| Days inventory outstanding | 0 | 0 | 0 | 0 |
| Days payable outstanding | 11 | 21 | 22 | 18 |
| Days sales outstanding | 49 | 64 | 67 | 53 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.88 | 1.84 | 1.70 | 1.56 |
| Acid test | 1.01 | 0.87 | 0.54 | 0.64 |
| Acid test (liberal) | 1.88 | 1.84 | 1.70 | 1.56 |
| Debt to equity ratio (Adjusted) | 0.08 | 0.10 | 0.13 | 0.11 |
| Interest coverage ratio (Adjusted) | 20.80 | 31.90 | 51.57 | 0.00 |
| Fixed charges coverage ratio (Adjusted) | 6.12 | 6.08 | 5.24 | 5.60 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $7,800,000 | $6,835,600 | $6,131,300 | $7,279,400 |
| Expenses | $6,990,700 | $6,129,500 | $5,413,400 | $6,343,800 |
| Net income | $1,138,700 | $1,554,000 | $1,055,400 | $935,600 |
| Earnings before interest and taxes (EBIT) | $1,835,900 | $2,146,100 | $1,544,900 | $1,472,800 |
| Adjusted EBIT | $1,973,535 | $2,322,049 | $1,665,608 | $1,629,794 |
| Free cash flow to firm | $1,183,863 | $1,862,083 | $335,327 | $1,109,973 |
| Free cash flow to equity | $949,800 | $1,773,400 | $142,990 | $852,300 |
| Operating lease expense and debt conversion in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $227,600 | $309,300 | $285,800 | $290,901 |
| Year one | $150,000 | $200,000 | $226,800 | $215,412 |
| Year two | $149,200 | $190,200 | $181,800 | $148,606 |
| Year three | $40,000 | $100,000 | $137,100 | $102,264 |
| Year four | $32,300 | $62,900 | $108,500 | $55,965 |
| Post year four | $51,100 | $81,000 | $144,100 | $117,617 |
| Total | $650,200 | $943,400 | $1,084,100 | $930,765 |
| Debt value | $359,859 | $533,405 | $660,367 | $535,630 |
| Depreciation | $89,965 | $133,351 | $165,092 | $133,907 |
Past growth rates |
|||||||||||||||||
15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
-5 % -10 % -15 % -20 % -25 % -30 % -35 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Thousands) |
||||||||||||||||||||||||||
$2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 |
|
|
|
|
|
|
||||||||||||||||||||
|
|
|
|
|
|
||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | ($142,000) | ($559,800) | $594,610 | |
| + Fixed Capital investment | $172,800 | $292,300 | $187,300 | $188,000 |
| + Acquisitions | $446,900 | $336,700 | $404,400 | $172,400 |
| - R&D amortized | ||||
| - Fixed capital depreciation | $288,800 | $288,600 | $273,900 | $277,100 |
| - Operating lease depreciation | $89,965 | $133,351 | $165,092 | $133,907 |
| = Reinvested | $98,935 | ($352,751) | $747,318 | ($50,607) |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $1,973,535 | $2,322,049 | $1,665,608 | $1,629,794 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $1,282,798 | $1,509,332 | $1,082,645 | $1,059,366 |
| Reinvestment expense (gain) | $98,935 | ($352,751) | $747,318 | ($50,607) |
| Free cash flow to firm (FCFF) | $1,183,863 | $1,862,083 | $335,327 | $1,109,973 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | -7.83 % | 17.79 % | 12.15 % |
| Working capital investment | -24.08 % | 2.25 % | 1.69 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 28.57 % | 31.50 % | 27.69 % |
| Net capital investments | 16.42 % | 16.71 % | 16.97 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | -16.23 % | 7.75 % | 8.89 % |
| Profit | -30.85 % | 3.33 % | 9.46 % |
| Revenue | 13.18 % | 12.05 % | 3.23 % |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,746,100 | $1,900,600 | $853,600 | $712,998 |
| Short term investments | $70,400 | $367,900 | $695,800 | $416,077 |
| Accounts receivable | $1,041,900 | $1,202,400 | $1,121,700 | $1,057,938 |
| Inventory | ||||
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $505,800 | $1,289,200 | $2,198,800 | $574,576 |
| Total assets | $3,364,200 | $4,760,100 | $4,869,900 | $2,761,589 |
| Accounts payable | $125,900 | $207,300 | $192,700 | $175,175 |
| Debt payments | ||||
| Accrued Expenses | $703,400 | $1,546,400 | $1,511,300 | $1,482,703 |
| Tax payable | $118,700 | $205,700 | $192,500 | $110,546 |
| Other liabilities | $842,800 | $633,300 | $965,300 | |
| Total liabilities | $1,790,800 | $2,592,700 | $2,861,800 | $1,768,424 |
| Working capital | $1,573,400 | $2,167,400 | $2,008,100 | $993,165 |
| Non cash working capital | ($243,100) | ($101,100) | $458,700 | ($135,910) |
| Investment in working capital | ($142,000) | ($559,800) | $594,610 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $7,800,000 | $6,835,600 | $6,131,300 | $7,279,400 |
| Expenses | $6,990,700 | $6,129,500 | $5,413,400 | $6,343,800 |
| Net income | $1,138,700 | $1,554,000 | $1,055,400 | $935,600 |
| Earnings before interest and taxes (EBIT) | $1,835,900 | $2,146,100 | $1,544,900 | $1,472,800 |
| Adjusted EBIT | $1,973,535 | $2,322,049 | $1,665,608 | $1,629,794 |
| Free cash flow to firm | $1,183,863 | $1,862,083 | $335,327 | $1,109,973 |
| Free cash flow to equity | $949,800 | $1,773,400 | $142,990 | $852,300 |
| Adjusted debt | $403,359 | $607,705 | $736,067 | $611,830 |
| Adjusted equity | $5,147,900 | $6,011,600 | $5,783,900 | $5,434,700 |
| Adjusted depreciation | $378,765 | $421,951 | $438,992 | $411,007 |
| Total reinvestment | $98,935 | ($352,751) | $747,318 | ($50,607) |
| Adjusted EBIT | $1,973,535 | $2,322,049 | $1,665,608 | $1,629,794 |
| Adjusted EBIT(1 - t) | $1,282,798 | $1,509,332 | $1,082,645 | $1,059,366 |
| FCFF | $1,183,863 | $1,862,083 | $335,327 | $1,109,973 |
| FCFE | $949,800 | $1,773,400 | $142,990 | $852,300 |
| Cash conversion cycle | 38 | 43 | 45 | 35 |
| Days inventory outstanding | 0 | 0 | 0 | 0 |
| Days payable outstanding | 11 | 21 | 22 | 18 |
| Days sales outstanding | 49 | 64 | 67 | 53 |
| Acid test | 1.01 | 0.87 | 0.54 | 0.64 |
| liberal acid test | 1.88 | 1.84 | 1.70 | 1.56 |
| Current ratio | 1.88 | 1.84 | 1.70 | 1.56 |
| Fixed charges coverage ratio | 5.69 | 5.62 | 4.86 | 5.06 |
| Interest coverage ratio | 19.35 | 29.48 | 47.83 | 0.00 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $1,746,100 | $1,900,600 | $853,600 | $712,998 |
| Short term investments | $70,400 | $367,900 | $695,800 | $416,077 |
| Accounts receivable | $1,041,900 | $1,202,400 | $1,121,700 | $1,057,938 |
| Inventory | ||||
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $505,800 | $1,289,200 | $2,198,800 | $574,576 |
| Total assets | $3,364,200 | $4,760,100 | $4,869,900 | $2,761,589 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $125,900 | $207,300 | $192,700 | $175,175 |
| Debt payments | ||||
| Accrued Expenses | $703,400 | $1,546,400 | $1,511,300 | $1,482,703 |
| Tax payable | $118,700 | $205,700 | $192,500 | $110,546 |
| Other liabilities | $842,800 | $633,300 | $965,300 | |
| Total liabilities | $1,790,800 | $2,592,700 | $2,861,800 | $1,768,424 |
| Working capital | $1,573,400 | $2,167,400 | $2,008,100 | $993,165 |
| Non cash working capital | ($243,100) | ($101,100) | $458,700 | ($135,910) |
| Investment in working capital | ($142,000) | ($559,800) | $594,610 | |