Earnings in (Millions) |
|||||||||||||||||||||||||||||||||||||||||
$20,000 $15,000 $10,000 $5,000 |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||
($5,000) ($10,000) |
|
|
|
|
|
||||||||||||||||||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | ||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash conversion cycle | -122 | -252 | -165 | -155 |
| Days inventory outstanding | 0 | 0 | 0 | 0 |
| Days payable outstanding | 155 | 304 | 229 | 251 |
| Days sales outstanding | 34 | 53 | 64 | 96 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current ratio | 0.86 | 0.28 | 1.21 | 1.26 |
| Acid test | 0.24 | 0.03 | 0.23 | 0.44 |
| Acid test (liberal) | 0.86 | 0.28 | 1.21 | 1.26 |
| Debt to equity ratio (Adjusted) | 0.88 | 1.01 | 0.47 | 0.42 |
| Interest coverage ratio (Adjusted) | 7.45 | 10.86 | 17.08 | 7.76 |
| Fixed charges coverage ratio (Adjusted) | 3.11 | 3.63 | 6.44 | 6.54 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $15,892 | $10,230 | $6,308 | $5,124 |
| Expenses | $12,196 | $7,762 | $4,409 | $3,764 |
| Net income | $3,781 | $4,749 | $2,331 | $1,606 |
| Earnings before interest and taxes (EBIT) | $7,432 | $6,662 | $3,830 | $2,763 |
| Adjusted EBIT | $8,140 | $7,061 | $3,776 | $2,778 |
| Free cash flow to firm | ($5,929) | ($5,605) | $661 | $195 |
| Free cash flow to equity | ($8,258) | ($6,344) | $118 | ($57) |
| Operating lease expense and debt conversion in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $1,527 | $1,297 | $365 | $67 |
| Year one | $1,144 | $1,650 | $653 | $70 |
| Year two | $894 | $1,099 | $643 | $63 |
| Year three | $677 | $634 | $515 | $59 |
| Year four | $563 | $284 | $103 | $50 |
| Post year four | $676 | $551 | $48 | $81 |
| Total | $5,481 | $5,515 | $2,327 | $390 |
| Debt value | $3,277 | $3,590 | $1,677 | $258 |
| Depreciation | $819 | $898 | $419 | $52 |
Past growth rates |
|||||||||||||||||
50 % 40 % 30 % 20 % 10 % |
|
|
|
|
|
||||||||||||
-10 % -20 % -30 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Millions) |
||||||||||||||||||||||||||
$10,000 $8,000 $6,000 $4,000 $2,000 |
|
|
|
|
|
|
||||||||||||||||||||
($2,000) ($4,000) ($6,000) ($8,000) ($10,000) |
|
|
|
|
|
|||||||||||||||||||||
| 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | ||||
| + Working capital investment | $10,626 | ($12,587) | $148 | |
| + Fixed Capital investment | $4,246 | $4,569 | $3,408 | $3,064 |
| + Acquisitions | $7 | $21,087 | $46 | |
| - R&D amortized | ||||
| - Fixed capital depreciation | $2,840 | $1,976 | $1,343 | $1,447 |
| - Operating lease depreciation | $819 | $898 | $419 | $52 |
| = Reinvested | $11,220 | $10,195 | $1,794 | $1,611 |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $8,140 | $7,061 | $3,776 | $2,778 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $5,291 | $4,590 | $2,454 | $1,806 |
| Reinvestment expense (gain) | $11,220 | $10,195 | $1,794 | $1,611 |
| Free cash flow to firm (FCFF) | ($5,929) | ($5,605) | $661 | $195 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 217.09 % | 169.09 % | 149.13 % |
| Working capital investment | -36.70 % | -22.45 % | -16.84 % |
| R&D investment | 0.00 % | 0.00 % | 0.00 % |
| Acquisitions | 229.78 % | 153.18 % | 115.53 % |
| Net capital investments | 89.90 % | 106.22 % | 122.08 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 14.19 % | 34.49 % | 35.61 % |
| Profit | -22.70 % | 20.03 % | 28.69 % |
| Revenue | 43.35 % | 44.33 % | 38.59 % |
| ( values in Millions ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,268 | $491 | $561 | $874 |
| Short term investments | ||||
| Accounts receivable | $1,465 | $1,476 | $1,109 | $1,350 |
| Inventory | ||||
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $1,783 | $2,647 | $1,246 | $278 |
| Total assets | $4,516 | $4,614 | $2,916 | $2,502 |
| Accounts payable | $2,778 | $3,501 | $1,485 | $1,460 |
| Debt payments | $169 | |||
| Accrued Expenses | $1,083 | $1,739 | $499 | $364 |
| Tax payable | ||||
| Other liabilities | $1,396 | $11,518 | $419 | |
| Total liabilities | $5,257 | $16,758 | $2,403 | $1,993 |
| Working capital | ($741) | ($12,144) | $513 | $509 |
| Non cash working capital | ($2,009) | ($12,635) | ($48) | ($196) |
| Investment in working capital | $10,626 | ($12,587) | $148 |
| Earnings in (Millions) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $15,892 | $10,230 | $6,308 | $5,124 |
| Expenses | $12,196 | $7,762 | $4,409 | $3,764 |
| Net income | $3,781 | $4,749 | $2,331 | $1,606 |
| Earnings before interest and taxes (EBIT) | $7,432 | $6,662 | $3,830 | $2,763 |
| Adjusted EBIT | $8,140 | $7,061 | $3,776 | $2,778 |
| Free cash flow to firm | ($5,929) | ($5,605) | $661 | $195 |
| Free cash flow to equity | ($8,258) | ($6,344) | $118 | ($57) |
| Adjusted debt | $14,428 | $15,110 | $5,232 | $3,929 |
| Adjusted equity | $16,364 | $14,913 | $11,051 | $9,285 |
| Adjusted depreciation | $3,659 | $2,874 | $1,762 | $1,499 |
| Total reinvestment | $11,220 | $10,195 | $1,794 | $1,611 |
| Adjusted EBIT | $8,140 | $7,061 | $3,776 | $2,778 |
| Adjusted EBIT(1 - t) | $5,291 | $4,590 | $2,454 | $1,806 |
| FCFF | ($5,929) | ($5,605) | $661 | $195 |
| FCFE | ($8,258) | ($6,344) | $118 | ($57) |
| Cash conversion cycle | -122 | -252 | -165 | -155 |
| Days inventory outstanding | 0 | 0 | 0 | 0 |
| Days payable outstanding | 155 | 304 | 229 | 251 |
| Days sales outstanding | 34 | 53 | 64 | 96 |
| Acid test | 0.24 | 0.03 | 0.23 | 0.44 |
| liberal acid test | 0.86 | 0.28 | 1.21 | 1.26 |
| Current ratio | 0.86 | 0.28 | 1.21 | 1.26 |
| Fixed charges coverage ratio | 2.84 | 3.42 | 6.54 | 6.50 |
| Interest coverage ratio | 6.81 | 10.25 | 17.33 | 7.72 |
|   | ||||
| Current Assets | ||||
| Cash and equivalent | $1,268 | $491 | $561 | $874 |
| Short term investments | ||||
| Accounts receivable | $1,465 | $1,476 | $1,109 | $1,350 |
| Inventory | ||||
| Deferred taxes | ||||
| Prepaid expenses | ||||
| Other assets | $1,783 | $2,647 | $1,246 | $278 |
| Total assets | $4,516 | $4,614 | $2,916 | $2,502 |
|   | ||||
| Current Liabilities | ||||
| Accounts payable | $2,778 | $3,501 | $1,485 | $1,460 |
| Debt payments | $169 | |||
| Accrued Expenses | $1,083 | $1,739 | $499 | $364 |
| Tax payable | ||||
| Other liabilities | $1,396 | $11,518 | $419 | |
| Total liabilities | $5,257 | $16,758 | $2,403 | $1,993 |
| Working capital | ($741) | ($12,144) | $513 | $509 |
| Non cash working capital | ($2,009) | ($12,635) | ($48) | ($196) |
| Investment in working capital | $10,626 | ($12,587) | $148 | |