In excel show formula's for each line item of how the Balance sheet was created? What information do i need to complete

Consolidated Balance Sheets - USD ($) $ in Thousands	Dec. 31, 2019	Dec. 31, 2018
Current assets
Cash and cash equivalents	$ 788,072	$ 557,403
Accounts receivable, net	708,714	652,546
Inventories	892,258	1,019,496
Prepaid expenses and other current assets	313,165	364,183
Total current assets	2,702,209	2,593,628
Property and equipment, net	792,148	826,868
Operating lease right-of-use assets	591,931
Goodwill	550,178	546,494
Intangible assets, net	36,345	41,793
Deferred income taxes	82,379	112,420
Other long term assets	88,341	123,819
Total assets	4,843,531	4,245,022
Current liabilities
Accounts payable	618,194	560,884
Accrued expenses	374,694	340,415
Customer refund liabilities	219,424	301,421
Operating lease liabilities	125,900
Current maturities of long term debt	0	25,000
Other current liabilities	83,797	88,257
Total current liabilities	1,422,009	1,315,977
Long term debt, net of current maturities	592,687	703,834
Operating lease liabilities, non-current	580,635
Other long term liabilities	98,113	208,340
Total liabilities	2,693,444	2,228,151
Commitments and contingencies (see Note 8)
Stockholders equity
Additional paid-in capital	973,717	916,628
Retained earnings	1,226,986	1,139,082
Accumulated other comprehensive loss	(50,765)	(38,987)
Total stockholders equity	2,150,087	2,016,871
Total liabilities and stockholders equity	4,843,531	4,245,022
Class A Common Stock
Stockholders equity
Common stock issued	62	62
Class B Convertible Common Stock
Stockholders equity
Common stock issued	11	11
Class C Common Stock
Stockholders equity
Common stock issued	$ 76	$ 75