Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
$80,000 $60,000 $40,000 $20,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
($20,000) ($40,000) ($60,000) |
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 |
|---|---|---|---|---|---|---|---|---|---|---|
| Cash conversion cycle | 43 | 46 | 43 | 40 | 39 | 50 | 49 | 48 | 46 | 49 |
| Days inventory outstanding | 68 | 69 | 66 | 64 | 60 | 60 | 56 | 59 | 57 | 57 |
| Days payable outstanding | 57 | 54 | 50 | 53 | 46 | 38 | 34 | 37 | 40 | 36 |
| Days sales outstanding | 32 | 31 | 27 | 29 | 26 | 28 | 27 | 27 | 28 | 27 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 |
|---|---|---|---|---|---|---|---|---|---|---|
| Current ratio | 0.78 | 1.22 | 0.81 | 0.77 | 1.23 | 0.96 | 1.11 | 1.00 | 1.06 | 1.14 |
| Acid test | 0.18 | 0.39 | 0.32 | 0.27 | 0.50 | 0.29 | 0.26 | 0.16 | 0.26 | 0.26 |
| Acid test (liberal) | 0.56 | 0.90 | 0.61 | 0.57 | 0.94 | 0.69 | 0.76 | 0.65 | 0.75 | 0.79 |
| Debt to equity ratio (Adjusted) | 0.32 | 0.51 | 0.52 | 0.53 | 0.51 | 0.59 | 0.59 | 0.58 | 0.46 | 0.47 |
| Interest coverage ratio (Adjusted) | 12.81 | 12.82 | 14.50 | 17.26 | 15.95 | 13.15 | 8.39 | 10.84 | 12.40 | 14.24 |
| Fixed charges coverage ratio (Adjusted) | 10.31 | 10.33 | 11.53 | 13.32 | 13.54 | 11.28 | 8.39 | 10.84 | 12.40 | 14.24 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $76,476 | $68,222 | $56,741 | $51,407 |
| Expenses | $66,700 | $59,821 | $49,830 | $45,078 |
| Net income | $10,340 | $8,684 | $7,257 | $6,481 |
| Earnings before interest and taxes (EBIT) | $16,014 | $13,532 | $11,273 | $9,979 |
| Adjusted EBIT | $16,703 | $14,340 | $12,091 | $10,855 |
| Free cash flow to firm | $9,518 | ($44,736) | ($1,796) | ($461) |
| Free cash flow to equity | $9,374 | ($44,834) | ($1,795) | ($346) |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $316 | $269 | $215 | $186 |
| Year one | $238 | $212 | $162 | $150 |
| Year two | $208 | $182 | $126 | $134 |
| Year three | $174 | $168 | $114 | $99 |
| Year four | $102 | $140 | $101 | $86 |
| Post year four | $408 | $428 | $259 | $265 |
| Total | $1,446 | $1,399 | $977 | $920 |
| Debt value | $846 | $869 | $570 | $547 |
| Depreciation | $141 | $145 | $95 | $91 |
Past growth rates |
|||||||||||||||||||||||||
18 % 16 % 14 % 12 % 10 % 8 % |
|
|
|
|
|
|
|
||||||||||||||||||
|
|
|
|
|
|
|
||||||||||||||||||||
| all | 10 years | 6 years | 4 years | 2 years | |||||||||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||||||||||||
$20,000 $10,000 |
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||
($10,000) ($20,000) ($30,000) ($40,000) ($50,000) |
|
|
|
|
|
|
|
|||||||||||||||||||||||||||||
| 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $2,112 | $2,075 | $1,899 | $1,802 |
| + Working capital investment | $1,151 | $48 | $1,235 | ($1,459) |
| + Fixed Capital investment | $2,945 | $2,667 | $2,181 | $2,539 |
| + Acquisitions | $53,430 | $7,480 | $7,480 | |
| - R&D amortized | $1,598 | $1,391 | $1,201 | $1,021 |
| - Fixed capital depreciation | $3,130 | $2,627 | $1,844 | $1,733 |
| - Operating lease depreciation | $141 | $145 | $95 | $91 |
| = Reinvested | $1,339 | $54,057 | $9,655 | $7,517 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $16,703 | $14,340 | $12,091 | $10,855 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $10,857 | $9,321 | $7,859 | $7,056 |
| Reinvestment expense (gain) | $1,339 | $54,057 | $9,655 | $7,517 |
| Free cash flow to firm (FCFF) | $9,518 | ($44,736) | ($1,796) | ($461) |
| past reinvestment rates | 2 years | 4 years | 6 years | 10 years | all |
|---|---|---|---|---|---|
| Reinvestment | 296.13 % | 205.41 % | 168.29 % | 130.10 % | 130.10 % |
| Working capital investment | 5.56 % | 1.54 % | -4.96 % | -4.13 % | -4.13 % |
| R&D investment | 20.86 % | 22.85 % | 25.18 % | 29.22 % | 29.22 % |
| Acquisitions | 286.60 % | 193.60 % | 162.18 % | 110.31 % | 110.31 % |
| Net capital investments | 27.87 % | 29.87 % | 29.59 % | 39.79 % | 39.79 % |
| Past growth rates | 2 years | 4 years | 6 years | 10 years | all |
|---|---|---|---|---|---|
| EBIT (adjusted) | 15.22 % | 14.66 % | 14.82 % | 9.52 % | 9.52 % |
| Profit | 17.41 % | 15.88 % | 16.70 % | 13.30 % | 13.30 % |
| Revenue | 11.41 % | 13.71 % | 13.30 % | 8.50 % | 8.50 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $5,354 | $6,693 | $6,389 | $5,469 |
| Short term investments | $202 | $1,133 | $1,744 | $423 |
| Accounts receivable | $6,629 | $5,725 | $4,185 | $4,062 |
| Inventory | $6,819 | $6,291 | $5,006 | $4,400 |
| Deferred taxes | $1,727 | $1,611 | $1,081 | $958 |
| Prepaid expenses | $3,300 | $2,876 | $1,924 | $1,803 |
| Other assets | ||||
| Total assets | $24,031 | $24,329 | $20,329 | $17,115 |
| Accounts payable | $5,710 | $4,910 | $3,802 | $3,617 |
| Debt payments | $12,039 | $2,128 | $11,441 | $8,287 |
| Accrued Expenses | $9,586 | $9,587 | $7,531 | $7,689 |
| Tax payable | $3,382 | $3,360 | $2,265 | $2,554 |
| Other liabilities | ||||
| Total liabilities | $30,717 | $19,985 | $25,039 | $22,147 |
| Working capital | ($6,686) | $4,344 | ($4,710) | ($5,032) |
| Non cash working capital | ($203) | ($1,354) | ($1,402) | ($2,637) |
| Investment in working capital | $1,151 | $48 | $1,235 | ($1,459) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | $76,476 | $68,222 | $56,741 | $51,407 | $43,377 | $40,238 | $39,244 | $39,951 | $38,125 | $37,154 |
| Expenses | $66,700 | $59,821 | $49,830 | $45,078 | $38,429 | $36,194 | $36,996 | $36,713 | $34,597 | $33,575 |
| Net income | $10,340 | $8,684 | $7,257 | $6,481 | $5,186 | $4,352 | $2,922 | $3,542 | $3,763 | $3,780 |
| Earnings before interest and taxes (EBIT) | $16,014 | $13,532 | $11,273 | $9,979 | $8,091 | $6,986 | $5,410 | $6,258 | $6,488 | $6,256 |
| Adjusted EBIT | $16,703 | $14,340 | $12,091 | $10,855 | $8,947 | $7,932 | $6,662 | $7,830 | $8,059 | $7,802 |
| Free cash flow to firm | $9,518 | ($44,736) | ($1,796) | ($461) | $679 | $12 | $3,473 | ($943) | $3,105 | ($627) |
| Free cash flow to equity | $9,374 | ($44,834) | ($1,795) | ($346) | $805 | $54 | $3,317 | ($919) | $3,201 | ($450) |
| Adjusted debt | $24,221 | $36,845 | $13,457 | $13,101 | $11,806 | $11,505 | $9,792 | $8,916 | $6,231 | $5,765 |
| Adjusted equity | $76,583 | $72,047 | $25,917 | $24,937 | $23,034 | $19,647 | $16,699 | $15,404 | $13,604 | $12,236 |
| Adjusted depreciation | $4,869 | $4,163 | $3,140 | $2,845 | $2,612 | $2,448 | $2,788 | $2,518 | $2,303 | $1,598 |
| Total reinvestment | $1,339 | $54,057 | $9,655 | $7,517 | $5,137 | $5,144 | $857 | $6,033 | $2,133 | $5,776 |
| Adjusted EBIT | $16,703 | $14,340 | $12,091 | $10,855 | $8,947 | $7,932 | $6,662 | $7,830 | $8,059 | $7,802 |
| Adjusted EBIT(1 - t) | $10,857 | $9,321 | $7,859 | $7,056 | $5,815 | $5,156 | $4,330 | $5,089 | $5,239 | $5,149 |
| FCFF | $9,518 | ($44,736) | ($1,796) | ($461) | $679 | $12 | $3,473 | ($943) | $3,105 | ($627) |
| FCFE | $9,374 | ($44,834) | ($1,795) | ($346) | $805 | $54 | $3,317 | ($919) | $3,201 | ($450) |
| Cash conversion cycle | 43 | 46 | 43 | 40 | 39 | 50 | 49 | 48 | 46 | 49 |
| Days inventory outstanding | 68 | 69 | 66 | 64 | 60 | 60 | 56 | 59 | 57 | 57 |
| Days payable outstanding | 57 | 54 | 50 | 53 | 46 | 38 | 34 | 37 | 40 | 36 |
| Days sales outstanding | 32 | 31 | 27 | 29 | 26 | 28 | 27 | 27 | 28 | 27 |
| Acid test | 0.18 | 0.39 | 0.32 | 0.27 | 0.50 | 0.29 | 0.26 | 0.16 | 0.26 | 0.26 |
| liberal acid test | 0.56 | 0.90 | 0.61 | 0.57 | 0.94 | 0.69 | 0.76 | 0.65 | 0.75 | 0.79 |
| Current ratio | 0.78 | 1.22 | 0.81 | 0.77 | 1.23 | 0.96 | 1.11 | 1.00 | 1.06 | 1.14 |
| Fixed charges coverage ratio | 9.89 | 9.75 | 10.75 | 12.24 | 12.24 | 9.94 | 6.81 | 8.67 | 9.98 | 11.42 |
| Interest coverage ratio | 12.28 | 12.09 | 13.52 | 15.86 | 14.42 | 11.59 | 6.81 | 8.67 | 9.98 | 11.42 |
|   | ||||||||||
| Current Assets | ||||||||||
| Cash and equivalent | $5,354 | $6,693 | $6,389 | $5,469 | $5,912 | $3,427 | $2,306 | $1,415 | $2,294 | $1,549 |
| Short term investments | $202 | $1,133 | $1,744 | $423 | $300 | $196 | $212 | $185 | $506 | $857 |
| Accounts receivable | $6,629 | $5,725 | $4,185 | $4,062 | $3,038 | $3,090 | $2,931 | $2,910 | $2,940 | $2,781 |
| Inventory | $6,819 | $6,291 | $5,006 | $4,400 | $3,640 | $3,456 | $3,384 | $3,490 | $3,338 | $3,284 |
| Deferred taxes | $1,727 | $1,611 | $1,081 | $958 | $843 | $521 | $397 | $309 | $621 | $595 |
| Prepaid expenses | $3,300 | $2,876 | $1,924 | $1,803 | $1,487 | $1,476 | $1,659 | $1,760 | $1,659 | $1,511 |
| Other assets | ||||||||||
| Total assets | $24,031 | $24,329 | $20,329 | $17,115 | $15,220 | $12,166 | $10,889 | $10,069 | $11,358 | $10,577 |
|   | ||||||||||
| Current Liabilities | ||||||||||
| Accounts payable | $5,710 | $4,910 | $3,802 | $3,617 | $2,795 | $2,205 | $2,075 | $2,209 | $2,300 | $2,051 |
| Debt payments | $12,039 | $2,128 | $11,441 | $8,287 | $2,172 | $3,731 | $2,233 | $3,210 | $3,150 | $2,281 |
| Accrued Expenses | $9,586 | $9,587 | $7,531 | $7,689 | $5,512 | $5,330 | $4,631 | $3,721 | $4,083 | $3,942 |
| Tax payable | $3,382 | $3,360 | $2,265 | $2,554 | $1,879 | $1,438 | $907 | $925 | $1,228 | $976 |
| Other liabilities | ||||||||||
| Total liabilities | $30,717 | $19,985 | $25,039 | $22,147 | $12,358 | $12,704 | $9,846 | $10,065 | $10,761 | $9,250 |
| Working capital | ($6,686) | $4,344 | ($4,710) | ($5,032) | $2,862 | ($538) | $1,043 | $4 | $597 | $1,327 |
| Non cash working capital | ($203) | ($1,354) | ($1,402) | ($2,637) | ($1,178) | ($430) | $758 | $1,614 | $947 | $1,202 |
| Investment in working capital | $1,151 | $48 | $1,235 | ($1,459) | ($748) | ($1,188) | ($856) | $667 | ($255) | |