Correlation between Financial Performances with the Stock Price in Indonesia Stock Exchange on Telecommunication Industry for 2017-2021 (Case Study: PT Telkom, PT XL Axiata, PT Indosat Ooredoo)

: Over the past few decades, telecommunication in Indonesia has experienced enormous growth and development, playing a crucial role in supporting the advancement of society, economic prosperity, and human connectivity. A couple major companies dominate the market including PT Telekomunikasi Indonesia and private firms like PT Indosat Ooredoo and PT XL Axiata. These companies provide a wide range of services, including mobile phone service, fixed-line services, internet connectivity, and digital solutions, adapting to the diverse needs of businesses and individuals across the country. The purpose of this research is to determine how financial ratios affect stock prices on the Indonesian stock exchange. Additionally, this study compares the financial health of PT Telekomunikasi Indonesia, PT Indosat Ooredoo, and PT XL Axiata based on ratio comparison of Decree No. KEP-100/MBU/2002. The results indicates that PT Telekomunikasi Indonesia has the healthiest financial performance by obtained AA category compared to PT Indosat Ooredoo and PT XL Axiata. This study finds the effect of eight financial ratios on the telecommunication industry for five years period. Based on the multiple linear regression test namely T test, it resulted that total asset turnover and total equity have a positive significant effect on stock price partially with a value less than 0.05. The F tests shows that all independent variables have effect to the stock prices by 80% and the remaining 20% are influenced by models outside this study.


n industry ha
an important role to implement competitive and attractive promotion packages in terms of their services and products to attract more customers.The implementation of digitalization leads to changes in human behaviour as well as development of technology in telecommunication, fundamentally, shifts in consumer preferences will push businesses toward going digital.Indonesia is the fastest developing telecommunication industry in Asia, which contributes about 748.75 trillion rupiahs to the GDP of Indonesia [1].The industry consists of mobile and mobile phone services providers as well as fixed broadband subscriptions.The telecommunication industry is expected to grow and develop rapidly along with digitized increase in Indonesia.Telecommunication infrastructure in Indonesia is well developed with more than 100 thousand mobile towers in the country.It provides 4G networks of internet access to over 94 percent of the cities in the country.The top three telecommunication industry companies in Indonesia are Telkom, Indosat, and XL Axiata.In terms of customers using their services, these businesses are the biggest.These businesses have sought to fulfil these changing needs as more Indonesians purchase smartphones and call for affordable data costs, wider coverage, and better service quality.The world faced a Covid-19 pandemic in 2019 that impacted business and human behavior which changed the activities into online basis.The Indonesian telecommunication market was enormously impacted by the Covid-19 pandemic.The following mobile app categories have experienced the fastest growth in the nation throughout the COVID-19 era: crises, remote working, education/elearning, and wellness.Telecommunication providers have played a significant role during the pandemic by huge increases in the demand of telecommunication services.For instance, Telkom group has a role as the major internet service provider (ISP) to give excellent services during the pandemic.Mobile operators Telkom, XL Axiata, and Indosat Ooredoo provided free internet of 30GB for students to access e-learning providers.Internet users in Indonesia are growing every year.Internet users in Indonesia are 210 million in the period of 2021-2022 [2].


LITERATURE REVIEW 2.1 Financial Ratio Analysis

A financial ratio is a comparison of related values seen in a company's financial records that demonstrates the significance of that company's financial position in relation to

s user's needs.Financia
ratios can be used to assess and contrast the financial health and performance of an organization.The utilisation of financial ratio analysis has been widely recognised as a valuable and efficient method for decision-makers, including business analysts, creditors, investors, and financial managers.The present study used various financial ratios to derive significant findings, as opposed to relying solely on the absolute figures presented in financial statements.The necessary components for conducting ratio analysis include the firm's income statement and balance sheet.The benefit of financial ratio is able to analyzed risk and return of various sizes companies.For ease, financial ratios can be classified into five broad categories: liquidity, activity, debt, profitability, and market ratios [3].Activity, Liquidty, and debt ratios mainly measure risk.Return measured by using profitability ratios.Market ratios capture risk and return.Ratio analysis is not only calculation of a given ratio but also interpretation of the ratio value that more important.There are two ways to conduct a comparison ratio which are cross-sectional and time-series analysis [3].The comparison of various firms' financial ratios at the same time is known as cross-sectional anal

