Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$200,000 $150,000 $100,000 $50,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
($50,000) |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | 0 | 5 | 4 | 7 |
| Days inventory outstanding | 9 | 12 | 9 | 11 |
| Days payable outstanding | 40 | 34 | 29 | 28 |
| Days sales outstanding | 31 | 27 | 24 | 23 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 0.92 | 0.95 | 0.92 | 0.96 |
| Acid test | 0.05 | 0.03 | 0.10 | 0.09 |
| Acid test (liberal) | 0.76 | 0.75 | 0.74 | 0.73 |
| Debt to equity ratio (Adjusted) | 0.23 | 0.28 | 0.21 | 0.35 |
| Interest coverage ratio (Adjusted) | 23.74 | 27.53 | 49.20 | 28.13 |
| Fixed charges coverage ratio (Adjusted) | 14.98 | 17.91 | 24.67 | 15.03 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $194,495 | $188,523 | $183,364 | $136,916 |
| Expenses | $182,805 | $173,003 | $169,835 | $128,845 |
| Net income | $11,891 | $15,550 | $13,529 | $8,129 |
| Earnings before interest and taxes (EBIT) | $24,525 | $29,420 | $23,933 | $14,937 |
| Adjusted EBIT | $29,744 | $29,930 | $24,451 | $15,357 |
| Free cash flow to firm | $20,008 | ($26,747) | $9,473 | $4,340 |
| Free cash flow to equity | $12,464 | ($30,726) | $7,045 | $2,431 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $732 | $584 | $494 | $476 |
| Year one | $593 | $528 | $412 | $424 |
| Year two | $439 | $403 | $354 | $356 |
| Year three | $340 | $291 | $259 | $311 |
| Year four | $397 | $239 | $208 | $237 |
| Post year four | $807 | $996 | $891 | $1,009 |
| Total | $3,308 | $3,041 | $2,618 | $2,813 |
| Debt value | $504 | $444 | $382 | $395 |
| Depreciation | $101 | $74 | $64 | $56 |
Past growth rates |
|||||||||||||||||
20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
-5 % -10 % -15 % -20 % -25 % -30 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$30,000 $20,000 $10,000 |
|
|
|
|
|
|
||||||||||||||||||||
($10,000) ($20,000) ($30,000) ($40,000) |
|
|
|
|
|
|||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | ($4,066) | $4,064 | ($883) | |
| + Fixed Capital investment | $11,791 | $15,596 | $11,620 | $9,496 |
| + Acquisitions | $33,900 | |||
| - R&D amortized | ||||
| - Fixed capital depreciation | $8,298 | $7,284 | $4,253 | $3,798 |
| - Operating lease depreciation | $101 | $74 | $64 | $56 |
| = Reinvested | ($674) | $46,202 | $6,420 | $5,642 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $29,744 | $29,930 | $24,451 | $15,357 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $19,334 | $19,454 | $15,893 | $9,982 |
| Reinvestment expense (gain) | ($674) | $46,202 | $6,420 | $5,642 |
| Free cash flow to firm (FCFF) | $20,008 | ($26,747) | $9,473 | $4,340 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 117.00 % | 91.47 % | 82.73 % |
| Working capital investment | -0.07 % | -1.90 % | -1.42 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 87.13 % | 58.08 % | 43.56 % |
| Net capital investments | 70.58 % | 71.42 % | 77.35 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | -0.62 % | 9.44 % | 19.56 % |
| Profit | -26.67 % | -6.00 % | 10.84 % |
| Revenue | 3.12 % | 2.95 % | 10.12 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,456 | $817 | $2,214 | $1,387 |
| Short term investments | ||||
| Accounts receivable | $16,354 | $14,106 | $11,940 | $8,788 |
| Inventory | $4,223 | $5,153 | $3,724 | $3,666 |
| Deferred taxes | ||||
| Prepaid expenses | $2,702 | $4,990 | $1,734 | $986 |
| Other assets | $194 | |||
| Total assets | $24,735 | $25,066 | $19,612 | $15,021 |
| Accounts payable | $17,861 | $14,634 | $12,267 | $9,131 |
| Debt payments | $1,398 | $4,043 | $1,758 | $632 |
| Accrued Expenses | $7,623 | $7,754 | $7,334 | $2,566 |
| Tax payable | $3,154 | |||
| Other liabilities | $103 | |||
| Total liabilities | $26,882 | $26,431 | $21,359 | $15,586 |
| Working capital | ($2,147) | ($1,365) | ($1,747) | ($565) |
| Non cash working capital | ($2,205) | $1,861 | ($2,203) | ($1,320) |
| Investment in working capital | ($4,066) | $4,064 | ($883) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $194,495 | $188,523 | $183,364 | $136,916 |
| Expenses | $182,805 | $173,003 | $169,835 | $128,845 |
| Net income | $11,891 | $15,550 | $13,529 | $8,129 |
| Earnings before interest and taxes (EBIT) | $24,525 | $29,420 | $23,933 | $14,937 |
| Adjusted EBIT | $29,744 | $29,930 | $24,451 | $15,357 |
| Free cash flow to firm | $20,008 | ($26,747) | $9,473 | $4,340 |
| Free cash flow to equity | $12,464 | ($30,726) | $7,045 | $2,431 |
| Adjusted debt | $20,793 | $23,535 | $11,140 | $14,765 |
| Adjusted equity | $88,983 | $82,646 | $52,731 | $42,723 |
| Adjusted depreciation | $8,399 | $7,358 | $4,317 | $3,854 |
| Total reinvestment | ($674) | $46,202 | $6,420 | $5,642 |
| Adjusted EBIT | $29,744 | $29,930 | $24,451 | $15,357 |
| Adjusted EBIT(1 - t) | $19,334 | $19,454 | $15,893 | $9,982 |
| FCFF | $20,008 | ($26,747) | $9,473 | $4,340 |
| FCFE | $12,464 | ($30,726) | $7,045 | $2,431 |
| Cash conversion cycle | 0 | 5 | 4 | 7 |
| Days inventory outstanding | 9 | 12 | 9 | 11 |
| Days payable outstanding | 40 | 34 | 29 | 28 |
| Days sales outstanding | 31 | 27 | 24 | 23 |
| Acid test | 0.05 | 0.03 | 0.10 | 0.09 |
| liberal acid test | 0.76 | 0.75 | 0.74 | 0.73 |
| Current ratio | 0.92 | 0.95 | 0.92 | 0.96 |
| Fixed charges coverage ratio | 12.36 | 17.61 | 24.15 | 14.62 |
| Interest coverage ratio | 19.57 | 27.07 | 48.15 | 27.36 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $1,456 | $817 | $2,214 | $1,387 |
| Short term investments | ||||
| Accounts receivable | $16,354 | $14,106 | $11,940 | $8,788 |
| Inventory | $4,223 | $5,153 | $3,724 | $3,666 |
| Deferred taxes | ||||
| Prepaid expenses | $2,702 | $4,990 | $1,734 | $986 |
| Other assets | $194 | |||
| Total assets | $24,735 | $25,066 | $19,612 | $15,021 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $17,861 | $14,634 | $12,267 | $9,131 |
| Debt payments | $1,398 | $4,043 | $1,758 | $632 |
| Accrued Expenses | $7,623 | $7,754 | $7,334 | $2,566 |
| Tax payable | $3,154 | |||
| Other liabilities | $103 | |||
| Total liabilities | $26,882 | $26,431 | $21,359 | $15,586 |
| Working capital | ($2,147) | ($1,365) | ($1,747) | ($565) |
| Non cash working capital | ($2,205) | $1,861 | ($2,203) | ($1,320) |
| Investment in working capital | ($4,066) | $4,064 | ($883) | |