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%