Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$30,000 $25,000 $20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | 106 | 109 | 101 | 0 |
| Days inventory outstanding | 88 | 87 | 87 | 0 |
| Days payable outstanding | 53 | 48 | 52 | 0 |
| Days sales outstanding | 71 | 69 | 66 | 0 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.54 | 1.62 | 1.66 | 0.00 |
| Acid test | 0.17 | 0.24 | 0.25 | 0.00 |
| Acid test (liberal) | 0.92 | 1.00 | 1.03 | 0.00 |
| Debt to equity ratio (Adjusted) | 0.46 | 0.54 | 0.71 | 0.52 |
| Interest coverage ratio (Adjusted) | 11.46 | 10.98 | 10.44 | 9.30 |
| Fixed charges coverage ratio (Adjusted) | 6.50 | 6.70 | 6.81 | 5.08 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $29,378 | $27,421 | $26,639 | $27,340 |
| Expenses | $27,665 | $25,834 | $26,438 | $26,224 |
| Net income | $2,988 | $3,148 | $2,053 | $1,780 |
| Earnings before interest and taxes (EBIT) | $4,166 | $3,804 | $4,039 | $1,813 |
| Adjusted EBIT | $4,926 | $5,049 | $5,408 | $3,367 |
| Free cash flow to firm | $2,544 | $2,074 | $2,234 | $932 |
| Free cash flow to equity | $2,762 | $2,891 | $1,865 | $1,776 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $328 | $294 | $276 | $301 |
| Year one | $179 | $155 | $151 | $136 |
| Year two | $145 | $109 | $122 | $116 |
| Year three | $118 | $82 | $80 | $77 |
| Year four | $91 | $59 | $73 | $55 |
| Post year four | $159 | $107 | $103 | $111 |
| Total | $1,020 | $806 | $805 | $796 |
| Debt value | $559 | $418 | $437 | $402 |
| Depreciation | $112 | $84 | $109 | $80 |
Past growth rates |
|||||||||||||||||
20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
-5 % -10 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$5,500 $5,000 $4,500 $4,000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 |
|
|
|
|
|
|
||||||||||||||||||||
|
|
|
|
|
|
||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $1,338 | $1,302 | $1,336 | $1,333 |
| + Working capital investment | ($1) | $49 | ||
| + Fixed Capital investment | $1,585 | $1,532 | $1,340 | $1,232 |
| + Acquisitions | $13 | $60 | $206 | $119 |
| - R&D amortized | $794 | $267 | $133 | |
| - Fixed capital depreciation | $1,371 | $1,384 | $1,358 | $1,347 |
| - Operating lease depreciation | $112 | $84 | $109 | $80 |
| = Reinvested | $658 | $1,208 | $1,281 | $1,257 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $4,926 | $5,049 | $5,408 | $3,367 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $3,202 | $3,282 | $3,515 | $2,188 |
| Reinvestment expense (gain) | $658 | $1,208 | $1,281 | $1,257 |
| Free cash flow to firm (FCFF) | $2,544 | $2,074 | $2,234 | $932 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 28.69 % | 31.27 % | 37.81 % |
| Working capital investment | 0.73 % | 0.49 % | 0.37 % |
| R&D investment | 40.73 % | 39.82 % | 45.09 % |
| Acquisitions | 1.12 % | 2.70 % | 3.38 % |
| Net capital investments | 48.09 % | 44.77 % | 47.65 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | -2.47 % | -4.70 % | 9.22 % |
| Profit | -5.22 % | 17.13 % | 18.93 % |
| Revenue | 6.89 % | 4.92 % | 2.49 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,305 | $1,814 | $1,736 | |
| Short term investments | $131 | $79 | $115 | |
| Accounts receivable | $5,683 | $5,198 | $4,801 | |
| Inventory | $5,278 | $4,941 | $4,743 | |
| Deferred taxes | $564 | |||
| Prepaid expenses | $199 | $182 | $199 | |
| Other assets | $656 | $828 | ||
| Total assets | $13,160 | $12,870 | $12,422 |
| Accounts payable | $3,172 | $2,711 | $2,819 | |
| Debt payments | $1,370 | $1,517 | $1,397 | |
| Accrued Expenses | $3,823 | $3,534 | $2,967 | |
| Tax payable | $176 | $178 | $280 | |
| Other liabilities | ||||
| Total liabilities | $8,541 | $7,940 | $7,463 | |
| Working capital | $4,619 | $4,930 | $4,959 | |
| Non cash working capital | $4,553 | $4,554 | $4,505 | |
| Investment in working capital | ($1) | $49 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $29,378 | $27,421 | $26,639 | $27,340 |
| Expenses | $27,665 | $25,834 | $26,438 | $26,224 |
| Net income | $2,988 | $3,148 | $2,053 | $1,780 |
| Earnings before interest and taxes (EBIT) | $4,166 | $3,804 | $4,039 | $1,813 |
| Adjusted EBIT | $4,926 | $5,049 | $5,408 | $3,367 |
| Free cash flow to firm | $2,544 | $2,074 | $2,234 | $932 |
| Free cash flow to equity | $2,762 | $2,891 | $1,865 | $1,776 |
| Adjusted debt | $6,514 | $6,431 | $7,220 | $5,950 |
| Adjusted equity | $14,307 | $11,958 | $10,240 | $11,377 |
| Adjusted depreciation | $2,277 | $1,735 | $1,601 | $1,427 |
| Total reinvestment | $658 | $1,208 | $1,281 | $1,257 |
| Adjusted EBIT | $4,926 | $5,049 | $5,408 | $3,367 |
| Adjusted EBIT(1 - t) | $3,202 | $3,282 | $3,515 | $2,188 |
| FCFF | $2,544 | $2,074 | $2,234 | $932 |
| FCFE | $2,762 | $2,891 | $1,865 | $1,776 |
| Cash conversion cycle | 106 | 109 | 101 | 0 |
| Days inventory outstanding | 88 | 87 | 87 | 0 |
| Days payable outstanding | 53 | 48 | 52 | 0 |
| Days sales outstanding | 71 | 69 | 66 | 0 |
| Acid test | 0.17 | 0.24 | 0.25 | 0.00 |
| liberal acid test | 0.92 | 1.00 | 1.03 | 0.00 |
| Current ratio | 1.54 | 1.62 | 1.66 | 0.00 |
| Fixed charges coverage ratio | 5.50 | 5.05 | 5.09 | 2.73 |
| Interest coverage ratio | 9.69 | 8.27 | 7.80 | 5.01 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $1,305 | $1,814 | $1,736 | |
| Short term investments | $131 | $79 | $115 | |
| Accounts receivable | $5,683 | $5,198 | $4,801 | |
| Inventory | $5,278 | $4,941 | $4,743 | |
| Deferred taxes | $564 | |||
| Prepaid expenses | $199 | $182 | $199 | |
| Other assets | $656 | $828 | ||
| Total assets | $13,160 | $12,870 | $12,422 | |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $3,172 | $2,711 | $2,819 | |
| Debt payments | $1,370 | $1,517 | $1,397 | |
| Accrued Expenses | $3,823 | $3,534 | $2,967 | |
| Tax payable | $176 | $178 | $280 | |
| Other liabilities | ||||
| Total liabilities | $8,541 | $7,940 | $7,463 | |
| Working capital | $4,619 | $4,930 | $4,959 | |
| Non cash working capital | $4,553 | $4,554 | $4,505 | |
| Investment in working capital | ($1) | $49 | ||