Recent content by Keegan88

Mate looks like you have found a good one, I have also done the calculations on this, for 2011 IV=$7.90 and 2012 IV=$10.72 at RR=12%. My calculations were done from comsec though. The question is do we buy or not?? Their Debt/Equity ratio is not bad either at 13.5%. According to comsec's...

Bo, I like what you have started to put together. I have done something very similar in excel for the stocks that I hold and those that are recommended from a newsletter I subscribe to. I see that you have the intrinsic value but what require return is this calculated from? I think that...

Ubtheboss, It is good to see that there is a bit of accuracy in it. The starting EqPS is the equity value at the present time. Now since I am using the forecast EPS and DPS to value the company if it achieves these estimates, I need to calculate what the equity will be in the future, (what I...

Hello all, Since you are all working out the intrinsic value of stocks, and coming up with different values, either through different methods or different inputs, I have been trying to put together an excel spreadsheet that will do this all for me rather than doing it by hand. The problem is...