Investment

Essay by zxin1028 June 2010

download word file, 11 pages 0.0

Downloaded 22 times

BAO3403 INVESTMENTS AND PORTFOLIO MANAGEMENT

Group members:

Liu Tianyi ID: 3750862

Zhao Xin ID: 3749501

Zhao Xin ID: 3750850

�

Summary

In this report, three companies which are listed on the Australian Stock Exchange are chosen: Woolworths Ltd., Lion Nathan Ltd. And Super Cheap Auto Group Ltd.. This report will be divided into three sections. In the first section, the company's historical share price will be downloaded on the website, and the price trend, required return and dividend growth will be calculated and represented in a chart. In the second section, the story of company will be introduced. It includes the information which can influent the investors decision, such as, director's statements, media releases and corporate governance etc.. In the third section, the conclusion will be made through the comparison of the three companies, and an allocation will be justified if we currently have $10,000 to invest.

�

Suggested Report

1.0 THE NUMBERS

1. 1 Trend in Monthly Share Prices

The date in Appendix 1 (Table 1) describes the adj.

close and returns of the three companies from 1 April 2004 and 1 April 2009 in monthly and the Squared Deviation of the date is pointed out.

In Figure 1,2&3 of the three line charts show monthly share prices and returns in the same period.

�

Figure 1

�

Figure 2

�

Figure 3

This is the form of price and return of WOW. The price of WOW registers as a growing trend although it has some fluctuation. The general trend of price is growing steadily. Returns fluctuate prodigious.

The price of SUL is very stable as nearly there is no fluctuation. However, returns of SUL fluctuated heavily. From the data, we can see that it has, the highest monthly return was 24.86% and the lowest was -26.04%.

The price of LNN is quite stable, the standard deviation of LNN is 0.048, and the beta is 0.063. When the price became the top in current five years, the return is also the highest. After that, the return was down to the lowest point

Average

Monthly price

Average Monthly Returns

Standard Deviation

Beta

WOW

21.8

0.01402

0.0550

0.7

LNN

8.217

0.00521

0.0481

0.63

SUL

3.04

0.00432

0.1064

1.03

In this chart, the average monthly price of WOW is the highest, which means the price is higher than the two other companies are.

Future Growth

Require return=

As risk- free rate (RF) is 2-year Australian Treasury rate in average, which is 2.84%

And he risk-premium is 7.3%, so the E (Rm) is 2.84%+7.3%=10.14%.

WOW: Require return= 2.84% +0.7(10.14%-2.84%) = 7.95%

LNN: Require return= 2.84% +0.63(10.14%-2.84%) = 7.439%

SUL: Require return= 2.84% +1.03(10.14%-2.84%) = 10.359%

As the Sustainable growth= (1- Payout ratio) x ROE

The payout ratio of each share is 69%, 80% and 54%, then the Return on Equity (ROE) is 27.2%, 31.7%and 19%. So,

WOW: sustainable growth= (1- 69%) x 27.2%= 8.432%

LNN: sustainable growth= (1- 80%) x 31.7%= 6.34%

SUL: sustainable growth= (1- 54%) x 19%= 8.74%

Average Historical Growth

Sustainable Growth

Forecast 2-year Growth

WOW

18.5%

8.432%

10.6%

LNN

9.2%

6.34%

7.8%

SUL

15.9%

8.74%

11.3%

The date of average historical growth rate, the sustainable growth and the forecast 2-year growth is showed in the table above. And it tells the growth rate in the 5 years.

Sustainable growth rate of earnings or dividend is the product of the ROE and the retention rate. Compared with historical earnings growth rate (18.5%) and forecast earnings growth rate (10.6%), the sustainable growth rate (8.432%) is lower in the WOW Company. In addition, in the LNN Company, the average historical growth is 9.2% and the forecast 2-year growth is 7.8%, the sustainable growth is lower than those two. About the SUL company is the lower than those date in the same stage.

�

1.3 Intrinsic Value

Constant Dividend

The dividend of WOW, LNN and SUL Companies is $0.92, $0.42, $0.13 of each.

Intrinsic Value (no growth) =

WOW: Intrinsic Value =

