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% )