Wednesday, July 22, 2020

Sun TV Limited - Fundamental Analysis and Intrinsic Value Calculation

In this post, let's analyse the basic parameters of Sun TV 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:

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 376.75 NO
Current Assets 4,044
Fixed Liabilities 118
Current Liabilities 549
Total number of shares 39.40
Check Value 57.42
Method 2

1. Size of the company Sales at least more than 200 crores.
Latest Annual Sales 3,782 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)
Current Assets 4,044 1. YES
Current Liabilities 549
Fixed Liabilities 118 2. YES




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 YES




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 30.44 NO
Earnings before 10 years 17.16
Check Value 77.42%




6. Moderate Price/Earnings Ratio PE ratio should be at least less than 14 (which means at least 7% return) YES




7. Moderate Ratio of Price to Assets PB ratio should be less than 1.5 or may be 2 NO

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 Sun TV Limited.

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 Sun TV Limited.


Earnings calculation


Income from operations 2,966

- Expenses 1,442

Income before tax 1,524

- Tax 518

Income after tax 1,006

+ Depreciation and Amortization


+ Profit from associates and Joint ventures


- Maintanence Capital expenditure


Distributable cash flow 1,006









Excess Cash Calculation


+ Fixed financial assets



Investments 261

Other financial assets 13.51
+ Current financial assets



Investments 2093

Cash and Cash eq 378

Bank balance 214

Other financial assets 170
- Total debt



Fixed liabilities 118

Current liabilities 549

Total 2462.4












Investment needed @Capital needed + excess cash Per share value
7.50% 13,413 15,876 402.94

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 Sun TV Limited, it is as given below.

Sun TV
Current Market Price 39.40
4 year average profit 25.53
4 year average capital expense 14.21
Free cash flow every year 11.32
Earnings in first 3 years 17.16
Earnings in recent 3 years 30.44
Earnings growth in 10 years 1.77
Profit growth after 10 years 45.30
Value after 10 years 634.20


Year Current value of money
1 10.53
2 9.79
3 9.10
4 8.47
5 7.87
6 7.32
7 6.81
8 6.33
9 5.89
10 312.42
Current Value of SunTV: 384.54


To check the intrinsic value and complete fundamental analysis, please see the video below

https://youtu.be/EmXJDkllF-w

Disclaimer: We are not SEBI approved Research Analyst or Investment Advisors. Please don't buy based only on our analysis. Do consult your financial advisor before investing.




No comments:

Post a Comment