Earnings in (Thousands) |
|||||||||||||||||||||||||||||||||||||||||||||||||
$60,000,000 $50,000,000 $40,000,000 $30,000,000 $20,000,000 $10,000,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
||||||||||||||||||||||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||||||||||||||||||||
| Values in days | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Cash conversion cycle | 43 | 40 | 36 | 33 | 51 |
| Days inventory outstanding | 54 | 53 | 51 | 53 | 52 |
| Days payable outstanding | 51 | 50 | 55 | 63 | 67 |
| Days sales outstanding | 41 | 37 | 40 | 43 | 65 |
| Risk ratios | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Current ratio | 1.50 | 1.62 | 1.63 | 1.51 | 1.36 |
| Acid test | 0.14 | 0.27 | 0.36 | 0.30 | 0.26 |
| Acid test (liberal) | 0.95 | 1.05 | 1.13 | 1.04 | 0.94 |
| Debt to equity ratio (Adjusted) | 0.36 | 0.45 | 0.57 | 0.00 | 1.37 |
| Interest coverage ratio (Adjusted) | 9.89 | 10.23 | 11.41 | 7.16 | 4.33 |
| Fixed charges coverage ratio (Adjusted) | 7.08 | 7.27 | 8.54 | 7.16 | 3.38 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Revenue | $53,513,000 | $49,124,000 | $46,307,000 | $40,161,000 |
| Expenses | $52,202,000 | $46,681,000 | $43,649,000 | $38,509,000 |
| Net income | $2,887,000 | $3,724,000 | $4,515,000 | $2,797,000 |
| Earnings before interest and taxes (EBIT) | $4,715,000 | $5,495,000 | $6,999,000 | $4,421,000 |
| Adjusted EBIT | $5,773,789 | $6,300,537 | $8,011,595 | $5,344,900 |
| Free cash flow to firm | $1,499,174 | $2,877,812 | $3,666,942 | $3,454,285 |
| Free cash flow to equity | $1,461,000 | $3,238,000 | $3,731,000 | $3,701,000 |
| Operating lease expense and debt conversion in (Thousands) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Current year | $231,000 | $251,000 | $236,000 | |
| Year one | $200,000 | $208,000 | $179,000 | |
| Year two | $171,000 | $179,000 | $156,000 | |
| Year three | $117,000 | $137,000 | $136,000 | |
| Year four | $93,000 | $85,000 | $109,000 | |
| Post year four | $441,000 | $565,000 | $319,000 | |
| Total | $1,253,000 | $1,425,000 | $1,135,000 | |
| Debt value | $771,480 | $874,038 | $696,630 | |
| Depreciation | $110,211 | $124,863 | $116,105 |
Past growth rates |
|||||||||||||||||
15 % 10 % 5 % |
|
|
|
|
|
||||||||||||
-5 % -10 % -15 % -20 % -25 % -30 % |
|
|
|
|
|||||||||||||
| all | 3 years | 2 years | |||||||||||||||
Cashflow in (Thousands) |
|||||||||||||||||||||||||||||||
$9,000,000 $8,000,000 $7,000,000 $6,000,000 $5,000,000 $4,000,000 $3,000,000 $2,000,000 $1,000,000 |
|
|
|
|
|
|
|
||||||||||||||||||||||||
|
|
|
|
|
|
|
||||||||||||||||||||||||||
| 2003 | 2004 | 2005 | 2006 | 2007 | |||||||||||||||||||||||||||
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| + R&D investment | $1,362,000 | $1,164,000 | $1,073,000 | $1,022,000 |
| + Working capital investment | $1,398,000 | $785,000 | $1,266,000 | $1,035,000 |
| + Fixed Capital investment | $2,075,000 | $1,775,000 | $1,597,000 | |
| + Acquisitions | $143,000 | $149,000 | ||
| - R&D amortized | $424,000 | $307,600 | $200,300 | $98,100 |
| - Fixed capital depreciation | $2,190,000 | $2,074,000 | $2,079,000 | $2,088,000 |
| - Operating lease depreciation | $110,211 | $124,863 | $116,105 | |
| = Reinvested | $2,253,789 | $1,217,537 | $1,540,595 | $19,900 |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Adjusted EBIT | $5,773,789 | $6,300,537 | $8,011,595 | $5,344,900 |
| Marginal tax rate | 35.00 % | 35.00 % | 35.00 % | 35.00 % |
| Adjusted EBIT(1 - t) | $3,752,963 | $4,095,349 | $5,207,537 | $3,474,185 |
| Reinvestment expense (gain) | $2,253,789 | $1,217,537 | $1,540,595 | $19,900 |
| Free cash flow to firm (FCFF) | $1,499,174 | $2,877,812 | $3,666,942 | $3,454,285 |
| past reinvestment rates | 2 years | 3 years | all |
|---|---|---|---|
| Reinvestment | 44.89 % | 39.79 % | 24.62 % |
| Working capital investment | 28.21 % | 26.91 % | 22.10 % |
| R&D investment | 32.36 % | 28.44 % | 31.37 % |
| Acquisitions | 1.91 % | 1.27 % | 1.71 % |
| Net capital investments | 49.32 % | 43.10 % | 35.30 % |
| Past growth rates | 2 years | 3 years | all |
|---|---|---|---|
| EBIT (adjusted) | -8.73 % | -16.71 % | 9.19 % |
| Profit | -25.32 % | -21.95 % | 10.35 % |
| Revenue | 8.55 % | 7.26 % | 11.44 % |
| ( values in Thousands ) | 2007 | 2006 | 2005 | 2004 |
|---|---|---|---|---|
| Cash and equivalent | $1,736,000 | $2,757,000 | $3,806,000 | $3,108,000 |
| Short term investments | $1,000 | $153,000 | $32,000 | $84,000 |
| Accounts receivable | $5,944,000 | $4,988,000 | $5,124,000 | $4,753,000 |
| Inventory | $6,885,000 | $6,058,000 | $5,319,000 | $4,957,000 |
| Deferred taxes | $348,000 | $193,000 | $321,000 | $384,000 |
| Prepaid expenses | ||||
| Other assets | $3,740,000 | $3,060,000 | $2,802,000 | $2,604,000 |
| Total assets | $18,654,000 | $17,209,000 | $17,404,000 | $15,890,000 |
| Accounts payable | $6,536,000 | $5,674,000 | $5,760,000 | $5,895,000 |
| Debt payments | $2,134,000 | $1,510,000 | $1,520,000 | $965,000 |
| Accrued Expenses | $418,000 | $382,000 | $347,000 | $342,000 |
| Tax payable | $728,000 | $569,000 | $493,000 | $419,000 |
| Other liabilities | $2,629,000 | $2,466,000 | $2,543,000 | $2,885,000 |
| Total liabilities | $12,445,000 | $10,601,000 | $10,663,000 | $10,506,000 |
| Working capital | $6,209,000 | $6,608,000 | $6,741,000 | $5,384,000 |
| Non cash working capital | $6,606,000 | $5,208,000 | $4,423,000 | $3,157,000 |
| Investment in working capital | $1,398,000 | $785,000 | $1,266,000 | $1,035,000 |
| Earnings in (Thousands) | 2007 | 2006 | 2005 | 2004 | 2003 |
|---|---|---|---|---|---|
| Revenue | $53,513,000 | $49,124,000 | $46,307,000 | $40,161,000 | $32,632,000 |
| Expenses | $52,202,000 | $46,681,000 | $43,649,000 | $38,509,000 | $31,462,000 |
| Net income | $2,887,000 | $3,724,000 | $4,515,000 | $2,797,000 | $1,730,000 |
| Earnings before interest and taxes (EBIT) | $4,715,000 | $5,495,000 | $6,999,000 | $4,421,000 | $2,476,000 |
| Adjusted EBIT | $5,773,789 | $6,300,537 | $8,011,595 | $5,344,900 | $3,584,759 |
| Free cash flow to firm | $1,499,174 | $2,877,812 | $3,666,942 | $3,454,285 | $2,256,335 |
| Free cash flow to equity | $1,461,000 | $3,238,000 | $3,731,000 | $3,701,000 | $2,523,000 |
| Adjusted debt | $8,352,480 | $8,910,038 | $9,882,630 | $12,562,690 | |
| Adjusted equity | $23,023,000 | $19,842,600 | $17,228,900 | $13,251,000 | $9,175,000 |
| Adjusted depreciation | $2,724,211 | $2,506,463 | $2,395,405 | $2,186,100 | $2,017,241 |
| Total reinvestment | $2,253,789 | $1,217,537 | $1,540,595 | $19,900 | $73,759 |
| Adjusted EBIT | $5,773,789 | $6,300,537 | $8,011,595 | $5,344,900 | $3,584,759 |
| Adjusted EBIT(1 - t) | $3,752,963 | $4,095,349 | $5,207,537 | $3,474,185 | $2,330,093 |
| FCFF | $1,499,174 | $2,877,812 | $3,666,942 | $3,454,285 | $2,256,335 |
| FCFE | $1,461,000 | $3,238,000 | $3,731,000 | $3,701,000 | $2,523,000 |
| Cash conversion cycle | 43 | 40 | 36 | 33 | 51 |
| Days inventory outstanding | 54 | 53 | 51 | 53 | 52 |
| Days payable outstanding | 51 | 50 | 55 | 63 | 67 |
| Days sales outstanding | 41 | 37 | 40 | 43 | 65 |
| Acid test | 0.14 | 0.27 | 0.36 | 0.30 | 0.26 |
| liberal acid test | 0.95 | 1.05 | 1.13 | 1.04 | 0.94 |
| Current ratio | 1.50 | 1.62 | 1.63 | 1.51 | 1.36 |
| Fixed charges coverage ratio | 5.79 | 6.34 | 7.46 | 5.92 | 2.33 |
| Interest coverage ratio | 8.07 | 8.92 | 9.97 | 5.92 | 2.99 |
|   | |||||
| Current Assets | |||||
| Cash and equivalent | $1,736,000 | $2,757,000 | $3,806,000 | $3,108,000 | $2,392,000 |
| Short term investments | $1,000 | $153,000 | $32,000 | $84,000 | $42,000 |
| Accounts receivable | $5,944,000 | $4,988,000 | $5,124,000 | $4,753,000 | $5,820,000 |
| Inventory | $6,885,000 | $6,058,000 | $5,319,000 | $4,957,000 | $4,050,000 |
| Deferred taxes | $348,000 | $193,000 | $321,000 | $384,000 | $698,000 |
| Prepaid expenses | |||||
| Other assets | $3,740,000 | $3,060,000 | $2,802,000 | $2,604,000 | |
| Total assets | $18,654,000 | $17,209,000 | $17,404,000 | $15,890,000 | $13,002,000 |
|   | |||||
| Current Liabilities | |||||
| Accounts payable | $6,536,000 | $5,674,000 | $5,760,000 | $5,895,000 | $5,142,000 |
| Debt payments | $2,134,000 | $1,510,000 | $1,520,000 | $965,000 | $1,088,000 |
| Accrued Expenses | $418,000 | $382,000 | $347,000 | $342,000 | $2,520,000 |
| Tax payable | $728,000 | $569,000 | $493,000 | $419,000 | $212,000 |
| Other liabilities | $2,629,000 | $2,466,000 | $2,543,000 | $2,885,000 | $572,000 |
| Total liabilities | $12,445,000 | $10,601,000 | $10,663,000 | $10,506,000 | $9,534,000 |
| Working capital | $6,209,000 | $6,608,000 | $6,741,000 | $5,384,000 | $3,468,000 |
| Non cash working capital | $6,606,000 | $5,208,000 | $4,423,000 | $3,157,000 | $2,122,000 |
| Investment in working capital | $1,398,000 | $785,000 | $1,266,000 | $1,035,000 | |