Loading...

This article is published under a Creative Commons license and not by the author of the article. So if you find any inaccuracies, you can correct them by updating the article.

Loading...
Loading...

Analysis of Financial Statements Based on Financial Ratio and Vertical-Horizontal Method in PT Unilever, Tbk, 2016-2017 Period Creative Commons

Link for citation this article

Nova Tri Anggraini

Journal of Social Science, Journal Year: 2022, Volume and Issue: 3(1), P. 10 - 17

Published: Jan. 1, 2022

Latest article update: Nov. 17, 2022

This article is published under the license

License
Link for citation this article Related Articles

Abstract

This research aims to horizontally and vertically determine the financial performance of PT Unilever, Tbk, especially by observing the development of assets and financial statements through the calculation of financial ratios. Based on the research results, it can be observed that based on the analysis of the ratio of Liquidity, Profitability and Leverage tend to fluctuate. The liquidity ratio has increased, Profitability ratio has increased in GPM and NPM but decreased in Cash Ratio, ROA, and ROE. The Leverage Ratio has decreased; thus, the financial performance of PT Unilever, Tbk has not been fully optimal. Based on the horizontal analysis, it can be concluded that the balance sheet and income statement of PT Unilever, Tbk are optimal. Based on the vertical analysis, it can be concluded that the balance sheet and income statement index of PT Unilever, Tbk are optimal.

Keywords

Financial ratio, Financial statement, horizontal method, vertical method

Introduction


The main problem faced in Indonesia within the PT Unilever must have good management and acquire support from the government and the community to establish a safe corporate economic environment. Presuming that PT Unilever can maintain the company's financial value stability, investors will surely compete to invest their capital in the company. For this reason, investors will focus closely on the financial performance of PT Unilever.


Financial performance describes the company's financial condition in a certain period, both in terms of raising funds and distributing funds, which are usually measured by indicators of capital adequacy, liquidity, and profitability (Andres, 2013). Capital adequacy can be calculated using the Capital Adequacy Ratio (CAR), where this ratio shows the company's ability to handle the risk of losses that may occur to the company (Cashmir, 2016). Liquidity is an analysis of the company's ability to meet its shortterm obligations (Djaja, 2018). Meanwhile, profitability is a comparison ratio used to determine the company's ability to earn profits from sales, assets, and equity, which is based on certain measurement bases (Djaja, 2018).


Nowadays, one of the most serious issues facing financial institutions is fraud in commercial transactions, which has resulted in many companies losing hundreds of billions of dollars (Rashid, 2018). Financial report preparation training had little impact on entrepreneurial performance (Hendiarto, 2021). Furthermore, financial liquidity ratios influence financial statement fraud, although profitability and leverage ratios have not been demonstrated to affect financial report fraud (Izzalqurny, 2019). Thus, financial stament analysis is rquired to avoid those problems


Financial statement analysis is the process of using financial and analytical tools to explore and comparison with the financial statement for te purpose of making business decision (Abu, 2020). Moreover, financial statements contain essential data that should be used to aid in decision-making (Van & Carraher, 2013).


Analysis of financial performance has been studied by Nufus (2020) that analyze the level of health, growth, and business prospects of the employess of the PT. X Cooperative. Moreover, Shala, Prebreza, and Ramosaj, (2021) examines the raw data from Samsung Enterprise's financial statements, which includes a horizontal and vertical analysis of the balance sheet and SAP for the years 2015- 2015 and 2017-2018. In addition, the purpose of this study is to discover about PT. Unilever Indonesia Tbk's financial performance from 2012 to 2016 utilizing vertical and horizontal analysis (Lakada, Lapian, Tumiwa, 2017). This current study is different from this research, since this research analyze the finacial performnace use financial ration and vertical-horizontal method.


The problem formulation proposed by the author is: "How are the Financial Statements at PT Unilever in 2017 against the 2016 financial statements based on financial ratio analysis and the horizontal- vertical method?"


This research aims to horizontally and vertically determine the financial performance of PT Unilever, Tbk, particularly examining the development of assets and financial statements through the calculation of financial ratios.


The purpose of this research is for the author to comprehend and implement the knowledge gained during


