Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||||||||||
$400,000 $350,000 $300,000 $250,000 $200,000 $150,000 $100,000 $50,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | |||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2008 | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|---|
| Cash conversion cycle | 10 | 11 | 13 | 15 | 15 |
| Days inventory outstanding | 45 | 47 | 49 | 49 | 49 |
| Days payable outstanding | 39 | 39 | 39 | 36 | 36 |
| Days sales outstanding | 4 | 3 | 3 | 2 | 2 |
| Risk ratios | 2008 | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|---|
| Current ratio | 0.81 | 0.90 | 0.90 | 0.90 | 0.92 |
| Acid test | 0.10 | 0.14 | 0.13 | 0.13 | 0.14 |
| Acid test (liberal) | 0.21 | 0.25 | 0.24 | 0.21 | 0.21 |
| Debt to equity ratio (Adjusted) | 0.52 | 0.50 | 0.50 | 0.41 | 0.40 |
| Interest coverage ratio (Adjusted) | 10.34 | 10.76 | 13.00 | 14.37 | 15.26 |
| Fixed charges coverage ratio (Adjusted) | 10.29 | 10.70 | 12.92 | 14.13 | 14.19 |
| Earnings in (Millions) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Revenue | $378,799 | $348,650 | $315,654 | $287,989 |
| Expenses | $366,373 | $337,646 | $304,671 | $277,923 |
| Net income | $12,731 | $11,284 | $11,231 | $10,267 |
| Earnings before interest and taxes (EBIT) | $21,742 | $19,458 | $18,454 | $17,043 |
| Adjusted EBIT | $21,750 | $19,466 | $18,460 | $17,052 |
| Free cash flow to firm | $4,928 | $3,936 | $2,250 | $2,882 |
| Free cash flow to equity | $3,519 | $2,565 | $1,479 | $2,054 |
| Operating lease expense and debt conversion in (Millions) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Current year | $10 | $10 | $9 | $20 |
| Year one | $10 | $10 | $10 | $18 |
| Year two | $10 | $10 | $10 | $17 |
| Year three | $10 | $10 | $10 | $11 |
| Year four | $10 | $10 | $10 | $11 |
| Post year four | $290 | $300 | $211 | $43 |
| Total | $340 | $350 | $260 | $120 |
| Debt value | $72 | $72 | $72 | $74 |
| Depreciation | $2 | $2 | $3 | $11 |
Past growth rates |
|||||||||||||||||
14 % 12 % 10 % 8 % 6 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
|||||||||||||||||||||||||||||||
$25,000 $20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||
|
|
|
|
|
|
|
||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | 2008 | |||||||||||||||||||||||||||
| ( values in Millions ) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | ($913) | ($1,488) | ($664) | ($275) |
| + Fixed Capital investment | $14,937 | $15,666 | $14,563 | $12,893 |
| + Acquisitions | $1,505 | $570 | ||
| - R&D amortized | ||||
| - Fixed capital depreciation | $6,317 | $5,459 | $4,717 | $4,405 |
| - Operating lease depreciation | $2 | $2 | $3 | $11 |
| = Reinvested | $9,210 | $8,717 | $9,749 | $8,202 |
| ( values in Millions ) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Adjusted EBIT | $21,750 | $19,466 | $18,460 | $17,052 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $14,137 | $12,653 | $11,999 | $11,084 |
| Reinvestment expense (gain) | $9,210 | $8,717 | $9,749 | $8,202 |
| Free cash flow to firm (FCFF) | $4,928 | $3,936 | $2,250 | $2,882 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 67.02 % | 71.76 % | 71.45 % |
| Working capital investment | -9.11 % | -7.92 % | -5.25 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 5.32 % | 5.13 % | 3.69 % |
| Net capital investments | 114.74 % | 116.95 % | 114.30 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 11.08 % | 8.27 % | 8.44 % |
| Profit | 12.05 % | 6.38 % | 7.67 % |
| Revenue | 8.29 % | 9.08 % | 9.46 % |
| ( values in Millions ) | 2008 | 2007 | 2006 | 2005 |
|---|---|---|---|---|
| Cash and equivalent | $5,569 | $7,373 | $6,414 | $5,488 |
| Short term investments | ||||
| Accounts receivable | $3,654 | $2,840 | $2,662 | $1,715 |
| Inventory | $35,180 | $33,685 | $32,191 | $29,447 |
| Deferred taxes | ||||
| Prepaid expenses | $3,182 | $2,690 | $2,557 | $1,841 |
| Other assets | ||||
| Total assets | $47,585 | $46,588 | $43,824 | $38,491 |
| Accounts payable | $30,370 | $28,090 | $25,373 | $21,671 |
| Debt payments | $11,269 | $8,283 | $8,648 | $7,781 |
| Accrued Expenses | $15,799 | $14,675 | $13,465 | $12,155 |
| Tax payable | $1,016 | $706 | $1,340 | $1,281 |
| Other liabilities | ||||
| Total liabilities | $58,454 | $51,754 | $48,826 | $42,888 |
| Working capital | ($10,869) | ($5,166) | ($5,002) | ($4,397) |
| Non cash working capital | ($5,169) | ($4,256) | ($2,768) | ($2,104) |
| Investment in working capital | ($913) | ($1,488) | ($664) | ($275) |
| Earnings in (Millions) | 2008 | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|---|
| Revenue | $378,799 | $348,650 | $315,654 | $287,989 | $258,681 |
| Expenses | $366,373 | $337,646 | $304,671 | $277,923 | $249,984 |
| Net income | $12,731 | $11,284 | $11,231 | $10,267 | $9,054 |
| Earnings before interest and taxes (EBIT) | $21,742 | $19,458 | $18,454 | $17,043 | $15,168 |
| Adjusted EBIT | $21,750 | $19,466 | $18,460 | $17,052 | $15,201 |
| Free cash flow to firm | $4,928 | $3,936 | $2,250 | $2,882 | $3,167 |
| Free cash flow to equity | $3,519 | $2,565 | $1,479 | $2,054 | $2,298 |
| Adjusted debt | $33,474 | $30,807 | $26,501 | $20,161 | $17,396 |
| Adjusted equity | $64,608 | $61,573 | $53,171 | $49,396 | $43,623 |
| Adjusted depreciation | $6,319 | $5,461 | $4,720 | $4,416 | $3,894 |
| Total reinvestment | $9,210 | $8,717 | $9,749 | $8,202 | $6,714 |
| Adjusted EBIT | $21,750 | $19,466 | $18,460 | $17,052 | $15,201 |
| Adjusted EBIT(1 - t) | $14,137 | $12,653 | $11,999 | $11,084 | $9,881 |
| FCFF | $4,928 | $3,936 | $2,250 | $2,882 | $3,167 |
| FCFE | $3,519 | $2,565 | $1,479 | $2,054 | $2,298 |
| Cash conversion cycle | 10 | 11 | 13 | 15 | 15 |
| Days inventory outstanding | 45 | 47 | 49 | 49 | 49 |
| Days payable outstanding | 39 | 39 | 39 | 36 | 36 |
| Days sales outstanding | 4 | 3 | 3 | 2 | 2 |
| Acid test | 0.10 | 0.14 | 0.13 | 0.13 | 0.14 |
| liberal acid test | 0.21 | 0.25 | 0.24 | 0.21 | 0.21 |
| Current ratio | 0.81 | 0.90 | 0.90 | 0.90 | 0.92 |
| Fixed charges coverage ratio | 10.29 | 10.70 | 12.91 | 14.12 | 14.16 |
| Interest coverage ratio | 10.34 | 10.76 | 13.00 | 14.36 | 15.23 |
|   | |||||
| Current Assets | |||||
| Cash and equivalent | $5,569 | $7,373 | $6,414 | $5,488 | $5,199 |
| Short term investments | |||||
| Accounts receivable | $3,654 | $2,840 | $2,662 | $1,715 | $1,254 |
| Inventory | $35,180 | $33,685 | $32,191 | $29,447 | $26,612 |
| Deferred taxes | |||||
| Prepaid expenses | $3,182 | $2,690 | $2,557 | $1,841 | $1,356 |
| Other assets | |||||
| Total assets | $47,585 | $46,588 | $43,824 | $38,491 | $34,421 |
|   | |||||
| Current Liabilities | |||||
| Accounts payable | $30,370 | $28,090 | $25,373 | $21,671 | $19,332 |
| Debt payments | $11,269 | $8,283 | $8,648 | $7,781 | $6,367 |
| Accrued Expenses | $15,799 | $14,675 | $13,465 | $12,155 | $10,342 |
| Tax payable | $1,016 | $706 | $1,340 | $1,281 | $1,377 |
| Other liabilities | |||||
| Total liabilities | $58,454 | $51,754 | $48,826 | $42,888 | $37,418 |
| Working capital | ($10,869) | ($5,166) | ($5,002) | ($4,397) | ($2,997) |
| Non cash working capital | ($5,169) | ($4,256) | ($2,768) | ($2,104) | ($1,829) |
| Investment in working capital | ($913) | ($1,488) | ($664) | ($275) | |