Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
$60,000 $40,000 $20,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
($20,000) ($40,000) ($60,000) |
|
|
|
|
|
|
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 | 1997 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Cash conversion cycle | 101 | 143 | 136 | 156 | 146 | 82 | 88 | 91 | 144 | 182 | 236 |
| Days inventory outstanding | 135 | 205 | 185 | 223 | 217 | 242 | 199 | 201 | 239 | 319 | 285 |
| Days payable outstanding | 113 | 136 | 122 | 137 | 145 | 230 | 174 | 180 | 188 | 219 | 123 |
| Days sales outstanding | 79 | 75 | 73 | 70 | 74 | 70 | 63 | 69 | 93 | 83 | 74 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 | 1997 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Current ratio | 2.15 | 2.20 | 1.47 | 1.50 | 1.26 | 1.34 | 1.35 | 1.43 | 1.22 | 1.38 | 1.29 |
| Acid test | 1.17 | 1.30 | 0.78 | 0.75 | 0.51 | 0.68 | 0.63 | 0.57 | 0.48 | 0.55 | 0.30 |
| Acid test (liberal) | 1.90 | 1.91 | 1.26 | 1.25 | 1.01 | 1.19 | 1.15 | 1.21 | 1.04 | 1.13 | 0.95 |
| Debt to equity ratio (Adjusted) | 0.08 | 0.06 | 0.07 | 0.09 | 0.09 | 0.12 | 0.12 | 0.08 | 0.06 | 0.07 | 0.13 |
| Interest coverage ratio (Adjusted) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Fixed charges coverage ratio (Adjusted) | 55.03 | 107.96 | 71.25 | 77.65 | 54.02 | 89.69 | 97.36 | 97.92 | 126.11 | 100.07 | 111.78 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $48,418 | $48,371 | $51,298 | $52,516 |
| Expenses | $42,033 | $38,251 | $43,260 | $41,206 |
| Net income | $8,144 | $19,337 | $8,085 | $11,361 |
| Earnings before interest and taxes (EBIT) | $9,167 | $21,329 | $11,509 | $14,026 |
| Adjusted EBIT | $11,666 | $24,724 | $16,458 | $19,490 |
| Free cash flow to firm | $3,250 | $16,398 | $9,008 | $6,009 |
| Free cash flow to equity | $6,098 | $22,830 | $11,113 | $9,914 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $212 | $229 | $231 | $251 |
| Year one | $192 | $200 | $217 | $240 |
| Year two | $151 | $174 | $181 | $218 |
| Year three | $99 | $113 | $141 | $165 |
| Year four | $75 | $72 | $103 | $150 |
| Post year four | $788 | $524 | $376 | $575 |
| Total | $1,517 | $1,312 | $1,249 | $1,599 |
| Debt value | $944 | $847 | $826 | $1,078 |
| Depreciation | $94 | $121 | $138 | $180 |
Past growth rates |
|||||||||||||||||||||||||
20 % 10 % |
|
|
|
|
|
|
|
||||||||||||||||||
-10 % -20 % -30 % -40 % -50 % -60 % -70 % -80 % -90 % |
|
|
|
|
|
|
|||||||||||||||||||
| all | 10 years | 6 years | 4 years | 2 years | |||||||||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||||||||||||
$30,000 $20,000 $10,000 |
|
|
|
|
|
|
|
|
||||||||||||||||||||||||||||
($10,000) ($20,000) ($30,000) ($40,000) ($50,000) ($60,000) |
|
|
|
|
|
|
|
|||||||||||||||||||||||||||||
| 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $8,372 | $8,434 | $9,094 | $8,755 |
| + Working capital investment | $5,083 | ($2,530) | ($1,798) | $1,659 |
| + Fixed Capital investment | $1,880 | $2,050 | $2,106 | $2,601 |
| + Acquisitions | $283 | $2,280 | $2,240 | $2,280 |
| - R&D amortized | $5,991 | $5,147 | $4,238 | $3,362 |
| - Fixed capital depreciation | $5,200 | $5,293 | $5,576 | $5,093 |
| - Operating lease depreciation | $94 | $121 | $138 | $180 |
| = Reinvested | $4,333 | ($327) | $1,690 | $6,660 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $11,666 | $24,724 | $16,458 | $19,490 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $7,583 | $16,070 | $10,698 | $12,668 |
| Reinvestment expense (gain) | $4,333 | ($327) | $1,690 | $6,660 |
| Free cash flow to firm (FCFF) | $3,250 | $16,398 | $9,008 | $6,009 |
| past reinvestment rates | 2 years | 4 years | 6 years | 10 years | all |
|---|---|---|---|---|---|
| Reinvestment | 27.55 % | 30.87 % | 133.75 % | 108.05 % | 104.75 % |
| Working capital investment | 25.64 % | 11.89 % | 8.73 % | 5.34 % | 4.86 % |
| R&D investment | 81.44 % | 79.25 % | 81.43 % | 73.19 % | 71.89 % |
| Acquisitions | 8.96 % | 14.21 % | 101.14 % | 60.68 % | 55.17 % |
| Net capital investments | 18.77 % | 19.44 % | 20.22 % | 24.61 % | 24.99 % |
| Past growth rates | 2 years | 4 years | 6 years | 10 years | all |
|---|---|---|---|---|---|
| EBIT (adjusted) | -71.77 % | -8.41 % | 0.96 % | 9.52 % | 10.70 % |
| Profit | -81.46 % | 1.36 % | 10.89 % | 15.52 % | 15.90 % |
| Revenue | 0.10 % | -3.04 % | 5.46 % | 11.82 % | 12.64 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $3,406 | $1,827 | $2,247 | $1,808 |
| Short term investments | $22,069 | $25,886 | $19,979 | $18,085 |
| Accounts receivable | $10,460 | $9,906 | $10,275 | $10,020 |
| Inventory | $5,302 | $6,111 | $6,039 | $6,660 |
| Deferred taxes | ||||
| Prepaid expenses | $5,498 | $3,157 | $3,196 | $2,939 |
| Other assets | $114 | $62 | $160 | $182 |
| Total assets | $46,849 | $46,949 | $41,896 | $39,694 |
| Accounts payable | $4,433 | $4,074 | $3,998 | $4,090 |
| Debt payments | $5,825 | $2,434 | $11,589 | $11,266 |
| Accrued Expenses | $1,974 | $1,903 | $1,720 | $2,203 |
| Tax payable | $1,380 | $6,466 | $3,617 | $1,963 |
| Other liabilities | $8,223 | $6,512 | $7,524 | $6,936 |
| Total liabilities | $21,835 | $21,389 | $28,448 | $26,458 |
| Working capital | $25,014 | $25,560 | $13,448 | $13,236 |
| Non cash working capital | $5,364 | $281 | $2,811 | $4,609 |
| Investment in working capital | $5,083 | ($2,530) | ($1,798) | $1,659 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 | 2003 | 2002 | 2001 | 2000 | 1999 | 1998 | 1997 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | $48,418 | $48,371 | $51,298 | $52,516 | $45,188 | $32,373 | $32,259 | $29,574 | $16,204 | $13,544 | $12,504 |
| Expenses | $42,033 | $38,251 | $43,260 | $41,206 | $43,579 | $23,722 | $24,596 | $26,104 | $13,025 | $11,594 | $10,291 |
| Net income | $8,144 | $19,337 | $8,085 | $11,361 | $3,910 | $9,126 | $7,788 | $3,726 | $3,179 | $1,950 | $2,213 |
| Earnings before interest and taxes (EBIT) | $9,167 | $21,329 | $11,509 | $14,026 | $5,531 | $11,735 | $10,349 | $5,775 | $4,423 | $2,592 | $3,078 |
| Adjusted EBIT | $11,666 | $24,724 | $16,458 | $19,490 | $15,665 | $15,337 | $14,117 | $12,828 | $6,810 | $4,703 | $5,030 |
| Free cash flow to firm | $3,250 | $16,398 | $9,008 | $6,009 | ($54,831) | $5,932 | $4,590 | $3,383 | $46 | $929 | $921 |
| Free cash flow to equity | $6,098 | $22,830 | $11,113 | $9,914 | ($51,259) | $8,520 | $6,825 | $2,436 | $1,131 | $1,886 | $1,772 |
| Adjusted debt | $8,258 | $6,393 | $7,173 | $8,357 | $7,121 | $4,087 | $3,433 | $1,699 | $795 | $792 | $1,000 |
| Adjusted equity | $105,945 | $109,007 | $98,419 | $95,678 | $82,738 | $33,761 | $28,399 | $22,446 | $12,901 | $10,738 | $7,933 |
| Adjusted depreciation | $11,285 | $10,561 | $9,952 | $8,635 | $6,417 | $2,781 | $2,292 | $1,738 | $985 | $704 | $523 |
| Total reinvestment | $4,333 | ($327) | $1,690 | $6,660 | $65,013 | $4,037 | $4,586 | $4,955 | $4,381 | $2,128 | $2,348 |
| Adjusted EBIT | $11,666 | $24,724 | $16,458 | $19,490 | $15,665 | $15,337 | $14,117 | $12,828 | $6,810 | $4,703 | $5,030 |
| Adjusted EBIT(1 - t) | $7,583 | $16,070 | $10,698 | $12,668 | $10,182 | $9,969 | $9,176 | $8,338 | $4,426 | $3,057 | $3,270 |
| FCFF | $3,250 | $16,398 | $9,008 | $6,009 | ($54,831) | $5,932 | $4,590 | $3,383 | $46 | $929 | $921 |
| FCFE | $6,098 | $22,830 | $11,113 | $9,914 | ($51,259) | $8,520 | $6,825 | $2,436 | $1,131 | $1,886 | $1,772 |
| Cash conversion cycle | 101 | 143 | 136 | 156 | 146 | 82 | 88 | 91 | 144 | 182 | 236 |
| Days inventory outstanding | 135 | 205 | 185 | 223 | 217 | 242 | 199 | 201 | 239 | 319 | 285 |
| Days payable outstanding | 113 | 136 | 122 | 137 | 145 | 230 | 174 | 180 | 188 | 219 | 123 |
| Days sales outstanding | 79 | 75 | 73 | 70 | 74 | 70 | 63 | 69 | 93 | 83 | 74 |
| Acid test | 1.17 | 1.30 | 0.78 | 0.75 | 0.51 | 0.68 | 0.63 | 0.57 | 0.48 | 0.55 | 0.30 |
| liberal acid test | 1.90 | 1.91 | 1.26 | 1.25 | 1.01 | 1.19 | 1.15 | 1.21 | 1.04 | 1.13 | 0.95 |
| Current ratio | 2.15 | 2.20 | 1.47 | 1.50 | 1.26 | 1.34 | 1.35 | 1.43 | 1.22 | 1.38 | 1.29 |
| Fixed charges coverage ratio | 43.24 | 93.14 | 49.82 | 55.88 | 19.07 | 68.63 | 71.37 | 44.08 | 81.91 | 55.15 | 68.40 |
| Interest coverage ratio | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
|   | |||||||||||
| Current Assets | |||||||||||
| Cash and equivalent | $3,406 | $1,827 | $2,247 | $1,808 | $1,520 | $1,878 | $1,036 | $1,099 | $739 | $1,552 | $877 |
| Short term investments | $22,069 | $25,886 | $19,979 | $18,085 | $10,432 | $10,673 | $7,579 | $5,764 | $3,703 | $2,377 | $712 |
| Accounts receivable | $10,460 | $9,906 | $10,275 | $10,020 | $9,166 | $6,184 | $5,606 | $5,629 | $4,137 | $3,064 | $2,527 |
| Inventory | $5,302 | $6,111 | $6,039 | $6,660 | $5,837 | $2,678 | $2,741 | $2,702 | $1,654 | $1,828 | $1,773 |
| Deferred taxes | |||||||||||
| Prepaid expenses | $5,498 | $3,157 | $3,196 | $2,939 | $2,786 | $1,797 | $1,488 | $1,993 | $958 | $1,110 | $816 |
| Other assets | $114 | $62 | $160 | $182 | $1,571 | $115 | |||||
| Total assets | $46,849 | $46,949 | $41,896 | $39,694 | $29,741 | $24,781 | $18,450 | $17,187 | $11,191 | $9,931 | $6,820 |
|   | |||||||||||
| Current Liabilities | |||||||||||
| Accounts payable | $4,433 | $4,074 | $3,998 | $4,090 | $3,901 | $2,546 | $2,398 | $2,415 | $1,300 | $1,256 | $765 |
| Debt payments | $5,825 | $2,434 | $11,589 | $11,266 | $8,818 | $8,669 | $6,265 | $4,289 | $5,001 | $2,729 | $2,255 |
| Accrued Expenses | $1,974 | $1,903 | $1,720 | $2,203 | $3,155 | $1,084 | $1,083 | $982 | $669 | $614 | $477 |
| Tax payable | $1,380 | $6,466 | $3,617 | $1,963 | $1,919 | $2,231 | $806 | $850 | $869 | $1,162 | $785 |
| Other liabilities | $8,223 | $6,512 | $7,524 | $6,936 | $5,864 | $4,025 | $3,088 | $3,445 | $1,346 | $1,434 | $1,023 |
| Total liabilities | $21,835 | $21,389 | $28,448 | $26,458 | $23,657 | $18,555 | $13,640 | $11,981 | $9,185 | $7,195 | $5,305 |
| Working capital | $25,014 | $25,560 | $13,448 | $13,236 | $6,084 | $6,226 | $4,810 | $5,206 | $2,006 | $2,736 | $1,515 |
| Non cash working capital | $5,364 | $281 | $2,811 | $4,609 | $2,950 | $2,344 | $2,460 | $2,632 | $2,565 | $1,536 | $2,181 |
| Investment in working capital | $5,083 | ($2,530) | ($1,798) | $1,659 | $606 | ($116) | ($172) | $67 | $1,029 | ($645) | |