Walmart - A Fair Value Report

Walmart sells stuff. Consumers need stuff. Investors need solid returns. Walmart creates solid returns. Let the fais do-do commence

Author's Avatar
Scott Waxler
Apr 09, 2021
Article's Main Image

This report is about Walmart Inc. (

WMT, Financial) and covers the company's fiscal year ended Jan. 31, 2021. Listed earnings and metrics utilizing earnings are for that specific 12 month time period unless otherwise noted. Unaudited or reviewed financial information is not apart of, nor included in, this report.

What they do
Walmart, Inc. is engaged in retail and wholesale operations with three reportable segments, Walmart U.S., Walmart International, and Sam's Club. Industry peers include Target Corp. (

TGT, Financial) and Amazon.com Inc. (AMZN, Financial).

Short-term target
My current short-term target for the stock is $148.87 with an initial trailing stop set at $137.61. Based on a recent price of $139.71, upward price movement will find resistance at $145.98 and again at $149.04, with final resistance found at $152.51. Downward price movement will find support at $137.04 and again at $134.71, with final support found at $128.20.

One-year growth price target
My one year growth price target is actually a price target range, determined by adding year over year earning growth to the prior year annual dividend yield and dividing the result by the current annual price to earnings ratio.

For this stock, my current one year growth price target range is $141-$164.

Volatility adjustment
There are different metrics available to help investors determine the volatility of a particular stock as compared to the volatility of the market as a whole. To me, the beta ratio is the metric that is the most representative of a stock's volatility. A beta ratio of less than 1 means that the security's price will be less volatile than the market, while a beta ratio greater than 1 indicates that the security's price will be more volatile than the market.

Basis my current beta ratio for this stock of 0.43, my volatility adjustment to recent pricing is $185 per share, making my current volatility adjusted price $325.

Quality of earnings
A company's earnings can be impacted by a variety of sources unrelated to the company's current day to day operations. Discontinued operations, tax refunds, depreciation, and impairment for example, may distort a company's operating income and consequently its fair value. Investors should always explore the sources of a company's operating income to better understand potential valuation impacts.

Of the company's $4.72 in fiscal 2021 per share earnings, 7 cents came from some combination of other sources, income taxes, interest, minority interests, or discontinued operations.

Key performance indicator rating
I use key performance indicators as a barometer to measure the effectiveness of management. Several of the metrics that I use are the tangible asset ratio, return on invested capital, free cash flow growth, earnings growth, debt growth, the dividend payout ratio, and the cash conversion cycle. Admittedly, my use of these and other metrics as a way to determine the effectiveness of management is subjective. Based on a 0-105 scale, my KPI for this company is 50.

Annual shareholder return
I calculate annual shareholder return by subtracting the stock price at the close of business on the last day of a company's fiscal year, from the stock price at the start of business on the first day of the company's fiscal year, plus any dividends paid during that period, and then dividing the result by the opening stock price on the first day of a company's fiscal year.

For fiscal 2021, the company spent $0.93 per share buying back company stock, paid a common stock dividend of $2.17 per share, and had year-over-year annual price appreciation of $23.91, which created a year-over-year annual shareholder return of 22%.

Over the prior five year period, the company spent an average of $2.29 per share buying back company stock, paid an average annual common stock dividend of $2.08 per share, and had average annual price appreciation of $11.06, which created an average annual shareholder return of 18%.

Cost of common equity
The cost of common equity is the minimum annual rate of return an investor should expect to earn when investing in shares of a particular company. I calculate this by adding the thirty-year treasury yield to the beta ratio for the stock multiplied by my default equity risk premium.

My cost of common equity for this stock is 3.60%.

Wieghted average cost of capital
There is little in this world that does not come with some form of cost. Capital, which I define as cash used by a company for productive purposes and includes equity, debt, preferred stock, and dividends, is no exception. The weighted average cost of capital then, in simple terms, is the average cost the company pays for the necessary capital to operate its business and is proportionate to equity, debt, preferred stock, and dividends.

My weighted average cost of capital for this company is 2.54%.

The year-over-year numbers
There are many year-over-year numbers for investors to focus on. But to me, there are only a handful that have any significant meaning, and so those are the numbers that I highlight in this space. Please remember these are year-over-year numbers.

For fiscal 2021, revenue increased 7%, earnings increased 3%, free cash flow increased 5%, and debt decreased by 13%. Additionally, the company's annual operating rate, which I calculate by adding operating expenses to the cost of goods sold and dividing the result by net sales, was 96.

Current price ratios
Investing requires effort. Value investing requires patience. Stock prices require consideration. As a way to screen a company to determine if it is worth my effort, patience and consideration, I use several price comparison ratios.

For this company, my Price to Earnings Ratio is 30, my Price to Book Ratio is 4, my Price to Tangible Book Value is 7, my Price to Debt Ratio is 6, my Price to Free Cash Flow Ratio is 38, and my Return on Invested Capital is 11%.

Risk-reward ratio
I determine my risk reward ratio by subtracting my current terminate target from a recent price and then dividing that result by my initiate target less a price fluctuation variable of 20%. What I am looking for with this ratio is a value of 5 or greater. My risk/reward ratio for this stock is 3.

Prior five-year averages
My average valuation for the prior five year fiscal period was $83. The stock price during that time period averaged $97, earnings averaged $4.68 per share, and the average PE Ratio was 21.

Fair value investing
It is important to remember that the current market price of an equity is the price negotiated between a willing buyer and a willing seller. This market price is not the fair value of the associated company, but the negotiated price of a single equity trade.

The basic investing tenet for a fair value investor is price determines return. As such it is important to have some understanding of the value of the company as an on-going concern, and to develop a strategy that, with current value in mind, will allow investment in that company at some reasonable discount to current pricing.

My most recent fair value estimate for the stock of this company as an on-going concern is $125. This estimated fair value forms the basis for my target prices as shown on my worksheet.

Walmart Inc. FYE 01/2021 FAIRLY VALUED The stock is currently trading at levels above my most recent $87 initiate target, but below my most recent $156 reduce target. Please See Linked PDF Worksheet.

My disclaimer
I am a long-term, buy and hold investor, practicing a value investing philosophy. I am not a licensed or registered investment professional. I currently have NO investment position in the company mentioned in this report. Financial statement data was obtained from the company's most recent Annual Report on Form 10-K.

Risk
Past and future gains contained herein are based on actual and anticipated earnings, actual and anticipated dividends, and actual and anticipated price appreciation. Valuations, while given as a specific amount, are always within a valuation range. Investors should be aware that any investment has the potential for loss, and past performance is no guarantee of future results.

Thanks for reading.

Wax

Read more here:

Not a Premium Member of GuruFocus? Sign up for a free 7-day trial here.

Rating:
5 / 5 (1 votes)