Earnings in (Thousands) |
|||||||||||||||||||||||||||||||||||||||||||||||||
$14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
($2,000,000) ($4,000,000) |
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Cash conversion cycle | 66 | 66 | 65 | 51 | 66 |
| Days inventory outstanding | 53 | 58 | 59 | 47 | 55 |
| Days payable outstanding | 51 | 47 | 48 | 48 | 45 |
| Days sales outstanding | 64 | 55 | 53 | 52 | 56 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Current ratio | 2.28 | 1.68 | 1.79 | 1.64 | 1.84 |
| Acid test | 1.39 | 0.86 | 1.07 | 0.92 | 1.10 |
| Acid test (liberal) | 2.08 | 1.46 | 1.59 | 1.46 | 1.64 |
| Debt to equity ratio (Adjusted) | 0.27 | 0.31 | 0.03 | 0.03 | 0.04 |
| Interest coverage ratio (Adjusted) | 41.07 | 67.49 | 0.00 | 0.00 | 3.79 |
| Fixed charges coverage ratio (Adjusted) | 10.41 | 10.12 | 15.02 | 13.22 | 2.57 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $13,230,205 | $11,155,090 | $9,663,955 | $8,229,488 |
| Expenses | $11,962,386 | $10,156,057 | $8,710,599 | $7,506,852 |
| Net income | $1,665,668 | $1,223,982 | $1,133,165 | $871,189 |
| Earnings before interest and taxes (EBIT) | $2,116,969 | $1,420,769 | $1,652,243 | $1,185,030 |
| Adjusted EBIT | $2,991,792 | $2,302,889 | $2,442,791 | $1,979,423 |
| Free cash flow to firm | $582,063 | ($2,088,013) | $521,552 | $478,007 |
| Free cash flow to equity | $963,373 | ($1,675,526) | $694,775 | $707,195 |
| Operating lease expense and debt conversion in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $214,516 | $193,365 | $162,676 | $149,769 |
| Year one | $188,220 | $152,895 | $119,526 | $107,762 |
| Year two | $135,662 | $117,478 | $77,599 | $74,460 |
| Year three | $92,306 | $74,943 | $59,224 | $53,461 |
| Year four | $64,954 | $52,771 | $43,391 | $42,910 |
| Post year four | $408,086 | $160,648 | $91,550 | $88,610 |
| Total | $1,103,744 | $752,100 | $553,966 | $516,972 |
| Debt value | $669,276 | $449,903 | $318,416 | $297,903 |
| Depreciation | $95,611 | $89,981 | $63,683 | $59,581 |
Past growth rates |
|||||||||||||||||
35 % 30 % 25 % 20 % 15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
|
|
|
|
|
||||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Thousands) |
|||||||||||||||||||||||||||||||
$3,000,000 $2,000,000 $1,000,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||
($1,000,000) ($2,000,000) ($3,000,000) |
|
|
|
|
|
|
|||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $1,528,078 | $1,289,603 | $1,004,829 | $847,899 |
| + Working capital investment | $228,528 | $327,199 | ($206,444) | ($181,508) |
| + Fixed Capital investment | $699,038 | $718,095 | $601,145 | $371,449 |
| + Acquisitions | $692,003 | $2,618,376 | $683,663 | $590,410 |
| - R&D amortized | $772,160 | $514,240 | $313,274 | $143,694 |
| - Fixed capital depreciation | $917,274 | $764,162 | $639,974 | $616,357 |
| - Operating lease depreciation | $95,611 | $89,981 | $63,683 | $59,581 |
| = Reinvested | $1,362,602 | $3,584,891 | $1,066,262 | $808,618 |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $2,991,792 | $2,302,889 | $2,442,791 | $1,979,423 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $1,944,665 | $1,496,878 | $1,587,814 | $1,286,625 |
| Reinvestment expense (gain) | $1,362,602 | $3,584,891 | $1,066,262 | $808,618 |
| Free cash flow to firm (FCFF) | $582,063 | ($2,088,013) | $521,552 | $478,007 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 154.78 % | 125.57 % | 106.02 % |
| Working capital investment | 16.81 % | 6.87 % | 1.30 % |
| R&D investment | 82.37 % | 76.00 % | 74.59 % |
| Acquisitions | 105.25 % | 84.52 % | 67.02 % |
| Net capital investments | 41.96 % | 40.59 % | 38.24 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | 26.02 % | 10.64 % | 15.79 % |
| Profit | 30.57 % | 19.86 % | 34.14 % |
| Revenue | 17.02 % | 15.71 % | 17.43 % |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $4,482,211 | $1,828,106 | $2,322,370 | $1,476,803 |
| Short term investments | $1,644,703 | $1,521,925 | $1,615,495 | $1,236,726 |
| Accounts receivable | $2,307,512 | $1,692,214 | $1,405,564 | $1,162,387 |
| Inventory | $877,243 | $834,800 | $724,751 | $514,065 |
| Deferred taxes | $475,544 | $418,146 | $326,318 | $289,810 |
| Prepaid expenses | ||||
| Other assets | $265,889 | $225,396 | $179,478 | $151,135 |
| Total assets | $10,053,102 | $6,520,587 | $6,573,976 | $4,830,926 |
| Accounts payable | $840,886 | $680,263 | $583,756 | $522,770 |
| Debt payments | ||||
| Accrued Expenses | $1,696,309 | $1,592,022 | $1,279,857 | $1,090,666 |
| Tax payable | $146,104 | $283,148 | $645,694 | $404,772 |
| Other liabilities | $1,724,909 | $1,325,671 | $1,164,551 | $930,492 |
| Total liabilities | $4,408,208 | $3,881,104 | $3,673,858 | $2,948,700 |
| Working capital | $5,644,894 | $2,639,483 | $2,900,118 | $1,882,226 |
| Non cash working capital | ($482,020) | ($710,548) | ($1,037,747) | ($831,303) |
| Investment in working capital | $228,528 | $327,199 | ($206,444) | ($181,508) |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Revenue | $13,230,205 | $11,155,090 | $9,663,955 | $8,229,488 | $6,236,808 |
| Expenses | $11,962,386 | $10,156,057 | $8,710,599 | $7,506,852 | $6,282,141 |
| Net income | $1,665,668 | $1,223,982 | $1,133,165 | $871,189 | $127,563 |
| Earnings before interest and taxes (EBIT) | $2,116,969 | $1,420,769 | $1,652,243 | $1,185,030 | $571,023 |
| Adjusted EBIT | $2,991,792 | $2,302,889 | $2,442,791 | $1,979,423 | $1,398,596 |
| Free cash flow to firm | $582,063 | ($2,088,013) | $521,552 | $478,007 | $85,783 |
| Free cash flow to equity | $963,373 | ($1,675,526) | $694,775 | $707,195 | ($44,214) |
| Adjusted debt | $4,119,276 | $3,899,903 | $445,379 | $426,359 | $464,678 |
| Adjusted equity | $15,410,911 | $12,439,937 | $13,488,105 | $12,241,757 | $10,884,721 |
| Adjusted depreciation | $1,785,045 | $1,368,382 | $1,016,931 | $819,632 | $587,640 |
| Total reinvestment | $1,362,602 | $3,584,891 | $1,066,262 | $808,618 | $823,305 |
| Adjusted EBIT | $2,991,792 | $2,302,889 | $2,442,791 | $1,979,423 | $1,398,596 |
| Adjusted EBIT(1 - t) | $1,944,665 | $1,496,878 | $1,587,814 | $1,286,625 | $909,087 |
| FCFF | $582,063 | ($2,088,013) | $521,552 | $478,007 | $85,783 |
| FCFE | $963,373 | ($1,675,526) | $694,775 | $707,195 | ($44,214) |
| Cash conversion cycle | 66 | 66 | 65 | 51 | 66 |
| Days inventory outstanding | 53 | 58 | 59 | 47 | 55 |
| Days payable outstanding | 51 | 47 | 48 | 48 | 45 |
| Days sales outstanding | 64 | 55 | 53 | 52 | 56 |
| Acid test | 1.39 | 0.86 | 1.07 | 0.92 | 1.10 |
| liberal acid test | 2.08 | 1.46 | 1.59 | 1.46 | 1.64 |
| Current ratio | 2.28 | 1.68 | 1.79 | 1.64 | 1.84 |
| Fixed charges coverage ratio | 7.37 | 6.25 | 10.16 | 7.91 | 1.05 |
| Interest coverage ratio | 29.06 | 41.64 | 0.00 | 0.00 | 1.55 |
|   | |||||
| Current Assets | |||||
| Cash and equivalent | $4,482,211 | $1,828,106 | $2,322,370 | $1,476,803 | $1,869,426 |
| Short term investments | $1,644,703 | $1,521,925 | $1,615,495 | $1,236,726 | $928,248 |
| Accounts receivable | $2,307,512 | $1,692,214 | $1,405,564 | $1,162,387 | $952,421 |
| Inventory | $877,243 | $834,800 | $724,751 | $514,065 | $514,015 |
| Deferred taxes | $475,544 | $418,146 | $326,318 | $289,810 | $271,746 |
| Prepaid expenses | |||||
| Other assets | $265,889 | $225,396 | $179,478 | $151,135 | $151,448 |
| Total assets | $10,053,102 | $6,520,587 | $6,573,976 | $4,830,926 | $4,687,304 |
|   | |||||
| Current Liabilities | |||||
| Accounts payable | $840,886 | $680,263 | $583,756 | $522,770 | $414,251 |
| Debt payments | $7,104 | ||||
| Accrued Expenses | $1,696,309 | $1,592,022 | $1,279,857 | $1,090,666 | $1,009,696 |
| Tax payable | $146,104 | $283,148 | $645,694 | $404,772 | $436,434 |
| Other liabilities | $1,724,909 | $1,325,671 | $1,164,551 | $930,492 | $679,044 |
| Total liabilities | $4,408,208 | $3,881,104 | $3,673,858 | $2,948,700 | $2,546,529 |
| Working capital | $5,644,894 | $2,639,483 | $2,900,118 | $1,882,226 | $2,140,775 |
| Non cash working capital | ($482,020) | ($710,548) | ($1,037,747) | ($831,303) | ($649,795) |
| Investment in working capital | $228,528 | $327,199 | ($206,444) | ($181,508) | |