Method


In this research, an operational formulation or definition will be provided to present a clearer picture of the variables examined.



  1. Financial performance referred to in this research is the company's financial condition calculated using the verticalhorizontal method and financial ratios in the financial statements of a company (Sartono, 2002). This method is used to assess the company's financial performance of PT Unilever, Tbk.

  2. PT Unilever, Tbk referred to in this research is PT Unilever, listed on the Indonesia Stock Exchange (IDX); thus, it facilitates the researcher to access its financial statements.


Unit of Analysis, Population, and Sample



  1. The unit of analysis of this research is PT Unilever, Tbk, which is listed on the Indonesia Stock Exchange (IDX).

  2. The population of this research uses all financial statements of PT Unilever, Tbk starting from 2016 - 2017.

  3. The sample used in this research is the balance sheet, profit/loss statement, and cash flow statement of PT Unilever, Tbk.


Analysis Tool



  1. Current Ratio


The following formula can calculate the current ratio:


Current Ratio = Current ASSETS / Current Liabilities



  1. Cash Ratio


The following formula can calculate the cash ratio:


Cash Ratio = (Cash+Marketable Securities)/(Current Liabilities)



  1. Gross Profit Margin


The following formula can calculate this ratio:


GPM=(Sales-Cost of Good Sold)/Sales



  1. Net Profit Margin


The following formula can calculate this ratio:


NPM=(Net Income)/Sales



  1. Return On Assets(ROA)


ROA can be calculated using two formulas as follow.


ROA=(Net Income)/(Total Assets)



  1. ROE can be calculated with :


ROE=(Net Income)/(Net Worth)



  1. Debt to Total Assets Ratio


This ratio can be calculated with the following formula.


DAR=(Total Debt)/(Total Assets)



  1. Debt to Equity Ratio


This ratio can be calculated with the following formula.


DER=(Total Debt)/(Total Equity)



  1. Horizontal Analysis


Horizontal analysis is an analysis conducted by comparing financial statements for several periods (Mapantau, 2012). This analysis determines the development of the ups and downs of components in the financial statements; it will show the company's development from one period to another.



  • Vertical analysis is an analysis carried out on only one financial statement period (Mapantau, 2012). This analysis calculates the percentage of the elements in the balance sheet to total assets and the elements in the income statement to total income.


Results And Discussion


General Overview of the Company


Unilever Indonesia has been an integral part of the retail market in Indonesia for more than 80 years since it was first established on 5 December 1933. The company has grown to become one of the leading companies in the Fast-moving Consumer Goods category in Indonesia.


The company has nine factories located in the industrial areas of Jababeka, Cikarang, and Rungkut, Surabaya, and has moved its head office to Bumi Serpong Damai. On 3 hectares land, this specially- built new head office is occupied by more than 1,400 of our employees. The company's products, consisting of 39 leading brands and approximately 1,000 Stock Keeping Units (SKU), are marketed through a network involving more than 800 independent distributors that span hundreds of thousands of stores throughout Indonesia.


Analysis



  1. Current Ratio



















































































































































Year



Current Ratio



%



2016



0,605632



60,563



2017



0,633693134



63,369



2. Cash Ratio



Year



Cash Ratio



%



2016



0,03436592



3,4366



2017



0,032299248



3,2299



GPM



Year



GPM



%



2016



0,510791254



51,079



2017



0,514985714



51,499



NPM



Year



NPM



%



2016



0,159552473



15,955



2017



0,169995032



17,000



ROA



Year



ROA



%



2016



0,381630742



38,163



2017



0,370486036



37,049



ROE



Year



ROE



%



2016



1,358486716



135,85



2017



1,353960306



135,4



DAR



Year



DAR



%



2016



0,719076575



71,908



2017



0,726368614



72,637



DER



Year



DER



%



2016



2,5596889



255,97



2017



2,654551524



265,46



Discussion



  1. Liquidity

  2. Current Ratio


The current ratio shows the ability of PT Unilever, Tbk to settle debts that current ASSETS must meet. This ratio shows that every Rp.1.00 of current debt is guaranteed by Rp.0.60563 current ASSETS of 2016 and Rp.0.63369 current ASSETS of 2017.



  1. Cash Ratio


