Nov 27, 2007

“Worst Case Scenario Valuation” for CPY …….

In the previous three posts I discussed the following points:

-reported earnings are substantially lower than operating earnings due to acquisition accounting

-sittings at Sears are still falling at almost a 10% clip and CPY can only raise prices by 5% so this is a serious problem, however EBITDA for Sears is still growing and both gross and sg&a margins are improving YoY

-CPY’s management will be using the Sears blue print for the acquired Wal-Mart business with a realistic chance that this company can generate $80M - $90M in EBITDA in 2010 and has a market value under $200M with $71M in net interest bearing long term debt

-Knightspoint (aka Ramius) increased their stake by 75% as the stock fell ….basically, very smart people who control the company and know the most about it are doubling down

Alright, here comes the fun part – what does valuation look like? In this post I will try to assign a “WORST CASE SCENARIO” price to CPY shares.

Here are my WORST CASE SCENARIO assumptions ……

-by the end of 2009 the PCA acquisition has proved to be a complete failure

-CPY’s management losses focus and the Sears business sees a decline in EBITDA to $40M per year – from $45M over the last 12 months -- so FCF comes in at $26 ($40 - $5 Capex - $9.2M in tax assuming $14M in D&A) in 2009

-there is no improvement in Wal-Mart EBITDA for the next two years (I think this is extremely conservative since they will surely improve EBITDA by just closing underperforming stores)

-CPY is forced to sell the Wal-Mart business at ½ acquisition price of $82.5M + ½ of the money invested in digital equipment which is targeted to be $38M …..non of PCA’s NOL’s are used or valued under this scenario

Under this worst case scenario, over the next 2 years CPY would use most of its FCF for the digital upgrade at Wal-Mart. CPY would than sell the Wal-Mart business at ½ its total investment and be left with just the Sears business which is now earning less due to loss of focus. Here is how the numbers look……


(I know that the picture is hard to read .....if you double click on it it will enlarge....if you want the excel version shoot me an email at offthebeatenpathinvestments@gmail.com)

Unless I am completely missing something, at current price of $25 per share we get to buy a stock that will have an estimated cash yield of 13% even if a lot of things go wrong. At $21 per share the forward cash yield is at 15%. If you are targeting a cash yield of 10% your buy point is $34 per share which is 20%+ above trading price.


* DISCLOSURE: I or accounts I manage may be long or short any and/or all stocks mentioned in this post. This is not a recommendation to buy or sell any security. For informational and educational purposes only.

No comments: