Chat with us, powered by LiveChat Homework - STUDENT SOLUTION USA

Walmarts  Annual Reports:  https://stock.walmart.com/investors/financial-information/annual-reports-and-proxies/default.aspx 

Targets Annual Reports: https://investors.target.com/annual-reports

Note:  We are only obtaining the data for 2010 2019.  Targets latest report is not available as of  this document. 

Instructions:

Using the Annual Reports from the above URLs

Enter your Financial Statement Data into your workbook for years 2010-2019.

Part 1: Calculate Profit Margin, Total Asset Turnover, Equity Multiplier, and Return on Equity for each year and each company. Display your results in a summary table.

Part 2: Calculate the average, maximum and minimum values of each financial ratio for each company. Display your results in a summary table.

Part 3: Using DuPont Analysis, compare and explain the difference between the Return on Equity figures of these companies in 2020. In other words, evaluate the ROE figure and explain the difference through the areas of profitability, asset management, and use of leverage.

Part 4: Prepare a graph displaying the value of Return on Equity over the years, for each company. Include a discussion on the trend.

error: Content is protected !!