Analyze stock value
"A Bloomberg terminal connected to Excel provides the value correcting splits, dividends, etc. Problem is it cost around $25,000. Another one which is free and I think that takes care of corporate action is ""quandl.com"". See an example here." It seems like you want to compare the company's values not necessarily the stock price.  Why not get the total outstanding shares and the stock price, generate the market cap.  Then you could compare changes to market cap rather than just share price.
The steps you outlined are fine by themselves. Step 5, seeking criticism can be less helpful than one may think.  See stocktwits.com  There are a lot of opposing opinions all of which can be correct over different time-frames.  Try and quantify your confidence and develop different strategies for different confidence levels. I was never smart enough or patient with follow through to be a successful value investor. It was very frustrating to watch stocks trade sideways for years before the company's intrinsic value was better reflected in the market.  Also, you could make an excellent pick, but a macro change and slump could set you back a year and raise doubts. In my experience portfolio management techniques like asset allocation and dollar-cost-averaging is what made my version of value investing work. Your interest in 10k/10q is something to applaud.  Is there something specific about 10k/10q that you do not understand?  Context is key, these types of reports are more relevant and understandable when compared to competitors in the same sector.   It is good to assess over confidence!  It is also good to diversify your knowledge and the effort put into Securities Analysis 6th edition will help with other books in the field.  I see a bit of myself in your post, and if you are like me, than subsequent readings, and full mastery of the concepts in 'Securities & Analysis 6th ed.'  will lead to over confidence, or a false understanding as there are many factors at play in the market.  So many, that even the most scientific approaches to investing can just as equally be described as an 'art'. I'm not aware of the details of your situation, but in general, for you to fully realize the benefits from applying the principals of value investing shared by Graham and more recently Warren Buffett, you must invest on the level that requires use of the consolidation or equity method of accounting, e.g. > 20% ownership.   Sure, the same principals used by Buffett can work on a smaller scale, but a small scale investor is best served by wealth accumulation, which can take many forms. Not the addition of instant equity via acquisitions to their consolidated financials. Lastly, to test what you have learned about value investing, and order execution, try the inverse.  At least on paper.  Short a stock with low value and a high P/E.  TWTR may be a good example? Learn what it is like to have your resources at stake, and the anguish of market and security volatility. It would be a lot easier to wait it out as a long-term value investor from a beach house in Santa Barbara :) "Check out Professor Damodaran's website: http://pages.stern.nyu.edu/~adamodar/ . Tons of good stuff there to get you started. If you want more depth, he's written what is widely considered the bible on the subject of valuation: ""Investment Valuation"". DCF is very well suited to stock analysis. One doesn't need to know, or forecast the future stock price to use it. In fact, it's the opposite. Business fundamentals are forecasted to estimate the sum total of future cash flows from the company, discounted back to the present. Divide that by shares outstanding, and you have the value of the stock. The key is to remember that DCF calculations are very sensitive to inputs. Be conservative in your estimates of future revenue growth, earnings margins, and capital investment. I usually develop three forecasts: pessimistic, neutral, optimistic. This delivers a range of value instead of a false-precision single number. This may seem odd: I find the DCF invaluable, but for the process, not so much the result. The input sensitivity requires careful work, and while a range of value is useful, the real benefit comes from being required to answer the questions to build the forecast. It provides a framework to analyze a business. You're just trying to properly fill in the boxes, estimate the unguessable. To do so, you pore through the financials. Skimming, reading with a purpose. In the end you come away with a fairly deep understanding of the business, how they make money, why they'll continue to make money, etc." Too calculate these values, information contained in the company's financial statements (income, balance, or cashflow) will be needed along with the price.  Google finance does not maintain this information for BME.  You will need to find another source for this information or analyze another another symbol's financial section (BAC for example). "A bit strange but okay.  The way I would think about this is again that you need to determine for what purpose you're computing this, in much the same way you would if you were to build out the model. The IPO valuation is not going to be relevant to the accretion/dilution analysis unless you're trying to determine whether the transaction was net accretive at exit. But that's a weird analysis to do. For longer holding periods like that you're more likely to look at IRR, not EPS. EPS is something investors look at over the short to medium term to get a sense of whether the company is making good acquisition decisions. And to do that short-to-medium term analysis, they look at earnings.   Damodaran would say this is a shitty way of looking at things and that you should probably be looking at some measure of ROIC instead, and I tend to agree, but I don't get paid to think like an investor, I get paid to sell shit to them (if only in indirect fashion). The short answer to your question is that no, you should not incorporate what you are calling liquidation value when determining accretion/dilution, but only because the market typically computes accretion/dilution on a 3-year basis tops. I've never put together a book or seen a press release in my admittedly short time in finance that says ""the transaction is estimated to be X% accretive within 4 years"" - that just seems like an absurd timeline.  Final point is just that from an accounting perspective, a gain on a sale of an asset is not going to get booked in either EBITDA or OCF, so just mechanically there's no way for the IPO value to flow into your accretion/dilution analysis there, even if you are looking at EBITDA/shares. You could figure the gain on sale into some kind of adjusted EBITDA/shares version of EPS, but this is neither something I've ever seen nor something that really makes sense in the context of using EPS as a standardized metric across the market. Typically we take OUT non-recurring shit in EPS, we don't add it in. Adding something like this in would be much more appropriate to measuring the success of an acquisition/investing vehicle like a private equity fund, not a standalone operating company that reports operational earnings in addition to cash flow from investing. And as I suggest above, that's an analysis for which the IRR metric is more ideally situated.  And just a semantic thing - we typically wouldn't call the exit value a ""liquidation value"". That term is usually reserved for dissolution of a corporate entity and selling off its physical or intangible assets in piecemeal fashion (i.e. not accounting for operational synergies across the business). IPO value is actually just going to be a measure of market value of equity." "The key to evaluating book value is return on equity (ROE). That's net profit divided by book value.  The ""value"" of book value is measured by the company's ROE (the higher the better). If the stock is selling below book value, the company's assets aren't earning enough to satisfy most investors. Would you buy a CD that was paying, say two percentage points below the going rate for 100 cents on the dollar? Probably not. You might be willing to buy it only by paying 2% less per year, say 98 cents on the dollar for a one year CD. The two cent discount from ""book value"" is your compensation for a low ""interest"" rate." No. The information you are describing is technical data about a stock's market price and trading volume, only. There is nothing implied in that data about a company's financial fundamentals (earnings/profitability, outstanding shares, market capitalization, dividends, balance sheet assets and liabilities, etc.) All you can infer is positive or negative momentum in the trading of the stock. If you want to understand if a company is performing well, then you need fundamental data about the company such as you would get from a company's annual and quarterly reports. what do you mean exactly?  Do you have a future target price and projected future dividend payments and you want the present value (time discounted price) of those? Edit: The DCF formula is difficult to use for stocks because the future price is unknown.  It is more applicable to fixed-income instruments like coupon bonds.  You could use it but you need to predict / speculate a future price for the stock. You are better off using the standard stock analysis stuff: Learn Stock Basics - How To Read A Stock Table/Quote The P/E ratio and the Dividend yield are the two most important.  The good P/E ratio for a mature company would be around 20.  For smaller and growing companies, a higher P/E ratio is acceptable.  The dividend yield is important because it tells you how much your shares grow even if the stock price stays unchanged for the year. HTH If you are looking to analyze stocks and don't need the other features provided by Bloomberg and Reuters (e.g. derivatives and FX), you could also look at WorldCap, which is a mobile solution to analyze global stocks, at FactSet and S&P CapitalIQ.  Please note that I am affiliated with WorldCap. You can't. If there was a reliable way to identify an undervalued stock, then people would immediately buy it, its price would rise and it wouldn't be undervalued any more. Try to find the P/E ratio of the Company and then Multiply it with last E.P.S, this calculation gives the Fundamental Value of the share, anything higher than this Value is not acceptable and Vice versa. "It is great that you want to learn more about the Stock Market. I'm curious about the quantitative side of analyzing stocks and other financial instruments. Does anyone have a recommendation where should I start? Which books should I read, or which courses or videos should I watch? Do I need some basic prerequisites such as statistics or macro and microeconomics? Or should I be advanced in those areas? Although I do not have any books or videos to suggest to you at the moment, I will do some more research and edit this answer. In order to understand the quantitative side of analyzing the stock market to have people take you serious enough and trust you with their money for investments, you need to have strong math and analytical skills. You should consider getting a higher level of education in several of the following: Mathematics, Economics, Finance, Statistics, and Computer Science.  In mathematics, you should at least understand the following concepts: In finance, you should at least understand the following concepts: In Computer Science, you should probably know the following: So to answer your question, about ""do you need to be advanced in those areas"", I strongly suggest you do. I've read that books on that topics are such as The Intelligent Investor and Reminiscences of A Stock Operator. Are these books really about the analytics of investing, or are they only about the philosophy of investing? I haven't read the Reminiscences of A Stock Operator, but the Intelligent Investor is based on a philosophy of investing that you should only consider but not depend on when you make investments." "Let me start with a somewhat sarcastic statement: There are probably as many things done to analyze a stock as there are people doing the analysis! That said, at a general level an analyst researches the historical performance of the company at a fairly detailed level (operations within divisions of the company, product development cycles within divisions, expenses vs income trends for each division and product, marketing costs, customer acquisition costs, etc); gathers information about what the company is doing now AND planning to do in the future -- often by a discussion with principles at the company; establishes a view on related macro-economic trends, sector and industry trends, demographic trends, etc.; and combines it all to forecast a change in revenues, margins, free cash flow, dividends, etc. over a period of time.   They then apply statistics that relate those numbers to stock price in order to imply stock prices and price ranges over those same periods.  Finally, depending on how those stock prices compare to the current stock price, they'll classify the stock as Buy, Sell, Hold, etc. This sounds like alot of work.   And it generally is if you get detailed about it, which is what professionals or significant money managers are doing.   However, there are also lots of arm-chair analysts posting their output on any number of financial sites (Seeking Alpha, Motley Fool, etc.) if you'd like to really explore the range of detail some people consider as a ""stock analysis"".  That sounds more negative than I intended it to be, so let me clarify that I think some of these write-ups are really quite good IMO." "First, note that a share represents a % of ownership of a company. In addition to the right to vote in the management of the company [by voting on the board of directors, who hires the CEO, who hires the VPs, etc...], this gives you the right to all future value of the company after paying off expenses and debts. You will receive this money in two forms: dividends approved by the board of directors, and the final liquidation value if the company closes shop. There are many ways to attempt to determine the value of a company, but the basic theory is that the company is worth a cashflow stream equal to all future dividends + the liquidation value. So, the market's ""goal"" is to attempt to determine what that future cash flow stream is, and what the risk related to it is. Depending on who you talk to, a typical stock market has some degree of 'market efficiency'. Market efficiency is basically a comment about how quickly the market reacts to news. In a regulated marketplace with a high degree of information available, market efficiency should be quite high. This basically means that stock markets in developed countries have enough traders and enough news reporting that as soon as something public is known about a company, there are many, many people who take that information and attempt to predict the impact on future earnings of the company. For example, if Starbucks announces earnings that were 10% less than estimated previously, the market will quickly respond with people buying Starbucks shares lowering their price on the assumption that the total value of the Starbucks company has decreased. Most of this trading analysis is done by institutional investors. It isn't simply office workers selling shares on their break in the coffee room, it's mostly people in the finance industry who specialize in various areas for their firms, and work to quickly react to news like this. Is the market perfectly efficient? No. The psychology of trading [ie: people panicking, or reacting based on emotion instead of logic], as well as any inadequacy of information, means that not all news is perfectly acted upon immediately. However, my personal opinion is that for large markets, the market is roughly efficient enough that you can assume that you won't be able to read the newspaper and analyze stock news in a way better than the institutional investors. If a market is generally efficient, then it would be very difficult for a group of people to manipulate it, because someone else would quickly take advantage of that. For example, you suggest that some people might collectively 'short AMZN' [a company worth half a trillion dollars, so your nefarious group would need to have $5 Billion of capital just to trade 1% of the company]. If someone did that, the rest of the market would happily buy up AMZN at reduced prices, and the people who shorted it would be left holding the bag. However, when you deal with smaller items, some more likely market manipulation can occur. For example, when trading penny stocks, there are people who attempt to manipulate the stock price and then make a profitable trade afterwards. This takes advantage of the low amount of information available for tiny companies, as well as the limited number of institutional investors who pay attention to them. Effectively it attempts to manipulate people who are not very sophisticated. So, some manipulation can occur in markets with limited information, but for the most part prices are determined by the 'market consensus' on what the future profits of a company will be.  Additional example of what a share really is: Imagine your neighbor has a treasure chest on his driveway: He gathers the neighborhood together, and asks if anyone wants to buy a % of the value he will get from opening the treasure chest. Perhaps it's a glass treasure chest, and you can mostly see inside it. You see that it is mostly gold and silver, and you weigh the chest and can see that it's about 100 lbs all together. So in your head, you take the price of gold and silver, and estimate how much gold is in the chest, and how much silver is there. You estimate that the chest has roughly $1,000,000 of value inside. So, you offer to buy 10% of the chest, for $90k [you don't want to pay exactly 10% of the value of the company, because you aren't completely sure of the value; you are taking on some risk, so you want to be compensated for that risk].  Now assume all your neighbors value the chest themselves, and they come up with the same approximate value as you. So your neighbor hands out little certificates to 10 of you, and they each say ""this person has a right to 10% of the value of the treasure chest"". He then calls for a vote from all the new 'shareholders', and asks if you want to get the money back as soon as he sells the chest, or if you want him to buy a ship and try and find more chests. It seems you're all impatient, because you all vote to fully pay out the money as soon as he has it. So your neighbor collects his $900k [$90k for each 10% share, * 10], and heads to the goldsmith to sell the chest. But before he gets there, a news report comes out that the price of gold has gone up. Because you own a share of something based on the price of gold, you know that your 10% treasure chest investment has increased in value. You now believe that your 10% is worth $105k. You put a flyer up around the neighborhood, saying you will sell your share for $105k. Because other flyers are going up to sell for about $103-$106k, it seems your valuation was mostly consistent with the market.  Eventually someone driving by sees your flyer, and offers you $104k for your shares. You agree, because you want the cash now and don't want to wait for the treasure chest to be sold. Now, when the treasure chest gets sold to the goldsmith, assume it sells for $1,060,000 [turns out you underestimated the value of the company]. The person who bought your 10% share will get $106k [he gained $2k]. Your neighbor who found the chest got $900k [because he sold the shares earlier, when the value of the chest was less clear], and you got $104k, which for you was a gain of $14k above what you paid for it. This is basically what happens with shares. Buy owning a portion of the company, you have a right to get a dividend of future earnings. But, it could take a long time for you to get those earnings, and they might not be exactly what you expect. So some people do buy and sell shares to try and earn money, but the reason they are able to do that is because the shares are inherently worth something - they are worth a small % of the company and its earnings." I believe you are missing knowledge of how to conduct a ratio analysis. Understanding liquidity ratios, specifically the quick or acid-test ratio will be of interest and help your understanding. http://www.investopedia.com/terms/a/acidtest.asp Help with conducting a ratio analysis. http://www.demonstratingvalue.org/resources/financial-ratio-analysis Finally, after working through the definitions, this website will be of use. https://www.stock-analysis-on.net/NYSE/Company/Exxon-Mobil-Corp/Ratios/Liquidity Having separate savings account for your kids college fund, retirement fund, holiday fund etc is one way to compartmentalise savings. Downside to this is the management of these funds especially if you have them with different banks. Like others here have pointed out, keeping track via spreadsheet is relatively easy and especially most banks now like OCBC, HSBC , DBS, POSB etc offer online banking, however from a financial standpoint, spreading your funds doesn't allow you to get as much interest as you would from one account that has the highest interest rate.