Banner
The Fair Value Report

VMware

My Disclaimer
I am a value investor. 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 SEC 10-K filing.

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.

Intent
The intent of this report is to provide the reader with a brief overview of my various company valuations so they can independently determine their current level of investment interest.

What They Do
VMware helps customers manage their IT resources across private clouds and complex multi-cloud, multi-device environments by offering solutions across three categories: Software-Defined Data Center (“SDDC”), Hybrid Cloud Computing and End-User Computing (“EUC”). This portfolio supports and addresses the key IT priorities of customers: accelerating their cloud journey, empowering digital workspaces and transforming networking and security. Industry peers include Oracle Corporation (NYSE: OCRL) and Citrix Systems (NASDAQ: CTXS).

Recent Business Acquisitions
In October 2019, the company completed the acquisition of Carbon Black, a developer of cloud-native endpoint protection, in a cash tender offer for all of the outstanding shares of Carbon Black’s common stock. The total preliminary purchase price was $2.0 billion, net of cash acquired of $111 million.

During the second quarter of fiscal 2020, the company completed the acquisition of Avi Networks, Inc., a provider of multi-cloud application delivery services. VMware acquired Avi Networks to provide customers with application delivery controller capabilities that include server load balancing for various applications and analytics. The total purchase price was $326 million, net of cash acquired of $9 million.

During the first quarter of fiscal 2020, the company completed the acquisition of AetherPal Inc., a provider of remote support solutions, to enhance VMware’s Workspace ONE offerings. The total purchase price was $45 million.

During the third quarter of fiscal 2020, the company completed four other acquisitions, which were not material individually to the financial statements. The company expects these acquisitions to enhance its product features and capabilities for its Software-Defined Data Center solutions and SaaS offerings. The aggregate purchase price, net of cash acquired for these four acquisitions was $68 million.

Recent Business Divestitures
The company listed no new business divestitures in its most recent SEC 10-K filing.

Subsequent Events
There were no subsequent events between the company’s fiscal year end and the filing of its most recent 10-K.

Short-Term Target
My current short-term target for the stock is $147.91 with an initial trailing stop set at $150.65. With a recent price of $152.94, upward price movement will find resistance at $155.89 and again at $160.33, with final resistance found at $167.43. Downward price movement will find support at $137.44 and again at $133.19, with final support found at $127.89.

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.97, my volatility adjustment to recent pricing is $5 per share, making my current volatility adjusted price $158.

Quality of Earnings
A company’s earnings can be impacted by sources unrelated to the company’s day to day operations. These unrelated sources 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 $15.18 per share in earnings, $12.25 per share came from sources unrelated to day to day operations and/or from income tax benefits.

Key Performance Indicator Rating
I use key performance indicators (KPIs) 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. Be that as it may, for me, they work. Based on a 0-105 scale, my KPI for this company is 61.

Five Year Growth of $10K
Had you invested $10K in this company five years ago (02/28/15), you would have received 118 shares of stock with a cost basis of $85.07 per share. Had you held the stock for five years and then closed your position (02/28/2020), you would have closed at $135.63 per share. During that holding period you would have collected $0 in regular and special dividends, and your initial $10K investment would have returned to you $15,943 a gain of 59% excluding regular and special dividends.

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 with in the period, and then dividing the result by the opening stock price on the first day of a company’s fiscal year. For fiscal 2019, the annual shareholder return was (23)%. The average annual shareholder return over the prior five year period was 21%.

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 4.31%.

Insider Transactions
The SEC classifies insiders as “management, officers or any beneficial owners with more than 10% class of a company’s security.” Insiders are required to abide by certain rules and fill out SEC forms every time they buy or sell company shares. In addition, to prevent insider trading, or benefiting illegally from material non-public information that their positions give them access to, the law prevents insiders from deposing of shares within six months of their purchase. This effectively bars insiders from profiting from quick trades based on their “insider” knowledge.

Over the past 12 months, the company has recorded 106 insider trades involving 1,743,441 shares of stock. Of the total insider trades, 16 were Buys involving 747,196 shares of stock, and 90 were Sells involving 996,245 shares of stock, creating an insider buy to sell ratio of 0.8 to 1..

Enterprise and Equity Values
As a fair value investor, I am looking for companies that have low debt and generate lots of cash. To me, the easiest way to highlight a company’s ability to generate cash is to compare the Enterprise Value to the Equity Value, what I call my E2E Ratio. What I am looking for with this ratio is something close to or above 1, meaning the company generates cash at a rate equal to or faster than it generates debt. For this company my enterprise value (market cap plus debt less cash) is $162 and my equity value (market cap plus cash less debt) is $144, making my E2E Ratio, 0.89.

Risk/Reward Ratio
I determine my risk reward ratio by subtracting the current price from my terminate target 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 7.

Prior Average Valuations
My average valuation for the prior five year fiscal period was $52. The stock price during that time period averaged $106, earnings averaged $2.39 per share, and the average PE Ratio was 45. The current PE Ratio is 10.

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

To a fair value investor, consideration is given to a company’s overall financial condition including past and future earnings growth, free cash flow, both book and tangible book values, net current asset value, and many other valuation metrics in order to determine a fair value for the company as an on-going concern.

Accordingly, my most recent fair value estimate for this stock is $204. My worksheet target prices reflect this fair value estimate.

VMware, Inc. (NYSE: VMW) – FYE 02/2020 – FAIRLY VALUED – The stock is currently trading at levels above my most recent $123 initiate target, but below my most recent $327 reduce target. Please See Linked PDF Worksheet

There you are, short and, hopefully, to the point.

Wax
Revised on 05/31/2020