After the introduction of the “canned” EV (see https://www.portfolio123.com/mvnforum/viewthread_thread,5710),
I am interested to revisit the ratio. According to the wikipedia article (Enterprise value - Wikipedia):
The portfolio 123 EV is defined as (quoting Marco):
For a long time I had been using
as a proxy to EV, mainly because the other items were not available at the time. I have found the original formula seems to work better than the new EV factor, even though it is “less correct”. Partly I have noticed the new factor contains a lot more NAs, possibly because the required items are NA, possibly because the of the following problem:
The wikipedia article makes it very clear for each of the item’s listed, it must be at market value. However, when we are listing items to add we typically rely on balance sheet values. Sometimes balance sheet entries can have stark differences between the recorded value (often at cost or at “par”) and the market value. A company may have bought an office building in 1900 for $10,000, and it may still sit on the balance sheet as that despite clearly being worth millions now.
The way I see it, I look at enterprise value from the point of view of an acquiring company - someone interested in buying the whole business. (Buffet said imagine buying the whole business when you buy a stock). The EV is meant to be the “true” cost of the business, not just paying off the equity holders but all other interested parties too. For the debt holders, paying them off at par seems a reasonable approximation. At the very least, if the debt is acquired by the incoming company, the debt will adjust itself to the credit status of the acquirer and knowing the market value pre-acquisition is less important.
The preferred equity is a bit more problematic. This cannot be redeemed at par, it would have to be bought back at market value, and this may be very different from the par value recorded on the balance sheet (presumably this is what PfdEquity is). My proposal is to “infer” the value of the preferred equity by taking the Preferred Dividend, guessing the preferred yield and back-calculating the preferred equity value:
Preferred Equity = Preferred Dividend / Preferred Dividend Yield
Unfortunately it still looks like Preferred Yield is an unknown, so I make a guess, take the 30 year yield (as a proxy to the “zero” rate), and add a risk premium (RP).
Preferred Equity = Preferred Dividend / (30 year yield + RP)
In p123 language I think that is:
= 100*(PfdDivQ / ((close(0,#Bond30Yr)+RP))
What value for the RP? This is harder - I am thinking we could do with knowing the credit rating of the company, or perhaps it does not matter since if we are the the position of an acquirer, the preferred yield would (post acquisition) be based on our own credit rating, so for the purposes of comparison (ranking) it does not matter. I am going to experiment with values from 1% to 5%. Perhaps one could use the “AvgRec”, since this happens to run from 1-5 (best-worst)!
I’d be interested in hearing opinions. As for “non controlling interest”, this seems a bit of a black box and I am having some more trouble tackling this one. I thought the post (https://www.portfolio123.com/mvnforum/viewthread_thread,5447#36772) that contained the formula:
Looks like an interesting start. Perhaps using a similar approach the Minority interest can be backed out. Or perhaps not, opinions welcome!