Create common size statement of Cash flows using information provided. Please show work and show excel equations for each line item. What new information do i need to complete

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