Any idea on why Bilcare is tanking? Is it worth looking at? As per the latest balance sheet (Sep 12) consolidated BV is 1445.92 cores or Rs. 614/share. With today's lower circuit the share price is down to 90.
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 |
Value as on Sep 12 | Liquidation Value | ||||
in Crores | Per Share | Multiplier | |||
a | Fixed Assets | 1,388.79 | 589.84 | 0.4 | 235.94 |
b | Inventories | 491.78 | 208.87 | 0.5 | 104.43 |
c | Trade Receivables | 1,004.07 | 426.44 | 1 | 426.44 |
d | Cash & Equivalents | 264.57 | 112.37 | 1 | 112.37 |
e=(a+b+c+d) | Total tangible assets | 3,149.21 | 1,337.52 | 879.18 | |
f | S.T Debt + L.T. Debt | (1,752.03) | (744.11) | 1 | (744.11) |
g=e-f | 593.40 | 135.07 |
All figures are based on consolidated balance sheet on companies website for Sep 12 Quarter.
In above chart, I have used only tangible assets and excluded assets such as intangibles, short-term loans and non-current investments. I have also used the full value of debt. Column 4 shows the BV / share to 593 and Column 6 shows liquidation value of 135 per share (arrived by multiplying column 4 by 5)
This in my opinion provides reasonable margin of safety from current price of 90. Even today there was a lower circuit and given the market sentiment we might see another one tomorrow.
Keep in mind this is a going concern and my assumptions are based on liquidation value.However, one critical factor in my assumptions is I have taken the full value of trade receivables. If we were to reduce it by 10 basis point to .9 we get the BV of these shares to 92.
Promoters have pledged 715,000 (or 3.04% of total share capital of the company) at end of Dec 12 quarter (as per the Quarterly financials on the companies website).
I have no position in these shares, but wanted to invite views of fellow boarders to see if there is any value in these shares.
-AS