Last Updated on December 18, 2021 at 10:36 pm
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.
🔥Secure your future with our Robo-advisory tool trusted by over 3,500 investors and advisors. From effortless retirement planning to funding your children’s biggest dreams, turn your financial goals into reality. 🔥
Subscribe for money management solutions via email! (Link takes you to our email sign-up form) Join 32,000+ readers in our community.
👉 New Tool Alert! NaviPlan: A Privacy-Focused Multi-asset Tracker and Goal Planner 👈
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.
Download version 14th of the freefincal stock analyzer June 16th, 2019 <== latest!