Wal Mart Financial Statements Trends

Wal Mart Stores Inc -- USA Stock  

USD 97.48  0.01  0.0103%

This module enables investors to look at Wal Mart 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 16.9 B, Cost of Revenue of 382.1 B or Earning Before Interest and Taxes EBIT of 26.6 B, but also many exotic indicators such as Interest Coverage of 11.2278, Long Term Debt to Equity of 0.5702 or Calculated Tax Rate of 32.8982. This module is a perfect complement to use when analyzing Wal Mart Valuation or Volatility. It can also complement various Wal Mart Technical models. See also analysis of Wal Mart Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(9.9 B)(11.6 B)(3.7 B)
Decreasing
Slightly volatile
Total Assets199.6 B203.5 B180.4 B
Increasing
Slightly volatile
Current Assets60.2 B63.3 B53.7 B
Increasing
Slightly volatile
Assets Non Current147.1 B139.3 B127.3 B
Increasing
Slightly volatile
Cash and Equivalents6.5 B8.7 B7.1 B
Increasing
Slightly volatile
Cash and Equivalents USD9.4 B8.7 B7.3 B
Increasing
Slightly volatile
Total Debt48 B50 B46.9 B
Increasing
Slightly volatile
Debt Current6.7 B6 B7.5 B
Increasing
Very volatile
Debt Non Current46.1 B44 B39.8 B
Increasing
Slightly volatile
Total Debt USD52.7 B50 B47.3 B
Increasing
Slightly volatile
Shareholders Equity85.2 B80.5 B71.3 B
Increasing
Slightly volatile
Shareholders Equity USD85.2 B80.5 B71.3 B
Increasing
Slightly volatile
Goodwill and Intangible Assets18.3 B16.7 B16.9 B
Increasing
Slightly volatile
Inventory47.2 B44.5 B39.3 B
Increasing
Slightly volatile
Total Liabilities122.9 B116 B107.1 B
Increasing
Slightly volatile
Current Liabilities64.6 B65.3 B59.8 B
Increasing
Slightly volatile
Liabilities Non Current54.6 B51.4 B47 B
Increasing
Slightly volatile
Trade and Non Trade Payables40.5 B38.5 B33.9 B
Increasing
Slightly volatile
Property Plant and Equipment Net122.7 B116.5 B105.6 B
Increasing
Slightly volatile
Trade and Non Trade Receivables6.5 B5.6 B5.2 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit92.5 B90 B71.9 B
Increasing
Slightly volatile
Tax Liabilities9.3 B7.8 B7.6 B
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income16.9 B15.1 B15 B
Increasing
Slightly volatile
Cost of Revenue382.1 B361 B323.4 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT26.6 B23.8 B23.9 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD26.6 B23.8 B23.9 B
Increasing
Slightly volatile
Gross Profit124.6 B121.1 B107 B
Increasing
Slightly volatile
Interest Expense2.6 B2.5 B2.3 B
Increasing
Slightly volatile
Net Income12.7 B14.7 B14.2 B
Increasing
Slightly volatile
Net Income Common Stock16.3 B14.7 B14.5 B
Increasing
Slightly volatile
Net Income Common Stock USD16.3 B14.7 B14.5 B
Increasing
Slightly volatile
Net Income from Discontinued Operations(335.3 M)(285 M)(210.6 M)
Decreasing
Stable
Net Income to Non Controlling Interests590.5 M386 M572.7 M
Increasing
Very volatile
Operating Expenses100.2 B97 B83.1 B
Increasing
Slightly volatile
Operating Income27 B24.1 B24.1 B
Increasing
Slightly volatile
Revenues490 B482.1 B429 B
Increasing
Slightly volatile
Revenues USD509.4 B482.1 B430.6 B
Increasing
Slightly volatile
Selling General and Administrative Expense100.2 B97 B83.1 B
Increasing
Slightly volatile
Weighted Average Shares3 B3.2 B3.6 B
Decreasing
Slightly volatile
Weighted Average Shares Diluted3.4 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(11.8 B)(10.8 B)(11.6 B)
Decreasing
Stable
Depreciation Amortization and Accretion9.8 B9.5 B7.9 B
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents749.5 M(430 M)113.7 M
Increasing
Stable
Net Cash Flow Business Acquisitions and Disposals482.6 M246 M(337.2 M)
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(2.7 B)(4.1 B)(5.6 B)
Increasing
Stable
Issuance Repayment of Debt Securities (4.3 B)(3.2 B)(63.8 M)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (6.6 B)(6.3 B)(4.9 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing(16.4 B)(16.1 B)(11.8 B)
Decreasing
Slightly volatile
Net Cash Flow from Investing(11.5 B)(10.7 B)(11.9 B)
Increasing
Very volatile
Net Cash Flow Investment Acquisitions and Disposals1.3 B1.1 B1.2 B
Increasing
Slightly volatile
Net Cash Flow from Operations28 B27.4 B24.1 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (808.4 M)(1 B)(341.5 M)
Decreasing
Slightly volatile
Cash Beginning of Year8.6 B9.1 B7.6 B
Increasing
Slightly volatile
Cash End of Year9.4 B8.7 B7.8 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover2.51262.3982.3916
Increasing
Very volatile
Book Value per Share26.669525.44920.7174
Increasing
Slightly volatile
Current Ratio0.780.9320.8911
Decreasing
Stable
Debt to Equity Ratio60.71.446.4378
Increasing
Slightly volatile
Share Dilution Ratio1.05621.00281.0078
Increasing
Slightly volatile
Dividend Yield0.02790.030.0222
Increasing
Slightly volatile
Dividends per Basic Common Share2.04211.961.4352
Increasing
Slightly volatile
EBITDA Margin0.07530.0690.074
Decreasing
Stable
Earnings per Basic Share5.07894.584.1666
Increasing
Slightly volatile
Earnings per Diluted Share4.164.574.0783
Increasing
Slightly volatile
EPS Diluted Growth(0.0032)(0.041)0.0604
Decreasing
Slightly volatile
EPS Growth(0.0054)(0.0449)0.0604
Decreasing
Slightly volatile
Earnings per Basic Share USD5.07894.584.1666
Increasing
Slightly volatile
Enterprise Value over EBIT11.578910.011.4649
Decreasing
Slightly volatile
Enterprise Value over EBITDA8.80537.7579.0189
Decreasing
Slightly volatile
Free Cash Flow per Share2.175.163.3846
Increasing
Slightly volatile
Gross Margin0.26260.2510.249
Increasing
Slightly volatile
Financial Leverage0.95360.89970.9245
Decreasing
Slightly volatile
Leverage Ratio2.72782.55432.6351
Increasing
Slightly volatile
NCFO Growth0.17590.1060.0886
Increasing
Very volatile
Net Income Growth(0.0135)(0.0469)0.0348
Decreasing
Slightly volatile
Profit Margin0.0260.030.0332
Decreasing
Slightly volatile
Payout Ratio0.42470.4280.3327
Increasing
Slightly volatile
Price to Book Value3.532.6383.3956
Decreasing
Slightly volatile
Price to Earnings Ratio21.6314.48917.29
Decreasing
Stable
Price to Sales Ratio0.550.4410.5657
Decreasing
Slightly volatile
Revenue Growth0.01065.0E-40.0335
Decreasing
Slightly volatile
Return on Average Assets0.07050.0730.0797
Decreasing
Slightly volatile
Return on Average Equity0.170.1860.2089
Decreasing
Slightly volatile
Return on Invested Capital0.16420.1490.1684
Decreasing
Slightly volatile
Return on Sales0.05470.0490.0559
Decreasing
Slightly volatile
Weighted Average Share Growth(0.0094)(0.0059)(0.0238)
Increasing
Slightly volatile
Sales per Share158150124
Increasing
Slightly volatile
Tax Efficiency0.7070.67130.6687
Increasing
Slightly volatile
Tangible Assets Book Value per Share60.648957.78447.8705
Increasing
Slightly volatile
Total Assets Per Share66.43463.118654.4038
Increasing
Slightly volatile
Cash Flow Per Share9.21628.66197.2467
Increasing
Slightly volatile
Return on Investment20.468218.375920.7526
Decreasing
Slightly volatile
Operating Margin4.64.99975.5773
Decreasing
Slightly volatile
Calculated Tax Rate32.898230.307832.3879
Decreasing
Slightly volatile
Receivables Turnover78.915477.750489.6177
Decreasing
Slightly volatile
Inventory Turnover8.51058.05688.422
Decreasing
Stable
PPandE Turnover4.48724.29614.2552
Increasing
Stable
Cash and Equivalents Turnover59.588754.050458.3761
Increasing
Stable
Accounts Payable Turnover13.341812.539612.9775
Decreasing
Slightly volatile
Accrued Expenses Turnover25.394923.926523.2959
Increasing
Slightly volatile
Interest Coverage11.22789.77111.9432
Decreasing
Slightly volatile
Long Term Debt to Equity0.57020.54660.5572
Increasing
Stable
Quick Ratio0.24490.22160.2102
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets(1.6702)(2.1946)(3.5457)
Increasing
Slightly volatile
Revenue to Assets2.52622.41572.3766
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets213.4 B201 B181.2 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA32.9 B33.3 B31.5 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD36.4 B33.3 B31.7 B
Increasing
Slightly volatile
Earnings before Tax24 B21.3 B21.6 B
Increasing
Slightly volatile
Average Equity82.5 B78.9 B68.8 B
Increasing
Slightly volatile
Enterprise Value304.9 B257.9 B269.5 B
Increasing
Slightly volatile
Free Cash Flow17.6 B16.5 B12.6 B
Increasing
Slightly volatile
Invested Capital170.9 B163.1 B145.8 B
Increasing
Slightly volatile
Invested Capital Average170.2 B159.4 B143.5 B
Increasing
Slightly volatile
Market Capitalization268.9 B212.5 B226 B
Increasing
Slightly volatile
Tangible Asset Value193.8 B182.9 B164.6 B
Increasing
Slightly volatile
Working Capital(4.4 B)(2 B)(6.1 B)
Increasing
Very volatile
Revenue Per Employee231.5 K219.2 K206.2 K
Increasing
Slightly volatile
Net Income Per Employee7.4 K6.7 K6.9 K
Increasing
Slightly volatile