Login
Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
magnan  
#1 Posted : Sunday, December 30, 2007 12:18:49 PM(UTC)
magnan

Rank: Member

Posts: 10

When I looked at the TSSW Back form for Genentech (DNA) it showed the following table for the forcasted PE's




Avg half or majority of lowest HighPEs       =  FcstHighPE 30.0

 Avg half or majority of the lowest Low PEs =  FcstLowPE 16.0

 Avg of the Forecast High and Low PEs      =  FcstAvg PE 23.0
 


However, I was not able to come up with these values when using the Value table at the top of the form. When I looked at Microsoft I was able to come up with the same calculations as Take Stock. Why are the forcast figures for DNA so far from the actual PE values in the Value table?

Thank you,

Joe

 

 

Wanna join the discussion?! Login to your forum account. New Registrations are disabled.

ETraub  
#2 Posted : Sunday, December 30, 2007 4:21:26 PM(UTC)
ETraub

Rank: Advanced Member

Posts: 82


Joe:

At 05:16 PM 12/30/2007, you wrote:
From the The Infirmary forum at StockCentral.com, Joe Magnan writes:


When I looked at the TSSW Back form for Genentech (DNA) it showed the following table for the forcasted PE's


Avg half or majority of lowest HighPEs       =  FcstHighPE 30.0
 Avg half or majority of the lowest Low PEs =  FcstLowPE 16.0

 Avg of the Forecast High and Low PEs      =  FcstAvg PE 23.0  


However, I was not able to come up with these values when using the Value
table at the top of the form. When I looked at Microsoft I was able to
come up with the same calculations as Take Stock. Why are the forcast
figures for DNA so far from the actual PE values in the Value table?

Now that's an excellent question! I have no idea why it is coming
up with bad numbers; but I'm glad you found it. (That's why we
call this the 'Omega test' period in software—the time when the
product is tested by the world. ;-))

In any case, I'll try to track it down and find out for you (and for
us) so we can fix it.

ET



Ellis Traub
magnan  
#3 Posted : Thursday, January 3, 2008 7:10:13 AM(UTC)
magnan

Rank: Member

Posts: 10

Ellis,

I appreciate you looking into this. Please note that the problem exists for several stocks, not just DNA. I think there is a fundamental issue with the tool. The results on many of the stocks are not correct which could lead to significant miss-judgements (I know you know this but I just wanted to emphasise it anyway).

Regards,

Joe

hongan  
#4 Posted : Thursday, January 3, 2008 8:57:53 AM(UTC)
hongan

Rank: Member

Posts: 14

This is explained as follows:

Take Stock use average of majority high/low PE for calculating forecast PE. Yet it gives it a condition:
If forecast High PE > 30,set forecast low PE to (forecast low PE * (30/forecast high PE) and limit forecast high PE to 30 .

Ellis can give you a further explanation on this.

Sally

magnan  
#5 Posted : Thursday, January 3, 2008 10:44:29 AM(UTC)
magnan

Rank: Member

Posts: 10

Hi Sally,

That works out great! Thank you. I am looking forward to the explanation from Ellis as to why.

Regards,

Joe

ETraub  
#6 Posted : Thursday, January 3, 2008 5:43:59 PM(UTC)
ETraub

Rank: Advanced Member

Posts: 82

Joe: At 03:42 PM 1/3/2008, you wrote:

> From the The Infirmary forum at StockCentral.com, Joe Magnan writes:
>That works out great! Thank you. I am looking forward to the
>explanation from Ellis as to why.

Well, there you have it. I looked at the numbers themselves and didn't go any further to see if those rules were applied. And Sally came up with the explanation as to WHAT was being done. If you're looking for an explanation as to why I designed it that way, here it is.

This product, in the desktop form, has an advanced mode that permits the user, when she is confident and knowledgeable to override the judgments provided by the program in the novice mode. Unfortunately, we have yet to see the advanced mode programmed into the on-line version. So everyone is stuck with the default judgments. Of necessity, the judgments applied for the novice are very conservative.

We have put a program out there for public use and do not want to risk any liability for people who fail to take responsibility for their actions and might wish to blame us for their mistakes. Those judgments, frankly, are the same as I use in my own studies because I happen to be conservative as well. But they are reasonable and they are intended to give values that are sustainable and comfortable?the two attributes I value highly when making my estimates of growth and PEs. I hope we will soon have the advanced version available to StockCentral members. I've been told to expect it around next summer. Does this give you the answer you were looking for?

ET

Ellis Traub
magnan  
#7 Posted : Friday, January 4, 2008 9:26:17 AM(UTC)
magnan

Rank: Member

Posts: 10

Ellis,

I am very comfortable with the conservative aproach built into Take Stock. I understand the need to cap the high PE forecast to maintain a certain amount of realism. Where I am having difficulty is in understanding the logic on the fomula to reduce the forecast low PE. Please excuse my ignorance, I am new to the fundamental side, up to now I have mostly used technical analysis.

Regards,

Joe

ETraub  
#8 Posted : Friday, January 4, 2008 12:07:46 PM(UTC)
ETraub

Rank: Advanced Member

Posts: 82

Joe:

At 02:24 PM 1/4/2008, you wrote:

>I am very comfortable with the conservative aproach built into Take
>Stock. I understand the need to cap the high PE forecast to maintain a
>certain amount of realism. Where I am having difficulty is in
>understanding the logic on the formula to reduce the forecast low PE.
>Please excuse my ignorance, I am new to the fundamental side, up to
>now I have mostly used technical analysis.
 

We needed a mechanism that would produce a reasonable but moderate result. It seemed to me a rational approach to look at the relationship between the high and low PE before the high was capped at 30 and to reduce the low PE to the same relationship to the capped PE.

We also looked at the prospect of using a PEG ratio of 1 for the low PE. However, in practice, looking at the results, it seemed to me that the choice we made was the better and more rational one.

The low PE is our means of arriving at a potential low price. We look at the lowest earnings we might expect and the lowest multiple of those earnings people might be expected to pay in the future, based on their historical practice (and moderated to be comfortable and sustainable).

By providing us with a mechanism with which we can consistently come up with the future price range, we then make the Upside/Downside Ratio much more useful than simply as a measure of "risk." We use the U/D ratio to assess how our evaluation of the company's quality and worth stacks up to "the herd's." If we have overvalued it compared to what the herd thinks, we come up with a low U/D ratio, which is an alarm that prompts us to go back and challenge our assumptions by which we came up with the quality judgments.

I hope that helps some more. You might want to read my book, Take Stock: A Roadmap to Profiting from you First Walk Down Wall Street. I pretty much cover all of this there.

ET

Ellis Traub
magnan  
#9 Posted : Saturday, January 5, 2008 12:52:06 AM(UTC)
magnan

Rank: Member

Posts: 10

Thank you Ellis for your support.

Best regards,

Joe

Users browsing this topic
Guest (3)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.087 seconds.