Earnings Yield and Earnings Growth (4)

http://spreadsheets.google.com/pub?key=tmw-xvsqNnjlMQGQrL2RXtg&output=html

Company XYZ9growth
From 2001 to 2009:

EPS grew from 6.2 to 44.5 , (CAGR of 27.94% )
DPS (net of tax) grew from 1.6 to 12 , (CAGR of 28.64% )
DPO ratio (net DPS) averaged 26.41% , in 2009 was 26.97%
EY increased (decreased) from 14.09% to 10.55% , averaged 8.18% per year invested, and averaged 44.63% per 5 years invested.
DY increased (decreased) from 3.64% to 2.84% , AVERAGED 2.13% per year invested, and averaged 11.14% per 5 years invested.
Share price rose (fell) from 0.44 to 4.22 , (CAGR of 32.66% )
Total annual return averaged 34.79% (Cap. Appr of 32.66% + DY of 2.13% )


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

Company XYZ-A0
From 1995 to 2009:

EPS grew from 4.3 to 40.5 , (CAGR of 16.13% )
DPS (net of tax) grew from 0.5 to 7 , (CAGR of 19.24% )
DPO ratio (net DPS) averaged 16.58% , in 2009 was 17.28%
EY increased (decreased) from 3.54% to 13.48% , averaged 8.74% per year invested, and averaged 24.39% per 5 years invested.
DY increased (decreased) from 0.41% to 2.33% , AVERAGED 1.33% per year invested, and averaged 4.3% per 5 years invested.
Share price rose (fell) from 1.215 to 3.005 , (CAGR of 6.22% )
Total annual return averaged 7.55% (Cap. Appr of 6.22% + DY of 1.33% )


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

Company NBG1
From 1999 to 2009:

EPS grew (shrank) from 7.8 to -15 , (CAGR of -209.37% )
DPS (net of tax) grew (shrank) from 2.9 to 0 , (CAGR of -100% )
DPO ratio (net DPS) averaged 94.1% , in 2009 was 0%
EY increased (decreased) from 5.29% to -57.69% , averaged -2.37% per year invested, and averaged -0.79% per 5 years invested.
DY increased (decreased) from 2.33% to 0% , AVERAGED 1.98% per year invested, and averaged 1.88% per 5 years invested.
Share price rose (fell) from 1.475 to 0.26 , (CAGR of -15.93% )
Total annual return averaged -13.96% (Cap. Appr of -15.93% + DY of 1.98% )