LNN: Intrinsic Value =

SUL: Intrinsic Value =

The intrinsic value without growth is lower than the current share price of each company. As the share of each company has the big value in market, the current price must be higher than the intrinsic value.

Constant Growth

Intrinsic value (constant growth) =

WOW: Intrinsic value =

LNN: Intrinsic value =

SUL: Intrinsic value =

WOW

LNN

SUL

Current share price

$24.89

$7.97

$2.30

Intrinsic Value(no growth)

$11.57

$5.68

$1.25

Intrinsic value(constant growth)

Sustainable growth

Historical average

Analyst's forecast

N/A

N/A N/A

40.63

N/A

N/A

8.73

N/A

N/A

ROE

27.2%

31.7%

19%

Mean Monthly Return

1.43%

0.55%

0.4%

Required rate of return

8.13%

7.765%

11.415%

Beta

0.7

0.65

1.15

Recent 5-year monthly standard deviation

0.055462

0.048436

0.10735

Discuss, compare and contrast these statistics between the three companies.

WOW: The average monthly price and the currently price for per share of the WOW Company is different from 1 April 2004 to 1 April 2009. However, the different is in the suitable area.

LNN: The average monthly price is $8.217 for per share and the current price for LNN is $7.97 for per share. So it is can be accepted.

SUL: $3.04 is the average monthly price for per share and $2.30 is the currently price for per share in SUL company. The balance between those two prices is $0.74 for per share. The historical price is a little higher than the current price for per share.

The highest current price in these three companies share is WOW Company that is $11.8 for per share. In addition, the SUL company share is the lowest in these three shares, which is $2.5 for per share. While compared with the constant dividend, the WOW share price is lower than the current price. Therefore, it would be sell well. At the same time, it is good for another two companies. The intrinsic values for constant growth for the three shares are much higher than the current prices. �

2.0 THE STORY

WOW

Woolworths Limited, as a large retail store, provides lots of famous brands on food & grocery, liquor, petrol general merchandise and consumer electronics in Australia and New Zealand. It was founded in Sydney in 1924. At that time, it was just a shop providing the necessary goods to people. In 1927, the company became a chain. During the next several decades' years, the company has established BIG W,Dick Smith and Safeway successive. Until 1993, Woolworth's group became a listed company and shares were traded on Australian and New Zealand Stock Exchange. At present, it owns more than 3,000 stores and 180,000 employees. In addition, there are 340,000 shareholders, and 40,000 of them are the employees in the company. As a listed company, everyone can access and download financial information easily on their websites. From Part 1, we can calculate the historical growth rate, sustainable growth rate and forecast 2-year growth rate are 18.5%, 8.432% and 10.6% respectively. In general, although the share price in the Woolworths Limited is a little high, but it still is a potential company to the investors.

LNN

Lion Nathan limited is an alcoholic beverages company which operations in Australia and New Zealand. It was built by James Squire in 1795. At that time, it was the first Australia's first brewer. During the next several years, the LNL was growing fast until today. On 1 October, the Lion Nathan creates an extraordinary portfolio representing distinctive wines from renowned regions around Australia and the world. Now it owns 1,800 Australians and 1,400 New Zealanders as the employees. And the shares of the company trade on the both Australian and New Zealand Stock Exchanges. This company contains good corporate governance, which encompasses accountability and transparency to shareholders. The shareholders can know the structure, processes, policies and charters easily anytime. In addition, everyone can find out the annual report on the company website to understand the company and make investment decisions. From 1 April 2004 to 1 April 2009, we can see the historical growth rate of the company is 9.2% and the sustainable growth rate is 6.34% and forecast 2-year growth rate is 7.8%. As what the people said that less risk, less returns. Investors can get the steady dividends from LNL.

SUL

