put into excel sheet and finish the missing numbers

m: 24971 (2) Sales cogs int. expense net income Avg inventory Av fixed Assets Ang total assets 51 nd: 98 108203 82853 72913 6083 1051 56800 11,121 ausio (195) ) 1098 . ROA for each macys: 5.721 home depot: 25.2731. gamestop:-19.657"). CO9S: Macys: 16177 home acpot:: 12913 inventory tumover: Fixed Asset turnover: game stop: 6083 Describe the likely reasons for the ditrerences In the profit margins for ROA and assets tumover (2) 13 (Million) M GS sales 24971 82853 Net income (1035) 1420 753108 Interest expense ( (54.80) Net income 1098 673 current Assets 7445 3127.7 total assets 19194 4044.3 Current liabilities 5232 21811 Long tem debt 4708 411.6 Total liabilities 12,758 2708.1 Retained earnings BOSO 1BB4213627 Sharchouders equity 1336.2 cash flow operations 1735 3251 manket price per share $1.51 $3.60 MN ios Gomestop Ratios Current Rand 1.423 current rato: to 1.43 oper. CashADW 33.16 oper. cashflow: 25.25 Liab to Assets 66.47 Llab to Assets: 68.20 Long term to Lt cap: 0.42 Long term to tap :0.40 oper. cf to total lia 13.60 oper. (F to forallia: 11.40 Altman's 7-score: mauys = 3.5 game hop=2.85 Bankrupture Manys: Initia'lmy Covid -19 almost made them file for bankrupty but sales have increased & the stock price is at pre-pandemi numbers. Gamestop: I believe they would have filed bankruptuy had the stock price soanng to over 4008 a share this past month. the debt has been restructured since . . Differences Similianties: maus - Clothing, nousehold, toys daily things lote) they are both retail stores that are both well known game stop: Video game store Both were headed towards bankrupt. gaming accessones + Systems 3 2014 2015 2014 2017 2018 2019 sales N/A 27079 25908 24939 24971 24560 Ni N/A 1070 619 1555 1098 564 Net cash N/A 2028 8 1311 1864 1738 970 TA N/A 20576 2008219583 19194 2112 For each year:r 2015(5.2.1.) 1. ROA: 2010 (3.082.) 2011(1.94-1.) 2018 (5.721.) and 2019 (2.6641 2. PM: 2015 (39.79) 2014 (39.02) 2011(91.91) 2018(42.28) 2019 (42.01) 3. AT: 201311.32) 2016(1.29) 2017(1.27) 2018 (1.30) 2019(1.16) 4. PIO+? 13p45) 5. Plot =? (3pts) 6. Driving changes in ROA: ROA decreased compared to previous year due to a decrease In net income . Three main parts: - operating ach Vities - Thresting achines -Financing activities phase in Mays: - Devine blc het income has dropped meaning the sales are dropping 61% the originai need and want have giminshed or Jomething else beter opened. But, also believe it could be at matunty due to spille in sales. Plot net cash flow 2pts. 3 causes for concern: - Net cash used by investing achyities has increased over double sinte 2019 Net income has decreased by a little under double since 2019. Restruthing, impairment and store cloring have increded since 2019. . . m: 24971 (2) Sales cogs int. expense net income Avg inventory Av fixed Assets Ang total assets 51 nd: 98 108203 82853 72913 6083 1051 56800 11,121 ausio (195) ) 1098 . ROA for each macys: 5.721 home depot: 25.2731. gamestop:-19.657"). CO9S: Macys: 16177 home acpot:: 12913 inventory tumover: Fixed Asset turnover: game stop: 6083 Describe the likely reasons for the ditrerences In the profit margins for ROA and assets tumover (2) 13 (Million) M GS sales 24971 82853 Net income (1035) 1420 753108 Interest expense ( (54.80) Net income 1098 673 current Assets 7445 3127.7 total assets 19194 4044.3 Current liabilities 5232 21811 Long tem debt 4708 411.6 Total liabilities 12,758 2708.1 Retained earnings BOSO 1BB4213627 Sharchouders equity 1336.2 cash flow operations 1735 3251 manket price per share $1.51 $3.60 MN ios Gomestop Ratios Current Rand 1.423 current rato: to 1.43 oper. CashADW 33.16 oper. cashflow: 25.25 Liab to Assets 66.47 Llab to Assets: 68.20 Long term to Lt cap: 0.42 Long term to tap :0.40 oper. cf to total lia 13.60 oper. (F to forallia: 11.40 Altman's 7-score: mauys = 3.5 game hop=2.85 Bankrupture Manys: Initia'lmy Covid -19 almost made them file for bankrupty but sales have increased & the stock price is at pre-pandemi numbers. Gamestop: I believe they would have filed bankruptuy had the stock price soanng to over 4008 a share this past month. the debt has been restructured since . . Differences Similianties: maus - Clothing, nousehold, toys daily things lote) they are both retail stores that are both well known game stop: Video game store Both were headed towards bankrupt. gaming accessones + Systems 3 2014 2015 2014 2017 2018 2019 sales N/A 27079 25908 24939 24971 24560 Ni N/A 1070 619 1555 1098 564 Net cash N/A 2028 8 1311 1864 1738 970 TA N/A 20576 2008219583 19194 2112 For each year:r 2015(5.2.1.) 1. ROA: 2010 (3.082.) 2011(1.94-1.) 2018 (5.721.) and 2019 (2.6641 2. PM: 2015 (39.79) 2014 (39.02) 2011(91.91) 2018(42.28) 2019 (42.01) 3. AT: 201311.32) 2016(1.29) 2017(1.27) 2018 (1.30) 2019(1.16) 4. PIO+? 13p45) 5. Plot =? (3pts) 6. Driving changes in ROA: ROA decreased compared to previous year due to a decrease In net income . Three main parts: - operating ach Vities - Thresting achines -Financing activities phase in Mays: - Devine blc het income has dropped meaning the sales are dropping 61% the originai need and want have giminshed or Jomething else beter opened. But, also believe it could be at matunty due to spille in sales. Plot net cash flow 2pts. 3 causes for concern: - Net cash used by investing achyities has increased over double sinte 2019 Net income has decreased by a little under double since 2019. Restruthing, impairment and store cloring have increded since 2019