Profitability Analysis of Indian Information Technology Companies using DuPont Model
Praveen Gujjar J1, Dr. T. Manjunatha2
1Research Scholar, Visvesvaraya Technological University, Belagavi–590 018 Karnataka, India.
2Professor and Head, Dept. of M B A, Visvesvaraya Technological University, B D T College of Engineering, Davangere-577 004, Karnataka, India.
*Corresponding Author E-mail: gujjarpraveen@gmail.com, tmmanju87@gmail.com
ABSTRACT:
The purpose of a business organization is to make profit. The profitability analysis is done to throw light on the current operating performance and efficiency of business firms. The study covers three Information Technology companies viz Prism informatics, Frontier Info and STG Lifecare listed on BSE India. The study has been undertaken for the period of Six years from 2010 to 2015 and the necessary data has been obtained from capital line database. Financial performance of a firm which is assessed using profitability ratios like return on asset (ROA) returns on sales (ROS). We have also focuses on the DuPont model and calculated return on equity (ROE) to help investors to identify the nature of Indian Information technology companies and will also help to take decision regarding investment. To identify the relationship between Prism informatics, Frontier Info, STG Lifecare ROS, ROA and ROE the correlation coefficient has been calculated and results have been outlined in this paper.
KEYWORDS: DuPont Analysis, Return on sales, return on asset, return on equity, profit margin.
1. INTRODUCTION:
Profit has no relevance to compare the efficiency of a business organization. A very high profit does not always indicate sound organizational efficiency and low profitability is not always a sign of organizational sickness. Therefore, it can be said that profit is not the prime variable on the basis of which the operational efficiency and financial efficiency of an organization can be compared. To measure the productivity of capital employed and to measure operational efficiency, profitability analysis is considered as one of the best techniques. The word ‘Performance’ means ‘the performing of an activity, keeping, in view the achievement made by it’.
In other words, ‘Performance’ means ‘the role Played by an arrangement keeping in view the achievement made by it’. In the context of the Information Technology, it takes into account the way of their progress. Nathwani et al (2004) performance’ is described as the efforts extended to achieve the targets efficiently and effectively, the achievement of targets involves the integrated use of human, financial and natural resources. Financial performance is the process of measuring the results of an organization policies and operations in terms of monetary value. These results are reflected in the firm's profitability, liquidity or leverage. Evaluating the financial performance of a business allows decision-makers to judge the results of business strategies and activities in objective monetary terms. Normally the ratios are used to determine the financial performance of an organization. A well designed and implemented financial management is expected to contribute positively to the creation of a firm’s value Padachi (2006). Ultimate goal of profitability of a firm can be achieved by efficient use of resources. It is concerned with maximization of shareholders or owners wealth Panwala (2009). financial performance evaluation is traditionally based on the analysis of financial ratios such return on equity (ROE), return on assets (ROA), net interest margin (NIM), capital asset ratio, growth rate of total revenue, cost/income ratio. Hanson, Parsons, Musser, and Power (1998) evaluated a financial management outreach program through the use of a survey. The survey asked participants the average value of the impact of the workshop tools to their farm budgeting and planning.
2. OBJECTIVES AND METHODOLOGY:
2.1 We have set following objectives
· To evaluate the return on equity with the help of return on assets and return on sales.
· To test the relationship among Indian Information Technology companies.
2.2 Data and methodology:
This study was based on three Indian Information Technology Companies viz Prism informatics, Frontier Info and STG Life care listed in BSE India. Study has been taken for the period 2010-2015. Return on Equity (ROE) is a financial ratio that refers to how much profit a company earned compared to the total amount of shareholder equity invested. ROE is what the shareholders look in return for their investment. Khrawish (2011) said that ROE is the ratio of Net Income after Taxes divided by Total Equity Capital. ROE is an internal performance measure of shareholder value, and it is by far the most popular measure of performance, since: (i) it proposes a direct assessment of the financial return of a shareholder’s investment; (ii) it is easily available for analysts, only relying upon public information; and (iii) it allows for comparison between different companies or different sectors of the economy. ROE is sometimes decomposed into separate drivers: this is called the “DuPont analysis”, where ROE=(result/turnover)*(turnover/total assets)*(totalassets/equity).
ROE shows whether management is growing the company's value at an acceptable rate. Also, it measures the rate of return that the firm earns on stockholder’s equity. ROE is helpful for investors to identify the nature of Indian Information technology companies and will also help to take decision regarding investment. Return on Sales (ROS) measures how profitable a firm’s sales are after all expenses, including taxes and interest, have been deducted. Return on assets (ROA) offers a different take on management effectiveness and reveals how much profit a company earns for every amount of its assets. To identify the relationship between the ROS, ROA and ROE the correlation coefficient CORREL has been calculated. As the value approaches 1 the connection is very strong; as the value approaches 0 it is the weakest link.
3. RESULTS AND ANALYSIS:
Table 1 shows DuPont Analysis of Prism informatics. Return on Equity (ROE) of the Prism informatics in the year 2010 is 0.02. From the year 2013 ROE of the company is gradually decreasing. In the year 2011 ROE is 0.16 which is slightly good as compared with other financial year during the study period. ROA is gradually decreases during the study period and ROS is gradually increases during the study period.
Table 2 shows DuPont Analysis of Frontier Info. ROE of the company in the year 2010 is-0.94. In the year 2012 ROE is 2.08 which is slightly good as compared with other financial year during the study period for the company. In the year 2012 ROA is 3.15 and it gradually decreases in the following year during the study period. In the year 2011 ROS is 1.45 and it gradually decreases in the following year during the study period.
Table 3 shows DuPont Analysis of STG Lifecare. ROE of the company in the year 2010 is-0.01. In the year 2012 ROE is 0.02 which is slightly good as compared with other financial year during the study period for the company STG Lifecare. In the year 2011 ROA is 0.01 and it gradually decreases in the following year during the study period. In the year 2011 ROS is 0.27 and it gradually decreases in the following year during the study period.
Table 4 shows Correlation testing of Prism informatics with Frontier Info and STG Life care. It has been observed that between Prism informatics ROE and Frontier info ROE there is a strong relationship but Prism informatics ROS and STG Life care ROS there is a weak relationship.
Table 5 shows Correlation testing of Frontier Info with Prism informatics and STG Life care. It has been observed that between Prism informatics ROS and Frontier info ROE there is a strong relationship but Frontier info ROE and STG Life care ROE there is a weak relationship.
Table 6 shows Correlation testing of STG Life care with Prism informatics and Frontier Info it has been observed that between Prism informatics ROE and STG life care ROE there is a strong relationship but Prism informatics ROS and STG Life care ROE there is a weak relationship.
Table 7 shows Correlation Coefficient of Prism informatics among ROS, ROA and ROE it has been observed that between ROE and ROA there is a strong relationship but ROS and ROE there is a weak relationship.
Table 8 and 9 shows that ROE and ROA there is a strong relationship but ROS and ROE there is a weak relationship for the company Frontier Info and STG Lifecare.
Table 1: Shows Financial analysis of Prism informatics with DuPont Ratio
Year |
Net Profit Margin |
Asset Turnover |
Equity Multiplier |
Return on Equity |
Return on asset |
Return on sales |
2010 |
0.254335 |
0.090104 |
1.276596 |
0.029255 |
0.02 |
0.09 |
2011 |
0.230724 |
0.467424 |
1.491729 |
0.160877 |
0.10 |
0.46 |
2012 |
0.075074 |
0.528022 |
1.519585 |
0.060237 |
0.03 |
0.52 |
2013 |
-0.33291 |
0.383477 |
1.454352 |
-0.18567 |
-0.12 |
0.38 |
2014 |
-0.18316 |
0.402679 |
1.200244 |
-0.08852 |
-0.07 |
0.40 |
2015 |
-3.09952 |
1.143414 |
3.39418 |
-12.0291 |
-3.54 |
1.14 |
Note: We have calculated ROE using DuPont model as mention in the methodology in Table1. Similar explanations hold good for remaining Tables 2-3.
Table 2: Shows Financial analysis of Frontier Info with DuPont Ratio
Year |
Net Profit Margin |
Asset Turnover |
Equity Multiplier |
Return on Equity |
Return on asset |
Return on sales |
2010 |
-2.11392 |
0.371765 |
1.200565 |
-0.9435 |
-0.79 |
0.37 |
2011 |
-1.34171 |
1.452555 |
1.574713 |
-3.06897 |
-1.95 |
1.45 |
2012 |
-4.77143 |
-0.66038 |
0.6625 |
2.0875 |
3.15 |
-0.66 |
2013 |
-0.15556 |
0.6 |
-0.86207 |
0.08046 |
-0.09 |
0.60 |
2014 |
-6.25 |
0.04878 |
-0.73214 |
0.223214 |
-0.30 |
0.04 |
2015 |
-5.2 |
0.079365 |
-0.45652 |
0.188406 |
-0.41 |
0.07 |
Table 3: Shows Financial analysis of STG Lifecare with DuPont Ratio
Year |
Net Profit Margin |
Asset Turnover |
Equity Multiplier |
Return on Equity |
Return on asset |
Return on sales |
2010 |
-0.02301 |
0.324496 |
2.157937 |
-0.01612 |
-0.01 |
0.32 |
2011 |
0.037791 |
0.276194 |
2.140034 |
0.02233 |
0.01 |
0.27 |
2012 |
-2.09375 |
0.039522 |
2.335577 |
-0.19327 |
-0.08 |
0.03 |
2013 |
-0.84459 |
0.063519 |
2.549234 |
-0.13676 |
-0.05 |
0.06 |
2014 |
11.45455 |
-0.00511 |
2.736976 |
-0.1601 |
-0.06 |
-0.01 |
2015 |
-126 |
0.000452 |
3.204348 |
-0.18261 |
-0.06 |
0.01 |
Table 4: Correlation testing of Prism informatics with Frontier Info and STG Life care
Correlation Testing |
Frontier Info ROE |
STG Life care ROE |
Frontier Info ROA |
STG Life care ROA |
Frontier Info ROS |
STG Life care ROS |
Prism informatics ROE |
-0.13 |
0.39 |
0.09 |
0.17 |
0.27 |
0.36 |
Prism informatics ROA |
-0.14 |
0.41 |
0.09 |
0.29 |
0.18 |
0.38 |
Prism informatics ROS |
0.21 |
-0.52 |
0.08 |
-0.41 |
0.20 |
-0.56 |
Table 5: Correlation testing of Frontier Info with Prism informatics and STG Life care
Correlation Testing |
Prism informatics ROE |
STG Life care ROE |
Prism informatics ROA |
STG Life care ROA |
Prism informatics ROS |
STG Life care ROS |
|
Frontier Info ROE |
-0.13 |
-0.89 |
-0.14 |
-0.95 |
0.21 |
-0.73 |
|
Frontier Info ROA |
0.09 |
-0.70 |
0.09 |
-0.79 |
0.08 |
-0.52 |
|
Frontier Info ROS |
0.27 |
0.81 |
0.18 |
0.87 |
0.20 |
0.62 |
Table 6: Correlation testing of STG Life care with Prism informatics and Frontier Info
Correlation Testing |
Prism informatics ROE |
Frontier Info ROE |
Prism informatics ROA |
Frontier Info ROA |
Prism informatics ROS |
Frontier Info ROS |
STG Life care ROE |
0.39 |
-0.89 |
0.41 |
-0.70 |
-0.52 |
0.81 |
STG Life care ROA |
0.17 |
-0.95 |
0.29 |
-0.79 |
-0.41 |
0.87 |
STG Life care ROS |
0.36 |
-0.73 |
0.38 |
-0.52 |
-0.56 |
0.62 |
Table 7: Correlation Coefficient of Prism informatics among ROS, ROA and ROE
Correlation Testing |
Prism informatics ROE |
Prism informatics ROA |
Prism informatics ROS |
Prism informatics ROE |
--------- |
0.99 |
-0.90 |
Prism informatics ROA |
0.99 |
-------- |
-0.90 |
Prism informatics ROS |
-0.90 |
-0.90 |
--------- |
Table 8: Correlation Coefficient of Frontier Info among ROS, ROA and ROE
Correlation Testing |
Frontier Info ROE |
Frontier Info ROA |
Frontier Info ROS |
Frontier Info ROE |
--------- |
0.90 |
-0.95 |
Frontier Info ROA |
0.99 |
-------- |
-0.86 |
Frontier Info ROS |
-0.95 |
-0.86 |
------------ |
Table 9: Correlation Coefficient of STG Lifecare among ROS, ROA and ROE
Correlation Testing |
STG Lifecare ROE |
STG Lifecare ROA |
STG Lifecare ROS |
STG Lifecare ROE |
--------- |
0.98 |
0.94 |
STG Lifecare ROA |
0.98 |
-------- |
0.91 |
STG Lifecare ROS |
0.94 |
0.91 |
--------- |
4. SUMMARY AND CONCLUSION:
We are trying to evaluate the return on equity with the help of return on assets and return on sales and also we are trying to compare relationship among three Information Technology companies which has been outlined in the following paragraph.
· The analysis of return on equity shows that increase in the ROA and ROS having positive impact on the ROE.
· From the Correlation testing we observed that between Prism informatics ROE and Frontier info ROE there is a strong relationship but Prism informatics ROS and STG Life care ROS there is a weak relationship and also we found that Prism informatics among ROS, ROA and ROE it has been observed that between ROE and ROA there is a strong relationship but ROS and ROE there is a weak relationship.
The DuPont Profitability Linkage Model is a simple but powerful tool to assess the financial performance of a company. We have focuses on DuPont model and calculated return on equity to help investors to identify the nature of Indian Information technology companies and will also help to take decision regarding investment.
5. REFERENCES:
1 Hanson, G. D., Parsons, R. L., Musser, W., and Power, L. (1998). Impact analysis of farm finance workshops. Journal of Extension, pp.45-54.
2 Khrawish, H.A. (2011) Determinants of Commercial Banks Performance: Evidence from Jordan. International Research Journal of Finance and Economics Zarqa University, pp. 19-45.
3 Nathwani and Nirmal, (2004) ‘The Study of Financial Performance of Banking Sector of India’, thesis PhD, Saurashtra University.
4 Padachi, K., (2006). ‘Trends in working capital management and its impact on firm’s performance’: An analysis of mauritian small manufacturing firms. Int. Rev. Bus. Res., pp. 45-56.
5 Panwala, M., (2009) ‘Dimensions of liquidity management-A case study of the Surat Textile’s Traders Cooperative Bank Ltd’., J. Account. Res., pp. 69-78.
Received on 24.03.2018 Modified on 25.04.2018
Accepted on 30.04.2018 ©AandV Publications All right reserved
Asian Journal of Management. 2018; 9(3):1105-1108.
DOI: 10.5958/2321-5763.2018.00176.2