Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||||||||||
$18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
($2,000) |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Cash conversion cycle | 113 | 119 | 114 | 120 | 140 |
| Days inventory outstanding | 46 | 45 | 48 | 45 | 46 |
| Days payable outstanding | 49 | 44 | 41 | 41 | 36 |
| Days sales outstanding | 116 | 118 | 108 | 116 | 130 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Current ratio | 2.09 | 1.86 | 2.01 | 1.73 | 1.37 |
| Acid test | 0.27 | 0.33 | 0.36 | 0.51 | 0.33 |
| Acid test (liberal) | 1.77 | 1.62 | 1.73 | 1.55 | 1.21 |
| Debt to equity ratio (Adjusted) | 0.67 | 0.66 | 0.75 | 0.95 | 1.63 |
| Interest coverage ratio (Adjusted) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Fixed charges coverage ratio (Adjusted) | 7.02 | 7.36 | 8.36 | 9.21 | 6.32 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $17,228 | $15,895 | $15,701 | $15,722 |
| Expenses | $16,190 | $14,799 | $14,874 | $15,097 |
| Net income | $1,135 | $1,210 | $978 | $859 |
| Earnings before interest and taxes (EBIT) | $1,535 | $922 | $973 | $1,199 |
| Adjusted EBIT | $1,868 | $1,392 | $1,646 | $2,044 |
| Free cash flow to firm | ($17) | $774 | $1,562 | $1,217 |
| Free cash flow to equity | ($29) | $1,360 | $1,954 | $1,370 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $266 | $189 | $197 | $222 |
| Year one | $212 | $161 | $165 | $181 |
| Year two | $169 | $124 | $124 | $143 |
| Year three | $129 | $102 | $102 | $109 |
| Year four | $90 | $84 | $90 | $94 |
| Post year four | $158 | $158 | $197 | $256 |
| Total | $1,024 | $818 | $875 | $1,005 |
| Debt value | $579 | $481 | $513 | $588 |
| Depreciation | $116 | $96 | $103 | $118 |
Past growth rates |
|||||||||||||||||
30 % 25 % 20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
-5 % -10 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
|||||||||||||||||||||||||||||||
$2,500 $2,000 $1,500 $1,000 $500 |
|
|
|
|
|
|
|
||||||||||||||||||||||||
($500) |
|
|
|
|
|
|
|||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $912 | $922 | $943 | $914 |
| + Working capital investment | ($116) | $42 | ($521) | ($41) |
| + Fixed Capital investment | $236 | $215 | $181 | $204 |
| + Acquisitions | $1,700 | $229 | $1 | $12 |
| - R&D amortized | $729 | $545 | $356 | $174 |
| - Fixed capital depreciation | $656 | $636 | $637 | $686 |
| - Operating lease depreciation | $116 | $96 | $103 | $118 |
| = Reinvested | $1,231 | $131 | ($492) | $112 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $1,868 | $1,392 | $1,646 | $2,044 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $1,214 | $905 | $1,070 | $1,328 |
| Reinvestment expense (gain) | $1,231 | $131 | ($492) | $112 |
| Free cash flow to firm (FCFF) | ($17) | $774 | $1,562 | $1,217 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 57.92 % | 23.28 % | 19.89 % |
| Working capital investment | -2.46 % | -17.87 % | -11.34 % |
| R&D investment | 88.52 % | 88.39 % | 84.79 % |
| Acquisitions | 82.67 % | 55.14 % | 33.27 % |
| Net capital investments | 21.60 % | 20.04 % | 19.18 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 29.21 % | 6.78 % | 0.68 % |
| Profit | -6.40 % | 7.09 % | 20.93 % |
| Revenue | 8.05 % | 4.69 % | 2.01 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,099 | $1,399 | $1,322 | $3,218 |
| Short term investments | $137 | $244 | ||
| Accounts receivable | $5,454 | $5,121 | $4,641 | $5,008 |
| Inventory | $1,305 | $1,163 | $1,201 | $1,143 |
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $682 | $934 | $1,328 | $1,559 |
| Total assets | $8,540 | $8,754 | $8,736 | $10,928 |
| Accounts payable | $1,367 | $1,133 | $1,043 | $1,037 |
| Debt payments | $525 | $1,485 | $1,139 | $3,074 |
| Accrued Expenses | $673 | $663 | $621 | $637 |
| Tax payable | ||||
| Other liabilities | $1,512 | $1,417 | $1,543 | $1,552 |
| Total liabilities | $4,077 | $4,698 | $4,346 | $6,300 |
| Working capital | $4,463 | $4,056 | $4,390 | $4,628 |
| Non cash working capital | $3,889 | $4,005 | $3,963 | $4,484 |
| Investment in working capital | ($116) | $42 | ($521) | ($41) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Revenue | $17,228 | $15,895 | $15,701 | $15,722 | $15,701 |
| Expenses | $16,190 | $14,799 | $14,874 | $15,097 | $15,412 |
| Net income | $1,135 | $1,210 | $978 | $859 | $360 |
| Earnings before interest and taxes (EBIT) | $1,535 | $922 | $973 | $1,199 | $494 |
| Adjusted EBIT | $1,868 | $1,392 | $1,646 | $2,044 | $1,484 |
| Free cash flow to firm | ($17) | $774 | $1,562 | $1,217 | $760 |
| Free cash flow to equity | ($29) | $1,360 | $1,954 | $1,370 | $911 |
| Adjusted debt | $7,518 | $6,141 | $6,652 | $7,638 | $7,606 |
| Adjusted equity | $11,160 | $9,275 | $8,816 | $8,001 | $4,679 |
| Adjusted depreciation | $1,501 | $1,277 | $1,096 | $977 | $861 |
| Total reinvestment | $1,231 | $131 | ($492) | $112 | $204 |
| Adjusted EBIT | $1,868 | $1,392 | $1,646 | $2,044 | $1,484 |
| Adjusted EBIT(1 - t) | $1,214 | $905 | $1,070 | $1,328 | $965 |
| FCFF | ($17) | $774 | $1,562 | $1,217 | $760 |
| FCFE | ($29) | $1,360 | $1,954 | $1,370 | $911 |
| Cash conversion cycle | 113 | 119 | 114 | 120 | 140 |
| Days inventory outstanding | 46 | 45 | 48 | 45 | 46 |
| Days payable outstanding | 49 | 44 | 41 | 41 | 36 |
| Days sales outstanding | 116 | 118 | 108 | 116 | 130 |
| Acid test | 0.27 | 0.33 | 0.36 | 0.51 | 0.33 |
| liberal acid test | 1.77 | 1.62 | 1.73 | 1.55 | 1.21 |
| Current ratio | 2.09 | 1.86 | 2.01 | 1.73 | 1.37 |
| Fixed charges coverage ratio | 5.77 | 4.88 | 4.94 | 5.40 | 2.10 |
| Interest coverage ratio | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
|   | |||||
| Current Assets | |||||
| Cash and equivalent | $1,099 | $1,399 | $1,322 | $3,218 | $2,477 |
| Short term investments | $137 | $244 | |||
| Accounts receivable | $5,454 | $5,121 | $4,641 | $5,008 | $5,601 |
| Inventory | $1,305 | $1,163 | $1,201 | $1,143 | $1,152 |
| Deferred taxes | |||||
| Prepaid expenses | |||||
| Other assets | $682 | $934 | $1,328 | $1,559 | $1,105 |
| Total assets | $8,540 | $8,754 | $8,736 | $10,928 | $10,335 |
|   | |||||
| Current Liabilities | |||||
| Accounts payable | $1,367 | $1,133 | $1,043 | $1,037 | $898 |
| Debt payments | $525 | $1,485 | $1,139 | $3,074 | $4,236 |
| Accrued Expenses | $673 | $663 | $621 | $637 | $532 |
| Tax payable | |||||
| Other liabilities | $1,512 | $1,417 | $1,543 | $1,552 | $1,903 |
| Total liabilities | $4,077 | $4,698 | $4,346 | $6,300 | $7,569 |
| Working capital | $4,463 | $4,056 | $4,390 | $4,628 | $2,766 |
| Non cash working capital | $3,889 | $4,005 | $3,963 | $4,484 | $4,525 |
| Investment in working capital | ($116) | $42 | ($521) | ($41) | |