Analysis of Financial Statements – UNILEVER PAKISTAN LIMITED – Financial Year 2004- Financial Year 2010

Unilever Pakistan Limited, formerly known as Lever Brothers Pakistan Limited (LBPL) is a subsidiary of Unilever PLC, UK. ULEVER was incorporated in Pakistan in 1948 as Lever Brothers Pakistan Limited and merged with Lipton in 1989 and Brooke Bond in 1997.

================================================================
COMPANY SNAPSHOT
================================================================
Name of company Unilever Pakistan Limited
Nature of Business Fast Moving Consumer Goods
Ticker ULEVER
Net Sales CY ’09 Rs 38,187,582,000
Net Sales CY’10 Rs 44,671,507,00
Share price (avg.) – year end Rs 4360
Market Capitalization – year end Rs 57964 million
================================================================

ULEVER has adapted Unilever global brands such as Lifebuoy, Lux, Surf and Walls to local consumer needs at affordable prices. Since 1998, ULEVER has been entrusted with the responsibility of developing the Afghanistan business through a dedicated sales & distribution network. A wide range of products are offered for export. In June 07, Unilever Overseas Holding Limited, the ultimate parent company, purchased all the shares held by the Government of Punjab. This has increased Unilever’s shareholding in the Company from 67.04% to 70.4%.

Segments at a glance

Unilever comprises of 4 segments:

— Home and Personal Care – represents laundry and a wide range of cleaning, skin care, hair care and oral care products

— Beverages – represents tea

— Ice Cream – represents ice cream

— Other – represents margarine

The graph above shows the sector wise percentage of the gross sales. Home care and personal care had the most sales with 55% with beverages coming next with 30%. Ice creams had a share of 12% in the total shares and spreads with 3%.

Home and Personal Care

The home and personal care business sales grew by more than 15% on account of robust performance in the key categories. In three years, the cumulative growth if this business stands at 110%. Due to the volume lost because of the floods and increase in material costs, the gross margin declined slightly. However, the decline was partly offset by effective advertising and lower operating costs and hence the company registered a gross margin of 16.1% in the year 2010.

The graph on the right shows the net sales and the profit through the years for home and personal care business.

Beverages

Sales growth was 13.5% which was mainly price-led. Free availability of smuggled tea through Afghan trade remained a point of concern for all local branded players. Gross margins were under pressure during the year as tea prices hit record high due to increase in global demand, stagnantsupply and currency devaluation.

Ice cream& Spreads

Despite severe electricity crisis in the summer season, Wall’s delivered a growth of 33.3% in 2010 all from volume. This growth was achieved by bringing in new flavours such as “Badami” and “Cornetto double chocolate” which attracted consumers.. The cumulative growth over the last three years has been 80%. The spreads also witnessed a growth of 20.2% mainly because of volume that it sold. The graph below shows the sales and profit margin through the years of the ice cream segment of Unilever Pakistan.

Financial Performance: FY’04 – FY’10

Pakistan faced multiple challenges during 2010. Low GDP growth, double digit inflation, deteriorating security environment, continuing devaluation of the Rupee and debilitating power cuts along with gas load shedding impacted business in general. The ever worsening security conditions of the country also had a great impact on the businesses. Furthermore, the devastating floods that started in mid-July wreaked havoc in the country and affected all kinds of businesses. In addition to the generally difficult operating environment that impacted all businesses in 2010, rampant smuggling of tea affected the growth and profitability of the business. Despite this, the company delivered a 7.10% high profit after tax, which is low as compared to the growth of 54% in FY’09, on the back of 17% growth in sales (FY09: 23.4%).

Despite high COGS, overall gross profit improved by around 9.31%. The gross margin level dropped a little from 35% in FY09 to 32.6% in FY10. Return on Asset showed a decrease from 40% in FY09 to 35% in FY10 whereas return on equity decreased from 93% to 92% in FY10. Overall PAT increased from Rs 3056 million in FY09 to Rs 3273 million n FY10, an increase of 7.1%.

