cells in yellow MUST be a formula. please give the formula/cells used
D E F Jan. 31, 2017 0 0 0 0 $6,867 5,835 43,046 1,941 57,689 0 0 0 0 179,492 (71,782) 107,710 A B 1 Walmart Balance Sheet Verticle Analysis 2 Consolidated Balance Sheets - USD ($) Jan. 31, 2018 3 Current assets: 4 Cash and cash equivalents $ 6,756 5 Receivables, net 5,614 6 Inventories 43,783 7 Prepaid expenses and other 3,511 8 Total current assets 59,664 9 Property and equipment: 10 Property and equipment 185,154 11 Less accumulated depreciation (77,479) 12 Property and equipment, net 107,675 13 Property under capital lease and 14 Property under capital lease and 12,703 15 Less accumulated amortization (5,560) 16 Property under capital lease and 7,143 17 Goodwill 18,242 18 Other assets and deferred charges 11,798 19 Total assets 204,522 20 Current liabilities: 21 Short-term borrowings 5,257 22 Accounts payable 46,092 23 Accrued liabilities 22,122 24 Accrued income taxes 645 25 Long-term debt due within one year 3,738 26 Capital lease and financing obligations 667 27 Total current liabilities 78,521 28 Long-term debt 30,045 29 Long-term capital lease and financing 6,780 30 Deferred income taxes and other 8,354 0 0 0 0 11,637 (5,169) 6,468 17,037 9,921 198,825 0 OOOOOOOOOO 1,099 41,433 20,654 921 2,256 565 66,928 36,015 6,003 9,344 B D E F 30,045 6,780 8,354 0 0 0 36,015 6,003 9,344 A 28 Long-term debt 29 Long-term capital lease and financing 30 Deferred income taxes and other 31 Commitments and contingencies 32 Equity: 33 Common stock 34 Capital in excess of par value 35 Retained earnings 36 Accumulated other comprehensive loss 37 Total Walmart shareholders' equity 38 Noncontrolling interest 39 Total equity 40 Total liabilities and equity 41 42 295 2,648 85,107 (10,181) 77,869 2,953 80,822 $ 204,522 OOOOOOOO 305 2,371 89,354 (14,232) 77,798 2,737 80,535 $ 198,825 0