Please fill in top section with work included using excel files below. I will rate positive!!
3. Please conduct financial analyses for Costco and three competitors by using the given excel files. Please report your analysis results below. COSTCO Key Financials' For the Fiscal Period Ending 12 months Aug-28- 2016A USD 12 months Sep-03- 2017A USD 12 months Sep-02- 20184 USD 12 months Sep-01- 2019A USD 12 months Feb-16- 2020A USD Currency ROA ROE Revenue Growth Profit Growth Financial Leverage Leverage Growth X X Walmart Key Financials For the Fiscal Period Ending 12 months Jan-31- 2016A USD 12 months Jan-31- 2017A USD 12 months Jan-31- 2018A USD 12 months Jan-31- 2019A USD 12 months Jan-31- 2020A USD Currency ROA ROE Revenue Growth Profit Growth Financial Leverage Leverage Growth X X Amazon Key Financials! For the Fiscal Period Ending 12 months Dec-31- 2015A USD 12 months Dec-31- 2016A USD 12 months Dec-31- 2017A USD 12 months Dec-31- 2018A USD 12 months Dec-31- 2019A USD Currency ROA ROE Revenne Growth Profit Growth Financial Leverage Leverage Growth Kroger Key Financials For the Fiscal Period Ending 12 months Jan-30- 2016A USD 12 months Jan-28- 2017A USD 12 months Feb-03- 2018A USD 12 months Feb-02- 2019A USD 12 months Feb-01- 2020A USD Currency ROA ROE Revenge Growth Profit Growth Financial Leverage Leverage Growth B C D E F 1 2 Costco Wholesale Corporation (NasdaqGS:COST) 3 Key Financials LTM For the Fiscal Period Ending 12 months 12 months Aug-28 Sep-03- 2016A 2017A USD 12 months Sep-02- 2018A USD 12 months Sep-01- 2019A 12 months Feb-16 2020A USD USD USD 118.719,0 2,350.0 129,025.0 2,679,0 141,576.0 3,134.0 ARMA 152.703.0 3,659.0 158,350.0 3,778.0 33.163.0 37 45.400 ART820 15.5640 16.999.00 5 Currency 6 7 Total Revenue 8 Net Income 9 Total Assets 10 Total Equity 11 Total Debt 12 13 14 15 Walmart Inc. (NYSE:WMT) 16 Key Financials: 12.332.0 5.161.0 11.0790 6.659.0 6,577.0 7.244.0 8.775.0 12 months 12 months 12 months Jan-31 Jan-31 Jan-31- 2016A 2017A 2018A USD USD USD 12 months Jan-31- 2019A 12 months Jan-31- 2020A USD USD 500,343.0 For the Fiscal Period Ending 17 18 Currency 19 20 Total Revenue 21 Net Income 22 Total Assets 23 Total Equity 24 Total Debt 482,130.0 14,694.0 514,405.0 6,670.0 9,862.0 192_5810 485,873.0 13,643.0 198 8250 80.535.0 46.588.0 2045220 219 2250 79.6340 523,964.0 14,881.0 23/25 81.5520 73,129,0 80.822.0 50,772.0 46,673.0 58,461.0 B C D E F 12 months Jan-30- 2016A 12 months 12 months Jan-28- Feb-03- 2017A 2018A USD 12 months Feb-02- 2019A USD 12 months Feb-01- 2020A USD USD USD 109,830.0 2,039.0 33. Rez 115,337,0 1,975.0 36.505.0 123,280.0 1,907.0 28 The Kroger Co. (NYSE:KR) 29 Key Financials For the Fiscal Period Ending 30 31 Currency 32 33 Total Revenue 34 Net Income 35 Total Assets 36 Total Equity 37 Total Debt 38 39 40 41 Amazon.com, Inc. (NasdaqGS:AMZN) 42 Key Financials 121,852.0 3,110.0 122,286.0 1,659.0 37197 38.110 45.250 6.905.0 6.798.0 12.108.0 6.710.0 14,085.0 7.835.0 15.229.0 8.573.0 21.1970 15,590.0 For the Fiscal Period Ending 43 44 Currency 12 months Dec-31- 2015A USD 12 months Dec-31- 2016A 12 months Dec-31- 2017A 12 months Dec-31- 2018A 12 months Dec 31- 2019A USD USD USD USD 45 107,006.0 596.0 135,987.0 2,371.0 83.402 46 Total Revenue 47 Net Income 48 Total Assets 49 Total Equity 50 Total Debt 177.866.0 3.033.0 1313100 232,887.0 10,073.0 280,522.0 11,588.0 R4747 162 RARO 225.248.0 13.3840 19 235.0 62.080.0 27.709.0 44, 108.0 43.549.0 34,516.0 17.512.0 20,413.0 77,535.0