The Cash Ratio shows the ability of PT Unilever, Tbk to meet current debts by using cash and securities at the bank. This ratio shows that every Rp.1.00 of current debt is guaranteed by Cash of Rp.223 in 2016, Rp.214 in 2017.



  1. Profitabilitas

  2. Gross Profit Margin


Gross profit margin percentage shows that PT. Unilever owns 0.420% of the revenue. This percentage has increased; in other words, the company's finances have been running optimally.



  1. Net Profit Margin


Net profit margin percentage shows that PT. Unilever owns 1.405%. This percentage has increased; in other words, the company's finances have been operating optimally. The higher the NPM value indicates that the company is more efficient in its operations (5awir, 2014). The company can reduce unnecessary costs; thus, the company can maximize the net profit obtained.



  1. Return On Asset


Return On Assets explains the results obtained from the investment made by the company in total ASSETS (Sawir, 2014). From the analysis results, this ratio decreased from 2016 to 2017 by 0.420%, due to profit before tax decreasing by 0.340%.



  1. Return On Equity


Return On equity provides an overview of the company's ability from its capital to generate profits for shareholders (Sawir, 2014). From the analysis results, this ratio has decreased from 2016 to 2017. The decrease was due to profit before interest and taxes, which increased from 2016 to 2017 by 0.34%, and the own capital was stagnant.



  1. Leverage

  2. Debt Ratio on Asset


Total Debt to Total Asset Ratio shows how much the company's ASSETS is financed by debt or how much of the total ASSETS is spent with total debt (Негу, 2018). From the analysis results, it can be observed that the debt ratio has increased from 2016 to 2017 by 0.729%, due to the total debt increased by 0.730% because income tax payables increased by 0.360%.



  1. Debt to Equity Ratio


Debt to Equity Ratio shows the ability of the bank's capital that can be used as collateral for the entire debt (Негу, 2018). From the analysis results, this ratio has increased from 2016 to 2017 by 9.490%, caused by increasing total debt by 0.730%. Meanwhile, equity from 2016 to 2017 decreased by 0.730% due to a decrease in general reserves, which decreased by 0.01%.



  1. Financial Performance Evaluation of PT Unilever, Tbk

  2. Based on Financial Ratio Analysis


In terms of liquidity, it can be observed from the Current Ratio, which has increased by 2.806%; thus, the company can be assumed to be progressing well due to excess funds being used effectively. As for the Cash Ratio, it decreased by 0.207%; it can be assumed that the company is not effective in managing its cash due to the decline in the value of cash.


In terms of profitability, it can be noticed that Gross Profit Margin and Net Profit Margin have increased. The respective increase in GPM of 0.420%
and NPM of 1.045% prove that the company's profit will increase because it has been good at managing its operational finances.


In terms of leverage, it can be noticed that the company does not observe its finances properly because each debt ratio increases, which causes the company's finances to be vulnerable.



  1. Based on Horizontal Analysis


When viewed from the data, it was identified that the index on the 2016 to 2017 balance sheet tended to show a significant increase. From 2016 towards 2017, the index of ASSETS, liabilities, and equity increased significantly. This means that the balance sheet of PT Unilever, Tbk was optimal.


According to the index data obtained in the income statement, it can be observed that yearly revenue tended to be stable and increased from 2016 to 2017. Thus, it can be concluded that the financial performance of PT Unilever, Tbk was optimal.



  1. Based on Vertical Analysis


From PT Unilever's vertical analysis table, it can be observed how the index increases for each asset and liabilities owned by the company. It can be seen that the total ASSETS, liabilities, and equity obtained increased from 2016 - 2017. As for the smallest ASSETS during two years originated from taxes. From the liabilities side, the largest amount of liabilities originated from bank loans. The biggest contribution to equity is unreserved profit.


When viewed from the income statement, PT Unilever has a very fluctuating index number. PT Unilever's revenue has increased significantly yearly, and the bank's total revenue is greater than the total expenses; this means that PT Unilever's financial performance is optimal.


