Given a chance, an informed investor would not buy-sell stocks blindly. They would do stock analysis before investing. But only a few people do it. Why? Because of the lack of suitable tools. So what is the solution? We can analyze stocks in Excel. Please Check: Stock Screener Derived From Stock Analysis Worksheet. Generally, when…
In this method, we first estimate the ‘absolute PE’ of a stock. Then multiply the calculated PE with EPS. This will give us the fair price or intrinsic value of the stock. We will read about this in more detail. What is the PE formula? Conventional PE = Market Price / EPS. The same formula we…
The stock comparison tool was one of the first tools which I developed in excel. In the last few days, we have made it more online savvy. Now, this tool can fetch stock data automatically upon click of a button. Check Our Big Screener – A WebApp The worksheet also has few limitations. It works…
Recently I was reading a book written by Peter Lynch (One Up on Wall Street). It talked about a concept called “multibagger stocks“. We all know what are multibagger stocks, right? Most of us have even use this as a phrase casually to refer to “quick return stocks”. But multibaggers are far for it. [Check…
If you like to estimate intrinsic value of a stock, then start with Net Current Asset Value Per Share (NCAVPS). Why? Because it is the easiest to calculate and is most reliable of all. Yes, for me it is even more reliable than DCF method. But the big problem with NCAVPS method is that, its…
[This article comes in a series of articles written about the fundamental analysis]. People who are interested in long term investing in stocks knows about financial ratio analysis. If you have heard about terms like price to earning ratio, price to book value ratio etc, you know ratios. But in this financial ratio analysis we…
Residual income method is a unique and a comparatively easier way to estimate intrinsic value of companies. What makes it unique is the factor called “residual income“. I’m a big fan of valuing companies using discounted cash flow method (DCF). Why? Because if done accurately, its computed intrinsic value can be very accurate. But its…
‘Authorised Share Capital’ and ‘Paid Up Share Capital’ are two terms that we as investors must know about. Why? Because changes in the numbers of these metrics can effect our investment returns (read here). Company needs capital to establish its assets and run its operations. From where the company will source its capital? It can…
PEG ratio is a useful valuation metric for stock investors. Potential investors can use it to gauge if a stock is overvalued or undervalued. PEG is a ratio which establishes a correlation between company’s price valuation with its future growth prospects (see here). We are more conversant with the use of P/E ratio (Price to Earnings…
Generally speaking, good news about a company can take its stock price up, and bad news can take the price down. In real world, lots of news keeps floating about companies. Some news are good and some may be bad. Hence the struggle of price moving up or down is happening every second. But what…
Use the below Stock Price Prediction Tool. It can help to forecast stock movements based on key financial indicators. Try answering a few questions related to P/E ratio, revenue trends, and institutional investor stakes, etc, and you can gain a rough insight into a stock’s potential performance. Do not worry, that calculator has an easy…
How to analyze bank stocks? Analysis of banking stocks is not like analyzing stocks of other businesses. Why? Because the business model of banks is different from other businesses. Hence, their financial statements are also prepared differently. A Screener for Top 20 Banks. In simple words, financial reporting of banks are different than other companies….
