Questions 14 are based on Walmarts 2019 Annual Report, under Consolidated Financial Statement and the Notes to the Consolidated Financial Statements. Data in Excel can be downloaded from Walmarts Investor Relations website. Please submit answers in Excel. Question 1: Calculate the following financial ratios for Walmart for the two years of data provided. Please use an average for the respective balance sheet line items; e.g., equity, assets.

1. Operating profit margin

2. Net profit margin

3. EBITDA

4. EBIT

5. Sales/accounts receivables

6. Days sales outstanding

7. COGS/inventory

8. Days inventory held

9. Sales/PPE 1

10. . Accounts payable turnover

11. Days accounts payables

12. Working capital

13. ROA

14. Current ratio

15. Operating income/interest expense

16. Asset turnover ratio

17. Total liabilities/total assets

18. Total liabilities/shareholders equity

19. ROE

20. Cash conversion cycle in days and in dollar value.