Supercheap Auto Limited is famous of automotive and boating, camping and fishing products. It is the leader in that area. It was founded by Reg and Hazel Rowe and located in Brisbane in 1972. There were 7, 14 and 200 stores in 1993, 1994 and 2006 respectively. In July 2004, the company became the listed company in Australia and the shares were traded on the Australian Stock Exchanges market. Over the past 15 years, Supercheap Auto has experienced more than 25% compound annual revenue growth. The company provides good environment and conditions for their employees, making every client happy to work. Now it owns employees. In addition, the company information can be found on the company website easily in order of making the investment decision. From part 1, during the last five years, the average historical growth and sustainable growth and forecast 2-year growth in SUL is 15.9%, 8.74% and 11.8% respectively. According to the three growth rate, no one can deny that the SUL has a bright future.

�

3.0 FINAL EVALUATION

Base on those questions above, it valuates different dates from three different companies that is Woolworths Limited (WOW), Lion Nathan limited (LNN) and Supercheap Auto Limited (SUL). Form the charts; we can notice the standard deviations are 5.55%, 4.84% and 10.74% of WOW, LNN and SUL. According to these, the risk of SUL is the highest in three companies. SUL is the lowest and WOW is medium. Nonetheless, contrast risk between WOW and SUL, it is only 0.7 per cent. Moreover, an average monthly return of WOW is the highest and SUL is the lowest. WOW and LNN, the beta is lower then 1. It means the risk for the tow shares is lower than market. While the beta for SUL is 1.15 which means the risk is higher than market portfolio of all securities. Therefore WOW is the best choice for the moment. It is because the low risk and high return.

On the other hand, average historical growths are 18.5%, 9.2% and 15.9% about WOW, LNN and SUL. It means in the history WOW can grow faster than others. In addition, the sustainable growth is 8.432%. Even though in the future WOW does not have the highest growth, it still has 10.6% growth in next 2 years. This situation probably on account of the analysts believed that the market in recession now and it will start to recover in a couple of years. In a word, they are still optimistic about the future. All of bates of average historical growth, sustainable growth and forecast growth are the lowest in three companies. As investors, it will become the worst decision if they invest this company. This is likely to owing to the higher payout ratio or lower reinvestment rate of the company. However its future is predicted to be higher than now by any possibility it because of we are in recession now as well. In the future, market is going up. SUL has the highest sustainable growth and forecast growth in chart but average historical growth is lower than WOW. Compare and contrast these data from WOW and SUL, maybe WOW is better because it is more stable.

Furthermore, current share price and intrinsic value of WOW are both the highest in this group. They are $24.89 and $11.57. The other way round, SUL is the lowest that are $2.3 and $1.25. LNN is medium. Due to mean monthly return of WOW is nearly three times than LNN even through recent 5-year monthly standard deviation is a little bit higher than LNN; it still can not stop the belief of investors to put capital into this company.

If I have $10,000 to invest at this moment, i can not put all money at one company. Because I can not get the most returns into one company. Even through the return is medium, so the risk of LNN is the lowest. So I don't need too much worry to get my money back. Thus, I can put 20% of capital in LNN. In a word, investment means risk. So if you want to get more money, you have to get risk. The risk of SUL is the highest but share price and intrinsic price are very cheap, forecast growth is very high and required rate of return is high as well. It means I can spend lower price to buy shares and in the future they will have more values. Therefore, I also can put 20% of capital in SUL. In the end, at all tables, WOW all can get the best estimation. Consequently, more than half of money will put into this company. The total capital is $6,000 in WOW. �

WOW

LNN

SUL

Date

Adj Close

Returns

S.D.

Adj Close

Returns

S.D.

Adj Close

Returns

S.D.

1/04/2004

11.8

6.25

3/05/2004

11.7

-0.0076

0.00047

6.51

0.04160

0.00132

1/06/2004

11.4

-0.0265

0.00164

6.78

0.04147

0.00131

1/07/2004

11.7

0.02719

0.00017

6.97

0.02802

0.00052

2.5

2/08/2004

12.7

0.08027

0.00439

7.1

0.01865

0.00018

2.86

0.14400

0.01951

1/09/2004

13.6

0.07668

0.00393

7.38

0.03944

0.00117

3.1

0.08392

0.00634

1/10/2004

13.4

-0.0176

0.00100

7.88

0.06775

0.00391

3.15

0.01613

0.00014

1/11/2004

15

0.12108

0.01146

7.95

0.00888

0.00001

3.29

0.04444

0.00161

1/12/2004

15

