Green cells are what is needed. GREATLY appreciated if you help with the excel formulas that I should be using. will upvote if logical with formulas ans correct

A D 1 2018 68,619 46,185 22,434 2019 71,309 48,394 22,915 B Lowe's Companies Inc. 2 2017 3 Revenue 65,017 4 Cost of goods sold 43,343 5 Gross profit 21,674 6 Accounts receivable 7 Inventory 10,458 8 Accounts payable 6,651 9 10 1. Gross profit margin 11 GP margin= Gross profit / Revenue 33.3% 12 132. Days inventory outstanding (DIO) 14 Average inventory 15 DIO = 365/(COGS / Average inventory) 11,393 6,590 12,561 8,279 32.7% 32.1% #DIV/0! #DIV/0! 16 17 3. Days payables outstanding (DPO) 18 Average accounts payable 19 DPO = 365/(COGS / Average payables) 20 21 4. Cash effect (caused by the change in Cash conversion cycle) 22 Change in cash conversion cycle (CCC), 2019 23 Average daily COGS = COGS/365 Cash effect= Change in CCC x Average daily 24 COGS (0.20)