Switch to:
Wal-Mart Stores Inc  (NYSE:WMT) Intrinsic Value: DCF (Earnings Based): $40.24 Mil (As of Today)

As of today, Wal-Mart Stores Inc's intrinsic value calculated from the Discounted Earnings model is $40.24.

Note: Discounted Earnings model is only suitable for predictable companies (Business Predictability Rank higher than 1-Star). Result may not be accurate due to the low predictability of business.

Margin of Safety (Earnings Based) using Discounted Earnings model for Wal-Mart Stores Inc is -142.23%.

NYSE:WMT' s Price-to-Intrinsic-Value-DCF (Earnings Based) Range Over the Past 10 Years
Min: 0.67   Max: 2.14
Current: 2.42

0.67
2.14

During the past 13 years, the highest Price-to-Intrinsic-Value-DCF (Earnings Based) Ratio of Wal-Mart Stores Inc was 2.14. The lowest was 0.67. And the median was 1.11.

NYSE:WMT's Price-to-Intrinsic-Value-DCF (Earnings Based) is ranked lower than
67% of the 60 Companies
in the Global industry.

( Industry Median: 1.43 vs. NYSE:WMT: 2.42 )

Historical Data

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.

* Premium members only.

Wal-Mart Stores Inc Annual Data

Jan08 Jan09 Jan10 Jan11 Jan12 Jan13 Jan14 Jan15 Jan16 Jan17
Intrinsic Value: DCF (Earnings Based) Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 75.36 67.49 64.68 54.27 46.98

Wal-Mart Stores Inc Quarterly Data

Jan13 Apr13 Jul13 Oct13 Jan14 Apr14 Jul14 Oct14 Jan15 Apr15 Jul15 Oct15 Jan16 Apr16 Jul16 Oct16 Jan17 Apr17 Jul17 Oct17
Intrinsic Value: DCF (Earnings Based) Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 54.62 46.98 47.19 44.52 40.24

Calculation

This is the intrinsic value calculated from the Discounted Earnings model with default parameters. The calculation method is the same as Discounted Cash Flow model except earnings are used in the calculation instead of free cash flow. This is the default method of calculation with GuruFocus DCF calculator.

Usually a two-stage model is used in calculating the intrinsic value with discounted cash flow model. The first stage is called growth stage; the second is called the terminal stage. In the growth stage the company grows at a faster rate. Because it cannot grow at that rate forever, a lower rate is used for the terminal stage.

GuruFocus DCF calculator is a two-stage model. The default values are defined as:

1. Discount Rate: d=12%

2. Growth Rate in the growth stage: g1=5.00%
Growth Rate in the growth stage = average earnings growth rate in the past 10 years. If it is higher than 20%, we use 20%. If it is less than 5%, we use 5% instead. => Average Earnings Growth Rate in the past 10 years was 5.00% which is less than 20% and higher than 5% => Growth Rate: 5.00%

3. Years of Growth Stage: y1=10

4. Terminal Growth Rate: g2=4%

5. Years of Terminal Growth: y2=10

6. EPS without NRI: eps without nri=$3.76.
GuruFocus DCF calculator is actually a Discounted Earnings calculator, the Earnings Per Share without NRI is used as the default. The reason we are doing this is we found that historically stock prices are more correlated with earnings than free cash flow.

All of the default settings can be changed and the results are calculated automatically.

Wal-Mart Stores Inc's Intrinsic Value: DCF (Earnings Based) for today is calculated as:

DCF (Earnings Based)=Earnings per Share (Diluted)*{[(1+g1)/(1+d)+(1+g1)^2/(1+d)^2+...+(1+g1)^10/(1+d)^10]
+(1+g1)^10/(1+d)^10*[(1+g2)/(1+d)+(1+g2)^2/(1+d)^2+...+(1+g2)^10/(1+d)^10]}

set x = (1+g1)/(1+d) = (1+0.05)/(1+0.12) = 0.9375
and y = (1+g2)/(1+d) = (1+0.04)/(1+0.12) = 0.928571428571

DCF (Earnings Based)=Earnings per Share (Diluted)*{[x+x^2+...+x^10]+x^10*[y+y^2+...+y^10]}
=Earnings per Share (Diluted)*[x*(1-x^10)/(1-x)+x^10*y*(1-y^10)/(1-y)]
=3.76*10.7016
=40.24

Margin of Safety (Earnings Based)=(DCF (Earnings Based)-Current Price)/DCF (Earnings Based)
=(40.238016-97.47)/40.238016
=-142.23 %

