In most cases, simply entering the text you are looking for will suffice. For more advanced queries, you can use modifiers. Some examples below:
| MagicDiligence | -1.14% |
| S&P 500 ETF | -5.87% |
| OUTPERFORM | 4.72% |
68% of our picks outperform the market.
Take a FREE Trial!
Updated daily. All values annualized from Jan. 2008.
Let's start by examining the "how" first, as it will help to explain the "why". The MFI formula for calculating enterprise value is:
Enterprise Value = Market Capitalization + Total Debt - Excess Cash
Most of this is straightforward. Market Capitalization is simply share price * number of shares, and is widely available. Total debt is all long and short term debt obligations from the balance sheet. The last operand, "Excess Cash", deserves a little explanation as it requires a bit of calculation. The idea is to use only the portion of the company's cash holdings that is not required to meet short term liabilities, should the need arise. Therefore, the calculation looks like:
Excess Cash = Total Cash - (Current Liabilities - Current Assets - Total Cash)
If Current Non-Cash Assets cover Current Liabilities, then Excess Cash is just the cash holdings with no adjustments. I know this is a bit confusing but it makes sense with a little thought. For example, if you have $500 in cash but need to pay a $100 credit card bill tomorrow, really you only have $400 in excess cash that you can freely spend.
So that's the "how" part. Now, the "why" part. Clearly, using enterprise value instead of market capitalization to calculate valuation statistics provides significant value, because it penalizes companies with a lot of debt and low cash balances, while rewarding companies with low debt and lots of cash. These low-debt, high-cash companies are higher quality as they can more easily survive an economic downturn or business problems, and have more flexibility in how to reward shareholders. With lots of cash and little debt, the company can pursue growth through new business lines or acquisitions, and can afford to buy back more shares or pay a higher dividend. On the other hand, those with high debt and low cash suffer the loss of profits through interest payments, and are also at risk of bankruptcy if business goes south and they can no longer afford to cover interest obligations.
Perhaps the usefulness of enterprise value is best illustrated by example. Let's take two recent Magic Formula stocks, one that has a lot of cash and little debt, the other with lots of debt and little cash. First, let's use the traditional Market Capitalization valuation:
| Metric | Barrett Business (BBSI) | Deluxe (DLX) |
|---|---|---|
| Price-to-Earnings | 12.12 | 3.51 |
Using P/E, there is little question that Deluxe looks substantially cheaper than Barrett. In fact, most stock screens would never even turn up Barrett as a very cheap stock, as 12x earnings is currently right about at the market multiple. However, using Enterprise Value tells a different story:
| Metric | Barrett Business (BBSI) | Deluxe (DLX) |
|---|---|---|
| EV-to-Earnings | 5.96 | 12.65 |
The tables completely turn! Why is this? The reason is simple. Barrett Business Services is a very financially sound company, with over $46 million in excess cash on the balance sheet, and no debt. Given a market capitalization of $90 million, this takes enterprise value under $50 million, and makes the company's current valuation as a going concern very low. On the other hand, Deluxe has a cash shortfall of $150 million (it relies on ongoing free cash flow to cover short-term liabilities), plus nearly $900 million in debt. While the market capitalization of about $400 million looks low against Deluxe's earnings, enterprise value balloons the cost of this company to over $1.4 billion dollars, quite a significant change! If you would have used enterprise value screening techniques in the first place, you never would have had to dig into Deluxe's balance sheet to discover it's weak financial status... the stock screen would have already done it for you!
By using enterprise value instead of market cap, Greenblatt's Magic Formula screen mechanically throws out many apparently cheap stocks, but with very weak balance sheets. Deluxe had to meet a much lower price standard than Barrett to earn it's way into the MFI screen.
Calculate Magic Formula statistics for any stock with the MFI Stats Calculator tool.
Earn money promoting MagicDiligence! Affiliate program is now available!.
Lower your risk and increase your returns. A MagicDiligence Membership provides you with in-depth research on the very best stocks in the Magic Formula screen today. Avoid the value traps and get in on the truly great companies. Completely free 30-day trial!
Comments
Posted by cookedc on 2009-03-09 21:17:23
Steve,Posted by Steve on 2009-03-10 04:54:17
Thanks for pointing out the mistype. It's been fixed.Posted by jonathan on 2009-03-31 13:18:28
Still wrong. For example, cash is $2, liabilities=$2 and assets=$0, and excess cash should be $0. You have it as $2-MAX($0,$2-$0-$2)=$2.Posted by Steve on 2009-03-31 14:09:38
Yes, that's right. In the above one, my formula should actually have been:Login to Post A New Comment: