Total Pageviews

Monday, July 21, 2014

ASII



Background
Based on World Bank in third quarter of 2013 Indonesia’s economic growth in 2014 was expected increase 5.6 % up. With dominant domestic consumption and stable politic atmosphere economic growth of Indonesia is still promising. Its challenge may have come from high inflation rate, foreign exchange rate, oil subsidies and high interest rate.
The result of president election in Indonesia at 2014 will affect the economic indicator in second semester of 2014. Investor seems to wait its result before take investment decision as each president has each program in economic development and policy.  
Government allocated much money to subsidies energy consumption especially for oil consumption. The import of diesel contributed to the trade deficit is much. Expert expected government to emphasize energy conversion policy to reduce it. The combination diesel and biodiesel could be a good option for energy conversion policy.  Based on Indonesian Palm oil association, 34 % of the nationwide palm oil biodiesel is absorbed domestically and the rest is exported. Indonesia has largest Palm tree plantations.
In other hand, government encourages people to use Low Cost Green Car to reduce subsidized oil consumption. Low Cost Green Car is vehicle with lower fuel consumption and friendly for environment. For household, gas is good alternative fuel.

Manufacture Industry
Manufacture industry in 2008 – 2012 has compound annual growth rate at 9.4 % (at current price). The investment in manufacture industry has been still growing as the increase in demand for products.
Transport Equipment and machinery sector
The industry has average growth rate at 9 % in 2008 – 2012 (at the current price). Government put development in infrastructure as one of important strategy to reach targeted economic growth. Loan to Value policy should also to be fixed with concerning in purchasing power of consumer.
Heavy equipment for mining and exploration is slowing down as the lower growth in quarrying sector. Its growth rate is slowing down since 2009 -2010. Due to decline in commodity price, commonly major company in mining and heavy equipment is experiencing decrease in its revenue in 2014.
But there are other commodities that increase in its price such as nickel.




Astra international
With low competitiveness in Indonesia, major player such as Astra International could lead the market share in several years for several products. The group has six major business, those are automotive, financial services, agribusiness, and Infrastructure and Information technology. The key drivers of its growth are automotive segment and heavy equipment and mining sector which is each contribution to revenue are 56.3 % for automotive and 26.3 % for heavy equipment and mining.
Net sales
%
109,154.0
56.3
13,867.0
7.2
51,012.0
26.3
12,675.0
6.5
7,843.0
4.0
2,261.0
1.2

In 2013 the group expands its business in automotive, infrastructure and property.
Company
Acquisition
Divestment
Astratel Nusantara and subs
Pelabuhan Pe-
najam buana -
Taka
Astra Otoparts
PT. Pakoakuina
15% share
(51% owned)
Astra Int Group
2.4 hectare land
for office tower
& residential
apartment
Suryaraya Prawira
100% share
Brahmayasa Bahtera
40% share

The group has subsidiary in financial services sector such as Bank Permata, Komatsu Astra Finance (KAF),Surya artha nusantara. Its contribution to group’s revenue is 7.2 % of total revenue.
Astra Int group does good synergy in operating its six business portfolio. The group deposits its biggest cash bank in bank permata amounting to 2.6 trillion and it also has biggest time deposit in bank permata amounting to 5.3 trillion in December 2013.
The group also does the same thing with its portfolio in infrastructure business. Astratel Nusantara did acquisition of penajam buana taka port in east Kalimantan in order to support its business in the area includes palm plantation sector, mining and heavy equipment sector. The purchase of the port is also having purpose to get revenue from other non-group businesses such as oil and gas.
The product of automotive subsidiary of the group are Toyota, Daihatsu, isuzu, UD Trucks,BMW and Peugeot and etc for wholesale car. Meanwhile the product of motorcycle is only Honda. Toyota is market leader in Indonesia for car and Honda lead market share of motorcycle in Indonesia.  Toyota owns more than 35 % of total market share and Honda has more than 60 % of total market share.
More vehicles mean more oil for its fuel. Government will allocated more subsidized gasoline and diesel as the increase of automotive product sold. In other hand that means the government has to provide more infrastructures for vehicle.
Year
Real  Growth
Sales Growth
2009
5.4
1.5
2010
6.9
31.0
2011
6.5
26.0
2012
6.1
15.7
2013
5.6
3.1
2014E
5.6
5.7

Based the data at above it can be taken an estimation of sales of 2014. It will grow at 5.7 % up. The correlation between real growth rate and sales growth is very significant which is at 0.9. Within adjusting the real growth at same level 5.6 %, the sales growth will be at 5.7 %.
Sales growth in 2013 is decline from 15.7 in to 3.1. The economic slowing down and tight monetary policy may have encouraged people to delay their spending.
Ratio analysis
ROE
2012
2013
2014
2015
2016
Net Profit margin
12.1
11.5
11.4
11.4
11.3
Asset Turn Over
103.2
90.6
87.0
78.3
71.5
ROA
12.5
10.4
9.9
8.9
8.1
Financial Leverage
256.0
254.9
219.5
208.6
200.9
ROE
31.9
26.6
21.8
18.6
16.2
Net sales
188,053.0
193,880.0
204,931.2
215,177.7
225,936.6
Gross profit
62,155.0
67,329.0
71,166.8
74,725.1
78,461.3
CFO
43,117.0
52,041.3
51,811.1
53,027.1
Net Addition
37,458.0
9,694.0
10,246.6
10,758.9
Free Cashflow
5,659.0
42,347.3
41,564.5
42,268.2

It is used adjustment in 2014, the company will allocate 5 % of revenue in its capital expenditure. The sales growth will be at 5.7 % as the result of investment in previous year. The sales growth in 2015-2016 is in 5 % with assumption capital expenditure will be at 5 % sales.







Monday, June 23, 2014

P G



Procter and Gamble Company is operating in 180 countries and region all over the world. Its key driver in generating its cash flow is its business territory at USA which is more than 39 percent of its worldwide total sales. The largest segment in its revenue is coming up from Fabric care and home care which is 32 % of total revenue. The second segment is beauty product which is at 24 % of sales.
According to IMF, economic growth of USA is predicted at 2 % It means the company has good opportunity to grow better. The last sales growth in 2012-2013 is 0.6 percent. The company categorizes its territory in to five major areas which are North America, Western Europe, Asia, Latin America and CEEMEA.
                  2011
                  2012
            2013
North America
41.0
39.0
39.0
western Europe
20.0
19.0
18.0
Asia
16.0
18.0
18.0
Latin America
9.0
10.0
10.0
CEEMEA
14.0
14.0
15.0

Segments
Percentage
Fabric Care and Home Care
32
Beauty
24
Grooming
9
Healthcare
15
Baby care and Family care
20

Forecast of Net sales
There is a significant correlation between its Capital expenditure and net sales. With in simple analysis we could find its correlation is more than 0.7 which means indicating strong correlation. Based on data of economic growth of USA in 2008 -2012 and data of its worldwide net sales in 2008 -2012, there is strong correlation between economic growth of USA and its net sales. It could be concluded that USA economy still having strong influence to its revenue.
If I used CAGR of Capital expenditure in 2008 – 2012, I find its CAGR is at 6 %. Within assumption of 6 % growth of its capex in 2014, I make assumption that its worldwide sales will grow 2 % up. In another factor IMF has prediction that US economy will grow 2 percent.





The forecasting of financial condition between in 2012-2016 is as the following table:
ROE
2012
2013
2014
2015
2016
Net Profit margin
13.0
13.5
13.5
13.3
13.1
Asset Turn Over
63.3
60.4
55.9
51.4
47.7
ROA
8.2
8.2
7.5
6.8
6.2
Financial Leverage
208.5
204.6
193.0
186.8
182.1
ROE
17.2
16.8
14.5
12.7
11.3

2013
2014
2015
2016
CFO
8071.0
10254.8
10425.7
10580.5
Net Addition of Fixed Asset
-3087.0
-4208.4
-4292.5
-4378.4
Free Cash Flow
4984.0
6046.4
6133.2
6202.1



