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%