Stock Analysis Worksheet V220.127.116.11
Use this worksheet to analyse your stocks. Just copy and paste the financial data of stocks in this worksheet, and it will do the rest. What it will do? It will estimate the stocks intrinsic value. Recommended: Kindly read all FAQ’s before using the worksheet
Utility of sheet
To get a feel of the utility of this worksheet, you are suggested to read this blog post. It will highlight the key aspects of this worksheet.
Financial ratios sheet updated.
It’s a minor update. A reporting format showing 10Y snapshot of Balance Sheet, Profit & Loss account, and Cash Flow Statement is introduced.
This update takes care of how how free cash flow and intrinsic value of stocks is estimated by the worksheet using Discounted Cash Flow (DCF) method. Know More about it here.
Management, profitability & financial health grading algorithm has been updated. It bring changes to the “overall score” given to stock in the “Cover” sheet (Oct-2019)
Effect of recent “Price trends & PE trends” has been considered to estimate intrinsic value (fair price) of stocks (Aug-2019)