CMR 302 Financial Information for Managers

Instructions

Don't forget to review the lesson materials for this section before starting this assignment. For this assignment, you'll access the Yahoo Finance and CSIMarket sites, enter the data in the Financial Analysis Template, and complete the financial analysis prompts. Once you're finished, submit the completed spreadsheet to this assignment page below.

Step 1

1. Download the Ratio Analysis Template spreadsheet
2. Complete the financial analysis of Walmart (WMT) for the two most recent years.

Step 2

1. Navigate tohttps://finance.yahoo.com. and enter WMT in the search or stock symbol field.
2. Select Financials from the menu selections just below the stock price.
3. After accessing a financial statement, click on Expand All at the top right of the statement.

Step 3

In a Word doc, answer and explain the following:

1. Analyze the data (refer to this Sample Analysis) over the most recent two-year period and reference the industry averages in the following areas:
   1. Staying power
   2. Earning power
   3. Overall efficiency ratios
   4. Working capital cycle ratios
2. Navigate to the CSIMarket (https://csimarket.com/index.php). to look up Industry Averages.
3. Enter the stock symbol in the search field.
4. Select the Fundamentals menu bar option.
5. Use the Industry column to retrieve data for all ratios except for Earnings Quality and Accounts Payable turnover.
6. Use trailing twelve-month data (TTM) under the Industry column for all ratios.