Conclusion


Based on the analysis, the ratio of Liquidity, Profitability, and Leverage tends to fluctuate. The liquidity ratio has increased, Profitability ratio has increased in GPM and NPM but decreased in Cash Ratio, RO A, and ROE. The Leverage Ratio has decreased; thus, the financial performance of PT Unilever, Tbk is not yet fully optimal.


Based on the horizontal analysis, it can be concluded that the balance sheet and income statement of PT Unilever, Tbk are optimal.


Based on the vertical analysis, it can be concluded that the balance sheet index and the income statement of PT Unilever, Tbk are optimal.


References



  1. Abu Talha Al-Ansari, A. A. (2020).

  2. Financial Statement Analysis of Grameenphone Limited. Google Scholar

  3. Andres, M. (2013). Analisis La рога n Keuangan dalam Mengukur Kinerja Keuangan pada PT. Hanjaya Mandala Sampoerna Tbk. Jurnal EMBA: Jurnal Riset Ekonomi, Manajemen, Bisnis Dan Akuntansi, 1(3). Google Scholar

  4. Cashmir. (2016). Analisis Laporan Keuangan . Jakarta: PT Raja Grafindo Persada.

  5. Djaja, I. (2018). All About Corporate Valuation. Jakarta: PT Gramedia.

  6. Hendiarto, R. S. (2021). The Influence of Training on Financial Statement Preparation on Entrepreneurship Performance. Turkish Journal of Computer and Mathematics Education (TURCOMAT), 12(A), 754-763. Google Scholar

  7. Негу. (2018). Analisis Laporan Keuangan Integrated and Comprehensive Edition. Jakarta: PT Gramedia.

  8. Izzalqurny, T. R., Subroto, B., & Ghofar, A. (2019). Relationship between Financial Ratio and Financial Statement Fraud Risk Moderated by Auditor Quality. International Journal of Research in Business and Social Science (2147-4478), 8(4), 34-43. Google Scholar

  9. Lakada, M. N., Lapian, S. J., &Tumiwa, J. R. (2017). Analyzing The Financial Statement Using Horizontal-Vertical Analysis To Evaluating The Company Financial Performance Period 2012-2016 (Case Study at PT. Unilever IndonesiaTbk). Jurnai EMBA: Jurnai Riset Ekonomi, Manajemen, Bisnis dan Akuntansi, 5(3). Google Scholar

  10. Mapantau, S. (2012). Analisis Laporan Keuangan Berdasarkan Metode Vertikal-Horizontal dan Rasio Keuangan untuk Mengevaluasi Kinerja Keuangan Perbankan pada Bank BUMN (Periode 2008-2010). Universitas Hasanuddin. Google Scholar

  11. Nufus, K., Supratikta, H., Muchtar, A., & Sunarsi, D. (2020). Analysis of Financial Performance: Case Study of PT. X Employee Cooperative. Utopia Y Praxis Latinoamericana, 25(Esp. 10), 429-444. Google Scholar

  12. Rashid, N., Mahmod, M. S., Afthanorhan, A., Endut, W. A., Yaakub, N., Harun, M. H„ & Salleh, S. I. (2018). The responsibilities of financial fraud activities among of auditor in the                  business

  13. organizations. International Journal of Academic Research in Business and Social Sciences, H12), 1646- 1651. Google Scholar

  14. Sartono, A. (2002). Manajemen Keuangan : Teori dan ApiiCashi, Jiiid 4. Yogyakarta: BPFE.

  15. Sa wir,   A. (2014). Analisis Kinerja

  16. Keuangan dan Perencanaan Keuangan Perusahaan .Jakarta: PT Gramedia. Google Scholar

  17. Shala, B., Prebreza, A., & Ramosaj, B. (2021). Horizontal and Vertical Analysis of SAMSUNG Enterprise for the Years 2015-2016 and 2017- 2018. Journal of Economics and Management Sciences, 4(1), p50- p50.Google Scholar

  18. Van Au ken, H., & Carraher, S. (2013). Influences on frequency of preparation of financial statements among SMEs. Journal of Innovation Management, 7(1), 143. Google Scholar