From table at above the assumption of free cash flow in 2016 is forecasted to 6202.1, the result is calculated with steady net sales growth at annually in 2 % from 2014 until 2016 and capital expenditure is  at 5% net sales in 2014-205. 


The company is mature and it is the market leader in almost all segments and its territory. It causes its sales growth very low in 0-2 percent in the last five years.

The CEO encourages all employees to make innovation as in his book in Game Changer. The company tends to decrease its employee in several years. In 2008 the number of employee was 135,000. It was decreased in to 121,000 people. The company looks using more technology and more outsourcing to reduce cost and enhance its profit.
All products and its manufacture process are protected with patent and license. Its good will and intangible assets in 2013 are more than 60 percent of its total asset. That means trade mark and its patent right are valuable asset for the company as their trademarks are market leader in each segment.






Sunday, June 1, 2014

UNVR




Background
Indonesia’s economy has consistent growth in its public consumption and investment. 97 % of its GDP is contributed by its domestic economy. The World Bank forecasted that Indonesia’s economy will grow 5.3 % in its report at quarter 3/2013. Its domestic economy consists of public consumption which is at 55 % of GDP and investment which is at 34 % of GDP.
Steady economy is accompanied by relatively stable inflation and healthy demographic structure with high productive age number. With that strength of Indonesia’s economy, public consumption and investment are expected continue to grow as the key driver of economic growth.

Inflation rate vs. BI Rate
Inflation rate (yoy) in 2013 is at 7.25 %, this is higher than previous year which was at 4.3 %.in order to control inflation rate government increase BI Rate at 7.5 %. With regression analysis we could find the correlation between BI rate and inflation rate in 2007-2013 with t-stat at 3.9 or bigger than 2. If BI rate is still 7.5 %, it will reduce the inflation rate from 7.25 % in to 6.90 %.
Once the inflation rate decline usually investor will expect central bank to reduce its BI rate. And people will be expected to increase their public consumption and investment.

UNVR
 UNVR is one of the favorite stocks in IHSG. In fundamental analysis, UNVR has a consistent growth in the several years as low competitiveness in Indonesia. The foreign investment such as UNVR is able to be a market leader easier. In the period of 2007 – 2013, the company has Compound annual growth rate (CAGR) at 16.1 % in its net sales. With regression analysis between non oil and gas manufacturing and net sales of the company, the possible sales growth in 2014 is at 16.1 % higher than its sales in 2013 which was at 12.7 %.
With possible lower inflation rate in 2014, public consumption will be higher. BI Rate is possible not changing and the inflation rate may have been reduced. People tend to increase its consumption include consumer goods, house hold product, food and beverage.
Good news from UNVR, the company has no long term debt. That means the company has strong internal source of fund. The company has good liquidity. 



Forecast
I used lattes CAGR to make simple assumption in sales of 2014. CAGR of 2007 -2013 is at 16.1 %. I made assumption that sales will experience consistent growth in 2014 – 2016. I took gross profit margin at 51.3 % of sales. I used assumption that the company will spend 5 % of its net sales for capital expenditure and it will be still used its short term loan as its source of fund to finance its asset.
The key ratio in 2012-2016 of its forecasting is as the following list

Ratio analysis
Net Profit margin
16.8
16.0
16.0
16.0
16.1
Asset Turn Over
227.8
230.4
175.4
145.5
126.8
ROA
38.3
36.8
28.1
23.3
20.4
Financial Leverage
302.0
313.7
203.9
171.2
155.7
ROE
115.7
115.4
57.4
40.0
31.7
Net Sales
27,303,248.0
30,757,435.0
35,678,624.6
41,387,204.5
48,009,157.3
CFO
5,751,738.0
6,616,947.3
7,539,803.3
8,747,675.8
Net Add fixed asset
1,031,438.0
1,537,871.8
1,783,931.2
2,069,360.2
Free Cash Flow
4,720,300.0
5,079,075.6
5,755,872.1
6,678,315.5