Walmart Financial Statements Trends

WMT -- USA Stock  

USD 95.10  0.18  0.19%

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.

Walmart Balance Sheet

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

Walmart Income Statement

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

Walmart Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(12.8 B)(10.8 B)(11.4 B)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals289.4 M246 M(199.9 M)
Increasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals1.3 B1.1 B1.2 B
Increasing
Slightly volatile
Net Cash Flow from Financing(19 B)(16.1 B)(12.7 B)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities (3.7 B)(3.2 B)(651.1 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares(4.8 B)(4.1 B)(5.5 B)
Increasing
Stable
Payment of Dividends and Other Cash Distributions (7.4 B)(6.3 B)(5.2 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(12.6 B)(10.7 B)(11.6 B)
Decreasing
Stable
Net Cash Flow from Operations17.3 B27.4 B23.7 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (1.2 B)(1 B)(480.5 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(505.9 M)(430 M)156.4 M
Decreasing
Slightly volatile
Depreciation Amortization and Accretion11.1 B9.5 B8.2 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share5.38824.584.3132
Increasing
Slightly volatile
Earnings per Diluted Share1.754.573.9975
Increasing
Stable
Earnings per Basic Share USD5.38824.584.3132
Increasing
Slightly volatile
Dividends per Basic Common Share2.30591.961.5472
Increasing
Slightly volatile
Return on Average Equity0.07610.1860.1996
Decreasing
Slightly volatile
Return on Average Assets0.06730.0730.0789
Decreasing
Slightly volatile
Return on Invested Capital0.17530.1490.1674
Decreasing
Slightly volatile
Gross Margin0.29530.2510.2521
Increasing
Slightly volatile
Profit Margin0.01020.030.0315
Decreasing
Slightly volatile
EBITDA Margin0.08120.0690.0741
Decreasing
Stable
Return on Sales0.05760.0490.0554
Decreasing
Slightly volatile
Asset Turnover2.82122.3982.4213
Increasing
Slightly volatile
Payout Ratio0.50350.4280.3515
Increasing
Slightly volatile
Enterprise Value over EBITDA9.12597.7578.9618
Decreasing
Slightly volatile
Enterprise Value over EBIT11.764710.011.3971
Decreasing
Slightly volatile
Price to Earnings Ratio54.8614.48919.9157
Increasing
Stable
Sales per Share177150130
Increasing
Slightly volatile
Price to Sales Ratio0.550.4410.5568
Decreasing
Slightly volatile
Price to Book Value3.972.6383.39
Decreasing
Slightly volatile
Debt to Equity Ratio73.31.447.4803
Increasing
Slightly volatile
Dividend Yield0.03530.030.0239
Increasing
Slightly volatile
Current Ratio0.930.9320.9128
Increasing
Very volatile
Free Cash Flow per Share5.415.163.9481
Increasing
Slightly volatile
Book Value per Share29.9425.44921.7606
Increasing
Slightly volatile
Tangible Assets Book Value per Share67.981257.78450.2118
Increasing
Slightly volatile
Total Assets Per Share74.257263.118656.886
Increasing
Slightly volatile
Cash Flow Per Share10.19058.66197.6228
Increasing
Slightly volatile
Return on Investment21.618718.375920.633
Decreasing
Slightly volatile
Operating Margin6.44.99975.66
Decreasing
Slightly volatile
Calculated Tax Rate35.656230.307832.2933
Decreasing
Stable
Receivables Turnover91.47177.750487.4215
Decreasing
Slightly volatile
Inventory Turnover9.47868.05688.4806
Decreasing
Very volatile
PPandE Turnover5.05424.29614.3082
Increasing
Slightly volatile
Cash and Equivalents Turnover63.588854.050458.3355
Increasing
Very volatile
Accounts Payable Turnover14.752512.539613.0601
Decreasing
Very volatile
Accrued Expenses Turnover28.148823.926523.5583
Increasing
Slightly volatile
Interest Coverage11.49539.77111.7603
Decreasing
Slightly volatile
Long Term Debt to Equity0.64310.54660.5658
Increasing
Stable
Quick Ratio0.26070.22160.2169
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets(2.5819)(2.1946)(3.2506)
Increasing
Slightly volatile
Revenue to Assets2.8422.41572.4112
Increasing
Slightly volatile

Walmart Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax25 B21.3 B21.8 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA32.6 B33.3 B31.9 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD39.1 B33.3 B32.4 B
Increasing
Slightly volatile
Market Capitalization280.9 B212.5 B227.8 B
Increasing
Stable
Enterprise Value318 B257.9 B271.6 B
Increasing
Slightly volatile
Invested Capital191.9 B163.1 B150.5 B
Increasing
Slightly volatile
Average Equity92.8 B78.9 B71 B
Increasing
Slightly volatile
Average Assets236.5 B201 B186.6 B
Increasing
Slightly volatile
Invested Capital Average187.5 B159.4 B147.7 B
Increasing
Slightly volatile
Tangible Asset Value215.2 B182.9 B169.3 B
Increasing
Slightly volatile
Free Cash Flow19.5 B16.5 B13.6 B
Increasing
Slightly volatile
Working Capital(4.4 B)(4.4 B)(5.6 B)
Increasing
Very volatile
Revenue Per Employee257.8 K219.2 K211.6 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  

Walmart Fundamental Drivers

Walmart Fundamental Market Drivers

Short Percent Of Float1.53%
Forward Price Earnings19.94
Shares Short Prior Month28.3M
Average Daily Volume Last 10 Day6.17M
Average Daily Volume In Three Month7.49M
Fifty Day Average94.45
Two Hundred Day Average88.13

Walmart 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 Insider Screener module to find insiders across different sectors to evaluate their impact on performance.
Search macroaxis.com