Alison's New App is now available on iOS and Android! Download Now
Namaste.In last few sessions, we are studying the Analysis of Statements.So, we have in details studying the Shipping Corporation case; calculating the comparative,common size as well as trend and then we went for calculation of ratios.So, for Havells Limited we have calculated first the balance sheet ratios.Three important ratios one was current ratio, quick ratio and the third one was debt equityratio.Then for P and , we have calculated profitability as net profit after tax popularly known asNP ratio, net profit before tax ratio and also EBIDTA or cash operating profit ratio.Is it clear to you?Now, we will continue the case and try to calculate return and activity related ratioswhich pick up one figure from P and L and one figure from balance sheet.So, you have to keep both the sheets ready now.Now, first of all this profitability which is calculated as a percentage to sales naturallywe would be interested in knowing profitability on their investment which is called as returnratios.So, we would try to calculate return on equity popularly known as ROE.Do you remember the formula?Just check from the sheet.So, this is the return meant for the equity shareholders which is profit after tax.So, we will take the final profit and divided by from the balance sheet, we take the totalshareholders’ funds.I will just do it again.So, profit after tax divided by shareholders funds.So, you get 0.27 as a percentage it is better understood, it means 27 percent is the profitabilitywith respect to owners or shareholders.There has been a good change from 22 it has improved to 27 you can easily compare withnormal returns which you get from bank FD which is 8 or 9 percent.So, definitely it is a good return, but there can be scope for even higher return.Now, the other measure is ROI also known as Return On Invested or investment or ReturnOn Invested capital.So, what is a formula?Instead of taking profit after tax we will take profit before tax.And to this we are going to add the interest income if any sorry, interest expense if any.Now, here again should we take PBT or should we take profit before exceptional items?Actually it makes more sense to take profit before exceptional item because you are tryingto calculate profitability of the business; exceptional items are not regularly goingto recover, you can see it is a big amount 202.So, we will go for 711 which is in the numerator, we will put it in bracket because this isthe profit before tax and before exceptional items.To this add finance cost which is interest and such types of costs.This is the numerator and divide it from the balance sheet.We have to take shareholders funds plus borrowings ok.So, what we are doing is in the numerator we are going to take profit before exceptionalitems before taxes, add finance costs and in the denominator we have taken owners plantfirst debt.So, we got 27 percent and in all the three years it is more or less constant at 27 percent.You can see here mainly it is only because of effects of taxes that there was a slightchange.So, this was ROE and ROI.Now, let us try to calculate activity ratios.So, to know how efficiently the company is using its assets.So, we will go to balance sheet.In balance sheet, you are having fixed assets.We will compare them with sales; maybe from P and L it is easier because we have got asales figure here.This is fixed asset turnover ratio as it is known as.So, normally we will go for operating revenue total operating revenue and divide it bytotal fixed assets.So, you are getting it 5.02.Shall we convert it into percent?Actually no, it does not make sense because this is number of times; that means, you areusing your assets to generate revenue 5 times in the year.Over the period of time, you will find it is more or less constant.Although their profits the revenues are increasing slowly the fixed assets are also increasingslowly so, more or less steady fixed asset turnover ratio.Now, we can also calculate other type of turnover ratios.I will just keep them here; one is TAT that is Total Asset Turnover ratio.So, let us compare the total revenue and divide it by total of all the assets.Now, naturally the ratio has gone down because in the first ratio that is FAT, we had takenin the denominator only fixed assets.Now, we have taken all the assets.So, you can see there is a compare it to fat this is lesser ratio.It is slightly going down, but it is more or less constant.So, this is how now going for little bit of working type capital types of assets.We can calculate inventory turnover ratio.So, for inventory turnover total operating revenues divided by the value of inventorywhich is 6.93 or point 0.70 7.5 and 6.91.So, it is more or less constant.The efficiency of use of inventory had increased the bit now it has fallen.Now, would you like to convert it into number of days?It is known as inventory velocity.Let us try to do that.What is the formula?We can just transpose this take 1 upon the given inventory turnover and then multiplyit by 365.So, this is in terms of days.So, it was 52 days, then it came down to 42 days; now, again it is 52 days.So, that means, any inventory which comes in the remains with the company for 52 days.Same way it can also be done for debtors and for other assets.Now, we can calculate more ratios, but we will not go into the debt, we are going toconsider two more cases of different companies where we will calculate much more varietyof ratios.Right now let us understand two other important ratios which are already calculated; one isEPS.What is the formula?We have discussed it earlier, do you remember?That is earning per share.So, we take profit or loss for the period and divide it by number of shares.So, here you can see there was a fall in EPS from 38 to 7 and then it has increased nowto 11.45.You can check the share capital which is more or less constant.So, you can see here that this is the EPS as calculated by the company.There are no pending warrants etcetera.So, diluted EPS and basic EPS is more or less same.Equity share dividend for first two years was constant.In the current year they have increased the dividend to 374 and this is the tax on dividend.So, they have also calculated equity dividend as a percentage; as a percentage to theirnominal value of capital.So, earlier it was 300 percent now they have increased it to 600 percent.We can also calculate their dividend their EPS which is already given and we can go fortheir payout ratio; dividend payout ratio.Now, there are two ways of doing it; either we can go for DPS by EPS, but right now wedo not have the figure of DPS, but we know the total dividend.So, what we can do is take the total dividend and divide it by the available profits whichis equity dividend of the company divided by the profit for the period.So, you are getting 52 converted into percentage.So, you can see earlier company was distributing 40 percent of their profit.Now, since the profits have increased, but they have doubled the dividend, so, the percentageof distribution has gone to 52 percent.Is it good to have higher or lower ratio?There is nothing good or bad, but higher ratio signifies that company is able to companyhas decided to distribute more profits.A lower ratio we will mean that companies distributing less, but retaining the profitfor own growth.So, it depends on the strategy of the company and on the opportunities which they have ok.So, we have just calculated few important ratios here.Now, in the next problem we will go for more detailed ratio taking out a particular companyand looking for variety of aspects of that company.In the mean tile I will request you to go through the ratio sheets which are given toyou and also variety of problems which we have already discussed.Having calculated variety of ratios of profitability, return, as well as the activity, let us havea look at expense ratios.So, this is our profit and loss account.We have got number of expenses particularly the larger expense is cost of material consumed.So, it will be of interest for us to know cost of material consumed is what percentageof the revenue.So, the formula for expense ratio is that particular expense ratio divided by sales.In this case since we know the revenue from operations and we have also been given otheroperating revenue we can also take total operating revenue in the denominator.So, let us find the cost of material consumed as a percentage of total operating revenue.We are calling it Cost of Material Consumed Ratio; like that you can give it any suitablename.So, it is 0.52.It is better understood if we convert it into percentage.So, you can see it is more or less stagnant 52.89, then 53.15 and 53.95.There is no other major expense item in the P and L. The largest expense was materialconsumed.So, that is what is required that is the way we can also link other items, but still letus link one more item that is employee benefit expense ratio.So, you can see over the period of three years it has increased.It is almost 7 percent; now earlier it was 5.28 percent.So, these were important expense ratios.Now, let us go to cash flow statement.In cash flow we have got cash flows categorized into three.So, the most important of that is cash from operating activities.Let us see what percentage of revenue it is.So, cash from operating activities as a percentage of revenue.Now, it is logical for us to take revenue from operations or total operating revenue.So, let us take total operating revenue.We get 0.09.So, total operating revenue was 5436 and the cash from that revenue of course, we haveincurred variety of expenses.The final cash which came into hand of business was 0.09 as a percentage it becomes 9.64.So, you can see slightly very some figure here.What was 13 percent in March 14 become 11 percent and now it is about 9.6 percent.So, there is a fall in the ratio of cash from operations as a percentage of operating revenue.One can also link the net cash from operating revenues to the operating profits.So, if you go to P and L, we have got profit before exceptional and extraordinary itemsto that if we add finance costs we will get profit before interest and taxes.So, we get 72 percent.So, out of the profits which we are reporting 72 percentage available as cash from operationsfor the business.There also you see a drop.Earlier it was more than 100 percent, then it became 90 and now it is 72, which meansthat lesser amount is now getting realized as a cash which is not a very positive ofvalue for the business.Like that you can calculate a few cash flow ratios.Of course, most of the important ratios are on the side of P and L where a different typeof ratios can be calculated on P and L. So, we will stop here.Namaste.Thank you.
Log in to save your progress and obtain a certificate in Alison’s free Diploma in Financial Accounting online course
Sign up to save your progress and obtain a certificate in Alison’s free Diploma in Financial Accounting online course
Please enter you email address and we will mail you a link to reset your password.