Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$25,000 $20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
($5,000) |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | -38 | 5 | 3 | 9 |
| Days inventory outstanding | 37 | 36 | 38 | 35 |
| Days payable outstanding | 174 | 100 | 110 | 101 |
| Days sales outstanding | 98 | 69 | 74 | 75 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 1.37 | 1.31 | 1.62 | 1.29 |
| Acid test | 0.31 | 0.34 | 0.57 | 0.42 |
| Acid test (liberal) | 1.23 | 1.14 | 1.46 | 1.14 |
| Debt to equity ratio (Adjusted) | 0.07 | 0.18 | 0.24 | 0.38 |
| Interest coverage ratio (Adjusted) | 27.70 | 27.64 | 25.58 | 17.42 |
| Fixed charges coverage ratio (Adjusted) | 17.45 | 17.56 | 18.01 | 12.24 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $20,013 | $17,674 | $15,204 | $10,879 |
| Expenses | $15,017 | $14,046 | $10,595 | $8,730 |
| Net income | $5,400 | $4,191 | $5,293 | $2,568 |
| Earnings before interest and taxes (EBIT) | $9,246 | $7,948 | $7,427 | $4,467 |
| Adjusted EBIT | $9,390 | $8,044 | $7,494 | $4,530 |
| Free cash flow to firm | $4,694 | ($303) | $1,643 | $2,314 |
| Free cash flow to equity | $3,936 | ($1,411) | $2,012 | $1,891 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $199 | $167 | $123 | $110 |
| Year one | $112 | $136 | $105 | $95 |
| Year two | $99 | $117 | $86 | $78 |
| Year three | $77 | $94 | $78 | $67 |
| Year four | $58 | $77 | $66 | $65 |
| Post year four | $708 | $767 | $799 | $808 |
| Total | $1,253 | $1,358 | $1,257 | $1,223 |
| Debt value | $658 | $777 | $689 | $654 |
| Depreciation | $55 | $71 | $53 | $47 |
Past growth rates |
|||||||||||||||||
30 % 25 % 20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$10,000 $8,000 $6,000 $4,000 $2,000 |
|
|
|
|
|
|
||||||||||||||||||||
($2,000) |
|
|
|
|
|
|||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | $346 | ($205) | $253 | |
| + Fixed Capital investment | $3,497 | $3,005 | $2,324 | $1,720 |
| + Acquisitions | $4,844 | $2,126 | $208 | |
| - R&D amortized | ||||
| - Fixed capital depreciation | $2,379 | $2,042 | $1,422 | $1,251 |
| - Operating lease depreciation | $55 | $71 | $53 | $47 |
| = Reinvested | $1,409 | $5,531 | $3,228 | $630 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $9,390 | $8,044 | $7,494 | $4,530 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $6,104 | $5,229 | $4,871 | $2,945 |
| Reinvestment expense (gain) | $1,409 | $5,531 | $3,228 | $630 |
| Free cash flow to firm (FCFF) | $4,694 | ($303) | $1,643 | $2,314 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 64.44 % | 65.05 % | 54.14 % |
| Working capital investment | 0.87 % | 2.31 % | 1.74 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 46.32 % | 45.43 % | 35.84 % |
| Net capital investments | 57.38 % | 54.16 % | 55.22 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 15.44 % | 11.41 % | 20.54 % |
| Profit | 25.21 % | 1.08 % | 16.95 % |
| Revenue | 12.41 % | 13.64 % | 18.74 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,964 | $1,339 | $2,188 | $1,199 |
| Short term investments | $240 | $252 | $250 | |
| Accounts receivable | $5,389 | $3,324 | $3,099 | $2,235 |
| Inventory | $910 | $825 | $716 | $545 |
| Deferred taxes | ||||
| Prepaid expenses | $332 | $202 | ||
| Other assets | $441 | $682 | ||
| Total assets | $8,595 | $6,169 | $6,937 | $4,431 |
| Accounts payable | $4,263 | $2,263 | $2,046 | $1,557 |
| Debt payments | $47 | $171 | $46 | $459 |
| Accrued Expenses | $1,399 | $1,532 | $1,569 | $1,034 |
| Tax payable | $227 | $396 | $326 | $263 |
| Other liabilities | $330 | $333 | $285 | $110 |
| Total liabilities | $6,266 | $4,695 | $4,272 | $3,423 |
| Working capital | $2,329 | $1,474 | $2,665 | $1,008 |
| Non cash working capital | $412 | $66 | $271 | $18 |
| Investment in working capital | $346 | ($205) | $253 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $20,013 | $17,674 | $15,204 | $10,879 |
| Expenses | $15,017 | $14,046 | $10,595 | $8,730 |
| Net income | $5,400 | $4,191 | $5,293 | $2,568 |
| Earnings before interest and taxes (EBIT) | $9,246 | $7,948 | $7,427 | $4,467 |
| Adjusted EBIT | $9,390 | $8,044 | $7,494 | $4,530 |
| Free cash flow to firm | $4,694 | ($303) | $1,643 | $2,314 |
| Free cash flow to equity | $3,936 | ($1,411) | $2,012 | $1,891 |
| Adjusted debt | $2,399 | $3,396 | $3,562 | $3,999 |
| Adjusted equity | $36,519 | $19,184 | $15,032 | $10,550 |
| Adjusted depreciation | $2,434 | $2,113 | $1,475 | $1,298 |
| Total reinvestment | $1,409 | $5,531 | $3,228 | $630 |
| Adjusted EBIT | $9,390 | $8,044 | $7,494 | $4,530 |
| Adjusted EBIT(1 - t) | $6,104 | $5,229 | $4,871 | $2,945 |
| FCFF | $4,694 | ($303) | $1,643 | $2,314 |
| FCFE | $3,936 | ($1,411) | $2,012 | $1,891 |
| Cash conversion cycle | -38 | 5 | 3 | 9 |
| Days inventory outstanding | 37 | 36 | 38 | 35 |
| Days payable outstanding | 174 | 100 | 110 | 101 |
| Days sales outstanding | 98 | 69 | 74 | 75 |
| Acid test | 0.31 | 0.34 | 0.57 | 0.42 |
| liberal acid test | 1.23 | 1.14 | 1.46 | 1.14 |
| Current ratio | 1.37 | 1.31 | 1.62 | 1.29 |
| Fixed charges coverage ratio | 17.19 | 17.35 | 17.85 | 12.07 |
| Interest coverage ratio | 27.27 | 27.31 | 25.35 | 17.18 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $1,964 | $1,339 | $2,188 | $1,199 |
| Short term investments | $240 | $252 | $250 | |
| Accounts receivable | $5,389 | $3,324 | $3,099 | $2,235 |
| Inventory | $910 | $825 | $716 | $545 |
| Deferred taxes | ||||
| Prepaid expenses | $332 | $202 | ||
| Other assets | $441 | $682 | ||
| Total assets | $8,595 | $6,169 | $6,937 | $4,431 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $4,263 | $2,263 | $2,046 | $1,557 |
| Debt payments | $47 | $171 | $46 | $459 |
| Accrued Expenses | $1,399 | $1,532 | $1,569 | $1,034 |
| Tax payable | $227 | $396 | $326 | $263 |
| Other liabilities | $330 | $333 | $285 | $110 |
| Total liabilities | $6,266 | $4,695 | $4,272 | $3,423 |
| Working capital | $2,329 | $1,474 | $2,665 | $1,008 |
| Non cash working capital | $412 | $66 | $271 | $18 |
| Investment in working capital | $346 | ($205) | $253 | |