is and called as benchmarking, and it often comp
red with the industry average ratio.Time-series analysis is looking at performance over time to analyze how it varies from each year.Comparison of current and prior company performance ratios utilizes for analyze the trend of performance year to year.


The Decree of Ministry Stated Owned Enterprises

The author utilizes the Decree of Ministry State Owned Enterprises No.KEP-100/MBU/2002 in order to analyze the company financial health.The details of the decree are including the liquidity, activity, solvency, and profitab

ity ratios.The minist
y of State-Owned Enterprise issued the scoring method to ease the company's financial health and company performance analysis.


Multiple Linear Regression

Multiple linear regression is an extension of simple linear regression which includes additional explanatory variables [4].

Multiple linear regression has the equation similar with simple linear regression with more terms.The equation are as follows:
Y = β + β1 x1 + β2 x2 + ⋯ + βp xp + e Where: Y = Dependent Variable β = Constant Term X = Explanatory variable βp = Slope Coefficients e = Residual

Hypothesis Formulation

A hypothesis in a thesis is a claim that is made for the purpose to be researched or put to test [5].Researchers seek to accept or reject the hypothesis in light of the empirical results through the gathering, analysis, and interpretation of data.The research's problem statement is presented as a query.

1. H0 = Independent variable partially has no significant and positive effect on the stock price of Telecommunication Industry for period 2017 -2021.H1 = Independent variable partially has significant and positive effect on the stock price of Telecommunication Industry for period 2017 -2021.2. H0 = Independent variable simultaneously has no significant and positive effect on the stock price of Telecommunication Industry for period 2017 -2021.H1 = Independent variable simultaneously has significant and positive effect on the stock price of Telecommunication Industry for period 2017 -2021.It stated that the conceptual or theoretical perspective of the researcher affects how data are gathered and understood [6].As a result, author should be explicit about the frameworks are using in their studies and explain how those frameworks connect to the specific research problem.The author evaluates ratio of companies' financial statements, the companies which evaluated are PT Telkom, PT XL Axiata, and Indosat Ooredoo.The outcome of financial ratio analysis will be continued by analysis of company health performance b

gression to find the cor
elation between financial performance of companies with the stock prices.Moreover, the author will offer an advice to investors on how to select companies with the best financial condition and how to take into con

deration the rela
ionship between financial ratios and stock price while making this decision.


Conceptual Framework


RESEARCH METHODOLOGY 3.1 Data Collection Method

The author uses secondary data in this research for references and the following are the sources of data used in this research:

1. Financial and annual reports of telecommunication industry which are PT Telkom, PT XL Axiata, PT Indosat Ooredoo listed on the IDX that have been audited from the 2017 to 2021 period.2. Previous credible research such as journals and articles.3. Stock prices historical data of telecommunication industry listed on IDX for five years start from 2017 to 2021 which obtained from Yahoo Finance.


Data Analysis Method

There are several stages in order to analyzed the effect of financial ratio to th

