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 Short-term (Operating) Activity Ratios
Quarterly Data

Evaluates revenues and output generated by the Walmart Inc. assets. Operating performance ratios describe the relationship between the Walmart Inc. level of operations and the assets needed to sustain operating activities.

• Short-term Activity Ratios (Summary)
• Inventory Turnover
• Receivables Turnover
• Payables Turnover
• Working Capital Turnover
• Average Inventory Processing Period
• Average Receivable Collection Period
• Operating Cycle
• Average Payables Payment Period
• Cash Conversion Cycle

Present Value of Free Cash Flow to Equity (FCFE)

The FCFE valuation approach estimates the value of equity as the present value of future FCFE discounted at the required rate of return on equity.

• Intrinsic Stock Value (Valuation Summary)
• Required Rate of Return (r)
• FCFE Growth Rate (g)

Enterprise Value to FCFF (EV/FCFF)

Free cash flow to the firm is the cash flow available to the Walmart Inc. suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made.

• Free Cash Flow to The Firm (FCFF)
• Interest Paid, Net of Tax
• EV to FCFF Ratio, Current
• EV to FCFF Ratio, Historical

Common-Size Income Statement
Quarterly Data

Income statement components (revenues and expenses) shown as percentage of total sales.

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

Balance Sheet: Liabilities and Stockholders’ Equity

The liabilities and stockholders’ equity reports major classes and amounts of external claims on assets and owners’ capital contributions, and other internally generated sources of capital.

Enterprise Value to EBITDA (EV/EBITDA)

To calculate EBITDA analysts start with net earnings. To that earnings number, interest, taxes, depreciation, and amortization are added. EBITDA as a pre-interest number is a flow to all providers of capital.

• Earnings before Interest, Tax, Depreciation and Amortization (EBITDA)
• EV to EBITDA Ratio, Current
• EV to EBITDA Ratio, Historical

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

Income Statement
Quarterly Data

The income statement (statement of earnings) reports on the performance of Walmart Inc., the result of its operating activities.

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.