Earnings in (Millions) |
|||||||||||||||||||||||||||||||||
$80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 |
|
|
|
|
|
||||||||||||||||||||||||||||
|
|
|
|
|
||||||||||||||||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash conversion cycle | 80 | 72 | 88 |
| Days inventory outstanding | 74 | 68 | 88 |
| Days payable outstanding | 10 | 11 | 30 |
| Days sales outstanding | 16 | 15 | 31 |
| Risk ratios | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current ratio | 1.22 | 1.03 | 0.99 |
| Acid test | 0.35 | 0.19 | 0.24 |
| Acid test (liberal) | 0.66 | 0.69 | 0.58 |
| Debt to equity ratio (Adjusted) | 0.05 | 0.36 | 0.09 |
| Interest coverage ratio (Adjusted) | 65.93 | 43.81 | 28.04 |
| Fixed charges coverage ratio (Adjusted) | 40.74 | 20.56 | 15.27 |
| Earnings in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $73,801 | $67,051 | $63,741 |
| Expenses | $65,091 | $58,419 | $55,831 |
| Net income | $9,786 | $12,022 | $10,435 |
| Earnings before interest and taxes (EBIT) | $14,097 | $15,789 | $14,365 |
| Adjusted EBIT | $14,176 | $16,079 | $14,610 |
| Free cash flow to firm | $692 | $12,602 | $4,225 |
| Free cash flow to equity | $1,210 | $13,987 | $4,972 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current year | $133 | $415 | $436 |
| Year one | $108 | $316 | $329 |
| Year two | $72 | $225 | $232 |
| Year three | $42 | $155 | $157 |
| Year four | $37 | $115 | $121 |
| Post year four | $247 | $340 | $344 |
| Total | $639 | $1,566 | $1,619 |
| Debt value | $378 | $930 | $957 |
| Depreciation | $54 | $186 | $191 |
Past growth rates |
|||||||||||||
10 % 5 % |
|
|
|
|
|||||||||
-5 % -10 % -15 % -20 % -25 % |
|
|
|
||||||||||
| all | 2 years | ||||||||||||
Cashflow in (Millions) |
|||||||||||||||||||||
$18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 |
|
|
|
|
|
||||||||||||||||
|
|
|
|
|
||||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| + R&D investment | |||
| + Working capital investment | $3,681 | ($2,619) | |
| + Fixed Capital investment | $1,458 | $2,454 | $2,206 |
| + Acquisitions | $4,417 | $4 | $4,932 |
| - R&D amortized | |||
| - Fixed capital depreciation | $980 | $1,804 | $1,675 |
| - Operating lease depreciation | $54 | $186 | $191 |
| = Reinvested | $8,522 | ($2,151) | $5,272 |
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Adjusted EBIT | $14,176 | $16,079 | $14,610 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $9,214 | $10,451 | $9,496 |
| Reinvestment expense (gain) | $8,522 | ($2,151) | $5,272 |
| Free cash flow to firm (FCFF) | $692 | $12,602 | $4,225 |
| past reinvestment rates | 2 years | all |
|---|---|---|
| Reinvestment | 35.95 % | 42.47 % |
| Working capital investment | 7.44 % | 4.96 % |
| R&D investment | 0.00 % | 0.00 % |
| Acquisitions | 23.99 % | 33.30 % |
| Net capital investments | 19.65 % | 20.84 % |
| Past growth rates | 2 years | all |
|---|---|---|
| EBIT (adjusted) | -12.58 % | -1.45 % |
| Profit | -20.51 % | -3.02 % |
| Revenue | 9.58 % | 7.38 % |
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash and equivalent | $6,498 | $4,781 | $6,258 |
| Short term investments | |||
| Accounts receivable | $3,323 | $2,808 | $5,361 |
| Inventory | $10,571 | $8,680 | $10,584 |
| Deferred taxes | |||
| Prepaid expenses | |||
| Other assets | $2,498 | $9,883 | $3,578 |
| Total assets | $22,890 | $26,152 | $25,781 |
| Accounts payable | $1,463 | $1,414 | $3,645 |
| Debt payments | $3,083 | $1,068 | $6,266 |
| Accrued Expenses | $11,994 | $10,486 | $13,182 |
| Tax payable | $654 | $782 | $1,393 |
| Other liabilities | $1,588 | $11,677 | $1,672 |
| Total liabilities | $18,782 | $25,427 | $26,158 |
| Working capital | $4,108 | $725 | ($377) |
| Non cash working capital | $693 | ($2,988) | ($369) |
| Investment in working capital | $3,681 | ($2,619) |
| Earnings in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $73,801 | $67,051 | $63,741 |
| Expenses | $65,091 | $58,419 | $55,831 |
| Net income | $9,786 | $12,022 | $10,435 |
| Earnings before interest and taxes (EBIT) | $14,097 | $15,789 | $14,365 |
| Adjusted EBIT | $14,176 | $16,079 | $14,610 |
| Free cash flow to firm | $692 | $12,602 | $4,225 |
| Free cash flow to equity | $1,210 | $13,987 | $4,972 |
| Adjusted debt | $878 | $14,309 | $3,172 |
| Adjusted equity | $18,554 | $39,619 | $35,707 |
| Adjusted depreciation | $1,034 | $1,990 | $1,866 |
| Total reinvestment | $8,522 | ($2,151) | $5,272 |
| Adjusted EBIT | $14,176 | $16,079 | $14,610 |
| Adjusted EBIT(1 - t) | $9,214 | $10,451 | $9,496 |
| FCFF | $692 | $12,602 | $4,225 |
| FCFE | $1,210 | $13,987 | $4,972 |
| Cash conversion cycle | 80 | 72 | 88 |
| Days inventory outstanding | 74 | 68 | 88 |
| Days payable outstanding | 10 | 11 | 30 |
| Days sales outstanding | 16 | 15 | 31 |
| Acid test | 0.35 | 0.19 | 0.24 |
| liberal acid test | 0.66 | 0.69 | 0.58 |
| Current ratio | 1.22 | 1.03 | 0.99 |
| Fixed charges coverage ratio | 40.51 | 20.19 | 15.01 |
| Interest coverage ratio | 65.57 | 43.02 | 27.57 |
|   | |||
| Current Assets | |||
| Cash and equivalent | $6,498 | $4,781 | $6,258 |
| Short term investments | |||
| Accounts receivable | $3,323 | $2,808 | $5,361 |
| Inventory | $10,571 | $8,680 | $10,584 |
| Deferred taxes | |||
| Prepaid expenses | |||
| Other assets | $2,498 | $9,883 | $3,578 |
| Total assets | $22,890 | $26,152 | $25,781 |
|   | |||
| Current Liabilities | |||
| Accounts payable | $1,463 | $1,414 | $3,645 |
| Debt payments | $3,083 | $1,068 | $6,266 |
| Accrued Expenses | $11,994 | $10,486 | $13,182 |
| Tax payable | $654 | $782 | $1,393 |
| Other liabilities | $1,588 | $11,677 | $1,672 |
| Total liabilities | $18,782 | $25,427 | $26,158 |
| Working capital | $4,108 | $725 | ($377) |
| Non cash working capital | $693 | ($2,988) | ($369) |
| Investment in working capital | $3,681 | ($2,619) | |