Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In excel show formula's for each line item of how Statement of cash flow was created? Consolidated Statements of Cash Flows - USD ($) $

In excel show formula's for each line item of how Statement of cash flow was created?

Consolidated Statements of Cash Flows - USD ($) $ in Thousands 12 Months Ended
Dec. 31, 2019 Dec. 31, 2018 Dec. 31, 2017
Cash flows from operating activities
Net income (loss) $ 92,139 $ (46,302) $ (48,260)
Adjustments to reconcile net income (loss) to net cash provided by operating activities
Depreciation and amortization 186,425 181,768 173,747
Unrealized foreign currency exchange rate gain (loss) (2,073) 14,023 (29,247)
Impairment charges 39,000 9,893 71,378
Amortization of bond premium 254 254 254
Loss on disposal of property and equipment 4,640 4,256 2,313
Stock-based compensation 49,618 41,783 39,932
Excess tax benefit (loss) from stock-based compensation arrangements 0 0 (75)
Deferred income taxes 38,132 (38,544) 55,910
Changes in reserves and allowances (26,096) (234,998) 108,757
Changes in operating assets and liabilities:
Accounts receivable (45,450) 186,834 (79,106)
Inventories 149,519 109,919 (222,391)
Prepaid expenses and other assets 24,334 (107,855) (52,106)
Other non-current assets 19,966 0 0
Accounts payable 59,458 26,413 145,695
Accrued expenses and other liabilities (18,987) 134,594 109,823
Customer refund liability (80,710) 305,141 0
Income taxes payable and receivable 18,862 41,051 (39,164)
Net cash provided by operating activities 509,031 628,230 237,460
Cash flows from investing activities
Purchases of property and equipment (145,802) (170,385) (281,339)
Sale of property and equipment 0 11,285 0
Purchase of equity method investment 0 (39,207) 0
Purchases of other assets (1,311) (4,597) (1,648)
Net cash (used in) provided by investing activities (147,113) (202,904) (282,987)
Cash flows from financing activities
Proceeds from long term debt and revolving credit facility 25,000 505,000 763,000
Payments on long term debt and revolving credit facility (162,817) (695,000) (665,000)
Employee taxes paid for shares withheld for income taxes (4,235) (2,743) (2,781)
Proceeds from exercise of stock options and other stock issuances 7,472 2,580 11,540
Other financing fees 63 306 0
Payments of debt financing costs (2,553) (11) 0
Net cash used in financing activities (137,070) (189,868) 106,759
Effect of exchange rate changes on cash, cash equivalents and restricted cash 5,100 12,467 4,178
Net increase in cash, cash equivalents and restricted cash 229,948 247,925 65,410
Cash, cash equivalents and restricted cash
Beginning of period 566,060 318,135 252,725
End of period 796,008 566,060 318,135
Non-cash investing and financing activities
Change in accrual for property and equipment (8,084) (14,611) 10,580
Other supplemental information
Cash paid (received) for income taxes, net of refunds 23,352 (16,738) 36,921
Cash paid for interest, net of capitalized interest $ 18,031 $ 28,586 $ 29,750

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Business Mathematics with Canadian Applications

Authors: S. A. Hummelbrunner, Kelly Halliday, Ali R. Hassanlou, K. Suzanne Coombs

11th edition

134141083, 978-0134141084

More Books

Students also viewed these Finance questions