Earnings in (Millions) |
|||||||||||||||||||||||||||||||||
$10,000 $8,000 $6,000 $4,000 $2,000 |
|
|
|
|
|
||||||||||||||||||||||||||||
($2,000) |
|
|
|
|
|||||||||||||||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash conversion cycle | 77 | 72 | 64 |
| Days inventory outstanding | 48 | 45 | 43 |
| Days payable outstanding | 30 | 28 | 30 |
| Days sales outstanding | 59 | 54 | 51 |
| Risk ratios | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current ratio | 1.82 | 1.89 | 1.04 |
| Acid test | 0.90 | 0.87 | 0.35 |
| Acid test (liberal) | 1.54 | 1.65 | 0.91 |
| Debt to equity ratio (Adjusted) | 0.59 | 0.42 | 0.33 |
| Interest coverage ratio (Adjusted) | 4.82 | 2.75 | 0.75 |
| Fixed charges coverage ratio (Adjusted) | 4.56 | 2.64 | 0.75 |
| Earnings in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $9,423 | $8,613 | $7,646 |
| Expenses | $9,716 | $8,923 | $8,102 |
| Net income | $2,114 | $840 | ($33) |
| Earnings before interest and taxes (EBIT) | $3,076 | $1,772 | $467 |
| Adjusted EBIT | $3,092 | $1,872 | $467 |
| Free cash flow to firm | $2,318 | ($120) | $585 |
| Free cash flow to equity | $2,401 | ($514) | $248 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current year | $37 | $28 | |
| Year one | $33 | $24 | |
| Year two | $28 | $21 | |
| Year three | $21 | $16 | |
| Year four | $13 | $13 | |
| Post year four | $38 | $31 | |
| Total | $170 | $133 | |
| Debt value | $107 | $84 | |
| Depreciation | $21 | $17 |
Past growth rates |
|||||||||||||
120 % 100 % 80 % 60 % 40 % 20 % |
|
|
|
|
|||||||||
|
|
|
|
|||||||||||
| all | 2 years | ||||||||||||
Cashflow in (Millions) |
|||||||||||||||||||||
$3,500 $3,000 $2,500 $2,000 $1,500 $1,000 $500 |
|
|
|
|
|
||||||||||||||||
($500) ($1,000) |
|
|
|
|
|||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| + R&D investment | |||
| + Working capital investment | ($276) | $451 | |
| + Fixed Capital investment | $316 | $278 | $168 |
| + Acquisitions | $348 | $1,207 | $96 |
| - R&D amortized | |||
| - Fixed capital depreciation | $675 | $582 | $545 |
| - Operating lease depreciation | $21 | $17 | |
| = Reinvested | ($308) | $1,337 | ($281) |
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Adjusted EBIT | $3,092 | $1,872 | $467 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $2,010 | $1,217 | $304 |
| Reinvestment expense (gain) | ($308) | $1,337 | ($281) |
| Free cash flow to firm (FCFF) | $2,318 | ($120) | $585 |
| past reinvestment rates | 2 years | all |
|---|---|---|
| Reinvestment | 47.27 % | 0.66 % |
| Working capital investment | 11.66 % | 7.77 % |
| R&D investment | 0.00 % | 0.00 % |
| Acquisitions | 58.25 % | 49.37 % |
| Net capital investments | 19.28 % | 31.30 % |
| Past growth rates | 2 years | all |
|---|---|---|
| EBIT (adjusted) | 49.13 % | 72.49 % |
| Profit | 86.26 % | 110.25 % |
| Revenue | 8.98 % | 10.38 % |
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash and equivalent | $3,135 | $3,107 | $1,896 |
| Short term investments | |||
| Accounts receivable | $1,517 | $1,276 | $1,059 |
| Inventory | $975 | $831 | $719 |
| Deferred taxes | $128 | ||
| Prepaid expenses | |||
| Other assets | $682 | $1,387 | $1,903 |
| Total assets | $6,309 | $6,729 | $5,577 |
| Accounts payable | $605 | $508 | $492 |
| Debt payments | $191 | $114 | $1,379 |
| Accrued Expenses | $1,084 | $1,089 | $1,131 |
| Tax payable | |||
| Other liabilities | $1,594 | $1,858 | $2,342 |
| Total liabilities | $3,474 | $3,569 | $5,344 |
| Working capital | $2,835 | $3,160 | $233 |
| Non cash working capital | ($109) | $167 | ($284) |
| Investment in working capital | ($276) | $451 |
| Earnings in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $9,423 | $8,613 | $7,646 |
| Expenses | $9,716 | $8,923 | $8,102 |
| Net income | $2,114 | $840 | ($33) |
| Earnings before interest and taxes (EBIT) | $3,076 | $1,772 | $467 |
| Adjusted EBIT | $3,092 | $1,872 | $467 |
| Free cash flow to firm | $2,318 | ($120) | $585 |
| Free cash flow to equity | $2,401 | ($514) | $248 |
| Adjusted debt | $11,631 | $8,993 | $6,370 |
| Adjusted equity | $19,586 | $21,633 | $19,120 |
| Adjusted depreciation | $696 | $599 | $545 |
| Total reinvestment | ($308) | $1,337 | ($281) |
| Adjusted EBIT | $3,092 | $1,872 | $467 |
| Adjusted EBIT(1 - t) | $2,010 | $1,217 | $304 |
| FCFF | $2,318 | ($120) | $585 |
| FCFE | $2,401 | ($514) | $248 |
| Cash conversion cycle | 77 | 72 | 64 |
| Days inventory outstanding | 48 | 45 | 43 |
| Days payable outstanding | 30 | 28 | 30 |
| Days sales outstanding | 59 | 54 | 51 |
| Acid test | 0.90 | 0.87 | 0.35 |
| liberal acid test | 1.54 | 1.65 | 0.91 |
| Current ratio | 1.82 | 1.89 | 1.04 |
| Fixed charges coverage ratio | 4.54 | 2.50 | 0.75 |
| Interest coverage ratio | 4.80 | 2.61 | 0.75 |
|   | |||
| Current Assets | |||
| Cash and equivalent | $3,135 | $3,107 | $1,896 |
| Short term investments | |||
| Accounts receivable | $1,517 | $1,276 | $1,059 |
| Inventory | $975 | $831 | $719 |
| Deferred taxes | $128 | ||
| Prepaid expenses | |||
| Other assets | $682 | $1,387 | $1,903 |
| Total assets | $6,309 | $6,729 | $5,577 |
|   | |||
| Current Liabilities | |||
| Accounts payable | $605 | $508 | $492 |
| Debt payments | $191 | $114 | $1,379 |
| Accrued Expenses | $1,084 | $1,089 | $1,131 |
| Tax payable | |||
| Other liabilities | $1,594 | $1,858 | $2,342 |
| Total liabilities | $3,474 | $3,569 | $5,344 |
| Working capital | $2,835 | $3,160 | $233 |
| Non cash working capital | ($109) | $167 | ($284) |
| Investment in working capital | ($276) | $451 | |