The current ratio was on a decline since 2003 till 2008 but it picked up in 2009. However, it remained the same in FY10 at 0.83 with no improvement.. Short term borrowings decreased from Rs 3233 million in FY08 to Rs 1038 million in FY09.Quick ratio, a better measure of liquidity followed a trend similar to current ratio, declining till FY08 and an increase in FY09. The ratio also witnessed an increase in FY’10 as it went up to 0.36 from 0.28 in FY’09. Till FY’08,there was a positive growth in current assets but the growth in current liabilities was far more. In FY’09, the current assets increased but the decline in current liabilities was large enough to improve the overall liquidity ratios. However, in FY’10, both the current assets and the current liabilities went up. The increase however was almost the same with current assets up by 25.63% and current liabilities by 26.36%. This is the reason why the current ratio was same for both the years.

Inventory Turnover (ITO) ratio depicts how quickly the company is able to sell off its inventory.ITO had been on a slight rise from FY06 to FY08. The slight increase is indicative of ULEVER’s declining operational efficiency with growth in net sales lagging behind the growth in inventory kept by the company. Especially in FY’08 the growth in inventories has been exponential, with a rise of 54.5%. However, ITO decreased from 58 days in FY09 to 46 days in FY’10. Stock in trade increased from Rs 3649 million in FY09 to Rs 3811 million. The decrease in ITO shows that ULEVER is able to efficiently turn its inventory into sales.

Day sales outstanding (DSO) shows how quickly the company is able to collect the dues from its debtors. It should be enough for the company to avoid risks of bad debts. DSO has slightly been improving over the years. It showed an increase in FY09 from 3 to 4 days. It remained the same, 4 days in FY’10 too.DSO is still very negligible compared to ITO. The operating cycle of ULEVER hence followed the same trend as that of ITO in the respective years.

TATO of ULEVER has remained flat at 3 over the period under review, reflecting that the company is anticipating any increase in its sales and responding to it in a timely fashion by enhancing its assets base accordingly. It has declined slightly in FY’07 and FY’08. The Sales/Equity, on the other hand, shows a rising trend after ’04 on the account of declining equity base in the subsequent years. However in FY09, equity base increased due to the increase in reserves resulting in a decline in sales/equity ratio. In FY’10, however, it increased to 12.55 due to 17% increase in sales as compared to 7% increase in equity.

As far as debt management is concerned, both D/A and D/E ratios after 2004 (the decline in 2004 is because the ULEVER retired significant amounts of debt in that year) show ULEVER’s increased reliance on debt financing rather than equity financing. The trend lines in particular show that D/A (0.63 to 0.80) ratio for the last four years has remained almost stable over the years whereas D/E ratio has increased significantly (1.8 to 4.13) owing to increasing long term debts (as further evident by the long term debt to equity ratio) to finance the expansion. However, the situation reversed in FY09. Long term debt to equity ratio was maintained at a level of 0.31 whereas debt to equity declined from 4.13 to 2.47 in FY09 resulting from a decline in current liabilities (mainly short term borrowings). In FY’10, both the ratios increased very slightly but more or less remained the same.

The TIE ratio has decreased from a level of 107 times in FY04 to only 20 times in FY09.Even though this ability increased in 2006 (owing to comparatively lower finance costs), a massive surge in finance costs (70.64%) vis-à-vis a 3% increase in EBIT, was responsible for a plunge in FY’07 TIE ratio. Finance costs also rose sharply in FY’08, mainly due to markup on short term borrowings and exchange loss, which caused further decline in TIE. This ratio slightly improved in FY09 due to lower finance costs. There was a decrease in bank charges, exchange losses and the interest on short term loans. In FY’10, the ratio increased to 34times from 20 times in FY’09 because of 55% decrease in finance cost of the company. The short-term borrowings also witnessed a nose dive as it decreased by 72%. The finance cost also decreased by almost 56%. The main reasons for the decrease were 42% decrease in mark-up of short-term borrowings as the amount of borrowing and the rate (KIBOR) were also less. There was also a86% decline in the exchange loss which caused the finance cost of the company to decline.

