Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$20,000 $18,000 $16,000 $14,000 $12,000 $10,000 $8,000 $6,000 $4,000 $2,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | 25 | 20 | 14 | 16 |
| Days inventory outstanding | 26 | 36 | 31 | 29 |
| Days payable outstanding | 53 | 67 | 69 | 66 |
| Days sales outstanding | 51 | 52 | 52 | 53 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 0.84 | 0.86 | 0.71 | 0.80 |
| Acid test | 0.05 | 0.04 | 0.02 | 0.10 |
| Acid test (liberal) | 0.72 | 0.74 | 0.61 | 0.69 |
| Debt to equity ratio (Adjusted) | 1.23 | 1.23 | 1.33 | 1.33 |
| Interest coverage ratio (Adjusted) | 5.96 | 4.21 | 3.33 | 4.15 |
| Fixed charges coverage ratio (Adjusted) | 5.48 | 3.95 | 3.13 | 3.82 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $18,916 | $15,655 | $15,357 | $14,133 |
| Expenses | $16,650 | $14,333 | $14,586 | $12,393 |
| Net income | $2,736 | $1,592 | $923 | $1,864 |
| Earnings before interest and taxes (EBIT) | $5,032 | $3,678 | $2,696 | $3,405 |
| Adjusted EBIT | $5,064 | $3,702 | $2,763 | $3,439 |
| Free cash flow to firm | $2,483 | $2,185 | $1,341 | $2,286 |
| Free cash flow to equity | $1,885 | $1,337 | $438 | $1,876 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $75 | $58 | $55 | $73 |
| Year one | $73 | $55 | $55 | $74 |
| Year two | $60 | $55 | $53 | $60 |
| Year three | $64 | $48 | $47 | $59 |
| Year four | $60 | $45 | $45 | $55 |
| Post year four | $464 | $455 | $511 | $588 |
| Total | $796 | $716 | $766 | $909 |
| Debt value | $468 | $409 | $419 | $507 |
| Depreciation | $43 | $34 | $30 | $39 |
Past growth rates |
|||||||||||||||||
55 % 50 % 45 % 40 % 35 % 30 % 25 % 20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$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 | ||||
| + Working capital investment | $360 | ($31) | $190 | |
| + Fixed Capital investment | $2,674 | $2,418 | $2,165 | $1,921 |
| + Acquisitions | $97 | |||
| - R&D amortized | ||||
| - Fixed capital depreciation | $2,183 | $2,132 | $1,967 | $1,933 |
| - Operating lease depreciation | $43 | $34 | $30 | $39 |
| = Reinvested | $808 | $221 | $455 | ($51) |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $5,064 | $3,702 | $2,763 | $3,439 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $3,292 | $2,406 | $1,796 | $2,235 |
| Reinvestment expense (gain) | $808 | $221 | $455 | ($51) |
| Free cash flow to firm (FCFF) | $2,483 | $2,185 | $1,341 | $2,286 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 16.87 % | 19.69 % | 14.20 % |
| Working capital investment | 4.82 % | 6.74 % | 5.06 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 0.00 % | 1.80 % | 1.35 % |
| Net capital investments | 90.86 % | 100.75 % | 97.05 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 31.09 % | 29.94 % | 15.54 % |
| Profit | 52.87 % | 51.79 % | 18.47 % |
| Revenue | 18.87 % | 10.69 % | 9.15 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $311 | $224 | $140 | $499 |
| Short term investments | ||||
| Accounts receivable | $2,652 | $2,209 | $2,195 | $2,058 |
| Inventory | $723 | $731 | $662 | $542 |
| Deferred taxes | $80 | $68 | ||
| Prepaid expenses | ||||
| Other assets | $1,365 | $1,828 | $1,560 | $713 |
| Total assets | $5,051 | $4,992 | $4,637 | $3,880 |
| Accounts payable | $1,450 | $1,382 | $1,467 | $1,255 |
| Debt payments | $1,722 | $1,134 | $2,204 | $1,403 |
| Accrued Expenses | $1,240 | $1,180 | $1,005 | $1,097 |
| Tax payable | ||||
| Other liabilities | $1,583 | $2,099 | $1,887 | $1,081 |
| Total liabilities | $5,995 | $5,795 | $6,563 | $4,836 |
| Working capital | ($944) | ($803) | ($1,926) | ($956) |
| Non cash working capital | $467 | $107 | $138 | ($52) |
| Investment in working capital | $360 | ($31) | $190 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $18,916 | $15,655 | $15,357 | $14,133 |
| Expenses | $16,650 | $14,333 | $14,586 | $12,393 |
| Net income | $2,736 | $1,592 | $923 | $1,864 |
| Earnings before interest and taxes (EBIT) | $5,032 | $3,678 | $2,696 | $3,405 |
| Adjusted EBIT | $5,064 | $3,702 | $2,763 | $3,439 |
| Free cash flow to firm | $2,483 | $2,185 | $1,341 | $2,286 |
| Free cash flow to equity | $1,885 | $1,337 | $438 | $1,876 |
| Adjusted debt | $12,433 | $12,320 | $12,179 | $12,655 |
| Adjusted equity | $10,137 | $10,007 | $9,125 | $9,489 |
| Adjusted depreciation | $2,226 | $2,166 | $1,997 | $1,972 |
| Total reinvestment | $808 | $221 | $455 | ($51) |
| Adjusted EBIT | $5,064 | $3,702 | $2,763 | $3,439 |
| Adjusted EBIT(1 - t) | $3,292 | $2,406 | $1,796 | $2,235 |
| FCFF | $2,483 | $2,185 | $1,341 | $2,286 |
| FCFE | $1,885 | $1,337 | $438 | $1,876 |
| Cash conversion cycle | 25 | 20 | 14 | 16 |
| Days inventory outstanding | 26 | 36 | 31 | 29 |
| Days payable outstanding | 53 | 67 | 69 | 66 |
| Days sales outstanding | 51 | 52 | 52 | 53 |
| Acid test | 0.05 | 0.04 | 0.02 | 0.10 |
| liberal acid test | 0.72 | 0.74 | 0.61 | 0.69 |
| Current ratio | 0.84 | 0.86 | 0.71 | 0.80 |
| Fixed charges coverage ratio | 5.44 | 3.92 | 3.05 | 3.78 |
| Interest coverage ratio | 5.92 | 4.18 | 3.25 | 4.11 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $311 | $224 | $140 | $499 |
| Short term investments | ||||
| Accounts receivable | $2,652 | $2,209 | $2,195 | $2,058 |
| Inventory | $723 | $731 | $662 | $542 |
| Deferred taxes | $80 | $68 | ||
| Prepaid expenses | ||||
| Other assets | $1,365 | $1,828 | $1,560 | $713 |
| Total assets | $5,051 | $4,992 | $4,637 | $3,880 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $1,450 | $1,382 | $1,467 | $1,255 |
| Debt payments | $1,722 | $1,134 | $2,204 | $1,403 |
| Accrued Expenses | $1,240 | $1,180 | $1,005 | $1,097 |
| Tax payable | ||||
| Other liabilities | $1,583 | $2,099 | $1,887 | $1,081 |
| Total liabilities | $5,995 | $5,795 | $6,563 | $4,836 |
| Working capital | ($944) | ($803) | ($1,926) | ($956) |
| Non cash working capital | $467 | $107 | $138 | ($52) |
| Investment in working capital | $360 | ($31) | $190 | |