Course 8110

Fall 2021

Prof. Don Jones

Group Project Assignment

Project Due Date : November 30. 2021 by 6 pm EST

Email your solution to the questions below with a covering page including your team number and team member names to: djones@uwindsor.ca

Required:

Complete the following tasks for Walmart Inc. for its fiscal year ended January 31, 2021. The financial statements can be found in the annual report at the following location:

https://s2.q4cdn.com/056532643/files/doc_financials/2021/ar/WMT_2021_AnnualReport.pdf

Required:

1.Calculate accounts receivable(net) turnover rate using net sales for the year ended January 31, 2021

2.Calculate the number of days net sales in accounts receivable(net) at January 31, 2021

3.Compute the inventory turnover rate for the year ended January 31, 2021

4.Compute the number of days sales in inventory at January 31, 2021

5.Compute the gross margin percentage on goods sold for the year ended January 31, 2021 and January 31, 2020. Did gross margin percentage Increase or decrease in 2021 compared to 2020 ?

6. Compute the property and equipment(net) turnover rate based on net sales for the year ended January 31, 2021

7. Calculate the current ratio at January 31, 2021 and January 313, 2020. Did liquidity increase or decrease in 2021 compared to 2020 ?

8.Calculate the debt to equity ratio at January 31, 2020.

9.Did consolidated net income attributable to Walmart increase or decrease in 2021 compared to

2020 ? List three major factors in 2021 that affected the companys net income compared to the year ended January 31, 2020.

10.Explain if the cash and cash equivalents and restricted cash balance at January 31, 2021 increased or decreased from January 31, 2020. Explain why, based on the cash flow statement, the change in cash position in the 2021 fiscal year occurred.