Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
($5,000) |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | 122 | 118 | 94 | 64 |
| Days inventory outstanding | 127 | 127 | 127 | 112 |
| Days payable outstanding | 85 | 76 | 97 | 130 |
| Days sales outstanding | 80 | 66 | 64 | 82 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.20 | 1.59 | 1.78 | 1.50 |
| Acid test | 0.26 | 0.62 | 0.84 | 0.76 |
| Acid test (liberal) | 0.95 | 1.27 | 1.48 | 1.32 |
| Debt to equity ratio (Adjusted) | 0.28 | 0.51 | 0.63 | 0.86 |
| Interest coverage ratio (Adjusted) | 0.00 | 0.00 | 0.00 | 0.00 |
| Fixed charges coverage ratio (Adjusted) | 34.10 | 34.02 | 50.21 | 52.98 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $19,348 | $17,914 | $19,207 | $19,380 |
| Expenses | $18,177 | $16,704 | $17,081 | $17,543 |
| Net income | $2,165 | $1,585 | $3,000 | $2,388 |
| Earnings before interest and taxes (EBIT) | $2,968 | $2,195 | $3,932 | $3,907 |
| Adjusted EBIT | $4,876 | $4,796 | $6,477 | $6,517 |
| Free cash flow to firm | ($701) | $644 | $1,527 | $1,699 |
| Free cash flow to equity | $59 | $1,572 | $2,733 | $2,338 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $143 | $141 | $129 | $123 |
| Year one | $116 | $120 | $105 | $99 |
| Year two | $90 | $97 | $81 | $78 |
| Year three | $72 | $70 | $58 | $65 |
| Year four | $71 | $63 | $34 | $62 |
| Post year four | $212 | $223 | $68 | $58 |
| Total | $704 | $714 | $475 | $485 |
| Debt value | $433 | $454 | $293 | $304 |
| Depreciation | $72 | $76 | $73 | $76 |
Past growth rates |
|||||||||||||||||
35 % 30 % 25 % 20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
-5 % -10 % -15 % -20 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$7,000 $6,000 $5,000 $4,000 $3,000 $2,000 $1,000 |
|
|
|
|
|
|
||||||||||||||||||||
($1,000) |
|
|
|
|
|
|||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $3,512 | $3,067 | $2,746 | $2,563 |
| + Working capital investment | $1,390 | $155 | $458 | |
| + Fixed Capital investment | $843 | $785 | $738 | $676 |
| + Acquisitions | $415 | $283 | ||
| - R&D amortized | $1,675 | $531 | $256 | |
| - Fixed capital depreciation | $542 | $927 | $929 | $909 |
| - Operating lease depreciation | $72 | $76 | $73 | $76 |
| = Reinvested | $3,871 | $2,473 | $2,683 | $2,537 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $4,876 | $4,796 | $6,477 | $6,517 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $3,169 | $3,118 | $4,210 | $4,236 |
| Reinvestment expense (gain) | $3,871 | $2,473 | $2,683 | $2,537 |
| Free cash flow to firm (FCFF) | ($701) | $644 | $1,527 | $1,699 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 100.74 % | 88.40 % | 81.27 % |
| Working capital investment | 24.42 % | 19.90 % | 14.93 % |
| R&D investment | 104.60 % | 91.47 % | 83.73 % |
| Acquisitions | 6.55 % | 4.36 % | 4.94 % |
| Net capital investments | 25.89 % | 23.10 % | 21.32 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 1.64 % | -14.88 % | -11.66 % |
| Profit | 30.93 % | -18.56 % | -9.12 % |
| Revenue | 7.70 % | 0.37 % | -0.73 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,801 | $2,018 | $3,050 | $3,680 |
| Short term investments | $424 | $1,995 | $2,749 | $3,794 |
| Accounts receivable | $4,240 | $3,247 | $3,378 | $4,373 |
| Inventory | $2,162 | $2,079 | $2,060 | $1,830 |
| Deferred taxes | $851 | $649 | $776 | $805 |
| Prepaid expenses | $310 | $314 | $270 | $319 |
| Other assets | $560 | |||
| Total assets | $10,348 | $10,302 | $12,283 | $14,801 |
| Accounts payable | $1,442 | $1,239 | $1,579 | $2,127 |
| Debt payments | $1,891 | $187 | $231 | $1,883 |
| Accrued Expenses | $2,951 | $2,332 | $2,321 | $2,838 |
| Tax payable | $296 | $444 | $538 | $1,023 |
| Other liabilities | $2,064 | $2,294 | $2,221 | $1,972 |
| Total liabilities | $8,644 | $6,496 | $6,890 | $9,843 |
| Working capital | $1,704 | $3,806 | $5,393 | $4,958 |
| Non cash working capital | $1,370 | ($20) | ($175) | ($633) |
| Investment in working capital | $1,390 | $155 | $458 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $19,348 | $17,914 | $19,207 | $19,380 |
| Expenses | $18,177 | $16,704 | $17,081 | $17,543 |
| Net income | $2,165 | $1,585 | $3,000 | $2,388 |
| Earnings before interest and taxes (EBIT) | $2,968 | $2,195 | $3,932 | $3,907 |
| Adjusted EBIT | $4,876 | $4,796 | $6,477 | $6,517 |
| Free cash flow to firm | ($701) | $644 | $1,527 | $1,699 |
| Free cash flow to equity | $59 | $1,572 | $2,733 | $2,338 |
| Adjusted debt | $4,814 | $7,702 | $8,657 | $8,767 |
| Adjusted equity | $17,364 | $15,044 | $13,771 | $10,202 |
| Adjusted depreciation | $2,289 | $1,534 | $1,259 | $985 |
| Total reinvestment | $3,871 | $2,473 | $2,683 | $2,537 |
| Adjusted EBIT | $4,876 | $4,796 | $6,477 | $6,517 |
| Adjusted EBIT(1 - t) | $3,169 | $3,118 | $4,210 | $4,236 |
| FCFF | ($701) | $644 | $1,527 | $1,699 |
| FCFE | $59 | $1,572 | $2,733 | $2,338 |
| Cash conversion cycle | 122 | 118 | 94 | 64 |
| Days inventory outstanding | 127 | 127 | 127 | 112 |
| Days payable outstanding | 85 | 76 | 97 | 130 |
| Days sales outstanding | 80 | 66 | 64 | 82 |
| Acid test | 0.26 | 0.62 | 0.84 | 0.76 |
| liberal acid test | 0.95 | 1.27 | 1.48 | 1.32 |
| Current ratio | 1.20 | 1.59 | 1.78 | 1.50 |
| Fixed charges coverage ratio | 20.76 | 15.57 | 30.48 | 31.76 |
| Interest coverage ratio | 0.00 | 0.00 | 0.00 | 0.00 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $1,801 | $2,018 | $3,050 | $3,680 |
| Short term investments | $424 | $1,995 | $2,749 | $3,794 |
| Accounts receivable | $4,240 | $3,247 | $3,378 | $4,373 |
| Inventory | $2,162 | $2,079 | $2,060 | $1,830 |
| Deferred taxes | $851 | $649 | $776 | $805 |
| Prepaid expenses | $310 | $314 | $270 | $319 |
| Other assets | $560 | |||
| Total assets | $10,348 | $10,302 | $12,283 | $14,801 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $1,442 | $1,239 | $1,579 | $2,127 |
| Debt payments | $1,891 | $187 | $231 | $1,883 |
| Accrued Expenses | $2,951 | $2,332 | $2,321 | $2,838 |
| Tax payable | $296 | $444 | $538 | $1,023 |
| Other liabilities | $2,064 | $2,294 | $2,221 | $1,972 |
| Total liabilities | $8,644 | $6,496 | $6,890 | $9,843 |
| Working capital | $1,704 | $3,806 | $5,393 | $4,958 |
| Non cash working capital | $1,370 | ($20) | ($175) | ($633) |
| Investment in working capital | $1,390 | $155 | $458 | |