*** Please provide excel spreadsheet to show calculations and


Question Description:

35

*** Please provide excel spreadsheet to show calculations and explanations as necessary to explain the results. Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please “cut and paste” your solutions into the Word or PDF file. Be sure to show how you did your calculations. Also, please be sure to include your name at the top of the first page of your file. Part 1 Perform a vertical and horizontal analysis of Wal-Mart Stores, Inc.’s income statements and balance sheets as of January 31, 2015. In performing this analysis, consider any notable trends or changes that you observe that may provide useful information concerning its financial condition. Also use as many years’ worth of statements as you feel necessary. You should write up your results in paragraph form. Part 2 Assess Wal-Mart, Stores Inc. concerning liquidity, solvency, profitability, and stock performance as of January 31, 2015. For each area, you should calculate the ratios we discussed in class and provide an analysis of the ratios calculated. I include historical stock price information and outstanding common share information below. Fiscal Year Ended 1/31/2015 1/31/2014 1/31/2013 1/31/2012 Adjusted Closing Price $83.94 $71.97 $65.79 $56.32 Common Shares Outstanding (millions) 3,228 3,233 3,314 3,418 Guyana83
posted a question · Feb 09, 2016 at 7:18pm

Answer

35