Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$12,000 $10,000 $8,000 $6,000 $4,000 $2,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
($2,000) |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | 53 | 71 | 44 | 44 |
| Days inventory outstanding | 69 | 97 | 68 | 69 |
| Days payable outstanding | 29 | 33 | 31 | 30 |
| Days sales outstanding | 13 | 6 | 7 | 5 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 2.12 | 1.62 | 1.77 | 1.85 |
| Acid test | 0.74 | 0.29 | 0.77 | 0.80 |
| Acid test (liberal) | 1.21 | 0.59 | 1.03 | 1.06 |
| Debt to equity ratio (Adjusted) | 2.61 | 1.41 | 1.73 | 1.81 |
| Interest coverage ratio (Adjusted) | 9.35 | 13.20 | 13.28 | 23.53 |
| Fixed charges coverage ratio (Adjusted) | 2.43 | 2.02 | 1.97 | 2.26 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $10,134 | $10,671 | $9,699 | $9,408 |
| Expenses | $9,814 | $10,021 | $9,098 | $8,850 |
| Net income | $718 | $676 | $683 | $705 |
| Earnings before interest and taxes (EBIT) | $1,278 | $1,200 | $1,068 | $1,174 |
| Adjusted EBIT | $1,393 | $1,346 | $1,248 | $1,365 |
| Free cash flow to firm | $853 | ($100) | $1,060 | $1,145 |
| Free cash flow to equity | $356 | ($717) | $573 | $607 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $425 | $564 | $539 | $547 |
| Year one | $417 | $512 | $476 | $495 |
| Year two | $396 | $481 | $413 | $424 |
| Year three | $359 | $446 | $387 | $361 |
| Year four | $322 | $396 | $359 | $331 |
| Post year four | $1,331 | $1,362 | $1,095 | $1,095 |
| Total | $3,250 | $3,761 | $3,269 | $3,253 |
| Debt value | $2,170 | $2,508 | $2,154 | $2,139 |
| Depreciation | $310 | $418 | $359 | $356 |
Past growth rates |
|||||||||||||||||
8 % 6 % 4 % 2 % |
|
|
|
|
|
||||||||||||
-2 % -4 % -6 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$1,500 $1,000 $500 |
|
|
|
|
|
|
||||||||||||||||||||
($500) ($1,000) |
|
|
|
|
|
|||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | ($35) | $561 | ($71) | |
| + Fixed Capital investment | $749 | $548 | $480 | $431 |
| + Acquisitions | $600 | |||
| - R&D amortized | ||||
| - Fixed capital depreciation | $352 | $316 | $299 | $333 |
| - Operating lease depreciation | $310 | $418 | $359 | $356 |
| = Reinvested | $52 | $975 | ($249) | ($258) |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $1,393 | $1,346 | $1,248 | $1,365 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $905 | $875 | $811 | $887 |
| Reinvestment expense (gain) | $52 | $975 | ($249) | ($258) |
| Free cash flow to firm (FCFF) | $853 | ($100) | $1,060 | $1,145 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 58.59 % | 28.83 % | 14.34 % |
| Working capital investment | 30.13 % | 17.17 % | 12.88 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 34.29 % | 22.86 % | 17.15 % |
| Net capital investments | 72.68 % | 68.18 % | 63.28 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 3.43 % | 5.45 % | 1.37 % |
| Profit | 6.03 % | 2.53 % | 0.46 % |
| Revenue | -5.16 % | 2.14 % | 3.16 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,018 | $500 | $1,208 | $1,161 |
| Short term investments | ||||
| Accounts receivable | $355 | $176 | $182 | $128 |
| Inventory | $1,251 | $1,770 | $1,160 | $1,142 |
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $295 | $325 | $234 | $253 |
| Total assets | $2,919 | $2,771 | $2,784 | $2,684 |
| Accounts payable | $517 | $593 | $535 | $496 |
| Debt payments | ||||
| Accrued Expenses | $721 | $897 | $790 | $726 |
| Tax payable | $136 | $219 | $250 | $229 |
| Other liabilities | ||||
| Total liabilities | $1,374 | $1,709 | $1,575 | $1,451 |
| Working capital | $1,545 | $1,062 | $1,209 | $1,233 |
| Non cash working capital | $527 | $562 | $1 | $72 |
| Investment in working capital | ($35) | $561 | ($71) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $10,134 | $10,671 | $9,699 | $9,408 |
| Expenses | $9,814 | $10,021 | $9,098 | $8,850 |
| Net income | $718 | $676 | $683 | $705 |
| Earnings before interest and taxes (EBIT) | $1,278 | $1,200 | $1,068 | $1,174 |
| Adjusted EBIT | $1,393 | $1,346 | $1,248 | $1,365 |
| Free cash flow to firm | $853 | ($100) | $1,060 | $1,145 |
| Free cash flow to equity | $356 | ($717) | $573 | $607 |
| Adjusted debt | $5,784 | $4,173 | $4,275 | $4,232 |
| Adjusted equity | $2,219 | $2,955 | $2,471 | $2,335 |
| Adjusted depreciation | $662 | $734 | $658 | $689 |
| Total reinvestment | $52 | $975 | ($249) | ($258) |
| Adjusted EBIT | $1,393 | $1,346 | $1,248 | $1,365 |
| Adjusted EBIT(1 - t) | $905 | $875 | $811 | $887 |
| FCFF | $853 | ($100) | $1,060 | $1,145 |
| FCFE | $356 | ($717) | $573 | $607 |
| Cash conversion cycle | 53 | 71 | 44 | 44 |
| Days inventory outstanding | 69 | 97 | 68 | 69 |
| Days payable outstanding | 29 | 33 | 31 | 30 |
| Days sales outstanding | 13 | 6 | 7 | 5 |
| Acid test | 0.74 | 0.29 | 0.77 | 0.80 |
| liberal acid test | 1.21 | 0.59 | 1.03 | 1.06 |
| Current ratio | 2.12 | 1.62 | 1.77 | 1.85 |
| Fixed charges coverage ratio | 2.23 | 1.80 | 1.69 | 1.94 |
| Interest coverage ratio | 8.58 | 11.76 | 11.36 | 20.24 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $1,018 | $500 | $1,208 | $1,161 |
| Short term investments | ||||
| Accounts receivable | $355 | $176 | $182 | $128 |
| Inventory | $1,251 | $1,770 | $1,160 | $1,142 |
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $295 | $325 | $234 | $253 |
| Total assets | $2,919 | $2,771 | $2,784 | $2,684 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $517 | $593 | $535 | $496 |
| Debt payments | ||||
| Accrued Expenses | $721 | $897 | $790 | $726 |
| Tax payable | $136 | $219 | $250 | $229 |
| Other liabilities | ||||
| Total liabilities | $1,374 | $1,709 | $1,575 | $1,451 |
| Working capital | $1,545 | $1,062 | $1,209 | $1,233 |
| Non cash working capital | $527 | $562 | $1 | $72 |
| Investment in working capital | ($35) | $561 | ($71) | |