caculate WACC use Excel and show how to do it
ACE HARDWARE CORPORATION CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) Years Ended December 31 2016 (52 Weeks)(52 Weeks)(52 Weeks) December 30. 2017 2016 Operating Activities Net income Adjustments to reconcile net income to net cash provided by operating 1474 S 1612 S 1562 Depreciation and amortization Amortization of deferred financing costs Loss on early extinguishment of debt Gain) loss on disposal of assets, net Credit) provision for doubtful accounts Warehouse facility closure costs Other, net 0.5 (0.6) (0.8) (0.8) 0.1 (0.3) Changes in operating assets and liabilities, exclusive of effect of 31.3) (43.7) Other current assets Other long-term assets Accounts payable and accrued expenses Other long-term liabilities Deferred taxes (18.3) (17.8) (3.2) (10.8) (40.4) (9.3) Net cash provided by operating activities 204.2 217.2 119.0 Investing Activities Purchases of marketable securities Proceeds from sale of marketable securities Purchases of property and equipment Cash paid for acquired businesses, net of cash acquired (Increase) decrease in notes receivable, net Other, net (6.5) 64.6) (57.5) (7.3) (70.8) (5.6) Net cash used in investing activities (131.8) 77.6 Financing Activities Net borrowings (payments) under revolving lines of credit Principal payments on long-term debt Payments of deferred financing costs Payments of cash portion of patronage distribution Payments of patronage refund certificates Repurchase of stock Purchase of noncontrolling interests Other, net (56.4) 150.2 (177.0) (9.2) (58.7 (53.7) (48.9) (6.7 (3.9) (5.2) Net cash used in financing activities (134.)(86.4) (18.5) 29.8 Increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental disclosure of cash flow information $ 23.0 Interest paid Income taxes paid See accompanying notes to the consolidated financial statements ACE HARDWARE CORPORATION CONSOLIDATED STATEMENTS OF CASH FLOWS (In millions) Years Ended December 31 2016 (52 Weeks)(52 Weeks)(52 Weeks) December 30. 2017 2016 Operating Activities Net income Adjustments to reconcile net income to net cash provided by operating 1474 S 1612 S 1562 Depreciation and amortization Amortization of deferred financing costs Loss on early extinguishment of debt Gain) loss on disposal of assets, net Credit) provision for doubtful accounts Warehouse facility closure costs Other, net 0.5 (0.6) (0.8) (0.8) 0.1 (0.3) Changes in operating assets and liabilities, exclusive of effect of 31.3) (43.7) Other current assets Other long-term assets Accounts payable and accrued expenses Other long-term liabilities Deferred taxes (18.3) (17.8) (3.2) (10.8) (40.4) (9.3) Net cash provided by operating activities 204.2 217.2 119.0 Investing Activities Purchases of marketable securities Proceeds from sale of marketable securities Purchases of property and equipment Cash paid for acquired businesses, net of cash acquired (Increase) decrease in notes receivable, net Other, net (6.5) 64.6) (57.5) (7.3) (70.8) (5.6) Net cash used in investing activities (131.8) 77.6 Financing Activities Net borrowings (payments) under revolving lines of credit Principal payments on long-term debt Payments of deferred financing costs Payments of cash portion of patronage distribution Payments of patronage refund certificates Repurchase of stock Purchase of noncontrolling interests Other, net (56.4) 150.2 (177.0) (9.2) (58.7 (53.7) (48.9) (6.7 (3.9) (5.2) Net cash used in financing activities (134.)(86.4) (18.5) 29.8 Increase (decrease) in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental disclosure of cash flow information $ 23.0 Interest paid Income taxes paid See accompanying notes to the consolidated financial statements
