I received a few requests to share the latest excel tool from some boarders. Attached is the latest one. Below guide will help navigate through it -
What needs doing to fill the data -
There are two grey colored tabs towards extreme right -
* Screener input -Download excel from screener. Copy-paste “Data Sheet” tab to this tab
* Shareholding input - Visit NSE website to get shareholding distribution data for last 6 Yrs.
That’s all! This will take 10-15 min time.
What you get from the tracker -
Valuation - Two red colored tabs towards the extreme left estimates the valuation of the company using Sanjay Bakshi’s concept and a conservative approach.
Balance Sheet, Cash Flow and P&L -The green colored tabs in the middle provide a view on revenue, profit, RoE, Cash Flow, Assets, Liabilities, Shareholding pattern and lot more.
The purpose the tracker serves is to help understand the business in numbers and also estimate reasonable valuation. Will be happy to guide if you would need any further help using the tracker 
Britannia_VU.xlsx (281.3 KB)