Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$40,000 $35,000 $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 | -67 | -72 | -146 | -78 |
| Days inventory outstanding | 46 | 44 | 43 | 44 |
| Days payable outstanding | 153 | 155 | 226 | 159 |
| Days sales outstanding | 41 | 39 | 37 | 37 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.31 | 1.33 | 1.11 | 1.28 |
| Acid test | 0.32 | 0.41 | 0.52 | 0.51 |
| Acid test (liberal) | 1.01 | 1.05 | 0.93 | 1.05 |
| Debt to equity ratio (Adjusted) | 0.13 | 0.10 | 0.10 | 0.12 |
| Interest coverage ratio (Adjusted) | 35.57 | 30.75 | 26.36 | 34.97 |
| Fixed charges coverage ratio (Adjusted) | 16.46 | 15.64 | 15.23 | 18.14 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $39,474 | $35,137 | $32,562 | $29,261 |
| Expenses | $34,501 | $30,221 | $29,138 | $25,391 |
| Net income | $5,658 | $5,642 | $4,078 | $4,212 |
| Earnings before interest and taxes (EBIT) | $7,855 | $7,228 | $6,638 | $5,751 |
| Adjusted EBIT | $7,967 | $7,349 | $6,749 | $5,840 |
| Free cash flow to firm | $2,243 | $265 | $6,276 | $3,675 |
| Free cash flow to equity | $2,574 | $1,020 | $5,891 | $4,025 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $260 | $231 | $187 | $155 |
| Year one | $180 | $200 | $153 | $100 |
| Year two | $160 | $102 | $100 | $93 |
| Year three | $150 | $90 | $82 | $65 |
| Year four | $141 | $86 | $50 | $55 |
| Post year four | $314 | $213 | $197 | $198 |
| Total | $1,205 | $922 | $769 | $666 |
| Debt value | $740 | $552 | $458 | $394 |
| Depreciation | $148 | $110 | $76 | $66 |
Past growth rates |
|||||||||||||||||
16 % 14 % 12 % 10 % 8 % 6 % 4 % 2 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$8,000 $7,000 $6,000 $5,000 $4,000 $3,000 $2,000 $1,000 |
|
|
|
|
|
|
||||||||||||||||||||
|
|
|
|
|
|
||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | $469 | $3,282 | ($3,330) | |
| + Fixed Capital investment | $2,430 | $2,068 | $1,736 | $1,387 |
| + Acquisitions | $1,611 | $678 | $1,089 | $64 |
| - R&D amortized | ||||
| - Fixed capital depreciation | $1,426 | $1,406 | $1,308 | $1,264 |
| - Operating lease depreciation | $148 | $110 | $76 | $66 |
| = Reinvested | $2,936 | $4,512 | ($1,889) | $121 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $7,967 | $7,349 | $6,749 | $5,840 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $5,179 | $4,777 | $4,387 | $3,796 |
| Reinvestment expense (gain) | $2,936 | $4,512 | ($1,889) | $121 |
| Free cash flow to firm (FCFF) | $2,243 | $265 | $6,276 | $3,675 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 75.57 % | 36.02 % | 27.82 % |
| Working capital investment | 38.88 % | 0.62 % | 0.46 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 22.65 % | 23.38 % | 17.95 % |
| Net capital investments | 45.11 % | 43.26 % | 41.58 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 8.08 % | 8.28 % | 10.01 % |
| Profit | 0.28 % | 15.41 % | 12.05 % |
| Revenue | 11.63 % | 9.67 % | 9.74 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $910 | $1,651 | $1,716 | $1,280 |
| Short term investments | $1,571 | $1,171 | $3,166 | $2,165 |
| Accounts receivable | $4,389 | $3,725 | $3,261 | $2,999 |
| Inventory | $2,290 | $1,926 | $1,693 | $1,541 |
| Deferred taxes | ||||
| Prepaid expenses | $654 | |||
| Other assets | $991 | $657 | $618 | |
| Total assets | $10,151 | $9,130 | $10,454 | $8,639 |
| Accounts payable | $7,602 | $6,770 | $8,860 | $5,599 |
| Debt payments | $1,054 | |||
| Accrued Expenses | ||||
| Tax payable | $151 | $90 | $546 | $99 |
| Other liabilities | ||||
| Total liabilities | $7,753 | $6,860 | $9,406 | $6,752 |
| Working capital | $2,398 | $2,270 | $1,048 | $1,887 |
| Non cash working capital | ($83) | ($552) | ($3,834) | ($504) |
| Investment in working capital | $469 | $3,282 | ($3,330) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $39,474 | $35,137 | $32,562 | $29,261 |
| Expenses | $34,501 | $30,221 | $29,138 | $25,391 |
| Net income | $5,658 | $5,642 | $4,078 | $4,212 |
| Earnings before interest and taxes (EBIT) | $7,855 | $7,228 | $6,638 | $5,751 |
| Adjusted EBIT | $7,967 | $7,349 | $6,749 | $5,840 |
| Free cash flow to firm | $2,243 | $265 | $6,276 | $3,675 |
| Free cash flow to equity | $2,574 | $1,020 | $5,891 | $4,025 |
| Adjusted debt | $4,943 | $3,102 | $2,771 | $2,791 |
| Adjusted equity | $38,140 | $31,004 | $27,094 | $23,412 |
| Adjusted depreciation | $1,574 | $1,516 | $1,384 | $1,330 |
| Total reinvestment | $2,936 | $4,512 | ($1,889) | $121 |
| Adjusted EBIT | $7,967 | $7,349 | $6,749 | $5,840 |
| Adjusted EBIT(1 - t) | $5,179 | $4,777 | $4,387 | $3,796 |
| FCFF | $2,243 | $265 | $6,276 | $3,675 |
| FCFE | $2,574 | $1,020 | $5,891 | $4,025 |
| Cash conversion cycle | -67 | -72 | -146 | -78 |
| Days inventory outstanding | 46 | 44 | 43 | 44 |
| Days payable outstanding | 153 | 155 | 226 | 159 |
| Days sales outstanding | 41 | 39 | 37 | 37 |
| Acid test | 0.32 | 0.41 | 0.52 | 0.51 |
| liberal acid test | 1.01 | 1.05 | 0.93 | 1.05 |
| Current ratio | 1.31 | 1.33 | 1.11 | 1.28 |
| Fixed charges coverage ratio | 16.23 | 15.38 | 14.98 | 17.86 |
| Interest coverage ratio | 35.07 | 30.24 | 25.93 | 34.44 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $910 | $1,651 | $1,716 | $1,280 |
| Short term investments | $1,571 | $1,171 | $3,166 | $2,165 |
| Accounts receivable | $4,389 | $3,725 | $3,261 | $2,999 |
| Inventory | $2,290 | $1,926 | $1,693 | $1,541 |
| Deferred taxes | ||||
| Prepaid expenses | $654 | |||
| Other assets | $991 | $657 | $618 | |
| Total assets | $10,151 | $9,130 | $10,454 | $8,639 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $7,602 | $6,770 | $8,860 | $5,599 |
| Debt payments | $1,054 | |||
| Accrued Expenses | ||||
| Tax payable | $151 | $90 | $546 | $99 |
| Other liabilities | ||||
| Total liabilities | $7,753 | $6,860 | $9,406 | $6,752 |
| Working capital | $2,398 | $2,270 | $1,048 | $1,887 |
| Non cash working capital | ($83) | ($552) | ($3,834) | ($504) |
| Investment in working capital | $469 | $3,282 | ($3,330) | |