* All numbers are in millions except for per share data and ratio. All numbers are in their local exchange's currency.


Explanation

Unlike valuation methods such as Net Current Asset Value, Tangible Book Value per Share, Graham Number, Median Ratio etc, discounted Cash Flow model evaluates the companies based on their future earnings power instead of their assets.


Be Aware

What you need to know about Discounted Earnings model:

1. The Discounted Earnings model evaluates a company based on its future earnings power
2. Growth is taken into account; therefore a faster growth company is worth more if everything else is the same.
3. Since we are projecting future growth, it is assumed that the company will grow at the same rate as it did during the past 10 years. Therefore this model works better for the companies that are relatively consistent performers.
4. The Discounted Earnings model works poorly for inconsistent performers like cyclicals.
5. Your expected return from the investment is a reasonable discount rate assumption.
6. A larger margin of safety should be required for companies with less predictable businesses.

You can screen for stocks that trade below their Intrinsic Value: DCF (FCF Based) and Intrinsic Value: DCF (Earnings Based) with the GuruFocus All-in-One Screener. Companies with a high Predictability Rank that trade at a discount to their Intrinsic Value: DCF (FCF Based) and Intrinsic Value: DCF (Earnings Based) can be found in the screen of Undervalued Predictable Companies.


Related Terms


Headlines

From the Internet

WMT
Why Walmart Haters Have Been Beyond Dumb

- theStreet 2017-11-18 09:21:00

WMT
Week Review November 16 2017

- Seekingalpha 2017-11-18 05:00:34

WMT
Wal Mart Please Stop Madness Buy

- Seekingalpha 2017-11-17 14:59:23

WMT
Time for High Beta & Momentum ETFs?

- Zacks 2017-11-17 12:23:00

WMT
Wal-Mart preorders 15 Tesla trucks for U.S., Canada

- MarketWatch 2017-11-17 12:16:00

WMT
Wal-Mart planning to test Tesla's truck: report

- MarketWatch 2017-11-17 11:42:00

WMT
Why Wal-Mart Is Getting a Dressing-Down

- Barron's 2017-11-17 11:14:00

WMT
Stock Market News For Nov 17, 2017

- Zacks 2017-11-17 09:09:00

WMT
Wal-Mart Is Holding Its Own Against Amazon

- Barron's 2017-11-17 09:06:27

WMT
Wal Mart Amazon Nervous

- Seekingalpha 2017-11-17 08:08:28

WMT
Thursday Wal Mart Cisco Cramers Mad Money 11 16 17

- Seekingalpha 2017-11-17 07:43:52

WMT
Exploding E Commerce Sales Drive Wal Mart Time High

- Seekingalpha 2017-11-17 02:57:14

WMT
Wal Mart Street Picks Sides Retail

- Seekingalpha 2017-11-16 20:22:55

WMT
PPG Industries: Cramer's Top Takeaways

- theStreet 2017-11-16 19:29:00

WMT
What Happened in the Stock Market Today

- Fool 2017-11-16 17:04:00

WMT
Plenty of Positive Retail Surprises

- Zacks 2017-11-16 16:42:00

WMT
Plenty of Positive Retail Surprises

- Zacks 2017-11-16 16:37:00

WMT
Has Wal-Mart Won the Retail Wars?

- Barron's 2017-11-16 14:35:55

WMT
Despite iPhone, Best Buy Continues to Struggle

- theStreet 2017-11-16 12:49:00

WMT
Wal-Mart Ready to Rumble With Amazon

- Barron's 2017-11-16 12:25:21

WMT
Why Wal-Mart Stock Was Soaring Today

- Fool 2017-11-16 12:14:00

WMT
New ETF is a bet on the death of retail stores

- MarketWatch 2017-11-16 11:56:00

WMT
Amazon Go May Coming May Help Stock

- Seekingalpha 2017-11-16 09:49:54

WMT
Walmart Now Pushes Clicks, Not Bricks

- theStreet 2017-11-16 09:49:00

WMT
A Wrap-Up Of The Latest Economic Data

- Zacks 2017-11-16 09:40:00

WMT
U.S. stocks open higher after two days of losses

- MarketWatch 2017-11-16 09:32:00

WMT
Stock Market News For Nov 16, 2017

- Zacks 2017-11-16 09:13:00

WMT
Asda sales up; parent warns on challenging market

- MarketWatch 2017-11-16 08:41: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)

GF Chat

{{numOfNotice}}
FEEDBACK