Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||||||||||
$70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
($10,000) |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Cash conversion cycle | 47 | 35 | 35 | 35 | 29 |
| Days inventory outstanding | 56 | 55 | 57 | 59 | 55 |
| Days payable outstanding | 55 | 58 | 62 | 63 | 66 |
| Days sales outstanding | 46 | 38 | 39 | 40 | 40 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Current ratio | 1.60 | 1.32 | 1.50 | 1.69 | 1.56 |
| Acid test | 0.21 | 0.07 | 0.17 | 0.27 | 0.09 |
| Acid test (liberal) | 1.03 | 0.76 | 0.89 | 1.04 | 1.01 |
| Debt to equity ratio (Adjusted) | 1.09 | 0.63 | 0.72 | 0.78 | 1.03 |
| Interest coverage ratio (Adjusted) | 8.41 | 9.02 | 9.53 | 6.62 | 6.13 |
| Fixed charges coverage ratio (Adjusted) | 6.14 | 7.23 | 7.35 | 5.27 | 4.74 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $63,367 | $59,490 | $52,620 | $46,839 |
| Expenses | $60,518 | $56,703 | $50,212 | $43,716 |
| Net income | $2,849 | $2,787 | $2,408 | $3,198 |
| Earnings before interest and taxes (EBIT) | $5,272 | $5,069 | $4,323 | $4,914 |
| Adjusted EBIT | $5,442 | $5,161 | $4,412 | $3,771 |
| Free cash flow to firm | ($1,604) | $757 | $976 | $1,528 |
| Free cash flow to equity | ($2,361) | $139 | $468 | $2,224 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $239 | $142 | $137 | $146 |
| Year one | $187 | $136 | $132 | $142 |
| Year two | $173 | $130 | $123 | $137 |
| Year three | $129 | $122 | $114 | $117 |
| Year four | $123 | $113 | $107 | $102 |
| Post year four | $2,843 | $2,682 | $2,484 | $2,405 |
| Total | $3,694 | $3,325 | $3,097 | $3,049 |
| Debt value | $1,518 | $1,249 | $1,164 | $1,183 |
| Depreciation | $69 | $50 | $48 | $51 |
Past growth rates |
|||||||||||||||||
14 % 12 % 10 % 8 % 6 % 4 % 2 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
|||||||||||||||||||||||||||||||
$6,000 $5,000 $4,000 $3,000 $2,000 $1,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||
($1,000) ($2,000) ($3,000) |
|
|
|
|
|
|
|||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | $2,500 | $216 | ($39) | ($835) |
| + Fixed Capital investment | $4,369 | $3,928 | $3,388 | $3,068 |
| + Acquisitions | ||||
| - R&D amortized | ||||
| - Fixed capital depreciation | $1,659 | $1,496 | $1,409 | $1,259 |
| - Operating lease depreciation | $69 | $50 | $48 | $51 |
| = Reinvested | $5,141 | $2,598 | $1,892 | $923 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $5,442 | $5,161 | $4,412 | $3,771 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $3,537 | $3,355 | $2,867 | $2,451 |
| Reinvestment expense (gain) | $5,141 | $2,598 | $1,892 | $923 |
| Free cash flow to firm (FCFF) | ($1,604) | $757 | $976 | $1,528 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 111.39 % | 96.25 % | 79.13 % |
| Working capital investment | 38.56 % | 25.25 % | 8.34 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 0.00 % | 0.00 % | 0.00 % |
| Net capital investments | 120.30 % | 119.58 % | 121.52 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 5.30 % | 10.30 % | 12.31 % |
| Profit | 2.20 % | 8.22 % | 6.39 % |
| Revenue | 6.31 % | 9.19 % | 10.47 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $2,450 | $813 | $1,648 | $2,245 |
| Short term investments | ||||
| Accounts receivable | $8,054 | $6,194 | $5,666 | $5,069 |
| Inventory | $6,780 | $6,254 | $5,838 | $5,384 |
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $1,622 | $1,445 | $1,253 | $1,224 |
| Total assets | $18,906 | $14,706 | $14,405 | $13,922 |
| Accounts payable | $6,721 | $6,575 | $6,268 | $5,779 |
| Debt payments | $1,964 | $1,362 | $753 | $504 |
| Accrued Expenses | $3,097 | $2,758 | $2,193 | $1,633 |
| Tax payable | $422 | $374 | $304 | |
| Other liabilities | ||||
| Total liabilities | $11,782 | $11,117 | $9,588 | $8,220 |
| Working capital | $7,124 | $3,589 | $4,817 | $5,702 |
| Non cash working capital | $6,638 | $4,138 | $3,922 | $3,961 |
| Investment in working capital | $2,500 | $216 | ($39) | ($835) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Revenue | $63,367 | $59,490 | $52,620 | $46,839 | $42,025 |
| Expenses | $60,518 | $56,703 | $50,212 | $43,716 | $40,406 |
| Net income | $2,849 | $2,787 | $2,408 | $3,198 | $1,809 |
| Earnings before interest and taxes (EBIT) | $5,272 | $5,069 | $4,323 | $4,914 | $3,349 |
| Adjusted EBIT | $5,442 | $5,161 | $4,412 | $3,771 | $3,406 |
| Free cash flow to firm | ($1,604) | $757 | $976 | $1,528 | $680 |
| Free cash flow to equity | ($2,361) | $139 | $468 | $2,224 | $169 |
| Adjusted debt | $16,644 | $9,924 | $10,283 | $10,217 | $11,432 |
| Adjusted equity | $15,307 | $15,633 | $14,205 | $13,029 | $11,132 |
| Adjusted depreciation | $1,728 | $1,546 | $1,457 | $1,310 | $1,204 |
| Total reinvestment | $5,141 | $2,598 | $1,892 | $923 | $1,534 |
| Adjusted EBIT | $5,442 | $5,161 | $4,412 | $3,771 | $3,406 |
| Adjusted EBIT(1 - t) | $3,537 | $3,355 | $2,867 | $2,451 | $2,214 |
| FCFF | ($1,604) | $757 | $976 | $1,528 | $680 |
| FCFE | ($2,361) | $139 | $468 | $2,224 | $169 |
| Cash conversion cycle | 47 | 35 | 35 | 35 | 29 |
| Days inventory outstanding | 56 | 55 | 57 | 59 | 55 |
| Days payable outstanding | 55 | 58 | 62 | 63 | 66 |
| Days sales outstanding | 46 | 38 | 39 | 40 | 40 |
| Acid test | 0.21 | 0.07 | 0.17 | 0.27 | 0.09 |
| liberal acid test | 1.03 | 0.76 | 0.89 | 1.04 | 1.01 |
| Current ratio | 1.60 | 1.32 | 1.50 | 1.69 | 1.56 |
| Fixed charges coverage ratio | 5.95 | 7.10 | 7.21 | 6.86 | 4.66 |
| Interest coverage ratio | 8.15 | 8.86 | 9.34 | 8.62 | 6.02 |
|   | |||||
| Current Assets | |||||
| Cash and equivalent | $2,450 | $813 | $1,648 | $2,245 | $708 |
| Short term investments | |||||
| Accounts receivable | $8,054 | $6,194 | $5,666 | $5,069 | $4,621 |
| Inventory | $6,780 | $6,254 | $5,838 | $5,384 | $4,531 |
| Deferred taxes | |||||
| Prepaid expenses | |||||
| Other assets | $1,622 | $1,445 | $1,253 | $1,224 | $3,092 |
| Total assets | $18,906 | $14,706 | $14,405 | $13,922 | $12,952 |
|   | |||||
| Current Liabilities | |||||
| Accounts payable | $6,721 | $6,575 | $6,268 | $5,779 | $5,448 |
| Debt payments | $1,964 | $1,362 | $753 | $504 | $866 |
| Accrued Expenses | $3,097 | $2,758 | $2,193 | $1,633 | $1,618 |
| Tax payable | $422 | $374 | $304 | $382 | |
| Other liabilities | |||||
| Total liabilities | $11,782 | $11,117 | $9,588 | $8,220 | $8,314 |
| Working capital | $7,124 | $3,589 | $4,817 | $5,702 | $4,638 |
| Non cash working capital | $6,638 | $4,138 | $3,922 | $3,961 | $4,796 |
| Investment in working capital | $2,500 | $216 | ($39) | ($835) | |