| | | | | | . | Cash Flow Drivers Report | | | | | . | ECOLAB INC (ECL) | | | | | . | Years ending December 31, | 31-Dec-2006 | 31-Dec-2005 | 31-Dec-2004 | 31-Dec-2003 | . | | | | | | . | | | | | | . | Core Operating Cash Flow | | | | | . | Core operating cash flow | 1,066 | 687 | 832 | 705 | . | Core operating cash flow growth rate | 55.12% | -17.41% | 18.12% | NM | . | | | | | | . | Cash Flow Drivers | | | | | . | Operating cushion: | | | | | . | Revenue from core operations | 4,896 | 4,535 | 4,185 | 3,762 | . | Cost of revenue (excl. depreciation & amortization) | 2,172 | 2,015 | 1,806 | 1,637 | . | Gross margin (excl. depreciation and amortization) | 2,723 | 2,519 | 2,379 | 2,125 | . | Selling, general and administrative expense (excl. depreciation & amortization) | 1,733 | 1,613 | 1,532 | 1,359 | . | Research and development expense | 73 | 68 | 61 | 53 | . | Operating cushion | 917 | 838 | 786 | 713 | . | Operating working capital: | | | | | . | Operating receivables | 868 | 744 | 738 | 626 | . | Deferred revenue | | | | |
|
| | | | | | . | Inventory | 365 | 326 | 339 | 310 | . | Operating payables | 331 | 278 | 270 | 212 | . | Capitalized operating expenses | | | | | . | Prepaids | 492 | 523 | 512 | 469 | . | Accruals | 1,232 | 1,003 | 1,160 | 987 | . | Operating working capital | 161 | 311 | 160 | 206 | . | | | | | | . | | | | | | . | | | | | | . | | | | | | . | Operating cushion %: | | | | | . | Gross margin (excl. depreciation and amortization) % | 55.63% | 55.56% | 56.85% | 56.49% | . | SG&A (excl. depreciation and amortization) % | 35.41% | 35.56% | 36.60% | 36.13% | . | R&D % | 1.50% | 1.51% | 1.47% | 1.41% | . | Operating cushion % | 18.72% | 18.49% | 18.78% | 18.94% | . | Operating working capital to revenue % | | | | | . | Operating receivables to revenue % | 17.72% | 16.40% | 17.64% | 16.64% | . | Deferred revenue to revenue % | | | | | . | Inventory (incl. capitalized interest) to revenue % | 7.45% | 7.18% | 8.09% | 8.24% | . | Operating payables to revenue % | 6.76% | 6.12% | 6.44% | 5.64% |
|
| | | | | | . | Capitalized operating expenses to revenue % | | | | | . | Prepaids to revenue % | 10.04% | 11.52% | 12.24% | 12.48% | . | Accruals to revenue % | 25.17% | 22.12% | 27.71% | 26.23% | . | Operating working capital to revenue % | 3.29% | 6.86% | 3.82% | 5.49% | . | | | | | | . | Operating working capital measured in revenue days (Cash cycle): | | | | | . | Operating receivables days | 64.68 | 59.84 | 64.39 | 60.74 | . | Deferred revenue days | | | | | . | Inventory days | 27.20 | 26.20 | 29.53 | 30.07 | . | Operating payables days | 24.67 | 22.35 | 23.51 | 20.60 | . | Capitalized operating expenses days | | | | | . | Prepaids days | 36.65 | 42.07 | 44.69 | 45.55 | . | Accruals days | 91.85 | 80.74 | 101.16 | 95.74 | . | Cash cycle | 12.01 | 25.03 | 13.95 | 20.03 | . | | | | | | . | Cash-Flow Impacts | | | | | . | Cash Impacts On Operating Cushion | | | | | . | Cash impacts on gross margin (excl. depreciation and amortization): | | | | | . | Growth | 201 | 199 | 239 | 203 | . | Change in GM % | 3 | -59 | 15 | -10 |
|
| | | | | | . | Change in gross margin (excl. depreciation and amortization) | 204 | 140 | 254 | 194 | . | Cash impacts on SG&A (excl. depreciation and amortization): | | | | | . | Growth | -128 | -128 | -153 | -128 | . | Change in SG&A % | 8 | 47 | -20 | -15 | . | Change in SG&A expense (excl. depreciation and amortization) | -121 | -81 | -173 | -143 | . | Cash impacts on research and development: | | | | | . | Growth | -5 | -5 | -6 | -5 | . | Change in R&D % | 1 | -2 | -2 | 2 | . | Change in research and development expense | -5 | -7 | -8 | -3 | . | Cash impacts on operating cushion: | | | | | . | Growth | 67 | 66 | 80 | 70 | . | Change in operating cushion % | 11 | -13 | -7 | -23 | . | Change in operating cushion | 78 | 53 | 73 | 47 | . | | | | | | . | Cash Impacts On Operating Working Capital | | | | | . | Cash impacts on operating receivables: | | | | | . | Growth | -59 | -62 | -70 | -58 | . | Change in receivables days | -65 | 56 | -42 | -15 | . | Change in operating receivables on balance sheet | -124 | -5 | -112 | -73 | . | Provision for doubtful receivables incl. in SG&A | | | | |
|
| | | | | | . | Change in operating receivables on cash flow analysis statement | -124 | -5 | -112 | -73 | . | Cash impacts on deferred revenue: | | | | | . | Growth | | | | 39 | . | Change in deferred revenue days | | | | -412 | . | Change in deferred revenue | | | | -373 | . | Cash impacts on inventory: | | | | | . | Growth | -26 | -28 | -35 | -31 | . | Change in inventory days | -13 | 41 | 6 | 12 | . | Change in inventory on balance sheet | -39 | 13 | -29 | -18 | . | Interest capitalized to inventory | | | | | . | Provision for impairment of inventory incl. in cost of revenue | | | | | . | Change in inventory on cash flow analysis statement | -39 | 13 | -29 | -18 | . | Cash impacts on operating payables: | | | | | . | Growth | 22 | 23 | 24 | 22 | . | Change in payables days | 31 | -14 | 33 | -15 | . | Change in operating payables | 53 | 8 | 57 | 7 | . | Cash impacts on capitalized operating expenses: | | | | | . | Growth | | | | | . | Change in capitalized operating expenses days | | | | | . | Change in capitalized operating expenses | | | | |
|
| | | | | | . | Cash impacts on prepaids: | | | | | . | Growth | -42 | -43 | -53 | -44 | . | Change in prepaids days | 73 | 33 | 10 | -5 | . | Change in prepaids | 31 | -10 | -43 | -50 | . | Cash impacts on accruals: | | | | | . | Growth | 80 | 97 | 111 | 51 | . | Change in accruals days | 149 | -254 | 62 | 447 | . | Change in accruals | 229 | -157 | 173 | 499 | . | Cash impacts on operating working capital: | | | | | . | Growth | -25 | -13 | -23 | -21 | . | Change in operating working capital days | 175 | -138 | 70 | 13 | . | Change in operating working capital | 150 | -151 | 46 | -8 | . | | | | | | . | Cash Flow Drivers | | | | | . | Total Interest Paid | | | | | . | Interest expense | -51 | -50 | -48 | -49 | . | Interest capitalized to PP&E | | | | | . | Interest capitalized to inventory | | | | | . | Total interest incurred | -51 | -50 | -48 | -49 | . | Change in interest payable | | | | |
|
| | | | | | . | Change in capitalized debt-issue costs | | | | | . | Interest paid with common stock | | | | | . | Total interest paid | -51 | -50 | -48 | -49 | . | Interest expense as % of average borrowings | 5.66% | 6.88% | 7.05% | 7.18% | . | Total interest paid as % of average borrowings | 5.66% | 6.88% | 7.05% | 7.18% | . | Cash flow available for debt service to total interest paid | 16.81 | 12.29 | 12.79 | 11.85 | . | | | | | | . | Total interest paid | -51 | -50 | -48 | -49 | . | Required principal payments on long-term debt and capital lease obligations | -80 | -5 | -4 | -13 | . | Total debt service requirements | -132 | -55 | -52 | -62 | . | Cash flow available for debt service to total debt service requirements | 6.56 | 11.14 | 11.83 | 9.36 | . | | | | | | . | Interest-bearing borrowings: | | | | | . | Commercial paper and financing-related notes payable | 109 | 147 | 51 | 66 | . | Current portion, long-term debt | 400 | 80 | 5 | 4 | . | Noncurrent portion, long-term debt | 557 | 519 | 645 | 604 | . | Current portion, capital lease obligations | | | | | . | Noncurrent portion, capital lease obligation | | | | | . | Noncurrent financing-related notes payable | | | | | . | Other financing-related current liabilities | | | | |
|
| | | | | | . | Other financing-related noncurrent liabilities and other financial services liabilities | | | | | . | Noncurrent subordinated and convertible debt | | | | | . | Interest-bearing borrowings | 1,066 | 746 | 702 | 675 | . | Average interest-bearing borrowings | 906 | 724 | 688 | 687 | . | | | | | | . | Cash Flow Available for Investment | | | | | . | Sustainable operating cash flow | 811 | 562 | 572 | 535 | . | Dividends - preferred | | | | | . | Cash flow available for investment | 811 | 562 | 572 | 535 | . | Cash flow available for investment growth rate | 44.31% | -1.66% | 6.76% | NM | . | | | | | | . | Sustainable Free Cash Flow | | | | | . | Cash flow available for investment | 811 | 562 | 572 | 535 | . | Capital expenditures | -385 | -258 | -345 | -286 | . | Investment in notes receivable | | | | | . | Investment in other net financial services assets | | | | | . | Investment in operations-related intangibles | -21 | 26 | -25 | -15 | . | Investment in other operations-related assets | | | | | . | Investment to support operations | -405 | -232 | -371 | -301 | . | Sustainable free cash flow | 406 | 331 | 201 | 234 |
|
| | | | | | . | Sustainable free cash flow growth rate | 22.72% | 64.44% | -14.10% | NM | . | | | | | | . | Cash Flow Drivers | | | | | . | Capital Expenditures | | | | | . | Capital expenditures: | | | | | . | Change in property, plant and equipment, net | -116 | -1 | -98 | -57 | . | Depreciation and amortization incl. in cost of revenue | -244 | -233 | -226 | -208 | . | Depreciation and amortization incl. in SG&A | -25 | -24 | -22 | -21 | . | Amortization expense on acquisition-related intangibles | | | | | . | Impairment charge - PP&E | | | | | . | Gain (loss) on disposal of PP&E | | | | | . | Interest capitalized to PP&E | | | | | . | Proceeds from sale and operating leaseback transactions | | | | | . | Capital expenditures | -385 | -258 | -345 | -286 | . | As % of cash flow available for investment | 47.42% | 45.85% | 60.41% | 53.45% | . | Capital expenditures to depreciation on property, plant and equipment | 1.43 | 1.00 | 1.40 | 1.25 | . | Capital expenditures equivalent of (additions) to operating leases | -56 | -86 | -39 | -34 | . | Capital expenditures cash-flow profile: | | | | | . | Capital expenditures to revenue % | 7.86% | 5.68% | 8.25% | 7.61% | . | | | | | |
|
| | | | | | . | Cash impact on capital expenditures: | | | | | . | Cash impact of growth on capex | -21 | -29 | -32 | NM | . | Cash impact of chgs in capex to revenue % on capex | -106 | 116 | -27 | NM | . | Cash impact of growth and chgs in capex to revenue % on capex | -127 | 88 | -59 | NM | . | | | | | | . | Investment in Notes Receivable | | | | | . | Investment in notes receivable: | | | | | . | Current other notes receivable | | | | | . | Noncurrent other notes receivable | | | | | . | Notes receivable | | | | | . | Investment in notes receivable | | | | | . | As % of cash flow available for investment | | | | | . | | | | | | . | Investment in other net financial services assets | | | | | . | Investment in other net financial services assets: | | | | | . | Other financial services assets | | | | | . | Other financial services liabilities | | | | | . | Other net financial services assets | | | | | . | Investment in other net financial services assets | | | | | . | As % of cash flow available for investment | | | | |
|
| | | | | | . | | | | | | . | Investment in Operations-Related Intangibles | | | | | . | Investment in operations-related intangibles: | | | | | . | Operations-related intangibles | 224 | 203 | 229 | 204 | . | Investment in operations-related intangibles | -21 | 26 | -25 | -15 | . | As % of cash flow available for investment | 2.57% | -4.65% | 4.42% | 2.84% | . | | | | | | . | Investment in operations-related intangibles cash-flow profile: | | | | | . | Investment in operations-related intangibles to revenue % | 0.43% | -0.58% | 0.60% | 0.40% | . | | | | | | . | Cash impact on investment in operations-related intangibles: | | | | | . | Cash impact of growth on investment in ops-related intangibles | 2 | -2 | -2 | NM | . | Cash impact of chgs in investment in ops-related intangibles to revenue % | -49 | 54 | -8 | NM | . | Cash impact of growth and chgs in investment in ops-related intangibles to revenue % | -47 | 51 | -10 | NM | . | | | | | | . | Investment in Other Operations-Related Assets | | | | | . | Investment in other operations-related assets: | | | | | . | Other operations-related current assets | | | | | . | Other operations-related noncurrent assets | | | | | . | Other operations-related assets | | | | |
|
| | | | | | . | Investment in other operations-related assets | | | | | . | As % of cash flow available for investment | | | | | . | | | | | | . | Investment in other ops-related assets cash-flow profile: | | | | | . | Investment in other ops-related assets to revenue % | | | | | . | | | | | | . | Cash impact on investment in other ops-related assets: | | | | | . | Cash impact of growth on investment in other ops-related assets | | | | NM | . | Cash impact of chgs in investment in other ops-related assets to revenue | | | | NM | . | Cash impact of growth and chgs in investment in other ops-related assets to revenue | | | | NM | . | Capital expenditures and investment to revenue % | 8.28% | 5.11% | 8.85% | 8.01% | . | | | | | | . | Impact of acquisitions and other transactions on cash flow: | | | | | . | Reported cash paid for acquisitions | | | 130 | | . | Calculated to reported change in receivables | 1.86 | 0.12 | 2.38 | 13.13 | . | Calculated to reported change in inventory | 2.19 | 5.10 | 5.23 | 6.36 | . | Calculated to reported change in payables and accruals | 6.34 | -7.83 | 6.61 | -37.92 | . | Calculated to reported capital expenditures | 1.30 | 1.04 | 1.34 | 1.41 | . | | | | | |
|