Analysis of Financial Statements Based on Financial Ratio and Vertical-Horizontal Method in PT Unilever, Tbk, 2016-2017 Period
Published: Jan. 1, 2022
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
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
In this research, an operational formulation or definition will be provided to present a clearer picture of the variables examined.
Unit of Analysis, Population, and Sample
Analysis Tool
The following formula can calculate the current ratio:
Current Ratio = Current ASSETS / Current Liabilities
The following formula can calculate the cash ratio:
Cash Ratio = (Cash+Marketable Securities)/(Current Liabilities)
The following formula can calculate this ratio:
GPM=(Sales-Cost of Good Sold)/Sales
The following formula can calculate this ratio:
NPM=(Net Income)/Sales
ROA can be calculated using two formulas as follow.
ROA=(Net Income)/(Total Assets)
ROE=(Net Income)/(Net Worth)
This ratio can be calculated with the following formula.
DAR=(Total Debt)/(Total Assets)
This ratio can be calculated with the following formula.
DER=(Total Debt)/(Total Equity)
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.
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
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
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.
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.
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.
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.
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%.
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.
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%.
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%.
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.
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.
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.
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.