Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$45,000 $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 | 38 | 36 | 44 | 44 |
| Days inventory outstanding | 17 | 17 | 21 | 21 |
| Days payable outstanding | 22 | 23 | 22 | 19 |
| Days sales outstanding | 43 | 42 | 45 | 42 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.11 | 1.06 | 1.12 | 1.05 |
| Acid test | 0.30 | 0.24 | 0.28 | 0.17 |
| Acid test (liberal) | 0.93 | 0.89 | 0.91 | 0.83 |
| Debt to equity ratio (Adjusted) | 0.39 | 0.58 | 0.13 | 0.82 |
| Interest coverage ratio (Adjusted) | 16.33 | 13.60 | 10.94 | 7.57 |
| Fixed charges coverage ratio (Adjusted) | 8.88 | 7.57 | 6.41 | 4.76 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $41,862 | $39,620 | $37,213 | $35,526 |
| Expenses | $39,315 | $37,274 | $35,837 | $34,381 |
| Net income | $3,033 | $2,529 | $1,825 | $1,266 |
| Earnings before interest and taxes (EBIT) | $4,720 | $3,953 | $2,986 | $2,089 |
| Adjusted EBIT | $5,748 | $4,911 | $4,048 | $3,218 |
| Free cash flow to firm | $2,552 | $1,385 | $1,272 | $865 |
| Free cash flow to equity | $2,582 | $1,392 | $1,267 | $917 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $295 | $288 | $261 | $251 |
| Year one | $234 | $254 | $210 | $184 |
| Year two | $185 | $211 | $176 | $149 |
| Year three | $148 | $153 | $141 | $116 |
| Year four | $120 | $118 | $121 | $85 |
| Post year four | $122 | $121 | $248 | $281 |
| Total | $1,104 | $1,145 | $1,157 | $1,066 |
| Debt value | $661 | $713 | $715 | $637 |
| Depreciation | $165 | $178 | $143 | $106 |
Past growth rates |
|||||||||||||||||
30 % 25 % 20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$6,000 $5,500 $5,000 $4,500 $4,000 $3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 |
|
|
|
|
|
|
||||||||||||||||||||
|
|
|
|
|
|
||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $1,206 | $1,051 | $1,042 | $984 |
| + Working capital investment | ($160) | ($278) | ($316) | |
| + Fixed Capital investment | $940 | $893 | $865 | $769 |
| + Acquisitions | $337 | $1,122 | $564 | $91 |
| - R&D amortized | $308 | $203 | $98 | |
| - Fixed capital depreciation | $666 | $600 | $555 | $511 |
| - Operating lease depreciation | $165 | $178 | $143 | $106 |
| = Reinvested | $1,184 | $1,807 | $1,359 | $1,227 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $5,748 | $4,911 | $4,048 | $3,218 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $3,736 | $3,192 | $2,631 | $2,092 |
| Reinvestment expense (gain) | $1,184 | $1,807 | $1,359 | $1,227 |
| Free cash flow to firm (FCFF) | $2,552 | $1,385 | $1,272 | $865 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 44.15 % | 46.65 % | 49.65 % |
| Working capital investment | -6.50 % | -8.33 % | -6.25 % |
| R&D investment | 32.60 % | 34.94 % | 37.96 % |
| Acquisitions | 22.08 % | 21.87 % | 17.49 % |
| Net capital investments | 26.57 % | 28.67 % | 30.69 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 15.70 % | 17.34 % | 18.87 % |
| Profit | 18.12 % | 24.53 % | 27.76 % |
| Revenue | 5.50 % | 5.88 % | 5.55 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $2,648 | $1,912 | $2,244 | $1,060 |
| Short term investments | $333 | $381 | $429 | $396 |
| Accounts receivable | $4,925 | $4,595 | $4,579 | $4,094 |
| Inventory | $1,718 | $1,657 | $1,921 | $1,864 |
| Deferred taxes | $756 | $900 | $861 | $982 |
| Prepaid expenses | ||||
| Other assets | $560 | $719 | $495 | $557 |
| Total assets | $10,940 | $10,164 | $10,529 | $8,953 |
| Accounts payable | $2,163 | $2,221 | $1,998 | $1,726 |
| Debt payments | $104 | $34 | $202 | $15 |
| Accrued Expenses | $1,544 | $1,584 | $1,475 | |
| Tax payable | $1,346 | |||
| Other liabilities | $6,060 | $5,714 | $5,753 | $5,479 |
| Total liabilities | $9,871 | $9,553 | $9,428 | $8,566 |
| Working capital | $1,069 | $611 | $1,101 | $387 |
| Non cash working capital | ($1,808) | ($1,648) | ($1,370) | ($1,054) |
| Investment in working capital | ($160) | ($278) | ($316) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $41,862 | $39,620 | $37,213 | $35,526 |
| Expenses | $39,315 | $37,274 | $35,837 | $34,381 |
| Net income | $3,033 | $2,529 | $1,825 | $1,266 |
| Earnings before interest and taxes (EBIT) | $4,720 | $3,953 | $2,986 | $2,089 |
| Adjusted EBIT | $5,748 | $4,911 | $4,048 | $3,218 |
| Free cash flow to firm | $2,552 | $1,385 | $1,272 | $865 |
| Free cash flow to equity | $2,582 | $1,392 | $1,267 | $917 |
| Adjusted debt | $4,964 | $5,118 | $1,193 | $5,741 |
| Adjusted equity | $12,581 | $8,812 | $8,851 | $7,021 |
| Adjusted depreciation | $1,139 | $981 | $796 | $617 |
| Total reinvestment | $1,184 | $1,807 | $1,359 | $1,227 |
| Adjusted EBIT | $5,748 | $4,911 | $4,048 | $3,218 |
| Adjusted EBIT(1 - t) | $3,736 | $3,192 | $2,631 | $2,092 |
| FCFF | $2,552 | $1,385 | $1,272 | $865 |
| FCFE | $2,582 | $1,392 | $1,267 | $917 |
| Cash conversion cycle | 38 | 36 | 44 | 44 |
| Days inventory outstanding | 17 | 17 | 21 | 21 |
| Days payable outstanding | 22 | 23 | 22 | 19 |
| Days sales outstanding | 43 | 42 | 45 | 42 |
| Acid test | 0.30 | 0.24 | 0.28 | 0.17 |
| liberal acid test | 0.93 | 0.89 | 0.91 | 0.83 |
| Current ratio | 1.11 | 1.06 | 1.12 | 1.05 |
| Fixed charges coverage ratio | 7.30 | 6.09 | 4.73 | 3.09 |
| Interest coverage ratio | 13.41 | 10.95 | 8.07 | 4.92 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $2,648 | $1,912 | $2,244 | $1,060 |
| Short term investments | $333 | $381 | $429 | $396 |
| Accounts receivable | $4,925 | $4,595 | $4,579 | $4,094 |
| Inventory | $1,718 | $1,657 | $1,921 | $1,864 |
| Deferred taxes | $756 | $900 | $861 | $982 |
| Prepaid expenses | ||||
| Other assets | $560 | $719 | $495 | $557 |
| Total assets | $10,940 | $10,164 | $10,529 | $8,953 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $2,163 | $2,221 | $1,998 | $1,726 |
| Debt payments | $104 | $34 | $202 | $15 |
| Accrued Expenses | $1,544 | $1,584 | $1,475 | |
| Tax payable | $1,346 | |||
| Other liabilities | $6,060 | $5,714 | $5,753 | $5,479 |
| Total liabilities | $9,871 | $9,553 | $9,428 | $8,566 |
| Working capital | $1,069 | $611 | $1,101 | $387 |
| Non cash working capital | ($1,808) | ($1,648) | ($1,370) | ($1,054) |
| Investment in working capital | ($160) | ($278) | ($316) | |