Last Price**$84.8**1.2%

Market Cap**$614.7B**

Intrinsic value score

4/10

Good

Intrinsic value

$108.8

DCF value - $38.1
Relative value - $179.5

Undervalued

22%

LTM P/E

43.9x

Peer set median: 44.9x

Discount rate

6.7%

Sign up and unlock this exclusive content!

Sign Up for FreeSign up and unlock this exclusive content!

Sign Up for FreeCrunching data... Almost there!

Crunching data... Almost there!

Crunching data... Almost there!

Crunching data... Almost there!

Investing armour 2024

50+ visuals to equip yourself with investing wisdom.
Sign up to receive it for FREE

As of today, DCF Value of Walmart Inc. is $38.1, which is undervalued by 22%, compared to the current market share price of $84.8

Step 1: Calculating Intrinsic Enterprise Value DCF Value was calculated by estimating Walmart Inc. future free cash flow and then discounting it, using a chosen discount rate to determine Intrinsic Enterprise Value of $273.2B Step 2: Balance Sheet Adjustments Intrinsic Equity Value is calculated by subtracting Balance Sheet items (Cash & Equivalents, Short-term investments and Total Debt) from previously calculated Intrinsic Enterprise Value. This Intrinsic Equity Value is then divided by the total number of outstanding shares of 8,044,000,000 to determine DCF Value of $38.1

As of today, Relative Value of Walmart Inc. is $179.5, which is overvalued by 111.5%, compared to the current market share price of $84.8

Relative Value was calculated by applying various valuation multiples (EV/Revenue, EV/EBITDA, P/E etc.) to Walmart Inc. financials to determine Relative Value of $179.5

Walmart Inc. current Cost of Equity is 7.0%, while its WACC stands at 6.7%. Cost of Equity is used to value equity, while discounting free cash flow to equity holders (such as Net Income or Free Cash Flow to Equity). Weighted Average Cost of Capital (WACC) is used to value the entire firm, while discounting cash flows available to both debt and equity holders (NOPAT or Free Cash Flow to the Firm)

The Cost of Equity represents the return a company must offer investors to compensate for the risk of investing in its stock. It's calculated using the Capital Asset Pricing Model (CAPM), which combines the risk-free rate, the stock's beta, and the equity risk premium (ERP). This model considers the inherent risk of investing in the stock compared to a risk-free investment and the market's overall risk. Cost of Equity = Risk-Free Rate + Beta x Effective Risk Premium (ERP) 7.0% = 4.52% + 0.5 x 5.0%

WACC, or Weighted Average Cost of Capital, is a calculation that reflects the average rate of return a company is expected to pay its security holders to finance its assets. It is a critical measure in financial analysis for valuing a company’s entire operations. The WACC formula combines the costs of equity and debt, weighted by their respective proportions in the company's capital structure. WACC = Cost of Equity x Equity Weight in Total Capital + Cost of Debt x (1 - Effective Tax Rate) Debt Weight in Total Capital 6.7% = 7.0% x 92.1% + 5.3% x (1 - 34.7%) x 7.9%