Earnings in (Thousands) |
|||||||||||||||||||||||||||||||||
$16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 |
|
|
|
|
|
||||||||||||||||||||||||||||
($2,000,000) |
|
|
|
|
|||||||||||||||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash conversion cycle | 40 | 35 | 33 |
| Days inventory outstanding | 57 | 54 | 50 |
| Days payable outstanding | 53 | 55 | 49 |
| Days sales outstanding | 36 | 36 | 31 |
| Risk ratios | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current ratio | 1.25 | 1.16 | 1.43 |
| Acid test | 0.07 | 0.06 | 0.28 |
| Acid test (liberal) | 0.67 | 0.64 | 0.88 |
| Debt to equity ratio (Adjusted) | 0.89 | 1.33 | 1.11 |
| Interest coverage ratio (Adjusted) | 11.93 | 23.57 | 17.79 |
| Fixed charges coverage ratio (Adjusted) | 1.25 | 1.77 | 1.25 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $15,527,537 | $15,010,781 | $14,278,944 |
| Expenses | $15,177,527 | $14,569,135 | $14,051,005 |
| Net income | $395,615 | $503,471 | $273,792 |
| Earnings before interest and taxes (EBIT) | $521,713 | $747,865 | $393,895 |
| Adjusted EBIT | $752,691 | $962,247 | $576,135 |
| Free cash flow to firm | $188,874 | $659,377 | $627,916 |
| Free cash flow to equity | ($211,837) | $248,814 | $281,117 |
| Operating lease expense and debt conversion in (Thousands) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Current year | $538,055 | $502,955 | $428,343 |
| Year one | $475,328 | $457,567 | $380,428 |
| Year two | $410,297 | $409,740 | $345,622 |
| Year three | $340,740 | $370,647 | $320,577 |
| Year four | $293,672 | $334,418 | $298,442 |
| Post year four | $1,187,547 | $2,383,357 | $2,030,193 |
| Total | $3,245,639 | $4,458,684 | $3,803,605 |
| Debt value | $2,149,540 | $2,885,734 | $2,461,025 |
| Depreciation | $307,077 | $288,573 | $246,103 |
Past growth rates |
|||||||||||||
20 % 15 % 10 % 5 % |
|
|
|
|
|||||||||
-5 % -10 % -15 % -20 % -25 % |
|
|
|
||||||||||
| all | 2 years | ||||||||||||
Cashflow in (Thousands) |
|||||||||||||||||||||
$1,000,000 $800,000 $600,000 $400,000 $200,000 |
|
|
|
|
|
||||||||||||||||
($200,000) ($400,000) |
|
|
|
|
|||||||||||||||||
| 2005 | 2006 | 2007 | |||||||||||||||||||
| ( values in Thousands ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| + R&D investment | |||
| + Working capital investment | $380,228 | ($58,072) | |
| + Fixed Capital investment | $460,571 | $343,415 | $260,773 |
| + Acquisitions | $48,036 | $248,319 | |
| - R&D amortized | |||
| - Fixed capital depreciation | $281,383 | $279,005 | $268,098 |
| - Operating lease depreciation | $307,077 | $288,573 | $246,103 |
| = Reinvested | $300,375 | ($33,916) | ($253,428) |
| ( values in Thousands ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Adjusted EBIT | $752,691 | $962,247 | $576,135 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $489,249 | $625,460 | $374,488 |
| Reinvestment expense (gain) | $300,375 | ($33,916) | ($253,428) |
| Free cash flow to firm (FCFF) | $188,874 | $659,377 | $627,916 |
| past reinvestment rates | 2 years | all |
|---|---|---|
| Reinvestment | 27.99 % | -3.90 % |
| Working capital investment | 34.22 % | 22.81 % |
| R&D investment | 0.00 % | 0.00 % |
| Acquisitions | 24.76 % | 16.51 % |
| Net capital investments | 74.52 % | 72.89 % |
| Past growth rates | 2 years | all |
|---|---|---|
| EBIT (adjusted) | -24.44 % | 11.56 % |
| Profit | -23.99 % | 15.58 % |
| Revenue | 3.38 % | 4.18 % |
| ( values in Thousands ) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Cash and equivalent | $222,954 | $173,552 | $703,197 |
| Short term investments | $200 | ||
| Accounts receivable | $1,511,681 | $1,480,316 | $1,232,107 |
| Inventory | $1,717,662 | $1,539,685 | $1,360,274 |
| Deferred taxes | $120,162 | $131,977 | $136,998 |
| Prepaid expenses | $143,255 | $116,931 | $97,286 |
| Other assets | |||
| Total assets | $3,715,714 | $3,442,461 | $3,530,062 |
| Accounts payable | $1,591,154 | $1,561,784 | $1,324,198 |
| Debt payments | $207,996 | $48,130 | $47,270 |
| Accrued Expenses | $1,170,775 | $1,224,565 | $979,796 |
| Tax payable | $3,491 | $135,448 | $117,487 |
| Other liabilities | |||
| Total liabilities | $2,973,416 | $2,969,927 | $2,468,751 |
| Working capital | $742,298 | $472,534 | $1,061,311 |
| Non cash working capital | $727,340 | $347,112 | $405,184 |
| Investment in working capital | $380,228 | ($58,072) |
| Earnings in (Thousands) | 2007 | 2006 | 2005 |
|---|---|---|---|
| Revenue | $15,527,537 | $15,010,781 | $14,278,944 |
| Expenses | $15,177,527 | $14,569,135 | $14,051,005 |
| Net income | $395,615 | $503,471 | $273,792 |
| Earnings before interest and taxes (EBIT) | $521,713 | $747,865 | $393,895 |
| Adjusted EBIT | $752,691 | $962,247 | $576,135 |
| Free cash flow to firm | $188,874 | $659,377 | $627,916 |
| Free cash flow to equity | ($211,837) | $248,814 | $281,117 |
| Adjusted debt | $2,757,002 | $3,456,486 | $3,030,123 |
| Adjusted equity | $3,083,844 | $2,597,447 | $2,739,221 |
| Adjusted depreciation | $588,460 | $567,578 | $514,201 |
| Total reinvestment | $300,375 | ($33,916) | ($253,428) |
| Adjusted EBIT | $752,691 | $962,247 | $576,135 |
| Adjusted EBIT(1 - t) | $489,249 | $625,460 | $374,488 |
| FCFF | $188,874 | $659,377 | $627,916 |
| FCFE | ($211,837) | $248,814 | $281,117 |
| Cash conversion cycle | 40 | 35 | 33 |
| Days inventory outstanding | 57 | 54 | 50 |
| Days payable outstanding | 53 | 55 | 49 |
| Days sales outstanding | 36 | 36 | 31 |
| Acid test | 0.07 | 0.06 | 0.28 |
| liberal acid test | 0.67 | 0.64 | 0.88 |
| Current ratio | 1.25 | 1.16 | 1.43 |
| Fixed charges coverage ratio | 0.87 | 1.38 | 0.85 |
| Interest coverage ratio | 8.27 | 18.32 | 12.16 |
|   | |||
| Current Assets | |||
| Cash and equivalent | $222,954 | $173,552 | $703,197 |
| Short term investments | $200 | ||
| Accounts receivable | $1,511,681 | $1,480,316 | $1,232,107 |
| Inventory | $1,717,662 | $1,539,685 | $1,360,274 |
| Deferred taxes | $120,162 | $131,977 | $136,998 |
| Prepaid expenses | $143,255 | $116,931 | $97,286 |
| Other assets | |||
| Total assets | $3,715,714 | $3,442,461 | $3,530,062 |
|   | |||
| Current Liabilities | |||
| Accounts payable | $1,591,154 | $1,561,784 | $1,324,198 |
| Debt payments | $207,996 | $48,130 | $47,270 |
| Accrued Expenses | $1,170,775 | $1,224,565 | $979,796 |
| Tax payable | $3,491 | $135,448 | $117,487 |
| Other liabilities | |||
| Total liabilities | $2,973,416 | $2,969,927 | $2,468,751 |
| Working capital | $742,298 | $472,534 | $1,061,311 |
| Non cash working capital | $727,340 | $347,112 | $405,184 |
| Investment in working capital | $380,228 | ($58,072) | |