tag:blogger.com,1999:blog-2991101600248617596.post8283787497158674643..comments2023-11-14T02:15:06.159-06:00Comments on Financial Alchemist: Using Excel to Import Financial Data from the WebTurley Mullerhttp://www.blogger.com/profile/01407515956935491747noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-2991101600248617596.post-64934181894357863382008-06-16T12:33:00.000-05:002008-06-16T12:33:00.000-05:00How do you get the yahoo earnings date into a cell...How do you get the yahoo earnings date into a cell for a stock list?jmar42https://www.blogger.com/profile/07458891837530403583noreply@blogger.comtag:blogger.com,1999:blog-2991101600248617596.post-46474214673819314002008-06-16T12:32:00.001-05:002008-06-16T12:32:00.001-05:00How would import the earnings date of a stock into...How would import the earnings date of a stock into google excel from yahoo finance?jmar42https://www.blogger.com/profile/07458891837530403583noreply@blogger.comtag:blogger.com,1999:blog-2991101600248617596.post-23886838991042020142007-08-30T22:18:00.000-05:002007-08-30T22:18:00.000-05:00Essential that calculation is a two stage dividend...Essential that calculation is a two stage dividend discount model based on the formula: PE= payout ratio/(Ke-g). Essentially, the calculation assumes EPS is $1 and then values the DPS for 5 years @ payout ratio and growth rate assumptions, then assumes payout of 65% for the residual value and growth of 3% and (Ke-g) equals the LT discount rate. Hence, the calculation values $1 of EPS to arrive at a price which is similarly the P/E Ratio. Its just a guide or "reality indicator".<BR/>Does that help?Turley Mullerhttps://www.blogger.com/profile/01407515956935491747noreply@blogger.comtag:blogger.com,1999:blog-2991101600248617596.post-59416552695663955352007-08-30T21:21:00.000-05:002007-08-30T21:21:00.000-05:00Turley, in Cell B12 of the EPS-PE Model, there is ...Turley, in Cell B12 of the EPS-PE Model, there is a very complex formula to calculate 'Normal PE'. I also noticed that the cell has no dependencies, so I assume it is there for informational purposes. Still, I can't quite decipher it. Could you explain what's going on there, either in algabraic terms or just verbally (preferably both)?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2991101600248617596.post-56737198711044235822007-08-20T14:07:00.000-05:002007-08-20T14:07:00.000-05:00EPS is a nebulous figure. It can be distorted a nu...EPS is a nebulous figure. It can be distorted a number a ways, a analysts usually come up with their own figures after excluding/including some items to try to arrive at a cleaner number. Firm, knowing this, will take big "one-time" charges or "Big Baths" to write off expenses in one fail swoop since analyst will ignore those expenses in their EPS calculations. Additionally, those expenses are written off in one accounting period, instead of being spread over multiple periods, so the result is lower EPS in the current period (which analysts back out) and higher EPS in future periods.<BR/>EPS can also distorted from share buy-backs or share issuance. Plus, dilution from employee stock options, warrants, and convertible debentures. EPS has its shortcomings. <BR/>Prospective growth rates have major problems too. Research has illustrated that 5yr projections are very inaccurate, and most often err on the high side. Actual growth rates tend to be lower than forecasts. It seems that "when in doubt" analyst choose the customary growth rate of 15%. Many times this doesn't make sense regarding instances where projected EPS growth for year 1 and 2 may be expected to decline yet the Projected 5yr annual growth rate is 15% or so. So this implies that growth in years 3-5 will have to be extreme to offset the first two years of decline. Or it could be the other way around, growth years 1-2 may be estimated at 50% a yr, thus growth for 3-5 will have to be real low or negative. <BR/>I don't think analysts connect their near term EPS projections with their 5yr annual growth rate forecast.<BR/>Research has shown that estimates for EPS (year 1 & 2: current year and next year) are quite accurate. <BR/>That suggests the best approach possibly is to use estimated EPS for year 1&2 and then apply a growth rate for years 3-5. That growth rate should be reasonable, long-run historic average, or industry average, etc. Careful attention must be paid to analysts' 5yr projected growth rate to determine if it's reasonable and probable.Turley Mullerhttps://www.blogger.com/profile/01407515956935491747noreply@blogger.comtag:blogger.com,1999:blog-2991101600248617596.post-65787386796856593732007-08-20T11:58:00.000-05:002007-08-20T11:58:00.000-05:00Interesting! Though it's definitely important to a...Interesting! Though it's definitely important to arrive at a well-estimated prospective EPS growth rate. I read somewhere that companies are able to manipulate these EPS figures by forming conglomerates through share exchange...Anonymousnoreply@blogger.com