The automated stock analyzer now pulls annual (standalone/consolidated) and quarterly financials from Value Research online. It also pulls financials from morningstar, adjusted stock price from money control and calculates intrinsic value five different ways!
Note: If you are not familiar with valuation techniques, I suggest that you download the tool, and read the references provided in each valuation sheet.
Anoop who created the calminvestor.com suggested I get financials from Monycontrol, because it is more detailed than the Morning Star version. However, the Money Control urls are not formulaic.
So I suggested thatI would get it instead from Value Research. I see that it has a few entries that are different from M*. Not too interested to explore the differences too much. Will await your feedback in this regard.
As of now, the data from VR online is only pulled and not used for any analysis. Let me know if anything specific can be done.
Valuation models available:
1) Price Multiple Model
2) Sustainable Growth Rate
3) Book Value Growth Rate (Buffett’s approach to valuation)
4) Discounted Cash Flow (DCF) Thanks to Debasish Hazra and Ninand Diveakr for pointing out a bug. This is now corrected
5) Reverse DCF
Do suggest ways in which the sheet can be improved. If you like it, do share this page. Here are some screenshots.
If you are not able to select some stock with Value Research, leave a comment. The fix is easy.
Caveats to note before using the sheet pointed out by Indraneal Balasubramaium
(1) Financial stocks like banks, housing finance companies and non-banking financial companies have balance sheet structures that are likely to be different from regular companies. Make sure to read the annual report and especially notes to financial statements.
(2) Take the time out to understand valuation models and how they are derived, what the implications are. Precision can give a false sense of accuracy, especially when dealing with an uncertain future. Better to be approximately right than exactly wrong.
Do share the sheet with your stock investor community.
Note: Always check if the stock price data downloaded from moneycontrol is correct by clicking on the link provided in the stock price page before proceeding. Let me know if there is a mismatch.
Register for Hyderabad Investor Workshop – June 28th, 2015
Register for the New Delhi DIY Investor meet: April 23rd 2017Get free, yet comprehensive calculators, tools and analysis delivered to your mailbox! Subscribe to get posts via email
Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Read more about the book and pre-order now!