In this post, let's analyse the basic parameters of Vedanta Limited. We will be analysing the company using three different methods which can get us clarity about the company.
The first method will be to check the financial strength and other key parameters of the company. We named this ‘Graham Method’. These criteria have been derived from the great Benjamin Graham, the author of Intelligent Investor. These criteria can give clarity whether it is fruitful for us to consider the stock for valuation.
Values are as of 2019
Graham Checklist:
In the first of the Graham’s method, which is called Net-Net by him, we won’t mostly find many companies. The method that suits today’s world will be the second one. Below are these parameters for Vedanta Limited.
| Graham Stock pick method | Values | Check | |
| Method 1 | |||
| One check pick | 1. Current market price less than 67% of the Net current assets 2. Net current assets = (Current assets – Total Liabilities) / Number of outstanding shares |
||
| Current Price | 82.65 | NO | |
| Fixed Assets | 1,42,215 | ||
| Current Assets | 59,828 | ||
| Fixed Liabilities | 47,878 | ||
| Current Liabilities | 76,641 | ||
| Total number of shares | 372.00 | ||
| Check Value | -116.51 | ||
| Method 2 | |||
| 1. Size of the company | Sales at least more than 200 crores. | ||
| Latest Annual Sales | 90,901 | YES | |
| 2. Strong financial stability | 1. Current assets must be at least twice current liabilities 2. Long term or Fixed liabilities must be less than net current assets (Current assets – current liabilities) |
||
| Fixed Assets | 1,42,215 | ||
| Current Assets | 59,828 | 1. NO | |
| Current Liabilities | 76,641 | ||
| Fixed Liabilities | 47,878 | 2. NO | |
| 3. Earnings Stability | Should have positive earnings for past 10 years at least. May be we can reduce this to 5 years for Indian market | NO | |
| 4. Dividend record | Should have paid dividend for last 10 years uninterrupted. May be we can reduce this to 5 years for Indian market | YES | |
| 5. Earnings Growth | Average earnings should have increased by at least 30%. We can increase it to 100% to be on safe side | ||
| Current Earnings | 10.62 | NO | |
| Earnings before 10 years | 8.55 | ||
| Check Value | 24.14% | ||
| Financial Ratios | |||
| 6. Moderate Price/Earnings Ratio | PE ratio should be at least less than 14 (which means at least 7% return) | 7.78 | |
| 7. Moderate Ratio of Price to Assets | PB ratio should be less than 1.5 or may be 2 | 0.40 | |
| 9. Moderate Ratio of Debt to Equity | Debt to Equity ratio should be less than 1 | 1.61 | |
| 10. Moderate Return on Equity | At least 20 % | 5.10% | |
| 11. Moderate Return on Total Assets | At least 15 % | 1.96% | |
| 12. Moderate Earnings growth rate | At least 15 % | 2.19% | |
Asset Based calculation method:
Next is called the Asset based calculation. In this we consider the last four financial year earnings to average them and arrive at a reasonable earning capacity of the company. Then we calculate how much is needed to earn that cash flow at a nominal 7% interest rate. This forms one part. The next is net cash in hand. That is calculated by subtracting the total liabilities from financials assets in hand because they are the highly liquid form of asset. The same is given below for Vedanta Limited.
| Earnings calculation | |||
| Income from operations | 86,009 | ||
| - Expenses | 76,422 | ||
| Income before tax | 9,586 | ||
| - Tax | 4,506 | ||
| Income after tax | 5,081 | ||
| + Depreciation and Amortization | |||
| + Profit from associates and Joint ventures | |||
| - Maintanence Capital expenditure | |||
| Distributable cash flow | 5,081 | ||
| Excess Cash Calculation | |||
| + Fixed financial assets | |||
| Investments | 4,891 | ||
| Other financial assets | 1,083 | ||
| + Current financial assets | |||
| Investments | 28,174 | ||
| Cash and Cash eq | 7,289 | ||
| Bank balance | 1,080 | ||
| Other financial assets | 2,482 | ||
| - Total debt | |||
| Fixed liabilities | 47,878 | ||
| Current liabilities | 76,641 | ||
| Total | -79,520 | ||
| Investment needed @ | Capital needed | + excess cash | Per share value |
| 7.50% | 67,742 | -11,778 | -31.66 |
| Without Considering Liabilities | 89.30 | ||
Buffet method:
The last method is called the Buffet Method. We named this method as such because we consider how the great Warren Buffett assesses a company before buying. We calculate the free cash flow by starting at the net income, adding the depreciation, subtracting the borrowings (spanned across 10 years) and the average capital expense over last four years. With this when we estimate the future cash flow for the company for next 10 years and find out the current value for it, we can attain an intrinsic value using this method. For Vedanta Limited, it is as given below.
| Vedanta Limited | |
| Current Market Price | 82.65 |
| 4 year average profit | 10.62 |
| 4 year average D&A | 18.61 |
| 4 year average capital expense | 19.53 |
| Borrowings deduction | 15.51 |
| Free cash flow every year | -5.81 |
| Earnings in first 3 years | 8.55 |
| Earnings in recent 3 years | 10.62 |
| Earnings growth in 10 years | 1.24 |
| Profit after 10 years | 13.18 |
| Value after 10 years | 184.54 |
| Year | Current value of money |
| 1 | -5.41 |
| 2 | -5.03 |
| 3 | -4.68 |
| 4 | -4.35 |
| 5 | -4.04 |
| 6 | -3.76 |
| 7 | -3.50 |
| 8 | -3.25 |
| 9 | -3.02 |
| 10 | 86.50 |
| Current Value: | 49.46 |
To check the intrinsic value and complete fundamental analysis, please see the video below
No comments:
Post a Comment