WMT US Equity 96 Actions - 97) Export - 98 Settings Financial Analysis 31 ADJ Walmart Inc ASC 842 Periods 10 Annuals . Cur FRC (USD). A Key Stats I/S B/S C/F Ratios Segments ) Addl ESG Custom 10 Profitability 12 Growth 13 Credit 14 Credit Ex Operating Leases 19 Liquidity 1 Working Capital L7) Yield Analysis In Millions of USD except Per Share 2011 Y 2012 Y 2013 Y 2014 Y 2015 Y 2016 Y 12 Months Ending 01/31/2011 01/31/2012 01/31/2013 01/31/2014 01/31/2015 01/31/2016 Returns Return on Common Equity 23.58 22.45 23.02 21.00 20.76 18.15 L. Return on Assets 9.33 8.39 8.57 7.86 8.02 7.29 Return on Capital 15.76 14.85 15.46 14.00 14.25 12.89 Ll Return on Invested Capital 13.96 13.90 14.30 12.98 13.33 12.50 25.34 7.87 24.82 7.50 5.64 24.83 7.48 5.59 Margins W Gross Margin L EBITDA Margin Lil Operating Margin Incremental Operating Margin Pretax Margin Income before XD Margin Net Income Margin Ll Net Income to Common Margin 24.98 7.75 5.93 3.85 5.45 3.67 3.52 3.52 11.19 5.58 3.78 3.89 24.83 7.72 5.92 5.57 5.48 3.78 3.63 3.63 25.13 6.96 5.00 -86.40 4.49 5.18 3.47 3.36 3.36 3.13 5.11 3.46 3.37 3.37 3.89 3.05 3.05 Additional Effective Tax Rate 32.20 32.57 31.01 32.87 32.20 Il Dvd Payout Ratio 28.90 32.13 31.63 38.42 38.47 Ll Sustainable Growth Rate 16.77 15.24 15.74 12.93 12.77 > >> This period is the first to include accounting standard changes for operating leases 30.31 42.83 10.37 SM 69 S 1 14646082 -2020 16.0022 |Analyze the following ratios over the past 5 years. (return on assets, current ratio, ick ratio, long-term debt/assets, accounts receivable turnover, days sales outstanding, inventory turnover, days inventory outstanding) Write an analysis using the above ratios regarding the company's financial health. Discuss each ratio and what it indicates within the company. Which ratio trends have been improving? Which ones have deteriorated