In: Finance
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.
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% |