Switch to:
Wal-Mart Stores Inc  (NYSE:WMT) Earnings Power Value (EPV): $88.90 (As of Oct17)

As of Oct17, Wal-Mart Stores Inc's earnings power value is $88.90.

Margin of Safety is -8.45

The basic concept of EPV is that one should value a stock based on the current free cash flow of a company and not on future projections which may, or may not, come true. It is arguably a better way to analyze stocks than Discounted Cash Flow analysis that relies on highly speculative growth assumptions many years into the future. Assumption: Current profitability is sustainable.


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
Earnings Power Value (EPV) Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only 61.09 64.85 72.86 79.42 85.71

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
Earnings Power Value (EPV) 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 83.14 85.71 86.45 88.28 88.90

Competitive Comparison
* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap.


Calculation

Earnings Power Value also known as just Earnings Power is a valuation technique popularised by Bruce Greenwald, an authority on value investing at Columbia University. It is arguably a better way to analyze stocks than Discounted Cash Flow analysis that relies on highly speculative growth assumptions many years into the future.

The basic concept of EPV is that one should value a stock based on the current free cash flow of a company and not on future projections which may, or may not, come true. This valuation tool excludes the potential growth that a company may have so that needs to be looked at separately. Since future growth is excluded from the analysis, only the maintenance capital expenditures are subtracted from after-tax EBIT (earnings before interest and taxes) and growth capex is ignored.

Wal-Mart Stores Inc's "Earning Power" Calculation:

Average of Last 20 Quarters Last Quarter
Revenue 484,360
DDA 9,516
Operating Margin % 5.17
SGA * 25% 24,207
Tax Rate % 31.56
Maintenance Capex 7,379
Cash and Cash Equivalents 7,026
Short-Term Debt 9,021
Long-Term Debt 40,906
Shares Outstanding (Diluted) 2,996

1. Start with "Earnings" not including accounting adjustments (one-time charges not excluded unless policy has changed). "Earnings" are "Operating Income.

2. Look at average margins over a business/Industry cycle: Average Operating Margin = 5.17%

To normalize margins and eliminate the effects on profitability of valuing the firm at different points in the business cycle, it is usually best to take a long-term average of operating margins. Ideally this would be as long as 10 years and include at least one economic downturn. However, since most of companies do not have as long as 10-year history, here GuruFocus uses the latest 5 years data to do the calculation. To smooth out unusual years but reflect recent developments, we take an average of the 5 year margin.

3. Multiply average margins by sustainable revenues and then adjust for maintenance SGA. This yields "normalized" EBIT:

To be conservative, GuruFocus uses an average of the 5 year revenues as the sustainable revenue.
EPV analysis recognises that part of SG&A expenditure is made to maintain and replace the existing assets, while part is made to grow sales. Since EPV is only interested in what it costs a going concern to maintain its existing asset base, it adds back a percentage of SG&A (between 15% and 50% - this is a matter of judgment and industry knowledge) to make up for the fact that some of this expenditure went to fund growth and shouldn't be accounted for. To start off, we assume 25% for the sake of prudence.
Sustainable Revenue = $ Mil, Average Operating Margin = 5.17%, Average Adjusted SGA = 24,207,
therefore "Normalized" EBIT = Sustainable Revenue * Average Operating Margin + Average Adjusted SGA = 484,360 * 5.17% +24,207 = $49258.0992 Mil.

4. Multiply by one minus Average Tax Rate (NOPAT):

Same as average operating margin calculation, GuruFocus takes an average of the 5 years tax rates.
Average Tax Rate = 31.56%, and "Normalized" EBIT = $49258.0992 Mil,
therefore After-tax "Normalized" EBIT = "Normalized" EBIT * ( 1 - Average Tax Rate ) = 49258.0992 * ( 1 - 31.56% ) = $33710.026478 Mil.

5. Add back Excess Depreciation (after tax at 1/2 average tax rate). This yields "normalized" Earnings:

Excess Depreciation = Average DDA * % of Excess Depreciation (after tax at 1/2 average tax rate) = 9,516 * 0.5 * 31.56% = $1501.775781 Mil.
"Normalized" Earnings = After-tax "Normalized" EBIT + Excess Depreciation = 33710.026478 + 1501.775781 = $35211.802259 Mil.

6. Adjusted for Maintenance Capital Expenditure:

First, calculate the revenue change regarding to the previous year. If the revenue decreased from the previous year, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
Second, if the revenue increased from the previous year, then calculate the percentage of Net PPE as of corresponding Revenue.
Third, calculate Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was negative, then the Maintenance Capital Expenditure = Capital Expenditure (positive).
If [Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase] was positive, then the Maintenance Capital Expenditure = Capital Expenditure (positive) - percentage of Net PPE as of corresponding Revenue * revenue increase.
Fourth, GuruFocus uses an average of the 5 year maintenance capital expenditures as maintenance CAPEX.
Wal-Mart Stores Inc's Average Maintenance CAPEX = $7,379 Mil

7. Investors require a return of "WACC" for the risk they are taking: WACC = 9%

8. Wal-Mart Stores Inc's current cash and cash equivalent = $7,026 Mil.
Wal-Mart Stores Inc's current interest bearing debt = Long-Term Debt & Capital Lease Obligation + Current Portion of Long-Term Debt = 40,906 + 9,021 = $49927 Mil.
Wal-Mart Stores Inc's current Shares Outstanding (Diluted Average) = 2,996 Mil.

Wal-Mart Stores Inc's Earnings Power Value (EPV) for Oct17 is calculated as:

EPV = ( ( Norm. Earnings-Maint. CAPEX ) / WACC + CashandEquiv - Int. Bearing Debt ) / Shares Outstanding (Diluted Average)
= ( ( 35211.802259 - 7,379)/ 9%+7,026-49927 )/2,996
=88.90

Margin of Safety (EPV)=( Earnings Power Value (EPV)-Current Price )/Earnings Power Value (EPV)
=( 88.9008127838-96.41 )/88.9008127838
= -8.45%

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


Explanation

Assumption: Current profitability is sustainable.

Earnings power value (EPV) uses a very basic equation which assumes no growth, although it does rely on an assumption about the cost of capital as well as the fact that current earnings are sustainable. It also involves several adjustments to clean up the underlying Earnings figures.


Be Aware

Though using today's earnings in calculating Earnings Power Value, GuruFocus is normalizing these earnings to the business cycle. This eliminates the effects on profitability of valuing the firm at different points in the business cycle. This means that we are considering the average earnings over 5 years.


Related Terms


Headlines

From the Internet

WMT
Bullish Ingles Markets

- Seekingalpha 2017-11-23 09:59:37

WMT
Video: Find Out What Stores Will Be Closed Today

- theStreet 2017-11-23 09:36:00

WMT
Wal Mart Stay Strong Take Profits

- Seekingalpha 2017-11-23 02:20:25

WMT
This Isn't Your Father's Wal-mart

- Fool 2017-11-22 17:23:00

WMT
What Does Kroger Know About Fashion?

- Fool 2017-11-22 14:33:00

WMT
4 Things Make Wal Mart Attractive Price

- Seekingalpha 2017-11-22 13:51:55

WMT
Black Friday Stories From Hell

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

WMT
Walmart CEO: A Tax Cut Would Mean a Lot

- theStreet 2017-11-22 10:03:00

WMT
What Walmart's CEO Thinks About Tax Reform

- theStreet 2017-11-22 10:00:00

WMT
Is Black Friday Dead?

- theStreet 2017-11-22 07:30: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