Thursday, May 28, 2009

Intrinsic value for coca-cola (KO) 2008

Input......
CurrentYear:2008
YearsToBackLooking:6
YearsToForwardLooking:10
SafetyMargin:0.5
52WeeksHigh:58.84
52WeeksLow:37.44
ExpectedROI:0.15
EPSHistory(YearsToBackLooking yrs):3.15,2.70,2.37,2.18,2.08,1.95
AvgPriceHistory(YearsToBackLooking yrs):52.06,54.98,44.52,43.19,45.17,43.18
DividendHistory(YearsToBackLooking yrs):1.52,1.36,1.24,1.12,1.00,0.88

Output......
Average EPS annual growth rate:10.15613%
Average Price/Eearning Ratio:19.8911
Average dividend: $1.186667
Average dividend payout: 49.25438%
Forecasted price in year 2018: $164.8376
future value in year 2018: $189.7506
intrinsic value: $46.90345
safe price by intrinsic value: $23.45173
safe price by yearly high yearly low: $48.14

No comments: