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% )
Keep INVESTING Simple and Safe (KISS) ****Investment Philosophy, Strategy and various Valuation Methods**** The same forces that bring risk into investing in the stock market also make possible the large gains many investors enjoy. It’s true that the fluctuations in the market make for losses as well as gains but if you have a proven strategy and stick with it over the long term you will be a winner!****Warren Buffett: Rule No. 1 - Never lose money. Rule No. 2 - Never forget Rule No. 1.
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
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% )
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%
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%
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%
Subscribe to:
Posts (Atom)