stock prices of the compa
ies in the market.The author uses cross-sectional analysis to compare the financial ratios of different companies in the same point in time.Time series analysis also involved in this research to evaluates performance over time and comparison of current to past performance by using multiyear comparisons to find out the developing trend.Financial ratios use in this research are Liquidity ratio, Activity ratio, Solvency ratio, and profitability ratio.Moreover, the author also uses the decree of Ministry State Owned Enterprises No.KEP-100/MBU/2002 to determine the company financial health condition, financial ratios in the decree contains of 8 financ al ratios which includes: Return on Investment (ROI), Return on Equity (ROE), Current Ratio, Cash Ratio, Collection Period, Inventory Turnover, Total Asset Turnover (TATO), and Total Equity to Total Asset Ratio.It continues with the comparison of 3 companies' financial ratios and carried out to the relationship between those ratios to the company's stock price by using regression approach. PT XL Axiata Table 4.3 Health Assessment of PT XL Axiata (Source:

uthor's Analysis) The auth
r financial ratios analysis of PT XL Axiata based on the decree of Ministry State Owned Enterprises is as the figure above shown.It can be seen from the table above that financial health of PT XL Axiata for the period 2017 -2021 considered to be low and less healthy.PT XL Axiata obtained the BB and B category year on year.The lowest score was in 2018 with 24,5 and 35% weight percentage due to negative in return on equity for -18% and return on investment for -6% and categorized as B (21 < TS ≤ 28).Moreover, there was an improvement of PT XL Axiata financial health in 2021 and became highest score for five years with 32,75 and 47% weight percentage.Therefore, it was categorized as BB (28 < TS ≤ 35) but still classified as l

s healthy.


RESULTS
AND ANALYSIS


 Normality Test

The normality test data is important to ensure whether or not the dependent and independent of analysed data usually distributed.Moreover, the data required to conduct the normality test is 30 samples.In this research, the author performed the analysis by using 30 samples of data and utilized one sample Kolmogorov -Smirnov to test the normal data.The figure above shows the result of normality test using one-sample Kolmogorov -Smirnov test.The results of this test have to be more than 0,05 to get the normal distribution.On the other hand, if it was less than 0,05 the data will be classif

d as not normal distributi
n.It can be seen from the table above that the result on significant values (2 tailed) was 0.200 which means the data considered as normal distribution.


 Multicollinearity Test

Multicollinearity is a statistical condition in regression analysis where two or more predictor variables in a model have a strong correlation with one another.If the multicollinearity occurred in regression, it can lead to the misleading or unstable results and affects the estimation of regression coefficients.The variance inflation factor, or VIF, is a method for calculating how much the variance is inflated [8].In addition, tolerance value also the factor which determine the multicollinearity.The terms to determine multicollinearity is as follow:

1. Variance Inflation Factor (VIF) value less than 10 is not classified as multicollinearity.

. Value of tolerance more than 0.1 is not cla
sified as multicollinearity The table above shows the analysis of multicollinearity with one liquidity ratio involved namely current ratio.Variance inflation factor (VIF) value among the variable is lower than 10 and the tolerance value is more than 1.There was no multicollinearity occurred after current ratio being eliminated from the analysis.Thus, the author concludes the data has no multicollinearity.


 Heteroscedasticity Test

The heteroscedasticity test determines if the regression model is based on unequal variance between the residuals.The true nature of heteroscedasticity is usually unknown, so the choice of the appropriate test depends on the nature of the data [9].The author used the glejser test to figure out whether or not the heteroscedasticity is appeared in this regression model.The circumstances of heteroscedasticity are:

1.The significant value more than 0.05 is no heteroscedasticity 2. The significant value less than 0.05 is heteroscedasticity Based on the figure 4.7, it shows that all the significant value on glejser test was above 0.05.Therefore, there is no heteroscedasticity in the regression model analyzed by the author.


Multiple Regression

In this study, the researcher conducted an analysis on the impac

of six financia
ratios.These ratios were derived from the Ministry of State Own Enterprise KEP-100/MBU/2002 decree.The financial ratios examined in this research include the Cash Ratio, Collection Period, Total Asset Turnover, Equity to Asset, Return on Asset, and Return on Equity.To ascertain the impact of the ratios of PT Telekomunikasi Indonesia, PT Indosat Ooredoo, and PT XL Axiata, the multiple linear regression model is employed, with the following formulation: The author analyzed the regression model by using simultaneous test or known as F test in order to figure out whether or not the combination of all independent variables which is financial ratios in the analysis are have the effect on the dependent variables which is stock price.The circumstances to determine whether the combination of independent variables have the effect to stock price is as follow:

1.The significant value of F is more than 0.05 has no effect to the dependent variable.

2. The significant value of F is less than 0.05 has effect to the dependent variable.The partially test or known as T test is used to analyzed whether or not each independent variable have the effect to dependent variable.The circumstance is:

1.If the probability value of independent variable less than 0.05 then the partially variable has significant effect on the dependent variable.2. If the coe