The (P/E) ratio shows how much investors are willing to pay per rupee of the reported profits, depends on the company’s price per share and its earnings per share (EPS). ULEVER’s EPS has been erratic (fluctuating between 120 and 130) till FY07, driven mainly by any changes in company’s profit after tax (as its no. of shares have been constant so far). In FY’08, the growth in profit after tax caused EPS to cross the 130 mark and went till Rs 149. This figure further increased to Rs 230 in FY09, an increase of 54%.In FY10, the EPS increased to Rs 246, an increase of 7%. This increase was due to the 7% increase in the net profit of the company. The P/E ratio also increased to 18 in FY’10 from 10 in FY’09.

The year-end market prices of ULEVER have been increasing till FY07. Consequently, the P/E ratio also followed a rising trend driven by the increases in market price of shares, reflecting the investor’s confident in ULEVER. In FY08 the market prices went down due to the ongoing stock crisis in the country, coupled with the global recession.The market price improved in FY09 to Rs 2300 (FY08: Rs 1808). The market price further improved to Rs 4360, an improvement of 89.6%. The huge improvement in the market price shows that UNILEVER was performing well and investors had confidence in the shares.

The book value per share of the company increased slightly from Rs 248 in FY09 to Rs 269 in FY’10. There was no change in the number of shares or the share capital but reserves increased from Rs 2622 million in FY09to Rs, 2891 million mainly because of the increase in unappropriated profits. Dividend per share also increased from Rs 229 in FY09 to Rs 246 in FY10. Total profit distributed by way of dividend amounts to 99.9% (FY09: 99.6%).

Future Outlook

After some respite, there is a growing fear that with the surge in price of oil, sugar, tea and other food items, inflation will increase. Continuing rupee devaluation, down trading of consumers due to lower disposable income and increase in acts of terrorism will put pressure on business performance. The destruction caused by the floods is also going to show its impact in the coming year.

Also, smuggling of black tea through Afghan transit trade is an on-going threat to the tea category. Counterfeiting of the popular brands continues to impact results generally. With no reprieve in the on-going electricity crisis, the ice cream and spreads businesses are likely to come under pressure.

Unilever, however, performed quite well during the last year. For example, even due to load shedding, the ice cream sector’s sales increased. Seeing it performance, it is expected to perform well in the coming years as well.

=============================================================================================
2004 2005 2006 2007 2008 2009 2010
=============================================================================================
Liquidity
Current Ratio times 1 1 0.9 0.7 0.7 0.8 0.83
Quick Ratio times 0.5 0.5 0.4 0.2 0.2 0.3 0.36
Asset Management
Inventory Turnover days 64 59 54 63 64 58 34.15
Debtors Turnover days 6 2 2 3 3 4 4.21
Operating Cycle days 70 61 56 66 67 62 38.37
Total Asset Turnover times 3 3 3 3 3 3 3.31
Sales/Equity times 8.66 9.57 11.47 11.78 13.97 11.60 12.55
Profitability
Gross Profit Margin % 30 38 37 39 35 35 32.63
Net Profit Margin % 9 9 8 7 6 8 7.33
Return on Assets % 37 43 39 31 26 27 35.40
Return on Equity % 82 87 90 85 90 93 91.94
Debt Management
Debt/Asset times 0.64 0.68 0.71 0.75 0.80 0.71 0.74
Debt/Equity times 1.79 2.14 2.51 3.08 4.13 2.47 2.79
Long-term Debt/Equity times 0.04 0.20 0.19 0.25 0.31 0.31 0.27
Times Interest Earned times 107 141 223 84 18 20 34.00
Market Value
Earnings per share Rs 130 121 124 127 149 230 246.00
Price/Earnings ratio times 11 15 16 18 12 10 18.00
Dividend per share Rs 135 120 122 123 123 229 246.00
Book Value per share Rs 158 139 138 149 167 248 269.00
Number of shares issued No in ‘0 13,294 13,294 13,294 13,294 13,294 13,294 13294
Market Price – year end Rs 1,475 1,775 2,000 2,280 1,808 2,300 4360.00
=============================================================================================

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s