0.00067

0.00018

8.6

0.08176

0.00586

3.19

-0.03040

0.00121

3/01/2005

14.6

-0.028

0.00176

8.2

-0.04651

0.00268

3.16

-0.00940

0.00019

1/02/2005

15.6

0.06648

0.00275

7.54

-0.08049

0.00734

3.14

-0.00633

0.00011

1/03/2005

16.1

0.03149

0.00031

7.25

-0.03846

0.00191

3.02

-0.03822

0.00181

1/04/2005

15.3

-0.0474

0.00377

7.29

0.00552

0.00000

2.65

-0.12252

0.01609

2/05/2005

16.1

0.05101

0.00137

7.35

0.00823

0.00001

2.75

0.03774

0.00112

1/06/2005

16.5

0.02738

0.00018

7.58

0.03129

0.00068

2.82

0.02545

0.00045

1/07/2005

16.4

-0.0067

0.00043

7.4

-0.02375

0.00084

3.04

0.07801

0.00543

1/08/2005

16.3

-0.0092

0.00054

8.04

0.08649

0.00661

3.09

0.01645

0.00015

1/09/2005

16.6

0.02339

0.00009

8.39

0.04353

0.00147

2.92

-0.05502

0.00352

3/10/2005

16.3

-0.018

0.00103

7.89

-0.05959

0.00420

2.8

-0.04110

0.00206

1/11/2005

17

0.04164

0.00076

7.44

-0.05703

0.00387

2.85

0.01786

0.00018

1/12/2005

16.9

-0.0094

0.00055

7.64

0.02688

0.00047

2.85

0.00000

0.00002

2/01/2006

17.3

0.02374

0.00009

7.49

-0.01963

0.00062

2.2

-0.22807

0.05401

1/02/2006

18.4

0.06667

0.00277

8

0.06809

0.00395

2.6

0.18182

0.03151

1/03/2006

18.8

0.02337

0.00009

8.11

0.01375

0.00007

2.37

-0.08846

0.00861

3/04/2006

18.7

-0.009

0.00053

8.32

0.02589

0.00043

2.23

-0.05907

0.00402

1/05/2006

18.6

-0.0032

0.00030

7.75

-0.06851

0.00543

2.15

-0.03587

0.00162

1/06/2006

20.2

0.08333

0.00480

7.8

0.00645

0.00000

1.59

-0.26047

0.07011

3/07/2006

19

-0.0551

0.00478

7.87

0.00897

0.00001

1.85

0.16352

0.02535

1/08/2006

20.7

0.08719

0.00535

7.98

0.01398

0.00008

2.31

0.24865

0.05970

1/09/2006

20.3

-0.0213

0.00124

8.1

0.01504

0.00010

2.5

0.08225

0.00607

2/10/2006

20.7

0.02122

0.00005

8.29

0.02346

0.00033

2.73

0.09200

0.00769

1/11/2006

22

0.06332

0.00243

8.09

-0.02413

0.00086

2.65

-0.02930

0.00113

1/12/2006

23.9

0.08636

0.00523

8.16

0.00865

0.00001

3.05

0.15094

0.02150

1/01/2007

23.8

-0.0063

0.00041

8.3

0.01716

0.00014

3.55

0.16393

0.02548

1/02/2007

27.2

0.14526

0.01723

8.29

-0.00120

0.00004

3.8

0.07042

0.00437

1/03/2007

27.2

-0.0004

0.00021

8.84

0.06634

0.00374

4.05

0.06579

0.00378

2/04/2007

28.3

0.04082

0.00072

9.15

0.03507

0.00089

4.61

0.13827

0.01794

1/05/2007

27.5

-0.0279

0.00176

9.14

-0.00109

0.00004

4.51

-0.02169

0.00068

1/06/2007

27

-0.0185

0.00106

9.27

0.01422

0.00008

4.3

-0.04656

0.00259

2/07/2007

27.3

0.01074

0.00001

8.5

-0.08306

0.00779

4.74

0.10233

0.00961

1/08/2007

29.9

0.09637

0.00678

9.17

0.07882

0.00542

4.79

0.01055

0.00004

3/09/2007

