Walmart Financial Statements Trends

WMT -- USA Stock  

USD 83.41  0.29  0.35%

This module enables investors to look at Walmart various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Consolidated Income of 17.7 B, Cost of Revenue of 424.7 B or Earning Before Interest and Taxes EBIT of 28 B, but also many exotic indicators such as Interest Coverage of 11.4953, Long Term Debt to Equity of 0.6431 or Calculated Tax Rate of 35.6562. This module is a perfect complement to use when analyzing Walmart Valuation or Volatility. It can also complement various Walmart Technical models. See also analysis of Walmart Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(13.6 B)(11.6 B)(4.6 B)
Decreasing
Slightly volatile
Total Assets199.6 B199.6 B181.9 B
Increasing
Slightly volatile
Current Assets60.2 B60.2 B54.2 B
Increasing
Slightly volatile
Assets Non Current163.9 B139.3 B129.5 B
Increasing
Slightly volatile
Cash and Equivalents7.9 B8.7 B7.3 B
Increasing
Slightly volatile
Cash and Equivalents USD10.2 B8.7 B7.5 B
Increasing
Slightly volatile
Total Debt46.6 B50 B47 B
Increasing
Slightly volatile
Debt Current7.1 B6 B7.4 B
Increasing
Very volatile
Debt Non Current51.8 B44 B40.6 B
Increasing
Slightly volatile
Total Debt USD58.9 B50 B47.9 B
Increasing
Slightly volatile
Shareholders Equity94.8 B80.5 B72.7 B
Increasing
Slightly volatile
Shareholders Equity USD94.8 B80.5 B72.7 B
Increasing
Slightly volatile
Goodwill and Intangible Assets19.6 B16.7 B17 B
Increasing
Slightly volatile
Inventory52.3 B44.5 B40.1 B
Increasing
Slightly volatile
Total Liabilities136.4 B116 B108.9 B
Increasing
Slightly volatile
Current Liabilities64.6 B64.6 B60.2 B
Increasing
Slightly volatile
Liabilities Non Current60.4 B51.4 B47.8 B
Increasing
Slightly volatile
Trade and Non Trade Payables45.3 B38.5 B34.6 B
Increasing
Slightly volatile
Property Plant and Equipment Net137.1 B116.5 B107.6 B
Increasing
Slightly volatile
Trade and Non Trade Receivables6.6 B5.6 B5.3 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit105.9 B90 B74.3 B
Increasing
Slightly volatile
Tax Liabilities9.2 B7.8 B7.6 B
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income17.7 B15.1 B15.1 B
Increasing
Slightly volatile
Cost of Revenue424.7 B361 B329.6 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT28 B23.8 B24 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD28 B23.8 B24 B
Increasing
Slightly volatile
Gross Profit127 B121.1 B108.3 B
Increasing
Slightly volatile
Interest Expense3 B2.5 B2.3 B
Increasing
Slightly volatile
Net Income9 B14.7 B14 B
Increasing
Stable
Net Income Common Stock17.3 B14.7 B14.6 B
Increasing
Slightly volatile
Net Income Common Stock USD17.3 B14.7 B14.6 B
Increasing
Slightly volatile
Net Income from Discontinued Operations(335.3 M)(285 M)(216.3 M)
Decreasing
Stable
Net Income to Non Controlling Interests454.1 M386 M547.9 M
Decreasing
Stable
Operating Expenses114.2 B97 B85.3 B
Increasing
Slightly volatile
Operating Income28.4 B24.1 B24.2 B
Increasing
Slightly volatile
Revenues505.5 B482.1 B434.3 B
Increasing
Slightly volatile
Revenues USD567.2 B482.1 B439.1 B
Increasing
Slightly volatile
Selling General and Administrative Expense114.2 B97 B85.3 B
Increasing
Slightly volatile
Weighted Average Shares3 B3.2 B3.5 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted3.8 B3.2 B3.6 B
Decreasing
Slightly volatile
Income Tax Expense7.7 B6.6 B7.1 B
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(12.8 B)(10.8 B)(11.6 B)
Decreasing
Stable
Depreciation Amortization and Accretion11.1 B9.5 B8.1 B
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(505.9 M)(430 M)(24.7 M)
Decreasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals289.4 M246 M(307.2 M)
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(4.8 B)(4.1 B)(5.6 B)
Increasing
Stable
Issuance Repayment of Debt Securities (3.7 B)(3.2 B)(256.6 M)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (7.4 B)(6.3 B)(5.1 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(19 B)(16.1 B)(12.3 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(12.6 B)(10.7 B)(11.9 B)
Increasing
Very volatile
Net Cash Flow Investment Acquisitions and Disposals1.3 B1.1 B1.1 B
Increasing
Slightly volatile
Net Cash Flow from Operations16.3 B27.4 B23.4 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (1.2 B)(1 B)(424.2 M)
Decreasing
Slightly volatile
Cash Beginning of Year10.7 B9.1 B7.9 B
Increasing
Slightly volatile
Cash End of Year10.2 B8.7 B7.9 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover2.82122.3982.4159
Increasing
Slightly volatile
Book Value per Share29.9425.44921.3329
Increasing
Slightly volatile
Current Ratio0.730.9320.8904
Decreasing
Stable
Debt to Equity Ratio59.51.445.9611
Increasing
Slightly volatile
Share Dilution Ratio1.17981.00281.0169
Increasing
Slightly volatile
Dividend Yield0.03530.030.0234
Increasing
Slightly volatile
Dividends per Basic Common Share2.30591.961.4958
Increasing
Slightly volatile
EBITDA Margin0.08120.0690.0741
Decreasing
Stable
Earnings per Basic Share5.38824.584.2222
Increasing
Slightly volatile
Earnings per Diluted Share3.04.574.0269
Increasing
Slightly volatile
EPS Diluted Growth(0.0482)(0.041)0.0491
Decreasing
Slightly volatile
EPS Growth(0.0528)(0.0449)0.0486
Decreasing
Slightly volatile
Earnings per Basic Share USD5.38824.584.2222
Increasing
Slightly volatile
Enterprise Value over EBIT11.764710.011.3665
Decreasing
Slightly volatile
Enterprise Value over EBITDA9.12597.7578.9465
Decreasing
Slightly volatile
Free Cash Flow per Share2.675.163.5596
Increasing
Slightly volatile
Gross Margin0.29530.2510.2516
Increasing
Slightly volatile
Financial Leverage1.05850.89970.9307
Increasing
Very volatile
Leverage Ratio3.00512.55432.6502
Increasing
Slightly volatile
NCFO Growth0.12470.1060.086
Decreasing
Very volatile
Net Income Growth(0.0552)(0.0469)0.0253
Decreasing
Slightly volatile
Profit Margin0.01770.030.0323
Decreasing
Slightly volatile
Payout Ratio0.50350.4280.3461
Increasing
Slightly volatile
Price to Book Value3.272.6383.3173
Decreasing
Slightly volatile
Price to Earnings Ratio27.9614.48917.5615
Decreasing
Stable
Price to Sales Ratio0.490.4410.5515
Decreasing
Slightly volatile
Revenue Growth6.0E-45.0E-40.0302
Decreasing
Slightly volatile
Return on Average Assets0.06850.0730.079
Decreasing
Slightly volatile
Return on Average Equity0.12490.1860.2037
Decreasing
Slightly volatile
Return on Invested Capital0.17530.1490.1677
Decreasing
Slightly volatile
Return on Sales0.05760.0490.0556
Decreasing
Slightly volatile
Weighted Average Share Growth(0.0069)(0.0059)(0.0222)
Increasing
Slightly volatile
Sales per Share177150127
Increasing
Slightly volatile
Tax Efficiency0.78980.67130.6752
Increasing
Slightly volatile
Tangible Assets Book Value per Share67.981257.78449.1971
Increasing
Slightly volatile
Total Assets Per Share74.257263.118655.676
Increasing
Slightly volatile
Cash Flow Per Share10.19058.66197.4305
Increasing
Slightly volatile
Return on Investment21.618718.375920.6583
Decreasing
Slightly volatile
Operating Margin6.494.99975.6782
Decreasing
Slightly volatile
Calculated Tax Rate35.656230.307832.44
Decreasing
Slightly volatile
Receivables Turnover91.47177.750489.6707
Decreasing
Slightly volatile
Inventory Turnover9.47868.05688.4683
Decreasing
Very volatile
PPandE Turnover5.05424.29614.3019
Increasing
Slightly volatile
Cash and Equivalents Turnover63.588854.050458.3511
Increasing
Stable
Accounts Payable Turnover14.752512.539613.0523
Decreasing
Very volatile
Accrued Expenses Turnover28.148823.926523.5562
Increasing
Slightly volatile
Interest Coverage11.49539.77111.7967
Decreasing
Slightly volatile
Long Term Debt to Equity0.64310.54660.562
Increasing
Slightly volatile
Quick Ratio0.26070.22160.2123
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets(2.5819)(2.1946)(3.5119)
Increasing
Slightly volatile
Revenue to Assets2.8422.41572.4039
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets236.5 B201 B184.5 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA32.8 B33.3 B31.6 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD39.1 B33.3 B32.1 B
Increasing
Slightly volatile
Earnings before Tax25 B21.3 B21.7 B
Increasing
Slightly volatile
Average Equity92.8 B78.9 B70.4 B
Increasing
Slightly volatile
Enterprise Value286.9 B257.9 B267.2 B
Increasing
Slightly volatile
Free Cash Flow19.5 B16.5 B13 B
Increasing
Slightly volatile
Invested Capital191.9 B163.1 B148.7 B
Increasing
Slightly volatile
Invested Capital Average187.5 B159.4 B146.1 B
Increasing
Slightly volatile
Market Capitalization247.2 B212.5 B223.3 B
Increasing
Stable
Tangible Asset Value215.2 B182.9 B167.6 B
Increasing
Slightly volatile
Working Capital(4.4 B)(4.4 B)(5.9 B)
Increasing
Stable
Revenue Per Employee257.8 K219.2 K209.2 K
Increasing
Slightly volatile
Net Income Per Employee7.9 K6.7 K7 K
Increasing
Slightly volatile

Thematic Opportunities

Explore Investment Opportunities
Build portfolios using Macroaxis predefined set of investing ideas. Many of Macroaxis investing ideas can easily outperform a given market. Ideas can also be optimized per your risk profile before portfolio origination is invoked.
Explore Thematic Ideas
Explore Investing Ideas  

Upcoming Events

Walmart Upcoming Company Events
Upcoming Quarterly ReportMay 18, 2017
Next Earnings ReportAugust 17, 2017
See also analysis of Walmart Correlation with competitors. Please also try Pair Correlation module to compare performance and examine historical correlation between any two equity instruments.