Thursday, May 28, 2009

Intrinsic value for JohnsonJohnson (JNJ) 2008

Input......
CurrentYear:2008
YearsToBackLooking:6
YearsToForwardLooking:10
SafetyMargin:0.5
52WeeksHigh:72.76
52WeeksLow:46.25
ExpectedROI:0.15
EPSHistory(YearsToBackLooking yrs):4.55,4.15,3.76,3.39,3.10,2.65
AvgPriceHistory(YearsToBackLooking yrs):63.57,64.48,62.92,64.31,57.85,52.56
DividendHistory(YearsToBackLooking yrs):1.795,1.620,1.455,1.275,1.095,0.925

Output......
Average EPS annual growth rate:11.45226%
Average Price/Eearning Ratio:17.28476
Average dividend: $1.360833
Average dividend payout: 37.50373%
Forecasted price in year 2018: $232.5754
future value in year 2018: $261.7391
intrinsic value: $64.69789
safe price by intrinsic value: $32.34895
safe price by yearly high yearly low: $59.505

No comments: