Switch to:
Wal-Mart Stores Inc (NYSE:WMT)
Intrinsic Value (DCF Projected)
$63.18 (As of Today)

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value (DCF), or Discounted Earnings (DCE) Intrinsic Value (DE) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Discounted Cash Flow and Book Value of the company. The details of how we calculate the intrinsic value of stocks are described in detail here.

As of today, Wal-Mart Stores Inc's DCF projected intrinsic value is $63.18. The stock price of Wal-Mart Stores Inc is $74.95. Therefore, Wal-Mart Stores Inc's Price to Intrinsic Value (DCF Projected) Ratio of today is 1.2.

WMT' s 10-Year Price to Intrinsic Value (DCF Projected) Range
Min: 1.1   Max: 6.1
Current: 1.2

1.1
6.1

During the past 13 years, the highest Price to Intrinsic Value (DCF Projected) Ratio of Wal-Mart Stores Inc was 6.10. The lowest was 1.10. And the median was 2.04.

WMT's Price to Intrinsic Value (DCF Projected) is ranked higher than
87% of the 519 Companies
in the Global Discount Stores industry.

( Industry Median: 4.70 vs. WMT: 1.20 )

Definition

Since the intrinsic value calculations based on Discounted Cash Flow Intrinsic Value (DCF), or Discounted Earnings (DCE) Intrinsic Value (DE) cannot be applied to companies without consistent revenue and earnings, GuruFocus developed a valuation model based on normalized Discounted Cash Flow and Book Value of the company.

The details of how we calculate the intrinsic value of stocks are described in detail here.

This method smooths out the free cash flow over the past 6-7 years, multiplies the results by a growth multiple, and adds a portion of total equity.

Value = ((Growth Multiple)*Free Cash Flow(6 year avg) + 0.8*Total Equity(most recent))/Shares Outstanding

In the case of negative total equity, the following formula is used (see the Total Equity section for the reason):

Value = ((Growth Multiple)*Free Cash Flow(6 year avg) + Total Equity(most recent)/0.8)/Shares Outstanding


Here Wal-Mart Stores Inc's FCF(6 year avg) is calculate as

Wal-Mart Stores Inc Quarterly Data

201204201207201210201301201304201307201310201401201404201407
total_freecashflow 3,0593,0149135,7071,9263,259-1,3716,3283,7823,005
200910201001201004201007201010201101201104201107201110201201
total_freecashflow -59610,510-1,5906,055-1,5197,998-4154,452-6667,374
200810200901200904200907
total_freecashflow -2,9109,6499643,187

Add all the Free Cash Flow together and divide 6 will get Wal-Mart Stores Inc's FCF(6 year avg) = $12,019.17.

Wal-Mart Stores Inc's DCF Projected Intrinsic Value for today is calculated as

Intrinsic Value=(Growth Multiple*Free Cash Flow(6 year avg)+Total Equity(Jul14)*0.8)/Shares Outstanding
=(12.0181811285*12019.1666667+77746*0.8)/3241.000
=63.76

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.


Explanation

The growth multiple is capped between 8.35 and 17.74.

Total equity weighting is more art than science and it should always be revisited in more detail when researching a company. Weightings from 0% to 100% to more than 100% are possible. 80% was chosen as a happy medium after taking the above ideas into consideration. Learn more here.

Wal-Mart Stores Inc's Price to DCF Projected Intrinsic Value Ratio for today is calculated as

Price to DCF Projected Intrinsic Value=Share Price/DCF Projected Intrinsic Value
=74.95/63.759741442
=1.18

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.


Related Terms

Intrinsic Value (DE), Intrinsic Value (DCF), Free Cash Flow


Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their own currency.

Wal-Mart Stores Inc Annual Data

Jan05Jan06Jan07Jan08Jan09Jan10Jan11Jan12Jan13Jan14
iv_dcf_share 18.8220.6124.0527.8133.7139.2545.9152.6559.7963.51

Wal-Mart Stores Inc Quarterly Data

Apr12Jul12Oct12Jan13Apr13Jul13Oct13Jan14Apr14Jul14
iv_dcf_share 53.0955.2156.9559.7959.8961.5861.0163.5163.180.00
Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)
Free 7-day Trial
FEEDBACK
Email Hide