INTRODUCTION AND OVERVIEW OF THE COMPANY
Each year,
financial statements from different companies are analyzed and compared to
offer insights into their growth and performance. This report provides a
comparative analysis of Lanka Milk Foods (CWE) PLC's financial results over a
five-years period.
Publicly
traded companies generate four main financial statements: the profit and loss
statement, the financial position statement, the cash flow statement, and the
statement of equity. These statements are accessible to both internal and
external stakeholders.
Companies
use various analytical methods, including horizontal analysis, vertical
analysis, trend analysis, ratio analysis, and Z-score analysis, to identify
their financial strengths and weaknesses. Such financial statement analysis can
also be employed to compare a company's performance with that of its
competitors and evaluate its past, present, and future performance.
Analyzing
financial statements offers many advantages, such as;
● Comprehensive
View of Financial Health: Financial statements provide a complete overview of a
company’s financial condition.
● Investment
Decisions: Investors can make informed decisions about buying or selling stocks
or bonds by assessing a company's growth potential and financial stability.
● Risk Assessment:
Examining financial statements allows for the evaluation of various risks,
including credit, operational, and market risks.
● Competitive
Benchmarking: Companies use financial statements to measure their performance
against competitors and industry benchmarks.
● Tax Planning:
Understanding financial outcomes helps businesses plan their taxes effectively
and ensure compliance with tax regulations.
Lanka Milk
Foods (CWE) PLC is a major dairy and beverage company in Sri Lanka, known for
its flagship brand, Lakspray. With over 50 years in the industry, the company
offers a range of products including Ambewela, Daily, My Juicee, Red Bull
beverages, Happy Cow cheese, and Dano milk powder. It operates two large dairy
farms, Ambewela Farm and Pattipola Farm, and modern facilities in Welisara and
Ambewela. The company also recently launched United Dairies Lanka, one of South
Asia's largest dairy farms. Lanka Milk Foods (CWE) PLC was established in 1981
and listed on the Colombo Stock Exchange in 1983, Lanka Milk Foods specializes
in packing and distributing whole milk powder and skimmed milk powder,
importing and distributing energy drinks in the local market, Key brands of
Lanka Milk Foods (CWE) PLC include; Lakspray, Blu and Dano.
Horizontal analysis is a financial analysis technique used to evaluate
changes in financial statement items over time. This method involves comparing
historical financial data across multiple periods to identify trends, growth
patterns, and variations in performance. The horizontal analysis involves two
types of formulas;
- Percentage change
Percentage change = (Rupee change / Base period amount) * 100%
- Absolute change in
rupees.
Rupee change = Analysis period amount – Base period amount
The chance to compare and evaluate Lanka Milk Foods (CWE) PLC's
financial positions from 2019 to 2023 is provided by this analysis. 2019 is the
base year for this analysis.
Table 2.1: Rupee change analysis of financial position (2019 – 2023)
Table 2.2:
Percentage change analysis of financial position (2019 – 2023)
Over the five years from 2019 to 2023, Lanka Milk Foods (CWE) PLC
experienced notable fluctuations in its non-current assets. Property, plant,
and equipment saw a steady increase up to 2021, but it has drastically dropped
in 2022 by Rs.10,475,000 (7.7%) compared to 2019 and in 2023 dropped by Rs.27,218,000
(20%) compared to 2019. This drop in PPE indicates Depreciation, Asset Disposal,
and Impairment, etc. Intangible assets appeared in the statement of Financial
Position in 2023 due to the Software developed for marketing staff Automation
System which will be amortized for 5 years. The Total Non-Current Assets
increased continuously from 2019 to 2021. But in 2022 it shows a decline
comparative to 2021 in Total Non-Current Assets but it has recovered and
significantly increased in 2023. As it shows growth in total non-current assets
in each year compared to the base year (2019), it suggests that it happened
mainly due to investment subsidiaries, and investment in equity securities.
The change in current assets reveals dynamic trends. Inventory declined
in 2020,2021,2022 and 2023 by Rs.30,110,5000 (45.6%), Rs.220,111,000 (33.4%),
Rs.261,586,000(39.7%) and Rs.126,708,000
(19.2%) respectively compared to 2019. This might indicate fluctuations in
demand, changes in inventory management practices, etc. Amounts Due from
related companies displayed gradual growth until 2022, and slightly declines in
2023 compared to 2022 (Even Though rise in 2023 compared to base year)
indicating that the company was effectively managing its receivables. Cash and
cash equivalents experienced a major decline in 2020, with figures of Rs.
-8263000 (-36.1%). Again, it has gradually increased until 2022, but in 2023
cash and cash equivalents declined by Rs.114,000 (0.5%) compared to 2019. Lanka
Milk Foods (CWE) PLC shows steady growth in total current assets, which signifies
the company’s ability to strengthen its working capital position. The company’s
total assets experienced growth during the five years. This indicates
substantial growth in the company’s financial health and overall asset base.
Lanka Milk Foods (CWE) PLC’s total equity experienced considerable
change during the five years. Stated capital and Capital reserves didn’t change
over 5 years. Total equity showed a rise in 2020,2021,2022 and 2023 by Rs.1,396,885,000
(16.8%), Rs.1,715,401,000 (20.6%), Rs.1,279,308,000 (15.4%) and Rs.4,871,188,000
(58.6%) respectively compared to 2019. Here the Significant rise in Total
equity in 2023 happened due to Fair Value through Other Comprehensive Income Reserves
and Revenue reserves.
Total Non-Current Liabilities of Lanka Milk Foods (CWE) PLC increased in
2023 by Rs. 17,274,000 (29.8%) compared to 2019. But it declined in 2023
compared to 2021.
Total Current Liabilities dropped in 2020 and 2021 compared to 2019 by
Rs. 204,743,000 (32.1%) and Rs.66,092,000 (10.4%) respectively. However, there
was a significant turnaround in 2022.
Finally, when we consider total liability and equity together, the
company’s financial position reveals a continuous improvement over 2019 to
2023.
Table 2.3:
Rupee change analysis of the statement of profit or loss (2019 – 2023)
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF PROFIT OR LOSS |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Revenue |
2150006.00 |
1501817.00 |
1179313.00 |
1108778.00 |
0.00 |
Cost of Sales |
1278893.00 |
1357591.00 |
1085745.00 |
978889.00 |
0.00 |
Gross
Profit |
871113.00 |
144226.00 |
93568.00 |
129889.00 |
0.00 |
Other Operating Income |
-410675.00 |
-503206.00 |
41562.00 |
-70710.00 |
0.00 |
Administrative Expenses |
113879.00 |
68934.00 |
62629.00 |
23565.00 |
0.00 |
Distribution Expenses |
6885.00 |
-21717.00 |
14797.00 |
-16782.00 |
0.00 |
Other Operating Expenses |
17484.00 |
43566.00 |
-11292.00 |
61477.00 |
0.00 |
Profit
from Operations |
322190.00 |
-449763.00 |
68996.00 |
-9081.00 |
0.00 |
Finance Income |
1201148.00 |
1131289.00 |
65030.00 |
11818.00 |
0.00 |
Finance Expense |
129541.00 |
333313.00 |
-58055.00 |
-64243.00 |
0.00 |
Net Finance Expense |
1071607.00 |
797976.00 |
123085.00 |
76061.00 |
0.00 |
Profit
Before Taxation |
1393797.00 |
348213.00 |
192081.00 |
66980.00 |
0.00 |
Income Tax Expense |
-25627.00 |
-17183.00 |
514.00 |
38527.00 |
0.00 |
Profit
for the Year |
1419424.00 |
365396.00 |
191567.00 |
28453.00 |
0.00 |
Table 2.4: Percentage change analysis of statement of profit or loss
(2019 – 2023)
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF PROFIT OR LOSS |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Revenue |
111.9% |
78.1% |
61.4% |
57.7% |
0.0% |
Cost of Sales |
67.5% |
71.6% |
57.3% |
51.6% |
0.0% |
Gross
Profit |
3260.0% |
539.7% |
350.2% |
486.1% |
0.0% |
Other Operating Income |
-79.5% |
-97.4% |
8.0% |
-13.7% |
0.0% |
Administrative Expenses |
57.8% |
35.0% |
31.8% |
12.0% |
0.0% |
Distribution Expenses |
5.1% |
-16.1% |
11.0% |
-12.5% |
0.0% |
Other Operating Expenses |
154.8% |
385.8% |
-100.0% |
544.4% |
0.0% |
Profit
from Operations |
160.6% |
-224.2% |
34.4% |
-4.5% |
0.0% |
Finance Income |
13396.7% |
12617.5% |
725.3% |
131.8% |
0.0% |
Finance Expense |
137.6% |
354.0% |
-61.7% |
-68.2% |
0.0% |
Net Finance Expense |
-1257.8% |
-936.6% |
-144.5% |
-89.3% |
0.0% |
Profit
Before Taxation |
1207.7% |
301.7% |
166.4% |
58.0% |
0.0% |
Income Tax Expense |
-184.1% |
-123.4% |
3.7% |
276.7% |
0.0% |
Profit
for the Year |
1398.7% |
360.1% |
188.8% |
28.0% |
0.0% |
The horizontal analysis shows that revenue has continuously surged from
2019 to 2023 by 57.7%, 61.4%, 78.1%, and 111.9% for 2020,2021,2022 and 2023
compared to 2019. This reflects positive aspects of a company’s performance
such as a strong financial position, improved market potential, and increased
profit potential.
Cost of goods sold increased by Rs.1,357,591,000 (71.6%) in 2022
compared to 2019, but in 2023 Cost of sales increased only by Rs.1,278,893,000
(67.5%) compared to 2019, which implies a decline in cost of sales in 2023
compared to 2022. This resulted in an
increase in gross profit by Rs. 129,889,000 (486.1%), Rs.93,568,000 (350.2%),
Rs.144,226,000 (539.7%), and Rs.871,113,000 (3260%) in 2020,2021,2022, and 2023
respectively compared to 2019. Improved gross profit can signal that the
company is gaining a competitive advantage or superior operational efficiency.
Profit from operations dropped in 2020 and 2022 compared to 2019 by 4.5%
and 224.2% respectively. Profit before taxation and profit for the year
gradually increased over 5 years Growing profits make the company more
attractive to investors, potentially leading to higher stock prices and easier
access to capital for future growth and ensuring operational efficiency and
financial health of Lanka Milk Foods (CWE) PLC.
Vertical analysis, also known as common-size analysis, is a financial
analysis technique that helps a business organization in determining the
relative proportions of different items in its financial statements, including
the statement of profit or loss and the statement of financial position. The
primary goal of vertical analysis is to express each item as a percentage of a
common base, typically total revenue for the statement of profit or loss and
total assets for the statement of financial position. This makes it easier to
compare the financial performance and structure of a business over time or with
competitors.
Common size percent = (Analysis amount/Base amount)
*100
Table 2.5:
Vertical analysis of financial position (2019 – 2023)
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF FINANCIAL POSITION |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Assets |
|
|
|
|
|
Non-Current
Assets |
|
|
|
|
|
Property, Plant and Equipment |
0.8% |
1.1% |
1.3% |
1.3% |
1.5% |
Intangible Assets |
0.0% |
0.0% |
0.0% |
0.0% |
0.0% |
Investment in Subsidiaries |
20.9% |
9.5% |
10.0% |
10.4% |
11.9% |
Investment in Equity Securities |
63.9% |
61.0% |
70.9% |
72.8% |
67.9% |
Deferred Tax Assets |
0.1% |
0.1% |
0.1% |
0.2% |
0.8% |
Right of Use Assets |
0.0% |
0.0% |
0.0% |
0.0% |
|
Total
Non-Current Assets |
85.7% |
71.6% |
82.3% |
84.8% |
82.2% |
|
|
|
|
|
|
Current
Assets |
|
|
|
|
|
Inventories |
3.7% |
3.5% |
4.1% |
3.5% |
7.3% |
Investment in Equity Securities |
1.1% |
1.4% |
1.8% |
2.0% |
2.3% |
Trade Receivables |
0.7% |
1.7% |
2.1% |
3.3% |
1.9% |
Other Receivables |
0.1% |
0.2% |
0.5% |
0.5% |
1.1% |
Amounts Due from Related Companies |
8.4% |
12.5% |
6.8% |
5.3% |
4.6% |
Current Tax Assets |
0.1% |
0.1% |
0.2% |
0.3% |
0.3% |
Cash and Cash Equivalents |
0.2% |
8.9% |
2.1% |
0.1% |
0.3% |
Total
Current Assets |
14.3% |
28.4% |
17.7% |
15.2% |
17.8% |
Total
Assets |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
|
|
|
|
|
|
Equity
and Liabilities |
|
|
|
|
|
Equity |
|
|
|
|
|
Stated Capital |
6.9% |
8.9% |
9.4% |
9.8% |
11.1% |
Capital Reserves |
0.7% |
0.9% |
1.0% |
1.0% |
1.2% |
Fair Value through Other Comprehensive Income
Reserve |
59.9% |
55.9% |
65.5% |
67.2% |
61.5% |
Revenue Reserves |
23.8% |
19.7% |
18.0% |
17.1% |
18.5% |
Total
Equity |
91.4% |
85.4% |
93.8% |
95.1% |
92.3% |
|
|
|
|
|
|
Liabilities |
|
|
|
|
|
Non-Current
Liabilities |
|
|
|
|
|
Lease Liability |
0.0% |
0.0% |
0.0% |
0.0% |
- |
Retirement Benefit Obligations |
0.5% |
0.6% |
0.8% |
0.6% |
0.6% |
Total
Non-Current Liabilities |
0.5% |
0.6% |
0.8% |
0.6% |
0.6% |
|
|
|
|
|
|
Current
Liabilities |
|
|
|
|
|
Trade and Other Payables |
0.8% |
10.5% |
0.9% |
0.7% |
3.8% |
Amounts Due to Related Parties |
0.6% |
1.5% |
1.3% |
0.0% |
0.4% |
Loans and Borrowings |
5.4% |
- |
2.8% |
- |
- |
Lease Liability |
0.0% |
0.0% |
0.0% |
0.0% |
- |
Bank Overdraft |
1.3% |
2.0% |
0.3% |
3.5% |
2.8% |
Total
Current Liabilities |
8.1% |
14.0% |
5.3% |
4.2% |
7.1% |
Total
Liabilities |
8.6% |
14.6% |
6.2% |
4.9% |
7.7% |
Total
Liabilities and Equity |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
From 2019 to 2023, Lanka Milk Foods (CWE) PLC's financial position has
seen notable changes, as observed in the vertical analysis of its statement of
financial position. One significant trend is the decline in property, plant,
and equipment as a percentage of total assets over the considered 5 years,
which fell from 1.5% in 2019 to 0.5% in 2023. Total non-current assets as a
percentage of total assets indicated 82.2%, 84.8%,82.3%,71.6%, and 85.7%
respectively for 2019,2020,2021,2022 and 2023. A significant portion of the
current assets comprises Amounts Due from Related Companies. Amounts Due from
Related Companies as a percentage of total assets continuously surged from 4.6%
in 2019 to 12.5%. But this had fallen to 8.4% in 2023. Total current assets as
a percentage of total assets indicated 17.8%, 15.2%, 17.7%, 28.4%, and 14.3%
respectively for 2019,2020,2021,2022, and 2023.
Regarding equity, stated capital as a percentage of total equity and
liability has declined from 11.1% in 2019 to 6.9% in 2023. Capital reserves
also continuously declined from 1.2% to 0.7% as a percentage of total equity
and liability during the considered 5 years. Fair Value through Other
Comprehensive Income Reserves consistently dominated, fluctuating between 55.9%
and 67.2% of total equity and liability. The total equity category, despite
some fluctuations, remained the central element in Lanka Milk Foods (CWE) PLC's
capital structure, representing 92.3% in 2019 and 91.4% in 2023.
Non-current liabilities fluctuate within the range of 0.5% to 0.8%
during the 5 years as a percentage of total equity and liability. have
increased. Current liabilities have remained a relatively smaller portion of
the capital structure compared to equity which is 8.1% in 2023. The proportion
of total assets attributed to total liabilities displayed fluctuations,
reaching 8.6% in 2023. Higher equity relative to liabilities means the company
relies less on debt to finance its operations. This reduces financial risk
because there are fewer fixed interest obligations and less probability of
financial distress during economic downturns.
Table 2.6: Vertical analysis of the statement of profit or loss (2019 –
2023)
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF PROFIT OR LOSS |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Revenue |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
Cost of Sales |
-78.0% |
-95.0% |
-96.1% |
-94.8% |
-98.6% |
Gross
Profit |
22.0% |
5.0% |
3.9% |
5.2% |
1.4% |
Other Operating Income |
2.6% |
0.4% |
18.0% |
14.7% |
26.9% |
Administrative Expenses |
-7.6% |
-7.8% |
-8.4% |
-7.3% |
-10.2% |
Distribution Expenses |
-3.5% |
-3.3% |
-4.8% |
-3.9% |
-7.0% |
Other Operating Expenses |
-0.7% |
-1.6% |
0.0% |
-2.4% |
-0.6% |
Profit
from Operations |
12.8% |
-7.3% |
8.7% |
6.3% |
10.4% |
Finance Income |
29.7% |
33.3% |
2.4% |
0.7% |
0.5% |
Finance Expense |
-5.5% |
-12.5% |
-1.2% |
-1.0% |
-4.9% |
Net Finance Expense |
24.2% |
20.8% |
1.2% |
-0.3% |
-4.4% |
Profit
Before Taxation |
37.1% |
13.5% |
9.9% |
6.0% |
6.0% |
Income Tax Expense |
0.3% |
0.1% |
-0.5% |
-1.7% |
-0.7% |
Profit
for the Year |
37.3% |
13.6% |
9.4% |
4.3% |
5.3% |
Revenue, which serves as the base value, remained stable at 100%
throughout the five years. The cost of sales declined gradually as a proportion
of revenue, from 98.6% in 2019 to 78.0% in 2023. This trend reflects the
company's ability to manage its production and operational costs efficiently,
contributing to improved profitability.
Gross profit, the result of subtracting the cost of sales from revenue,
increased from 1.4% in 2019 to 22.0% in 2023. This growth highlights the
company's effective cost management and suggests successful pricing or sales
strategies that have boosts the gross profit margin.
Profit from operation as a percentage of revenue indicates 10.4%, 6.3%,
8.7%, -7.3% and 12.8% respectively for 2019,2020,2021,2022 and 2023.
The proportion of profit before taxation and profit for the year,
relative to revenue, also showed significant growth. These figures increased
from 6.0% and 5.3% in 2019 to 37.1% and 37.3% in 2023, respectively. This
substantial growth indicates a strong ability to convert revenue into net
profit, underscoring efficient operations and potentially a favorable tax
environment.
In business organizations, trend analysis entails looking at historical
data to recognize trends and make future informed decisions. Organizations may
foresee changes, modify their plans, and maintain their competitiveness by
analyzing trends.
Trend percentage = (Analysis period amount/Base
period amount) *100
In here, Base period is 2019
Table 2.7:
Trend analysis of financial position (2019 – 2023)
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF FINANCIAL POSITION |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Assets |
|
|
|
|
|
Non-Current
Assets |
|
|
|
|
|
Property, Plant and Equipment |
80.0% |
92.3% |
105.2% |
100.5% |
100.0% |
Intangible Assets |
|
- |
- |
- |
- |
Investment in Subsidiaries |
280.2% |
99.0% |
99.0% |
99.0% |
100.0% |
Investment in Equity Securities |
150.7% |
112.0% |
123.8% |
121.6% |
100.0% |
Deferred Tax Assets |
26.7% |
14.3% |
16.0% |
31.3% |
100.0% |
Right of Use Assets |
|
|
|
|
- |
Total
Non-Current Assets |
167.0% |
108.8% |
118.8% |
117.0% |
100.0% |
|
|
|
|
|
|
Current
Assets |
|
|
|
|
|
Inventories |
80.8% |
60.3% |
66.6% |
54.4% |
100.0% |
Investment in Equity Securities |
77.3% |
73.3% |
93.9% |
99.6% |
100.0% |
Trade Receivables |
59.1% |
112.3% |
131.8% |
197.0% |
100.0% |
Other Receivables |
22.3% |
26.3% |
55.3% |
52.1% |
100.0% |
Amounts Due from Related Companies |
293.5% |
338.2% |
175.3% |
131.2% |
100.0% |
Current Tax Assets |
28.8% |
29.2% |
64.7% |
96.8% |
100.0% |
Cash and Cash Equivalents |
99.5% |
4384.5% |
1001.1% |
63.9% |
100.0% |
Total
Current Assets |
128.7% |
198.2% |
117.8% |
96.3% |
100.0% |
Total
Assets |
160.1% |
124.7% |
118.6% |
113.3% |
100.0% |
|
|
|
|
|
|
Equity
and Liabilities |
|
|
|
|
|
Equity |
|
|
|
|
|
Stated Capital |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
Capital Reserves |
100.0% |
100.0% |
100.0% |
100.0% |
100.0% |
Fair Value through Other Comprehensive Income
Reserve |
155.9% |
113.2% |
126.3% |
123.8% |
100.0% |
Revenue Reserves |
206.3% |
132.7% |
115.5% |
104.7% |
100.0% |
Total
Equity |
158.6% |
115.4% |
120.6% |
116.8% |
100.0% |
|
|
|
|
|
|
Liabilities |
|
|
|
|
|
Non-Current
Liabilities |
|
|
|
|
|
Lease Liability |
|
|
|
|
- |
Retirement Benefit Obligations |
129.2% |
119.8% |
148.5% |
109.3% |
100.0% |
Total
Non-Current Liabilities |
129.8% |
120.3% |
149.0% |
109.8% |
100.0% |
|
|
|
|
|
|
Current
Liabilities |
|
|
|
|
|
Trade and Other Payables |
35.1% |
340.9% |
27.5% |
21.2% |
100.0% |
Amounts Due to Related Parties |
244.6% |
456.5% |
376.2% |
9.8% |
100.0% |
Loans and Borrowings |
|
- |
|
- |
- |
Lease Liability |
|
|
|
|
- |
Bank Overdraft |
72% |
88% |
14% |
140% |
100% |
Total
Current Liabilities |
183% |
247% |
90% |
68% |
100% |
Total
Liabilities |
179% |
236% |
95% |
71% |
100% |
Total
Liabilities and Equity |
160% |
125% |
119% |
113% |
100% |
Total non-current assets of Lanka Milk Foods (CWE) PLC increased
steadily over the five years, reaching 167.0% of the 2019 value by 2023. This
implies it happened mainly due to investment subsidiaries, and investment in equity
securities.
Total current assets showed considerable growth until 2022 climbing to
198.2% of the 2019 figure by 2022. This suggests effective management of
current assets, potentially an increase in inventory, amount due from related
parties, and cash reserves. Total current assets in 2023 is 128.7% of the 2019
figure which implies a decline of current assets in 2023 compared to 2022.
The company's total assets also experienced notable growth, reaching
160.1% of the 2019 level in 2023. The increase in total assets signifies
overall growth and enhanced financial health.
The equity of Lanka Milk Foods (CWE) PLC showed a consistent growth,
amounting to 158.6% of the 2019 figure by 2023. This reflects a sound financial
performance and a positive impact on shareholder equity. Here the Significant
rise in Total equity in 2023 happened due to Fair Value through Other
Comprehensive Income Reserve and Revenue reserves.
Total Non-Current Liabilities of Lanka Milk Foods (CWE) PLC shows
109.8%,149.0%,120.3% and 129.8% of the 2019 figure for 2020,2021,2022 and 2023
respectively. It implies a decline in Non-Current Liabilities in 2022 compared
to 2021.
Total current liabilities surged significantly, reaching 247% of the
2019 value in 2022. This might indicate an increase in trade and other
payables, amount due to related parties. This may permit further analysis to
ensure liquidity and financial stability. In 2023, total current liabilities
show 183% of the 2019 figure, which implies a decline in total current liabilities
of Lanka Milk Foods (CWE) PLC in 2023 compared to 2022.
The Total equity and liability of Lanka Milk Foods (CWE) PLC suggest a
substantial growth over the considered 5 years from 2019 to 2023.
Table 2.8:
Trend analysis of statement of profit or loss (2019 – 2023)
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF PROFIT OR LOSS |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Revenue |
211.9% |
178.1% |
161.4% |
157.7% |
100.0% |
Cost of Sales |
167.5% |
171.6% |
157.3% |
151.6% |
100.0% |
Gross
Profit |
3360.0% |
639.7% |
450.2% |
586.1% |
100.0% |
Other Operating Income |
20.5% |
2.6% |
108.0% |
86.3% |
100.0% |
Administrative Expenses |
157.8% |
135.0% |
131.8% |
112.0% |
100.0% |
Distribution Expenses |
105.1% |
83.9% |
111.0% |
87.5% |
100.0% |
Other Operating Expenses |
254.8% |
485.8% |
0.0% |
644.4% |
100.0% |
Profit
from Operations |
260.6% |
-124.2% |
134.4% |
95.5% |
100.0% |
Finance Income |
13496.7% |
12717.5% |
825.3% |
231.8% |
100.0% |
Finance Expense |
237.6% |
454.0% |
38.3% |
31.8% |
100.0% |
Net Finance Expense |
-1157.8% |
-836.6% |
-44.5% |
10.7% |
100.0% |
Profit
Before Taxation |
1307.7% |
401.7% |
266.4% |
158.0% |
100.0% |
Income Tax Expense |
-84.1% |
-23.4% |
103.7% |
376.7% |
100.0% |
Profit
for the Year |
1498.7% |
460.1% |
288.8% |
128.0% |
100.0% |
Lanka Milk Foods (CWE) PLC revenue showed an upward trend, growing
steadily over the five years. In 2023, it reached 211.97% of the 2019 figure.
This indicates steady revenue growth, implying that the company has effectively
expanded both its customer base and product offerings.
The cost of sales increased steadily until 2022 but decreased in 2023
compared to the 2022. In 2023, it was at 167.5% of the 2019 level, reflecting
effective cost control and procurement strategies.
Gross profit exhibited substantial growth, reaching 3360.0% of the 2019
figure in 2023, despite the dip in 2021 compared to 2020.This trend highlights
Lanka Milk Foods (CWE) PLC's ability to sustain robust profitability amid
growing sales, reflecting efficient operations and effective value creation.
Both profit before taxation and profit for the year experienced
substantial increases, with the 2023 figures reaching 1307.7% and 1498.7% of
their respective 2019 values. This remarkable profitability growth shows the
company’s ability to convert revenue growth and cost efficiency into
significant profits, indicating a resilient business model and robust financial
performance.
The trend analysis of Lanka Milk Foods (CWE) PLC's income statement
indicates a positive financial image. The company has consistently boosted its
revenue, maintained effective cost control, and achieved impressive
profitability. This financial resilience positions the company favorably for
future growth and strategic opportunities, making it an appealing prospect for
investors.
Ratio analysis is a key instrument for assessing a company's financial
performance and well-being. It entails the calculation of various financial
ratios using data from the organization's financial statements, including the Statement
of Profit or Loss, Statement of Financial Position, and Statement of Cash Flow.
These ratios assist stakeholders in making defensible decisions by offering
insightful information on several facets of the business's financial
performance.
Financial ratios can be categorized as follows;
1. Liquidity and Efficiency ratios
2. Solvency ratios
3. Profitability ratios
4. Market value ratios
A liquidity ratio is a type of financial ratio used to determine a company’s
ability to pay its short-term debt obligations. This ratio aids in figuring out
if a business can pay its current liabilities using its liquid, or current,
assets. A larger ratio indicates sound financial standing for the company. The
efficiency ratio is usually used to analyze how well a company uses its assets
and liabilities or in other words it measures a company’s ability to use its
assets to generate income. Under liquidity and efficiency ratio, working
capital, current ratio, acid test ratio, accounts receivable turnover, day’s
sales uncollected, merchandise turnover, day’s sales in inventory, and total
assets turnover are calculated.
Working capital is the difference between current assets and current
liabilities. Working capital is most important because it is used to keep a
business operating smoothly. When a company has negative working capital, which
means it does not have enough cash to cover its day-to-day functions.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Total
Current Assets |
2,070,138 |
3,188,130 |
1,895,777 |
1,549,565 |
1,608,901 |
Total
Current Liabilities |
1,169,836 |
1,574,218 |
571,778 |
433,127 |
637,870 |
Working
Capital |
900,302 |
1,613,912 |
1,323,999 |
1,116,438 |
971,031 |
In Lanka Milk Foods (CWE) PLC, working capital has continuously
increased over the period of 2019 to 2022 from Rs.971,031,000 to
Rs.1,613,912,000, which indicates continued improvement in liquidity and
operational efficiency. The company might be effectively managing its
short-term assets and liabilities. But in 2023 it has declined by Rs.713,610
,000 when compared to 2022.While it is still positive, it suggests a decline in
liquidity. The decrease was due to the percentage decrease in current assets is
greater than that of percentage decrease in current liabilities in 2023
compared to 2022. It might indicate that the company is facing tighter
liquidity conditions, which warrants a closer look at the reasons behind this
reduction.
Current ratio measures the short-term debt paying ability of the
company. To calculate the current ratio of a company, divide a company’s
current assets by its current liabilities. A ratio above 1 indicates the
company can meet its short-term obligations while below 1 suggests potential
liquidity issues.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Total
Current Assets |
2,070,138 |
3,188,130 |
1,895,777 |
1,549,565 |
1,608,901 |
Total
Current Liabilities |
1,169,836 |
1,574,218 |
571,778 |
433,127 |
637,870 |
Current
Ratio |
1.77 |
2.03 |
3.32 |
3.58 |
2.52 |
It is evident that the highest current ratio can be seen in 2020 during
the analysis period. From 2020 onwards, this ratio has declined gradually. Even
though the ratio declines, as all current ratios are greater than 1, we can
conclude that the company can cover their short-term obligations. However,
though a high ratio—say, more than 3.00—could indicate that the company can
cover its current liabilities three times, it also may indicate that it is not
using its current assets efficiently, securing financing very well, or properly managing its working capital. In 2020 and
2021, it shows the current ratio more than 3 which indicates that the company
is not using its current assets efficiently.
Quick ratio only considers more liquid assets. It leaves out current
assets such as inventory and prepaid expenses because the two are less liquid.
So, the quick ratio is more of a true test of a company’s ability to cover its
short-term obligations. Since it indicates a company's strong ability to meet
short-term obligations, a higher number is desired.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Total Current Assets |
2,070,138 |
3,188,130 |
1,895,777 |
1,549,565 |
1,608,901 |
Inventories |
532,944 |
398,066 |
439,541 |
358,547 |
659,652 |
Quick
Assets |
1,537,194 |
2,790,064 |
1,456,236 |
1,191,018 |
949,249 |
Total
Current Liabilities |
1,169,836 |
1,574,218 |
571,778 |
433,127 |
637,870 |
Acid
Test Ratio |
1.31 |
1.77 |
2.55 |
2.75 |
1.49 |
The highest ratio is reported in 2020 which is 2.75 and the lowest in
2023 which is 1.31. Even though the acid test ratio of Lanka Milk Foods (CWE)
PLC continuously declined over the last 4 years, the ratio has been more than 1
for every considered year, so it signals a stable position in the company. Typically,
a good acid-test ratio value is considered to be around 1 or higher, as this
suggests that the company's liquid assets are sufficient to cover its current
liabilities.
3.1.4 Accounts Receivable Turnover
Accounts Receivable Turnover measures how efficiently and quickly a
company converts its account receivables into cash within a given accounting
period.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Sales(Revenue) |
4,072,143 |
3,423,954 |
3,101,450 |
3,030,915 |
1,922,137 |
Trade Receivables |
102,438 |
194,871 |
228,608 |
341,801 |
173,475 |
Average
Trade Receivables |
148,655 |
211,740 |
285,205 |
257,638 |
172,925 |
Accounts
Receivable Turnover |
27.39 |
16.17 |
10.87 |
11.76 |
11.12 |
*In 2018, Trade Receivables= Rs.172,375,000
In Lanka Milk Foods (CWE)PLC, accounts receivable turnover increased
from 11.12 times to 27.39 times from 2019 to 2023. This indicates that Lanka
Milk Foods (CWE) PLC is collecting its receivables more quickly. This implies
more efficient collection practices and improved cash flow management.
Merchandise turnover is a financial ratio showing how many times a
company has sold and replaced inventory during a given period.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Cost
of Sales |
3,174,309 |
3,253,007 |
2,981,161 |
2,874,305 |
1,895,416 |
Inventories |
532,944 |
398,066 |
439,541 |
358,547 |
659,652 |
Average
Inventories |
465,505 |
418,804 |
399,044 |
509,100 |
578,870 |
Merchandise
Turnover |
6.82 |
7.77 |
7.47 |
5.65 |
3.27 |
*In 2018, Inventories=Rs. 498,088,000
From 2019 to 2022, there is a general upward trend that peaks in 2022.
After that, there was a slight decrease in 2023. This reflects that the
company's merchandise turnover improved over time, with a slight decline in the
most recent year. Higher turnover ratios generally indicate efficient inventory
management and strong sales.
This ratio determines the days the company may obtain the cash for its
sales. Lower the ratio is favorable.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Trade
Receivables |
102,438 |
194,871 |
228,608 |
341,801 |
173,475 |
Sales
(Revenue) |
4,072,143 |
3,423,954 |
3,101,450 |
3,030,915 |
1,922,137 |
Days
Sales Uncollected |
9.18 |
20.77 |
26.90 |
41.16 |
32.94 |
Days Sales Uncollected Ratio of
Lanka Milk Foods (CWE) PLC shows a significant improvement over the five-year
period, decreasing from 32.94 days in 2019 to 9.18 days in 2023. This reflects
that the company is becoming much more efficient in collecting its receivables.
Days sales inventory (DSI) is a financial ratio that measures the average
number of days it takes a company to sell its inventory. Lower DSI is preferable as it indicates that inventory is sold and
replaced more quickly.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Inventories |
532,944 |
398,066 |
439,541 |
358,547 |
659,652 |
Cost
of Sales |
3,174,309 |
3,253,007 |
2,981,161 |
2,874,305 |
1,895,416 |
Days
Sales in Inventory |
61.28 |
44.66 |
53.82 |
45.53 |
127.03 |
The DSI shows a significant
improvement from 2019 to 2020 but then fluctuates over the following years.
After reaching a low in 2020, the DSI increased slightly in the subsequent
years. The decrease from 2019 to 2020 suggests significant improvements in
inventory efficiency. The increase in the DSI ratio from 44.66 days in 2022 to
61.28 days in 2023 reflects that Lanka Milk Foods (CWE) PLC is having difficulty selling its inventory, which can
tie up cash and impact its cash flow.
Asset turnover ratio measures the value of a company's sales or revenues
generated relative to the value of its assets.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Sales
(Revenue) |
4,072,143 |
3,423,954 |
3,101,450 |
3,030,915 |
1,922,137 |
Total Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
Average
Total Assets |
12,839,183 |
10,967,850 |
10,453,042 |
9,614,161 |
10,546,542 |
Total
Assets Turnover |
0.317 |
0.312 |
0.297 |
0.315 |
0.182 |
*In 2018, Total Assets= Rs. 12,077,838,000
The Total Assets Turnover ratio shows a general upward trend over the
five years, from 0.182 in 2019 to 0.317 in 2023, though a slight decline has
happened in 2021 compared to 2020. This implies that the company has been
improving its efficiency in using its assets to generate sales.
Solvency ratios are referred to as financial leverage ratios. A
company's ability to pay off its long-term debt is measured by its solvency
ratio. It serves as an indicator of a company's financial health by indicating
if its cash flow is adequate to cover its long-term liabilities. Typical ratios
of solvency are as follows: Debt Ratio, Equity Ratio, and Time Interest Earned.
The debt ratio is a measure of how much debt a company has relative to
its assets. A higher debt ratio indicates that the company is more leveraged
and at greater risk of defaulting on its debt obligations.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Total
Liabilities |
1,245,117 |
1,644,015 |
658,237 |
496,822 |
695,877 |
Total
Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
Debt
Ratio |
8.63% |
14.62% |
6.16% |
4.86% |
7.72% |
The debt ratio of Lanka Milk Foods (CWE) PLC decreased from 14.62% in
2022 to 8.63% in 2023, which is a positive development. The highest debt ratio
is recorded in 2022 which is 14.62% while the lowest debt ratio is recorded in
2020 which is 4.86% So this company
shows a debt ratio between 4%-15% over 5 years.
As the debt ratio is lower than the equity ratios over the considered 5
years, it is a good situation for the financial health of the company because
it reduces the risk of financial distress or bankruptcy.
This ratio measures how much equity a company has relative to its
assets. A higher equity ratio indicates that the company is less leveraged and
more financially stable.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Total
Equity |
13,190,557 |
9,598,677 |
10,034,770 |
9,716,254 |
8,319,369 |
Total
Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
Equity
Ratio |
91.37% |
85.38% |
93.84% |
95.14% |
92.28% |
In Lanka Milk Foods (CWE) PLC shows equity ratios between 85.38% to
95.14% over the considered 5 years. Companies with an equity ratio of more than
50% are preferred by investors and creditors. As this company has the equity
ratios of more than 50% in all 5 years, it implies that the Lanka Milk Foods
PLC is in a financially stable position.
One indicator of a company's ability to produce adequate cash flow to
meet its interest payments is the times interest earned ratio. A higher ratio
of times interest earned signifies a stronger ability of the business to pay
its interest.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Profit
Before Interest Expense and Taxation |
522,792 |
(249,161) |
343,595 |
212,306 |
209,569 |
Interest
Expense |
223,704 |
427,476 |
36,108 |
29,920 |
94,163 |
Times
Interest Earned |
2.34 |
-0.58 |
9.52 |
7.10 |
2.23 |
In Lanka Milk Foods (CWE)PLC, the times interest earned ratio of the
company decreased from 9.52 in 2021 to -0.58 in 2022, which is a very negative
development. A negative times interest earned ratio indicates that the company
is not generating enough cash flow to cover its interest payments. But in 2023,
Time Interest Earned Ratio became positive (2.34) which indicates that it can
comfortably cover its interest payments and ensure favorable financial health.
Financial measurements known as profitability ratios are used to measure
and evaluate a company's performance during a specific period in terms of
income (profit), whether it be in relation to revenue, assets, operational
costs, or shareholder equity.
The ability of a company to generate net income from revenues is shown
by this ratio. A higher profit margin indicates that the business makes greater
profits from sales.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Net
Income |
1,520,907 |
466,879 |
293,050 |
129,936 |
101,483 |
Net
Sales |
4,072,143 |
3,423,954 |
3,101,450 |
3,030,915 |
1,922,137 |
Profit
Margin |
37.35% |
13.64% |
9.45% |
4.29% |
5.28% |
Though a small drop has happened in the net profit margin in 2020
compared to 2019, the net profit margin increased continuously over the last 4
years from 4.29% to 37.35%. This indicates that the Lanka Milk Foods (CWE) PLC
retained 37.35% of its revenue as profit in 2023. The significant increase in
profit margin suggests growing profitability, possibly due to cost management
and revenue growth. And it implies that investors may view the company
favorably, potentially leading to a higher stock price or more investment
opportunities.
This ratio measures how much of every rupee in sales is left over after
deducting the cost of sales to meet operating costs and profit. For a company
to survive, this value needs to be high.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Gross
Profit |
897,834 |
170,947 |
120,289 |
156,610 |
26,721 |
Net
Sales |
4,072,143 |
3,423,954 |
3,101,450 |
3,030,915 |
1,922,137 |
Gross
Margin |
22.05% |
4.99% |
3.88% |
5.17% |
1.39% |
Lanka Milk Foods (CWE) PLC’s Gross Profit Margin indicates a gradual
increment over the considered 5 years from 1.39% to 22.05%. This increase in
gross profit may indicate that the company is becoming more efficient in its
operations, possibly by reducing production costs or achieving better economies
of scale.
Return on Total Assets assesses the percentage of net profit relative to
total assets, revealing how effectively a company uses its assets to generate
profit.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Net
Income |
1,520,907 |
466,879 |
293,050 |
129,936 |
101,483 |
Total Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
Average
Total Assets |
12,839,183 |
10,967,850 |
10,453,042 |
9,614,161 |
10,546,542 |
Return
on Total Assets |
11.85% |
4.26% |
2.80% |
1.35% |
0.96% |
*In 2018, Total Assets= Rs.12,077,838,000
ROA was 0.96% in 2019 and gradually surged to 11.85% in 2023. This ratio
measures how efficiently the company utilizes its assets to generate earnings.
The consistent growth suggests improved asset utilization and profitability.
3.3.4 Return on Common Shareholders' Equity (ROE)
Return on Equity measures the percentage of net profit relative to
shareholders' equity, indicating how efficiently a company generates profit
from shareholders' investments.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Net
Income |
1,520,907 |
466,879 |
293,050 |
129,936 |
101,483 |
Preference
Dividends |
- |
- |
- |
- |
- |
Total Equity |
13,190,557 |
9,598,677 |
10,034,770 |
9,716,254 |
8,319,369 |
Average
Equity |
11,394,617 |
9,816,724 |
9,875,512 |
9,017,812 |
10,010,405 |
Return
on C/S Equity |
13.35% |
4.76% |
2.97% |
1.44% |
1.01% |
*In 2018, Total Equity= Rs.11,701,440,000
In 2019, the ROE of Lanka Milk Foods (CWE) PLC was 1.01%, and it
increased over the years to 13.35% in 2023. ROE reflects the return generated
for common shareholders. The continuous growth in ROE indicates that the
company is effectively utilizing common equity to generate returns for
shareholders.
The basic earnings per share (EPS) refers to the total amount of net
income that a company generates for each common share outstanding.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Net
Income |
1,520,907 |
466,879 |
293,050 |
129,936 |
101,483 |
Preference
Dividends |
- |
- |
- |
- |
- |
Weighted
Average Number of Ordinary Shares |
39998 |
39998 |
39998 |
39998 |
39998 |
Basic
EPS |
38.02 |
11.67 |
7.33 |
3.25 |
2.54 |
Basic Earning per share of Lanka Milk Foods (CWE) PLC has gradually
increased from Rs.2.54 in 2019 to Rs. 38.02 in 2023, indicating that the
company is operating more efficiently, potentially through better management
practices, cost control, or operational improvements.
3.3.6 Book
Value per Common Share
The book value
per common share is measured by taking the ratio of equity available to common
stockholders against the number of shares outstanding.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Shareholder's
Equity |
13,190,557 |
9,598,677 |
10,034,770 |
9,716,254 |
8,319,369 |
Preferred
Equity |
- |
- |
- |
- |
- |
Weighted
Average Number of Ordinary Shares |
39998 |
39998 |
39998 |
39998 |
39998 |
Book
Value per C/S |
329.78 |
239.98 |
250.88 |
242.92 |
207.99 |
Over the five years, Book Value per common share of
Lanka Milk Foods (CWE) PLC shows an overall upward trend from Rs07.99 in 2019
to Rs29.78 in 2023. This implies a general increase in the company's net book
value per share, which is a favorable sign of growth. The overall increase in
BVPS indicates that the company is strengthening its equity base. Over time,
the value of the equity that shareholders own in the company is increasing.
Market value ratios are a type of financial measure used to evaluate, analyze,
and compare stock prices to competitors' prices as well as to other relevant
facts and figures. To determine a company's place in the market, these ratios
monitor its financial success.
The Price Earning (PE) ratio
measures the valuation of a company's stock relative to its earnings.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Market
Price per share |
141 |
133 |
150 |
74 |
110 |
Earning
per share |
38.02 |
11.67 |
7.33 |
3.25 |
2.54 |
Price
Earning |
3.70 |
11.37 |
20.51 |
22.78 |
43.35 |
The price-to-earnings (P/E) ratio of Lanka Milk Foods (CWE)PLC gradually
declined from 43.35 to 3.7 from 2019 to 2023. This means that investors are
willing to pay less per share for the company's earnings in 2023 than in the previous
years. Overall, the decreasing P/E ratio is a negative indicator for the
company. Continuous declines in the P/E ratio could reflect worsening investor
sentiment or a loss of confidence in the company’s future prospects.
Dividend yield calculates
the return on investment from dividends paid by a company relative to its stock
price. It indicates the income generated from owning the stock.
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Annual
Dividend Per share |
5 |
7.5 |
5 |
2.5 |
1.25 |
Market
Price per share |
141 |
133 |
150 |
74 |
110 |
Dividend
Yield |
3.55% |
5.65% |
3.33% |
3.38% |
1.14% |
Lanka Milk Foods (CWE) PLC’s dividend yield fell from 5.65% in 2022 to
3.55% in 2023, marking a notable decline. This reduction implies that the
company is returning a smaller fraction of its earnings to shareholders as
dividends. However, it is important to remember that dividend yield is just one
aspect to consider when evaluating a stock. Other things to evaluate include
the company's financial condition, competitive landscape, and management team.
Overall, the drop in dividend yield may be a negative indicator for
shareholders, implying they will receive less in dividend payouts.
3.5 Altman Z Score (Bankruptcy Model)
Altman’s Z- score model is a numerical measurement that is used to
forecast the probability of bankruptcy of the company.
This is a combination of five weighted business ratios that is used to
estimate the profitability of financial distress.
Z = 1.2 X1 + 1.4 X2 + 3.3 X3
+ 0.6 X4 + 0.999 X5
X1 = Working capital / total assets
X2 = Retained earnings / total assets
X3 = Earnings before interest and tax / total assets
X4 = Market value of equity / total assets
X5 = Total revenue / total asset
Based on the Z score,
Z > 2.99 - Safe
zone
1.8 < Z < 2.99 - Grey zone
Z < 1.8 -
Distress zone
|
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Working
Capital |
900,302 |
1,613,912 |
1,323,999 |
1,116,438 |
971,031 |
Total
Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
X1 |
0.06 |
0.14 |
0.12 |
0.11 |
0.11 |
1.2
X1 |
0.07 |
0.17 |
0.15 |
0.13 |
0.13 |
|
|
|
|
|
|
Retained
Earnings |
3,328,400 |
2,101,943 |
1,814,237 |
1,634,632 |
1,556,558 |
Total
Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
X2 |
0.23 |
0.19 |
0.17 |
0.16 |
0.17 |
1.4X2 |
0.32 |
0.26 |
0.24 |
0.22 |
0.24 |
|
|
|
|
|
|
Earning
before Interest and Tax |
522,792 |
(249,161) |
343,595 |
212,306 |
209,569 |
Total
Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
X3 |
0.04 |
-0.02 |
0.03 |
0.02 |
0.02 |
3.3
X3 |
0.12 |
-0.07 |
0.11 |
0.07 |
0.08 |
|
|
|
|
|
|
Market Price per share |
141 |
133 |
150 |
74 |
110 |
Share Outstanding |
39998 |
39998 |
39998 |
39998 |
39998 |
Market
Value of Equity |
5,629,718.50 |
5,309,734.50 |
6,009,699.50 |
2,959,852.00 |
4,399,780.00 |
Total
Liabilities |
1,245,117 |
1,644,015 |
658,237 |
496,822 |
695,877 |
X3 |
4.52 |
3.23 |
9.13 |
5.96 |
6.32 |
0.6X3 |
2.71 |
1.94 |
5.48 |
3.57 |
3.79 |
|
|
|
|
|
|
Sales |
4,072,143 |
3,423,954 |
3,101,450 |
3,030,915 |
1,922,137 |
Total
Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
X4 |
0.28 |
0.30 |
0.29 |
0.30 |
0.21 |
0.999X4 |
0.28 |
0.30 |
0.29 |
0.30 |
0.21 |
|
|
|
|
|
|
Z |
3.51 |
2.60 |
6.26 |
4.29 |
4.45 |
According to the z-score of
Lanka Milk
Foods (CWE) PLC, Lanka
Milk Foods (CWE) PLC is in
the “Safe Zone’’ in 2019, 2020, 2021, and 2023 as the Z score is more
than 2.99. A safe zone implies there is no chance of bankruptcy. But in 2022
shows a Z score of between 1.8 and 2.99 which means the company is in the grey
zone and with a moderate chance of filing for bankruptcy.
Overall, the increase in Altman
Z-Score of Lanka Milk Foods (CWE) PLC from 2022 to 2023 is a favorable sign for
the company. It suggests that the company's chances of going bankrupt have
lessened.
The goal of financial statement analysis
is to comprehend and evaluate the data in the financial statements in order to
assess the firm's profitability and soundness financially and to project the
company's future prospects. The analysis's results are used by both internal
and external stakeholders. The above report consists of a thorough analysis of
Lanka Milk Foods (CWE) PLC. Data from five financial years were taken, and
horizontal, vertical, trend, and ratio analyses were performed.
Through this analysis, we can
conclude that Lanka Milk Foods (CWE) PLC has shown good performance and revenue
growth. Also, the percentage of total assets has been increasing.
From the Liquidity and efficiency ratio, we can determine the company's
efficiency and can conclude that its performance is efficient or not. Accordingly,
we can conclude that Lanka Milk Foods (CWE) PLC has maintained the liquidity
level at a stable amount.
When referring to the solvency
ratios: Debt Ratio, Equity Ratio and Time Interest Earned it implies that the
Lanka Milk Foods PLC is in a financially stable position.
Profitability ratios show that the company's financial performance has
consistently improved. Increasing gross margin, ROA, ROE, EPS, and profit
margin are signs of increased profitability and effective resource usage. The
company's operations appear to have been more profitable over time, as
indicated by this generally good trend for shareholders.
Market ratios determine a company's place in the market. The P/E ratio
and Dividend Yield of Lanka Milk Foods (CWE) PLC declined in 2023 compared to
2022, reflecting worsening investor sentiment or a loss of confidence in the
company’s future prospects.
Altman Z-Score of Lanka Milk
Foods (CWE) PLC has surged from 2022 to 2023 is a favorable sign for the
company. It suggests that the company's chances of going bankrupt have
lessened.
Bloomenthal, A.
(2024, July 26). Financial Ratio Analysis:
Definition, types, examples, and how to use. Investopedia.
https://www.investopedia.com/terms/r/ratioanalysis.asp
https://www.blogger.com/profile/18361654206049948515.
(2024, January 9). Colombo Stock Market
Financial Research. https://finacialsrilanka.blogspot.com/2024/#google_vignette
Lanka Milk Foods
PLC. (2023, September 3). Reports | Lanka
Milk Foods. Lanka Milk Foods. https://www.lmfgroup.lk/reports/
Team, C. (2023,
October 27). Altman’s Z-Score Model.
Corporate Finance Institute. https://corporatefinanceinstitute.com/resources/commercial-lending/altmans-z-score-model/
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF PROFIT OR LOSS |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Revenue |
4,072,143 |
3,423,954 |
3,101,450 |
3,030,915 |
1,922,137 |
Cost of Sales |
(3,174,309) |
(3,253,007) |
(2,981,161) |
(2,874,305) |
(1,895,416) |
Gross
Profit |
897,834 |
170,947 |
120,289 |
156,610 |
26,721 |
Other Operating Income |
106,066 |
13,535 |
558,303 |
446,031 |
516,741 |
Administrative Expenses |
(310,855) |
(265,910) |
(259,605) |
(220,541) |
(196,976) |
Distribution Expenses |
(141,477) |
(112,875) |
(149,389) |
(117,810) |
(134,592) |
Other Operating Expenses |
(28,776) |
(54,858) |
|
(72,769) |
(11,292) |
Profit
from Operations |
522,792 |
(249,161) |
269,598 |
191,521 |
200,602 |
Finance Income |
1,210,114 |
1,140,255 |
73,996 |
20,784 |
8,966 |
Finance Expense |
(223,704) |
(427,476) |
(36,108) |
(29,920) |
(94,163) |
Net Finance (Expense)/Income |
986,410 |
712,779 |
37,888 |
(9,136) |
(85,197) |
Profit
Before Taxation |
1,509,202 |
463,618 |
307,486 |
182,385 |
115,405 |
Income Tax Expense |
11,705 |
3,261 |
(14,436) |
(52,449) |
(13,922) |
Profit
for the Year |
1,520,907 |
466,879 |
293,050 |
129,936 |
101,483 |
Statement of
Financial Position
Lanka Milk Foods (CWE) PLC |
|||||
STATEMENT
OF FINANCIAL POSITION |
|||||
For the Year Ended 31st March |
2023 (Rs.'000) |
2022 (Rs.'000) |
2021 (Rs.'000) |
2020 (Rs.'000) |
2019 (Rs.'000) |
Assets |
|
|
|
|
|
Non-Current
Assets |
|
|
|
|
|
Property, Plant and Equipment |
109,008 |
125,751 |
143,283 |
136,964 |
136,226 |
Intangible Assets |
2,990 |
|
|
|
|
Investment in Subsidiaries |
3,015,000 |
1,065,000 |
1,065,000 |
1,065,000 |
1,076,022 |
Investment in Equity Securities |
9,218,177 |
6,852,754 |
7,576,553 |
7,437,642 |
6,118,831 |
Deferred Tax Assets |
20,082 |
10,750 |
12,059 |
23,542 |
75,266 |
Right of Use Assets |
279 |
307 |
335 |
363 |
|
Total
Non-Current Assets |
12,365,536 |
8,054,562 |
8,797,230 |
8,663,511 |
7,406,345 |
|
|
|
|
|
|
Current
Assets |
|
|
|
|
|
Inventories |
532,944 |
398,066 |
439,541 |
358,547 |
659,652 |
Investment in Equity Securities |
162,302 |
153,778 |
197,002 |
209,061 |
209,839 |
Trade Receivables |
102,438 |
194,871 |
228,608 |
341,801 |
173,475 |
Other Receivables |
21,524 |
25,369 |
53,253 |
50,198 |
96,324 |
Amounts Due from Related Companies |
1,219,147 |
1,404,537 |
728,200 |
544,979 |
415,355 |
Current Tax Assets |
9,036 |
9,167 |
20,322 |
30,381 |
31,395 |
Cash and Cash Equivalents |
22,747 |
1,002,342 |
228,851 |
14,598 |
22,861 |
Total
Current Assets |
2,070,138 |
3,188,130 |
1,895,777 |
1,549,565 |
1,608,901 |
Total
Assets |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |
|
|
|
|
|
|
Equity
and Liabilities |
|
|
|
|
|
Equity |
|
|
|
|
|
Stated Capital |
999,950 |
999,950 |
999,950 |
999,950 |
999,950 |
Capital Reserves |
105,116 |
105,116 |
105,116 |
105,116 |
105,116 |
Fair Value through Other Comprehensive Income
Reserve |
8,647,091 |
6,281,668 |
7,005,467 |
6,866,556 |
5,547,745 |
Revenue Reserves |
3,438,400 |
2,211,943 |
1,924,237 |
1,744,632 |
1,666,558 |
Total
Equity |
13,190,557 |
9,598,677 |
10,034,770 |
9,716,254 |
8,319,369 |
|
|
|
|
|
|
Liabilities |
|
|
|
|
|
Non-Current
Liabilities |
|
|
|
|
|
Lease Liability |
312 |
290 |
306 |
320 |
|
Retirement Benefit Obligations |
74,969 |
69,507 |
86,153 |
63,375 |
58,007 |
Total
Non-Current Liabilities |
75,281 |
69,797 |
86,459 |
63,695 |
58,007 |
|
|
|
|
|
|
Current
Liabilities |
|
|
|
|
|
Trade and Other Payables |
121,898 |
1,182,122 |
95,516 |
73,504 |
346,795 |
Amounts Due to Related Parties |
90,743 |
169,346 |
139,566 |
3,641 |
37,094 |
Loans and Borrowings |
775,000 |
|
300,000 |
|
|
Lease Liability |
20 |
60 |
59 |
59 |
|
Bank Overdraft |
182,175 |
222,690 |
36,637 |
355,923 |
253,981 |
Total
Current Liabilities |
1,169,836 |
1,574,218 |
571,778 |
433,127 |
637,870 |
Total
Liabilities |
1,245,117 |
1,644,015 |
658,237 |
496,822 |
695,877 |
Total
Liabilities and Equity |
14,435,674 |
11,242,692 |
10,693,007 |
10,213,076 |
9,015,246 |