Hi Jognils,Nice work. Noticed you had a couple of questions which I might be able to help you with.Sales growth, quarterly:Yes, differences in sequential sales (that is, from one quarter to the next) is seasonal, so there will be some big swings here. That is why most analysts look at year over year growth which is one quarter compared to the same quarter in the previous year. So the Christmas quarter is always compared with the Christmas quarter. That gets rid of the seasonal effect.This also allows more accurate looks at gross, operating, and net margins to see how they are (hopefully) improving for the same quarters separated by a year.If you want to look sequentially, I suggest use rolling TTM numbers, that is Q1+Q2+Q3+Q4, Q2+Q3+Q4+Q1, Q3+Q4+Q1+Q2, and so on, moving forward in time by one quarter at a time. This captures an entire year, so this also gets rid of the seasonality problem.Return on assets or return on equity:These are usually reported as full-year figures. So, for the net income part of this equation, use the total net income from the last four quarters. For the assets or the equity, take the average of that item over the course of that year. In other words, take the amount at the beginning of the time period, add the amount at the end, and divide by two.The reason it's done this way is because the income statement shows what happens over the course of some time period, but the balance sheet (where assets and equity are found) are just snapshots, frozen in time. By taking the average, you convert those snapshots into a number that represents the time period.Let me give an example using ATVI:Net income:Q3, 12/31/07: $272.2 millionQ2, 9/30/07: $0.7 millionQ1, 6/30/07: $27.8 millionQ4, 3/31/07: ($14.4) millionTTM: $286.3 millionTotal assets:End Q3, 12/31/07: $2,613.1 millionEnd Q3, 12/31/06: $1,891.5 million (this is also the beginning value for Q4)Average: $2,252.3 millionROA: $286.3 / $2,252.3 = 11.4%Similarly with ROE, using equity instead of assets.Now, some people use EBIT (earnings before interest and taxes) instead of net income. That might explain some differences between websites' data.As for different numers between CAPS and Yahoo! Finance, anything that is price based (such as P/E, P/Sales, Dividend yield, etc.) on CAPS uses a "recent" price instead of the latest price. Thus, these ratios will differ between the two sites.Hope this helps.Cheers,Jim
Best Of |
Favorites & Replies |
Start a New Board |
My Fool |
BATS data provided in real-time. NYSE, NASDAQ and NYSEMKT data delayed 15 minutes.
Real-Time prices provided by BATS. Market data provided by Interactive Data.
Company fundamental data provided by Morningstar<