Showing posts with label Earnings Yield and Earnings Growth. Show all posts
Showing posts with label Earnings Yield and Earnings Growth. Show all posts

Saturday 11 July 2009

Earnings Yield and Earnings Growth (5)

http://spreadsheets.google.com/pub?key=tB2t3SJMRVNLsb4C8kawnlA&output=html

Company XYZA1
From 1995 to 2009:

EPS grew from 9.82 to 20 , (CAGR of 4.86% )
DPS (net of tax) grew from 2.65 to 5.2 , (CAGR of 4.6% )
DPO ratio (net DPS) averaged 24.33% , in 2009 was 26%
EY increased (decreased) from 3.47% to 9.3% , averaged 5.97% per year invested, and averaged 8.2% per 5 years invested.
DY increased (decreased) from 0.94% to 2.42% , AVERAGED 1.49% per year invested, and averaged 1.86% per 5 years invested.
Share price rose (fell) from 2.83 to 2.15 , (CAGR of -1.82% )
Total annual return averaged -0.32% (Cap. Appr of -1.82% + DY of 1.49% )


Comments:

Those who bought this stock at the high prices of 1995, 1996, and 1997 and held till today, would find that this share is today below these high prices, abeit in a bear market.

Though this is a company running a monopoly business, paying too much for a good stock can mean a negative return for the investment.

Therefore, it is always important to buy a good company when its price is obviously low, e.g. during the time when the market is obviously low, or when its price is temporarily down not related to any deterioration in its fundamentals.

On the other hand, those who bought this stock at the low prices of 1997 and 1998, would have reasonable returns from this stock. This would have been a situation when the investor might wish he or she had averaged down on this stock during those times.


Let us also examine the returns from this stock from the year 1999.

http://spreadsheets.google.com/pub?key=t5B6EOYlRpP6CMU7pMQbDiA&output=html

Company XYZA1(1999-2009)
From 1999 to 2009:

EPS grew from 9 to 20 , (CAGR of 12.02% )
DPS (net of tax) grew from 2.5 to 5.2 , (CAGR of 8.48% )
DPO ratio (net DPS) averaged 23.28% , in 2009 was 26%
EY increased (decreased) from 5.86% to 9.3% , averaged 6.31% per year invested, and averaged 10.49% per 5 years invested.
DY increased (decreased) from 1.19% to 2.42% , AVERAGED 1.5% per year invested, and averaged 2.26% per 5 years invested.
Share price rose (fell) from 1.535 to 2.15 , (CAGR of 3.43% )
Total annual return averaged 4.93% (Cap. Appr of 3.43% + DY of 1.5% )

Friday 10 July 2009

Earnings Yield and Earnings Growth (3)

http://spreadsheets.google.com/pub?key=tM4dijzIZ-GSYae8UUHtrZw&output=html


Company XYZ6
From 1995 to 2009:
EPS grew from 125 to 275, (CAGR of 5.4% )
DPS (net of tax) grew from 84 to 266 , (CAGR of 7.99% )
DPO ratio (net DPS) averaged 99.14% , in 2009 was 96.73%
EY increased (decreased) from 5.07% to 6.18% , averaged 5.89% per year invested, and averaged 7.83% per 5 years invested.
DY increased (decreased) from 3.4% to 5.98% , AVERAGED 5.89% per year invested, and averaged 7.71% per 5 years invested.
Share price rose (fell) from 24.675 to 44.5 , (CAGR of 4.01% )
Total annual return averaged 9.9%



http://spreadsheets.google.com/pub?key=tmJjNThDyJg030tAuW1JZcA&output=html

Company XYZ7
From 1999 to 2009:
EPS grew from 10.9 to 58.5 , (CAGR of 11.85% )
DPS (net of tax) grew from 2 to 30 , (CAGR of 19.79% )
DPO ratio (net DPS) averaged 44.37% , in 2009 was 51.28%
EY increased (decreased) from 7.99% to 14.74% , averaged 7.56% per year invested, and averaged 31.43% per 5 years invested.
DY increased (decreased) from 1.47% to 7.56% , AVERAGED 3.8% per year invested, and averaged 15.67% per 5 years invested.
Share price rose (fell) from 1.365 to 3.97 , (CAGR of 7.38% )
Total annual return averaged 11.17%


http://spreadsheets.google.com/pub?key=tr5Cw9liTlNFIgUDOZBjXuw&output=html

Company XYZ8CYC
From 1999 to 2009:
EPS grew from 12.4 to 2.5 , (CAGR of -16.67% )
DPS (net of tax) grew from 5.3 to 5 , (CAGR of -0.65% )
DPO ratio (net DPS) averaged 66.01% , in 2009 was 200%
EY increased (decreased) from 9.58% to 1.28% , averaged 10.45% per year invested, and averaged 25.4% per 5 years invested.
DY increased (decreased) from 3.41% to 2.56% , AVERAGED 4.77% per year invested, and averaged 9.24% per 5 years invested.
Share price rose (fell) from 1.295 to 1.955 , (CAGR of 4.2% )
Total annual return averaged 8.98% (Cap. Appr of 4.2% + DY of 4.77% )