29.7

-0.007

0.00044

9.23

0.00654

0.00000

4.49

-0.06263

0.00448

1/10/2007

33.5

0.12588

0.01251

9.28

0.00542

0.00000

4.75

0.05791

0.00287

1/11/2007

33.9

0.01196

0.00000

9.23

-0.00539

0.00011

4.36

-0.08211

0.00747

3/12/2007

34

0.00414

0.00010

9.61

0.04117

0.00129

4.3

-0.01376

0.00033

1/01/2008

28.8

-0.1527

0.02779

9.45

-0.01665

0.00048

3.6

-0.16279

0.02793

1/02/2008

29

0.0066

0.00006

9.55

0.01058

0.00003

3.4

-0.05556

0.00359

3/03/2008

29

0.00035

0.00019

8.75

-0.08377

0.00792

3.15

-0.07353

0.00606

1/04/2008

28.7

-0.0103

0.00059

8.35

-0.04571

0.00259

2.85

-0.09524

0.00991

1/05/2008

27.7

-0.0342

0.00232

9.66

0.15689

0.02300

3.09

0.08421

0.00638

2/06/2008

24.5

-0.118

0.01742

8.55

-0.11491

0.01443

2.38

-0.22977

0.05480

1/07/2008

25.2

0.03068

0.00028

8.83

0.03275

0.00076

2.6

0.09244

0.00776

1/08/2008

28.4

0.1254

0.01241

8.93

0.01133

0.00004

2.66

0.02308

0.00035

1/09/2008

27.2

-0.0409

0.00302

9.27

0.03807

0.00108

2.47

-0.07143

0.00574

1/10/2008

27.8

0.02206

0.00006

8.79

-0.05178

0.00325

2.19

-0.11336

0.01385

3/11/2008

26.8

-0.036

0.00250

8.68

-0.01251

0.00031

2.2

0.00457

0.00000

1/12/2008

26.7

-0.0049

0.00036

8.22

-0.05300

0.00339

2.68

0.21818

0.04574

2/01/2009

27.7

0.03862

0.00061

8.2

-0.00243

0.00006

2.3

-0.14179

0.02135

2/02/2009

26.1

-0.0563

0.00495

8.56

0.04390

0.00150

2.45

0.06522

0.00371

2/03/2009

25

-0.0432

0.00328

8.08

-0.05607

0.00376

2.25

-0.08163

0.00739

1/04/2009

24.9

-0.0048

0.00035

7.97

-0.01361

0.00035

2.3

0.02222

0.00032

Mean

21.8

0.01402

8.217

0.00521

3.04

0.00432

Standard Deviation

0.05505

0.04806

0.1064

Appendix 1�

Reference List

1. Woolworths Limited, 17/05/2009

(a)http://www.woolworthslimited.com.au/phoenix.zhtml?c=144044&p=homepage

Lion Nathan Limited, 17/05/2009

(a)http://www.lion-nathan.com.au/Great-Company/About-Us/History.aspx

(b)http://www.lion-nathan.com.au

Supercheap Auto Limited, 17/05/2009

(a)http://www.supercheapauto.com.au/corporate/company-history.aspx

(b)http://www.supercheapauto.com.au/corporate/investor-centre/corporate-governace.aspx

Returns %

Prices

$/%

Months

61

57

53

49

45

41

37

33

29

25

21

17

13

9

5

1

40

30

20

10

0

-10

-20

WOW Monthly Price and Returns

Returns %

Prices

$/%

Months

58

55

52

49

46

43

40

37

34

31

28

25

22

19

16

13

10

7

4

1

30

20

10

0

-10

-20

-30

SUL Monthly Price and Returns

Returns %

Prices

$/%

Months

61

57

53

49

45

41

37

33

29

25

21

17

13

9

5

1

20

15

10

5

0

-5

-10

-15

LNN Monthly Prices and Returns

�PAGE � �PAGE �13�

_1304072966.unknown

_1304073245.unknown

_1304107901.unknown

_1304108232.unknown

_1304073366.unknown

_1304073170.unknown

_1303982598.unknown

_1303992084.unknown

_1303992113.unknown

_1303982586.unknown