Develop a specific recommendation, with supporting rationale, as to whether Walmart’s recent results in financial performance is of sufficient financial strength, will THE COMPANY be financially sustainable over the next two to three years, and which steps should be done to improve its financial stability? If the management of the company would like to improve the company’s financial performance, what should the management of THE COMPANY do? Your recommendations should be based on the results of the analysis. (About 1 page)
https://www.morningstar.com/stocks/xnys/wmt/quote
Ratio Analysis
Ratio analysis.
Collect the following ratios for your COMPANY for the last 3 years. Present the ratios as the table(s) in your project. Create graphs for some ratios on your choice to show trends.
Walmart Inc (WMT)
Financial Health
2020
2021
2022
Current Ratio
0.79
0.97
0.93
Quick Ratio
0.20
0.26
0.26
Debt/ Equity
0.86
0.72
0.63
Financial Leverage
3.17
3.12
2.94
Walmart Inc (WMT)
Operating and Efficiency
202020212022
Operating performance ratio
Days of Sales in Inventory
41.02
38.81
43.16
Days of Sales Outstanding
4.38
4.18
4.71
Days of Payables Outstanding
43.49
41.73
44.41
Profitability ratios
Gross Profit Margin %
24.69
24.83
25.10
Operating Profit Margin %
3.93
4.03
4.53
Net Profit Margin %
2.84
2.42
2.39
Receivables Turnover
83.39
87.37
77.42
Inventory Turnover
8.90
9.40
8.46
Fixed Assets Turnover
4.39
4.72
5.15
Total Assets Turnover
2.30
2.29
2.30
Return on Investment ratios.
ROA %
6.53
5.53
5.50
ROE %
20.22
17.37
16.66
b) Walmart major competitor.
Amazon.com Inc (AMZN)
202020212022 ROE %
27.44
28.81
-1.92
Net Profit Margin
5.53
7.10
-0.53
Asset Turnover
1.41
1.27
1.16
Financial Leverage
3.44
3.04
3.17
Debt/Equity ratios
0.90
0.84
0.96
Develop a specific recommendation, with supporting rationale, as to whether Walmarts recent results in
financial performance is of sufficient financial strength, will THE COMPANY be financially sustainable
over the next two to three years, and which steps should be done to improve its financial stability? If the
management of the company would like to improve the company’s financial performance, what should
the management of THE COMPANY do? Your recommendations should be based on the results of the
analysis. (About 1 page)
https://www.morningstar.com/stocks/xnys/wmt/quote
Ratio Analysis
Ratio analysis.
a. Collect the following ratios for your COMPANY for the last 3 years. Present the ratios as the
table(s) in your project. Create graphs for some ratios on your choice to show trends.
Current Ratio
Quick Ratio
Debt/ Equity
Financial Leverage
Walmart Inc (WMT)
Financial Health
2020
2021
0.79
0.97
0.20
0.26
0.86
0.72
3.17
3.12
2022
0.93
0.26
0.63
2.94
Operating
performance
ratio
Profitability
ratios
Return on
Investment
ratios.
Walmart Inc (WMT)
Operating and Efficiency
2020
2021
Days of Sales in 41.02
38.81
Inventory
Days of Sales
4.38
4.18
Outstanding
Days of
43.49
41.73
Payables
Outstanding
Gross Profit
24.69
24.83
Margin %
Operating Profit 3.93
4.03
Margin %
Net Profit
2.84
2.42
Margin %
Receivables
83.39
87.37
Turnover
Inventory
8.90
9.40
Turnover
Fixed Assets
4.39
4.72
Turnover
2022
43.16
4.71
44.41
25.10
4.53
2.39
77.42
8.46
5.15
Total Assets
Turnover
2.30
2.29
2.30
ROA %
ROE %
6.53
20.22
5.53
17.37
5.50
16.66
b) Walmart major competitor.
ROE %
Net Profit Margin
Asset Turnover
Financial Leverage
Debt/Equity ratios
Amazon.com Inc (AMZN)
2020
2021
27.44
28.81
5.53
7.10
1.41
1.27
3.44
3.04
0.90
0.84
2022
-1.92
-0.53
1.16
3.17
0.96
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
