Use this Excel tool to compare risk vs. reward in Indian stock investments. The index component of the stock price analyzer published yesterday has been removed to enable comparison between two stocks. The way I see it, this comparison tool can be used for any stocks irrespective of the sector they belong (unlike financial statements).  Such…

Use this Excel sheet to analyze the risk vs. reward of investing in a stock in comparison with an index. The analysis is based on price history (adjusted for dividends, splits and bonuses) and is a spin-off the popular Mutual Fund Risk-return analyzer Two versions of the sheet are available: The ‘annual’ version in which risk…

The Excel stock analyzer now has two spreadsheets based on Warren Buffett’s approach to stock valuation. The valuation sheets have been built from the ground up  based on this article: Valuing Stocks the Warren Buffett Way The article mentions that more details can be found at: “Buffettology: The Previously Unexplained Techniques That Have Made Warren…

Use this Excel spreadsheet to analyze Indian stocks.  I am trying to build a stock analyzer with which one can comprehensively analyze a stock, obtain fair value with different methods, obtain growth rates of different metrics and visualize them graphically. This is the first version of such an attempt. The sheet calculates ‘fair value’ of…