Earnings in (Millions) |
|||||||||||||||||||||||||||||||||
$250,000 $200,000 $150,000 $100,000 $50,000 |
|
|
|
|
|
||||||||||||||||||||||||||||
($50,000) |
|
|
|
|
|||||||||||||||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash conversion cycle | 4 | 5 | 5 |
| Days inventory outstanding | 11 | 10 | 9 |
| Days payable outstanding | 44 | 35 | 35 |
| Days sales outstanding | 37 | 31 | 32 |
| Risk ratios | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current ratio | 1.17 | 1.28 | 1.37 |
| Acid test | 0.24 | 0.40 | 0.45 |
| Acid test (liberal) | 1.01 | 1.11 | 1.21 |
| Debt to equity ratio (Adjusted) | 0.10 | 0.13 | 0.22 |
| Interest coverage ratio (Adjusted) | 195.94 | 72.33 | 53.72 |
| Fixed charges coverage ratio (Adjusted) | 47.90 | 33.98 | 26.18 |
| Earnings in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $220,904 | $210,118 | $198,200 |
| Expenses | $202,216 | $192,980 | $184,101 |
| Net income | $18,688 | $17,138 | $14,099 |
| Earnings before interest and taxes (EBIT) | $32,333 | $32,427 | $25,679 |
| Adjusted EBIT | $32,526 | $32,622 | $25,893 |
| Free cash flow to firm | $11,827 | $13,892 | ($4,259) |
| Free cash flow to equity | $10,679 | $11,143 | ($5,989) |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current year | $513 | $509 | $507 |
| Year one | $478 | $507 | $444 |
| Year two | $430 | $477 | $401 |
| Year three | $347 | $390 | $349 |
| Year four | $293 | $311 | $284 |
| Post year four | $1,106 | $864 | $932 |
| Total | $3,167 | $3,058 | $2,917 |
| Debt value | $1,921 | $1,886 | $1,757 |
| Depreciation | $320 | $314 | $293 |
Past growth rates |
|||||||||||||
14 % 12 % 10 % 8 % 6 % 4 % 2 % |
|
|
|
|
|||||||||
-2 % |
|
|
|
||||||||||
| all | 2 years | ||||||||||||
Cashflow in (Millions) |
|||||||||||||||||||||
$35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
||||||||||||||||
($5,000) ($10,000) |
|
|
|
|
|||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| + R&D investment | |||
| + Working capital investment | $39 | ($312) | |
| + Fixed Capital investment | $16,678 | $13,813 | $8,701 |
| + Acquisitions | $17,300 | ||
| - R&D amortized | |||
| - Fixed capital depreciation | $8,708 | $7,506 | $5,913 |
| - Operating lease depreciation | $320 | $314 | $293 |
| = Reinvested | $7,689 | $5,681 | $19,795 |
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Adjusted EBIT | $32,526 | $32,622 | $25,893 |
| Marginal tax rate | 40.00 % | 40.00 % | 40.00 % |
| Adjusted EBIT(1 - t) | $19,516 | $19,573 | $15,536 |
| Reinvestment expense (gain) | $7,689 | $5,681 | $19,795 |
| Free cash flow to firm (FCFF) | $11,827 | $13,892 | ($4,259) |
| past reinvestment rates | 2 years | all |
|---|---|---|
| Reinvestment | 34.21 % | 65.28 % |
| Working capital investment | -0.70 % | -0.46 % |
| R&D investment | 0.00 % | 0.00 % |
| Acquisitions | 0.00 % | 37.12 % |
| Net capital investments | 78.02 % | 70.68 % |
| Past growth rates | 2 years | all |
|---|---|---|
| EBIT (adjusted) | -0.29 % | 10.93 % |
| Profit | 8.65 % | 13.79 % |
| Revenue | 5.00 % | 5.41 % |
| ( values in Millions ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash and equivalent | $7,362 | $10,493 | $10,043 |
| Short term investments | $732 | $953 | $1,101 |
| Accounts receivable | $22,446 | $17,628 | $17,184 |
| Inventory | $5,310 | $4,656 | $4,121 |
| Deferred taxes | |||
| Prepaid expenses | $3,527 | $2,574 | $1,887 |
| Other assets | |||
| Total assets | $39,377 | $36,304 | $34,336 |
| Accounts payable | $21,756 | $16,675 | $16,074 |
| Debt payments | $1,162 | $2,159 | $739 |
| Accrued Expenses | $5,275 | $4,546 | $3,690 |
| Tax payable | $5,605 | $5,029 | $4,508 |
| Other liabilities | |||
| Total liabilities | $33,798 | $28,409 | $25,011 |
| Working capital | $5,579 | $7,895 | $9,325 |
| Non cash working capital | ($1,353) | ($1,392) | ($1,080) |
| Investment in working capital | $39 | ($312) |
| Earnings in (Millions) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $220,904 | $210,118 | $198,200 |
| Expenses | $202,216 | $192,980 | $184,101 |
| Net income | $18,688 | $17,138 | $14,099 |
| Earnings before interest and taxes (EBIT) | $32,333 | $32,427 | $25,679 |
| Adjusted EBIT | $32,526 | $32,622 | $25,893 |
| Free cash flow to firm | $11,827 | $13,892 | ($4,259) |
| Free cash flow to equity | $10,679 | $11,143 | ($5,989) |
| Adjusted debt | $7,585 | $9,291 | $13,564 |
| Adjusted equity | $77,088 | $68,935 | $62,676 |
| Adjusted depreciation | $9,028 | $7,820 | $6,206 |
| Total reinvestment | $7,689 | $5,681 | $19,795 |
| Adjusted EBIT | $32,526 | $32,622 | $25,893 |
| Adjusted EBIT(1 - t) | $19,516 | $19,573 | $15,536 |
| FCFF | $11,827 | $13,892 | ($4,259) |
| FCFE | $10,679 | $11,143 | ($5,989) |
| Cash conversion cycle | 4 | 5 | 5 |
| Days inventory outstanding | 11 | 10 | 9 |
| Days payable outstanding | 44 | 35 | 35 |
| Days sales outstanding | 37 | 31 | 32 |
| Acid test | 0.24 | 0.40 | 0.45 |
| liberal acid test | 1.01 | 1.11 | 1.21 |
| Current ratio | 1.17 | 1.28 | 1.37 |
| Fixed charges coverage ratio | 47.62 | 33.78 | 25.96 |
| Interest coverage ratio | 194.78 | 71.90 | 53.28 |
|   | |||
| Current Assets | |||
| Cash and equivalent | $7,362 | $10,493 | $10,043 |
| Short term investments | $732 | $953 | $1,101 |
| Accounts receivable | $22,446 | $17,628 | $17,184 |
| Inventory | $5,310 | $4,656 | $4,121 |
| Deferred taxes | |||
| Prepaid expenses | $3,527 | $2,574 | $1,887 |
| Other assets | |||
| Total assets | $39,377 | $36,304 | $34,336 |
|   | |||
| Current Liabilities | |||
| Accounts payable | $21,756 | $16,675 | $16,074 |
| Debt payments | $1,162 | $2,159 | $739 |
| Accrued Expenses | $5,275 | $4,546 | $3,690 |
| Tax payable | $5,605 | $5,029 | $4,508 |
| Other liabilities | |||
| Total liabilities | $33,798 | $28,409 | $25,011 |
| Working capital | $5,579 | $7,895 | $9,325 |
| Non cash working capital | ($1,353) | ($1,392) | ($1,080) |
| Investment in working capital | $39 | ($312) | |