Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$25,000 $20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | -82 | -59 | -36 | -48 |
| Days inventory outstanding | 8 | 7 | 6 | 6 |
| Days payable outstanding | 114 | 90 | 66 | 88 |
| Days sales outstanding | 25 | 24 | 23 | 34 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 2.36 | 2.24 | 2.96 | 2.63 |
| Acid test | 1.65 | 1.56 | 2.37 | 2.04 |
| Acid test (liberal) | 2.32 | 2.20 | 2.91 | 2.59 |
| Debt to equity ratio (Adjusted) | 0.06 | 0.07 | 0.07 | 0.08 |
| Interest coverage ratio (Adjusted) | 0.00 | 0.00 | 0.00 | 0.00 |
| Fixed charges coverage ratio (Adjusted) | 35.26 | 25.02 | 21.11 | 10.16 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $24,006 | $19,315 | $13,931 | $8,279 |
| Expenses | $21,109 | $17,691 | $12,761 | $8,060 |
| Net income | $3,496 | $1,989 | $1,335 | $276 |
| Earnings before interest and taxes (EBIT) | $5,008 | $2,818 | $1,815 | $383 |
| Adjusted EBIT | $5,465 | $3,353 | $2,279 | $905 |
| Free cash flow to firm | $3,489 | $1,974 | $1,400 | $129 |
| Free cash flow to equity | $3,735 | $2,184 | $1,610 | $250 |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $155 | $134 | $108 | $89 |
| Year one | $172 | $134 | $110 | $91 |
| Year two | $173 | $134 | $101 | $79 |
| Year three | $160 | $132 | $97 | $65 |
| Year four | $148 | $122 | $95 | $61 |
| Post year four | $617 | $498 | $354 | $232 |
| Total | $1,425 | $1,154 | $865 | $617 |
| Debt value | $933 | $748 | $559 | $395 |
| Depreciation | $133 | $107 | $80 | $56 |
Past growth rates |
|||||||||||||||||
60 % 55 % 50 % 45 % 40 % 35 % 30 % 25 % 20 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$6,000 $5,000 $4,000 $3,000 $2,000 $1,000 |
|
|
|
|
|
|
||||||||||||||||||||
|
|
|
|
|
|
||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $782 | $712 | $534 | $489 |
| + Working capital investment | ($657) | ($627) | ($356) | |
| + Fixed Capital investment | $735 | $657 | $260 | $176 |
| + Acquisitions | ||||
| - R&D amortized | $347 | $205 | $98 | |
| - Fixed capital depreciation | $317 | $225 | $179 | $150 |
| - Operating lease depreciation | $133 | $107 | $80 | $56 |
| = Reinvested | $63 | $206 | $81 | $459 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $5,465 | $3,353 | $2,279 | $905 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $3,552 | $2,179 | $1,482 | $588 |
| Reinvestment expense (gain) | $63 | $206 | $81 | $459 |
| Free cash flow to firm (FCFF) | $3,489 | $1,974 | $1,400 | $129 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 5.60 % | 5.56 % | 23.67 % |
| Working capital investment | -23.63 % | -23.77 % | -17.82 % |
| R&D investment | 27.34 % | 30.24 % | 43.47 % |
| Acquisitions | 0.00 % | 0.00 % | 0.00 % |
| Net capital investments | 25.42 % | 22.80 % | 24.58 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 47.91 % | 43.06 % | 49.17 % |
| Profit | 54.95 % | 47.53 % | 58.14 % |
| Revenue | 21.66 % | 26.40 % | 32.09 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $9,352 | $6,392 | $3,491 | $2,969 |
| Short term investments | $6,034 | $3,718 | $4,770 | $2,495 |
| Accounts receivable | $1,637 | $1,252 | $895 | $774 |
| Inventory | $346 | $270 | $165 | $101 |
| Deferred taxes | $782 | $607 | $331 | $231 |
| Prepaid expenses | $3,805 | |||
| Other assets | $2,270 | $648 | $485 | |
| Total assets | $21,956 | $14,509 | $10,300 | $7,055 |
| Accounts payable | $4,970 | $3,390 | $1,779 | $1,451 |
| Debt payments | ||||
| Accrued Expenses | $4,329 | $3,081 | $1,705 | $1,229 |
| Tax payable | ||||
| Other liabilities | ||||
| Total liabilities | $9,299 | $6,471 | $3,484 | $2,680 |
| Working capital | $12,657 | $8,038 | $6,816 | $4,375 |
| Non cash working capital | ($2,729) | ($2,072) | ($1,445) | ($1,089) |
| Investment in working capital | ($657) | ($627) | ($356) |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $24,006 | $19,315 | $13,931 | $8,279 |
| Expenses | $21,109 | $17,691 | $12,761 | $8,060 |
| Net income | $3,496 | $1,989 | $1,335 | $276 |
| Earnings before interest and taxes (EBIT) | $5,008 | $2,818 | $1,815 | $383 |
| Adjusted EBIT | $5,465 | $3,353 | $2,279 | $905 |
| Free cash flow to firm | $3,489 | $1,974 | $1,400 | $129 |
| Free cash flow to equity | $3,735 | $2,184 | $1,610 | $250 |
| Adjusted debt | $933 | $748 | $559 | $395 |
| Adjusted equity | $15,965 | $10,909 | $7,955 | $5,076 |
| Adjusted depreciation | $797 | $536 | $357 | $206 |
| Total reinvestment | $63 | $206 | $81 | $459 |
| Adjusted EBIT | $5,465 | $3,353 | $2,279 | $905 |
| Adjusted EBIT(1 - t) | $3,552 | $2,179 | $1,482 | $588 |
| FCFF | $3,489 | $1,974 | $1,400 | $129 |
| FCFE | $3,735 | $2,184 | $1,610 | $250 |
| Cash conversion cycle | -82 | -59 | -36 | -48 |
| Days inventory outstanding | 8 | 7 | 6 | 6 |
| Days payable outstanding | 114 | 90 | 66 | 88 |
| Days sales outstanding | 25 | 24 | 23 | 34 |
| Acid test | 1.65 | 1.56 | 2.37 | 2.04 |
| liberal acid test | 2.32 | 2.20 | 2.91 | 2.59 |
| Current ratio | 2.36 | 2.24 | 2.96 | 2.63 |
| Fixed charges coverage ratio | 32.31 | 21.03 | 16.81 | 4.30 |
| Interest coverage ratio | 0.00 | 0.00 | 0.00 | 0.00 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $9,352 | $6,392 | $3,491 | $2,969 |
| Short term investments | $6,034 | $3,718 | $4,770 | $2,495 |
| Accounts receivable | $1,637 | $1,252 | $895 | $774 |
| Inventory | $346 | $270 | $165 | $101 |
| Deferred taxes | $782 | $607 | $331 | $231 |
| Prepaid expenses | $3,805 | |||
| Other assets | $2,270 | $648 | $485 | |
| Total assets | $21,956 | $14,509 | $10,300 | $7,055 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $4,970 | $3,390 | $1,779 | $1,451 |
| Debt payments | ||||
| Accrued Expenses | $4,329 | $3,081 | $1,705 | $1,229 |
| Tax payable | ||||
| Other liabilities | ||||
| Total liabilities | $9,299 | $6,471 | $3,484 | $2,680 |
| Working capital | $12,657 | $8,038 | $6,816 | $4,375 |
| Non cash working capital | ($2,729) | ($2,072) | ($1,445) | ($1,089) |
| Investment in working capital | ($657) | ($627) | ($356) | |