Question

In: Finance

Working on the key finances for Walmart for a project for my bachelors. What are Walmart's...

Working on the key finances for Walmart for a project for my bachelors. What are Walmart's financial statements for the last 5 years (please include picture of statements and where you found it from)? What are their following ratios: working capital, quick, operating margin, EBITDA? Are there any other important ratios to focus on? Please include where this data can be found.

Solutions

Expert Solution

Walmart Inc, is listed in New York Stock exchange. The financials are available in the Investor relations page in their corporate website.

Below are the financail statements for the last 5 years (FY 2016- FY 2020)

Source: walmart.com

Ratios & Other important information from Financial statements -

1) Working Capital -

$ in million

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Current Assets          61,806          61,897          59,664        57,689        60,239
Current Liabilities          77,790          77,477          78,521        66,928        64,619
Working Capital        -15,984        -15,580        -18,857        -9,239        -4,380

2) Operating Margin -

$ in million

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Operating Income          20,568          21,957          20,437        22,764        24,105
Turnover 519,926 510,329 495,761 481,317 478,614
Operating margin 3.96% 4.30% 4.12% 4.73% 5.04%

3) EBITDA -

(Interest & Tax can be found out in the Income statement. Depreciation & Amortization is available in the Cashflow statement).  

$ in million

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Net income          15,201            7,179          10,523        14,293        15,080
Interest            2,410            2,129            2,178          2,267          2,467
Tax            4,915            4,281            4,600          6,204          6,558
Depreciation & Amortization          10,987          10,678          10,529        10,080          9,454
EBITDA         33,513         24,267         27,830        32,844        33,559

4) Current Ratio

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Current Assets - $ in million          61,806          61,897          59,664        57,689        60,239
Current Liabilities - $ in million          77,790          77,477          78,521        66,928        64,619
Current Ratio              0.79              0.80              0.76            0.86            0.93

5) Quick Ratio

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Current Assets - $ in million          61,806          61,897          59,664        57,689        60,239
Inventories - $ in million          44,435          44,269          43,783        43,046        44,469
Current Liabilities - $ in million          77,790          77,477          78,521        66,928        64,619
Quick Ratio              0.22              0.23              0.20            0.22            0.24

6) Debt to Equity Ratio

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Total Liabilities - $ in million 154,943 139,661 123,700 118,290 115,970
Share holder's equity - $ in million 81,552 79,634 80,822 80,535 83,611
Debt to Equity              1.90              1.75              1.53            1.47            1.39

7) Return on Equity

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Net Income - $ in million          15,201            7,179          10,523        14,293        15,080
Share holder's equity - $ in million          81,552          79,634          80,822        80,535        83,611
Return on Equity              0.19              0.09              0.13            0.18            0.18

8) Debt to EBITDA

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Total Liabilities - $ in million 154,943 139,661 123,700 118,290 115,970
EBITDA - $ in million          33,513          24,267          27,830        32,844        33,559
Debt to EBITDA              4.62              5.76              4.44            3.60            3.46

9) Net Margin

$ in million

Particulars FY 2020 FY 2019 FY 2018 FY 2017 FY 2016
Net Income          15,201            7,179          10,523        14,293        15,080
Turnover 519,926 510,329 495,761 481,317 478,614
Net Margin 2.92% 1.41% 2.12% 2.97% 3.15%

Related Solutions

Working on the key finances for Walmart for a project for my bachelors. What are Walmart's...
Working on the key finances for Walmart for a project for my bachelors. What are Walmart's financial statements for the last 5 years? What are their following ratios: working capital, quick, operating margin, EBITDA? Are there any other important ratios to focus on?
Im working on a project proposal. The proposal is for a walmart in my state. The...
Im working on a project proposal. The proposal is for a walmart in my state. The schedules is made and soely created by the store manager which leads to many erros and a lot of ppl not getting scheduled or getting scheduled at the wrong times. The proposal is to get a group of assistant managers and have them come together for sixty minutes a week to make a week’s worth of schedules. Each manager will be assigned an department...
What are Walmart's organization’s management practices? How and why is Walmart succeeding or failed as a...
What are Walmart's organization’s management practices? How and why is Walmart succeeding or failed as a result of its management?
Walmart- Case Questions 1) Consider the history of Walmart. Is Walmart's success best described as an...
Walmart- Case Questions 1) Consider the history of Walmart. Is Walmart's success best described as an intended or emergent strategy? 2) Evaluate changes in Walmart's general environment (e.g., PESTEL analysis) to identify trends that represent both opportunities and challenges. What trends are most important for Walmart's future? 3) Evaluate the competitive forces for the retail industry to identify the forces controlling its profitability (e.g., five forces analysis). Is Walmart positioned for long term profitability? What changes can Walmart make to...
Walmart Industry Analysis: Conditions, climate, and competition of Walmart's industry and segment.
Walmart Industry Analysis: Conditions, climate, and competition of Walmart's industry and segment.
Walmart company research project. what is the Walmart company technology plan ?
Walmart company research project. what is the Walmart company technology plan ?
Walmart company research project. what is Walmart management and organizations ? explain.
Walmart company research project. what is Walmart management and organizations ? explain.
Walmart has been open all long the Pandemic 1- Look up Walmart's corporate numbers. What are...
Walmart has been open all long the Pandemic 1- Look up Walmart's corporate numbers. What are were the sales, revenues, earning for the last quarter? 2- What are some critics about Walmart's ability to protect its employees from the Pandemic? 3- Is Target experiencing the same challenges as Walmart?
Walmart company research project. what is the Walmart financial statement ? research on this topic .
Walmart company research project. what is the Walmart financial statement ? research on this topic .
Walmart's competitor at Canada level and international level . example Costco vs Walmart at Canada level...
Walmart's competitor at Canada level and international level . example Costco vs Walmart at Canada level . international level any other example . how Walmart is better than them and what are challenges of competitors Walmart is facing . must includes all these points with sub heading (800 words minimum )
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT