Financial statement analysis and common stock valuation

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Measures how efficiently Walmart Inc. generates revenues from its investments in fixed or total assets.

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Total Asset Turnover
• Equity Turnover

Analysis of Liquidity Ratios

Measures the adequacy of Walmart Inc. cash resources to meet its near-term cash obligations.

• Liquidity Ratios (Summary)
• Current Ratio
• Quick Ratio
• Cash Ratio

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

An approach to decomposing Walmart Inc. return on equity, return on assets, and net profit margin ratio as the product of other financial ratios.

• Two-Component Disaggregation of ROE
• Three-Component Disaggregation of ROE
• Five-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA
• Four-Component Disaggregation of ROA
• Disaggregation of Net Profit Margin

Analysis of Reportable Segments

Walmart Inc. operates in 3 segments: Walmart U.S.; Walmart International; and Sam’s Club U.S..

• Segment Profit Margin
• Segment Return on Assets (Segment ROA)
• Segment Asset Turnover
• Segment Capital Expenditures to Depreciation
• Net sales
• Operating income (loss)
• Total assets
• Depreciation and amortization
• Capital expenditures

Analysis of Geographic Areas

Walmart Inc. operates in 2 regions: U.S. operations and Non-U.S. operations.

• Area Asset Turnover
• Revenues
• Long-lived assets

Analysis of Liquidity Ratios
Quarterly Data

Measures the adequacy of a Walmart Inc. cash resources to meet its near-term cash obligations.

• Liquidity Ratios (Summary)
• Current Ratio
• Quick Ratio
• Cash Ratio

Capital Asset Pricing Model (CAPM)

CAPM is a theory concentrated with deriving the expected rates of return on risky assets based on the assets’ systematic risk levels. Systematic risk is the variability of returns that is due to macroeconomic factors that affect all risky assets. It cannot be eliminated by diversification.

• Rates of Return
• Variance and Covariance
• Systematic Risk (β) Estimation
• Expected Rate of Return

Analysis of Long-term (Investment) Activity Ratios

Measures how efficiently Walmart Inc. generates revenues from its investments in fixed or total assets.

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
• Total Asset Turnover
• Equity Turnover

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

Common Stock Valuation Ratios

Relative valuation technique determine the value of Walmart Inc. by comparing it to similar entities (like industry or sector) on the basis of several relative ratios that compare its stock price to relevant variables that affect the stock value, such as earnings, book value, and sales.

• Current Valuation Ratios
• Historical Valuation Ratios (Summary)
• Price to Earnings (P/E)
• Price to Operating Profit (P/OP)
• Price to Sales (P/S)
• Price to Book Value (P/BV)

Enterprise Value (EV)

Enterprise value is total company value (the market value of common equity, debt, and preferred equity) minus the value of cash and short-term investments.

• Current EV
• Historical EV

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

An approach to decomposing Walmart Inc. return on equity, return on assets, and net profit margin ratio as the product of other financial ratios.

• Two-Component Disaggregation of ROE
• Three-Component Disaggregation of ROE
• Five-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA
• Four-Component Disaggregation of ROA
• Disaggregation of Net Profit Margin