Earnings Yield and Earnings Growth (2)

http://spreadsheets.google.com/pub?key=tpKxEtz8jHe2E0aYMwaMSng&output=html

Company XYZ3
From 1995 to 2009:
EPS grew from 15.6 to 72 , (CAGR of 10.73% )
DPS (net of tax) grew from 3.2 to 40.7 , (CAGR of 18.48% )
DPO ratio (net DPS) averaged 57.03% , in 2009 was 56.53%
EY increased (decreased) from 7.39% to 9.01% , averaged 6.86% per year invested, and averaged 14.58% per 5 years invested.
DY increased (decreased) from 1.52% to 5.09% , AVERAGED 3.46% per year invested, and averaged 9.38% per 5 years invested.
Share price rose from 2.11 to 7.995 , (CAGR of 9.29% )
Total annual return averaged 12.75%



http://spreadsheets.google.com/pub?key=tk868XD3Y3vG7gvY54K8sGw&output=html

Company XYZ4
From 1995 to 2009:
EPS grew from 27.6 to 44 , (CAGR of 3.16% )
DPS (net of tax) grew from 16.1 to 35 , (CAGR of 5.31% )
DPO ratio (net DPS) averaged 95.24% , in 2009 was 79.55%
EY increased (decreased) from 7.41% to 8.19% , averaged 7.49% per year invested, and averaged 8.82% per 5 years invested.
DY increased (decreased) from 4.32% to 6.51% , AVERAGED 6.81% per year invested, and averaged 8.08% per 5 years invested.
Share price rose from 3.725 to 5.375 , (CAGR of 2.47% )
Total annual return averaged 9.28%



http://spreadsheets.google.com/pub?key=tmak2CPwe7UCWr6h5ZEFcww&output=html

Company XYZ5
From 1995 to 2009:
EPS grew from 7.8 to 41 , (CAGR of 11.7% )
DPS (net of tax) grew from 2.2 to 25 , (CAGR of 17.59% )
DPO ratio (net DPS) averaged 32.08% , in 2009 was 60.98%
EY increased (decreased) from 5.38% to 7.68% , averaged 7.96% per year invested, and averaged 15.97% per 5 years invested.
DY increased (decreased) from 1.52% to 4.68% , AVERAGED 2.5% per year invested, and averaged 5.88% per 5 years invested.
Share price rose from 1.45 to 5.34 , (CAGR of 9.08% )
Total annual return averaged 11.58%

Earnings Yield and Earnings Growth (1)

http://spreadsheets.google.com/pub?key=thvY0NrrijC4gY11mjZd3PQ&output=html

Company XYZ
From 1995 to 2009:
EPS grew from 12.8 to 58.2, (CAGR of 10.62%).
DPS (net of tax) grew from 5.3 to 33.8, (CAGR of 13.15%).
DPO ratio (net DPS) averaged 39.22%, the latest in 2009 was 58.08%.
EY increased (decreased) from 4.79% to 7.53%, averaged 9.59% per year invested, and averaged 15.67% per 5 years invested.
DY increased (decreased) from 1.99% to 4.38%, AVERAGED 3.42% per year invested, and averaged 6.47% per 5 years invested.
Share price rose from 2.67 to 7.725, (CAGR of 7.34%).
Total annual return averaged 10.76%.



http://spreadsheets.google.com/pub?key=tTbLLUoeX_bs_guMAtRvqdQ&output=html

Company XYZ1
From 1995 to 2009:
EPS grew from 69 to 150 , (CAGR of 5.31% )
DPS (net of tax) grew from 53.2 to 200 , (CAGR of 9.23% )
DPO ratio (net DPS) averaged 106.18% , the latest in 2009 was 133.33%
EY increased (decreased) from 3.95% to 5.29% , averaged 4.29% per year invested, and averaged 5.61% per 5 years invested.
DY increased (decreased) from 3.05% to 7.05% , AVERAGED 4.35% per year invested, and averaged 5.63% per 5 years invested.
Share price rose from 17.45 to 28.375 , (CAGR of 3.29% ).
Total annual return averaged 7.65%.



http://spreadsheets.google.com/pub?key=t7ILk0yniC6soSLCP8gsksg&output=html

Company XYZ2
From 1995 to 2009:
EPS grew from 23.1 to 70 , (CAGR of 7.67% )
DPS (net of tax) grew from 8.1 to 42.1 , (CAGR of 11.61% )
DPO ratio (net DPS) averaged 78.57% , the latest in 2009 was 60.14%
EY increased (decreased) from 6.2% to 7.47% , averaged 5.59% per year invested, and averaged 11.6% per 5 years invested.
DY increased (decreased) from 2.17% to 4.49% , AVERAGED 4.03% per year invested, and averaged 10.87% per 5 years invested.
Share price rose from 3.725 to 9.375 , (CAGR of 6.35% )
Total annual return averaged 10.38%