Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started