Sign up for Equitymaster's free daily newsletter, The 5 Minute WrapUp and get access to our latest Multibagger guide (2017 Edition) on picking money-making stocks.

This is an entirely free service. No payments are to be made.

Download Now Subscribe to our free daily e-letter, The 5 Minute WrapUp and get this complimentary report.
We hate spam as much as you do. Check out our Privacy Policy and Terms Of Use.
Dupont Analysis of Telecom Companies - Views on News from Equitymaster
  • E-MAIL
  • A  A  A
  • Mar 16, 2007

    Dupont Analysis of Telecom Companies

    Return on equity is a measure that most investors are greatly concerned about as it is a measure of what return the company is able to generate on the shareholders money. While there is no doubt as to its relevance, the return can in itself be broken down into three components to further analyse how these returns were earned and what mainly helped in generating the same. The ratio helps to understand where superior (or inferior) return is derived from, by breaking it down to its components.

    How the Dupont works

    Dupont breaks down the return on equity into three components with various balance sheet items canceling each other out due to cross multiplication and ultimately yielding profit after tax divided by equity. However in the process, we also do come to know how each item has performed individually. It is calculated as follows:

    Return on Equity = (PAT/Revenues) * (Revenues/Total Assets)* (Total Assets/Equity)

    Thus one is able to gauge three different points of performance, for the company.

    PAT/Revenues: This is the measure of the company's profitability to show what kind of profit margins the company has been able to generate which is indicative in a limited sense of its pricing ability and cost control when compared with its own performance and with the performance of other companies.

    Revenue/Total Assets: The asset turnover ratio is indicative of how efficiently the company has managed to utilise its assets. A high ratio as compared to others is indicative of the company being able to put its assets to more productive use as compared to other companies.

    Total Assets/Equity: This ratio is known as the equity multiplier. It is indicative of the leverage employed by the company. It shows how much reliance the company has been putting on debt to finance its assets. While we are not suggesting that debt is bad for a company too much of it can put the company in trouble when headwinds get generated in an industry.

    Having this basic understanding of what return on equity is, we will now proceed to apply it to various companies in the telecom sector to analyse their performance over the past five years.

    Idea Cellular Limited

    The company has had to book losses over the past few years and hence arriving at its return on equity for the initial years was not possible. However the Dupont analysis does throw up some interesting observations. The company has turned profit positive over the past two years and has since seen its ROE double during this period. This it has been able to attain mainly on account of an improved asset utilisation due to an increase in its sales over the years. However, the company still has got plenty of potential for improving its performance by laying an emphasis on increasing profits and generating more cash flows to fund its assets internally. Hopefully, in the near term, we may see this happening as the company expands it subscriber base. The most worrisome feature about the company is that it has placed heavy reliance on the use of debt to finance its assets over the past five years.

    Bharti Airtel

    Bharti Airtel has been the most consistent performer of the lot. The company has significantly improved its performance to become the company with the highest ROE. The company has over the years acquired the largest market share of the total wireless subscribers in India. This is also reflective in its ability to significantly boost its revenues, which has led to better utilisation of its assets. Also, the profit margins for the company have risen significantly. The increase in the company's revenues has been faster than the increase in its assets, which has led to economies of scale that has ultimately reflected in its asset turnover ratio. The good performance is also the result of a judicious mix of debt and equity to finance the assets, which creates a tax shield on interest expense leading to higher profit after tax but at the same time, does not put it in jeopardy, just in case things take a turn for the worse.


    The company has had the best performance record for utilisation of its assets. However, this is on account of the fact that the company has not been spending very aggressively on creating assets in the recent past. But of late, the performance of its asset utilisation ratio has trended downwards which could be attributable to the recent acquisition made by the company that has caused its asset base to swell considerably while its sales have not increased in line with the assets.

    What's worrisome is the fact that the company has seen a significant decline in its profit margins over the past years. Thus, it has gone from being a company with the highest ROE to one that has the lowest ROE today. The company has another good to it that is it has over the years managed to reduce its financial leverage by reducing the reliance on debt to fund its assets. This is evident from a trailing equity multiplier. The company has had a bad year in terms of profit after tax as they tumbled form Rs 7.1 bn in FY05 to just Rs 698 m in FY06, which has dented its ROE significantly. However this is mainly a result of the integration of Tyco and Teleglobe, which the company had acquired in 2004 and 2005 respectively. As the company manages to turn around the performance of these acquired companies, one can expect to see a rise in its profit ratios and hence ROE.


    The company has seen its profit margins erode away significantly, mainly due to the heat that it is feeling form the private players in the Mumbai and Delhi circles where it operates. Although it continues to maintain a dominant position in the fixed line segment, it has not been able to stem the decline in its fixed line connections over the years. It is no wonder then that its profit margins have dwindled. The company has been rather consistent in its asset turnover performance but this is a result of a fall in its revenues and asset base over the years. Also the reduction in equity multiplier which would otherwise have been a good move for the company is in fact turning out to be a disadvantage and concern owing to the fact that its assets have reduced consistently while its share holders equity has only increased marginally. A culmination of these factors is that the company's ROE has come down significantly over the past five years.

    Tata Teleservices Maharashtra Limited (TTSL)

    The company has been able to improve its asset utilisation on the back of improved sales over the years. The asset base has also increased significantly, which has been again financed by a judicious mix of debt and equity but it does need to exercise caution so as to ensure that its debt to equity ratio does not spiral out of control. However, the company has had negative profits as a result of which, it was not possible to arrive at the ROE.


    To sum it all up, Bharti Airtel (although not the best performer individually in all the components of Dupont analysis) has been the best performer over the past five years with the highest ROE amongst the companies compared. Not only has it improved its profitability and asset utilisation ratios, it has also judiciously used the debt to finance its assets. This has helped the company to improve its ROE each year.



    Equitymaster requests your view! Post a comment on "Dupont Analysis of Telecom Companies". Click here!


    More Views on News

    Bharti Airtel: A Good Quarterly Performance (Quarterly Results Update - Detailed)

    May 6, 2016

    Bharti Airtel has reported a8.4% YoY growth in the topline and an increase of 2.8% YoY in the bottomline for the quarter ended March 2016.

    Bharti Infratel: Ends the Year Positively (Quarterly Results Update - Detailed)

    Apr 27, 2016

    Bharti Infratel has reported a 7.3% YoY growth in the topline and an increase of 18.7% YoY in the bottomline for the quarter ended March 2016.

    Bharti Infratel: A Good Quarter (Quarterly Results Update - Detailed)

    Apr 8, 2016

    Bharti Infratel has reported a 4.9% YoY growth in the topline and an increase of 11.5% YoY in the bottomline for the quarter ended December 2015.

    More Views on News

    Most Popular

    This Small Cap Can Drive Chinese Players Out of India (and Make a Fortune in the Process)(The 5 Minute Wrapup)

    Aug 17, 2017

    A small-cap Indian company with high-return potential and blue-chip-like stability is set to supplant the Chinese players in this niche segment.

    The Most Important Innovation in Finance Since Gold Coins(Vivek Kaul's Diary)

    Aug 10, 2017

    Bill connects the dots...between money and growth, real money and real resources, gold and cryptocurrencies...and between gold, cryptocurrencies, and time.

    It's the Best Time to Buy IT Stocks(Daily Profit Hunter)

    Aug 16, 2017

    The IT Sector could be in an uptrend till February 2019. Are you prepared to ride the trend?

    Bitcoin Continues Stellar Rise(Chart Of The Day)

    Aug 10, 2017

    Bitcoin hits an all-time high, is there more upside left?

    5 Steps To Become Financially Independent(Outside View)

    Aug 16, 2017

    Ensure your financial Independence, and pledge to start the journey towards financial freedom today!

    Copyright © Equitymaster Agora Research Private Limited. All rights reserved.
    Any act of copying, reproducing or distributing this newsletter whether wholly or in part, for any purpose without the permission of Equitymaster is strictly prohibited and shall be deemed to be copyright infringement.

    LEGAL DISCLAIMER: Equitymaster Agora Research Private Limited (hereinafter referred as 'Equitymaster') is an independent equity research Company. Equitymaster is not an Investment Adviser. Information herein should be regarded as a resource only and should be used at one's own risk. This is not an offer to sell or solicitation to buy any securities and Equitymaster will not be liable for any losses incurred or investment(s) made or decisions taken/or not taken based on the information provided herein. Information contained herein does not constitute investment advice or a personal recommendation or take into account the particular investment objectives, financial situations, or needs of individual subscribers. Before acting on any recommendation, subscribers should consider whether it is suitable for their particular circumstances and, if necessary, seek an independent professional advice. This is not directed for access or use by anyone in a country, especially, USA or Canada, where such use or access is unlawful or which may subject Equitymaster or its affiliates to any registration or licensing requirement. All content and information is provided on an 'As Is' basis by Equitymaster. Information herein is believed to be reliable but Equitymaster does not warrant its completeness or accuracy and expressly disclaims all warranties and conditions of any kind, whether express or implied. Equitymaster may hold shares in the company/ies discussed herein. As a condition to accessing Equitymaster content and website, you agree to our Terms and Conditions of Use, available here. The performance data quoted represents past performance and does not guarantee future results.

    SEBI (Research Analysts) Regulations 2014, Registration No. INH000000537.

    Equitymaster Agora Research Private Limited. 103, Regent Chambers, Above Status Restaurant, Nariman Point, Mumbai - 400 021. India.
    Telephone: +91-22-61434055. Fax: +91-22-22028550. Email: info@equitymaster.com. Website: www.equitymaster.com. CIN:U74999MH2007PTC175407

    Become A Smarter Investor In
    Just 5 Minutes

    Multibagger Stocks Guide 2017
    Get our special report, Multibagger Stocks Guide (2017 Edition) Now!
    We will never sell or rent your email id.
    Please read our Terms


    Aug 23, 2017 (Close)