Thursday, May 28, 2009

Intrinsic value for Microsoft 2008

Input......
CurrentYear:2008
YearsToBackLooking:6
YearsToForwardLooking:10
SafetyMargin:0.5
52WeeksHigh:29.57
52WeeksLow:14.87
ExpectedROI:0.15
EPSHistory(YearsToBackLooking yrs):1.87,1.49,1.27,1.16,1.04,1.05
AvgPriceHistory(YearsToBackLooking yrs):25.86,31.16,26.85,25.68,27.14,26.89
DividendHistory(YearsToBackLooking yrs):0.44,0.40,0.35,3.4,0.16,0.08

Output......
Average EPS annual growth rate:12.57901%
Average Price/Eearning Ratio:21.62116
Average dividend: $0.805
Average dividend payout: 65.67354%
Forecasted price in year 2018: $132.2193
future value in year 2018: $154.3834
intrinsic value: $38.16121
safe price by intrinsic value: $19.0806
safe price by yearly high yearly low: $22.22

No comments: