cafeconomics

 Based on Prof.Damodaran's/S&P Capital IQ data set, there are approximately 3982 stocks listed on Indian market or at least for which data is available. The actual number could be different but that's not the issue here.  In the attached excel workbook, the first excel sheet contains the data set of total number of stocks with a serial number starting from 1. In the second excel sheet, we have 30 names selected using random number functions on excel. By clicking on the random tab we iterate the random selection of stocks. After iterating this process for a large number of times, 30 names have been chosen. The key is to not be biased towards any particular company or group.On the third excel sheet the price only return performance of these randomly chosen stocks has been compiled from the economic times website. The 5-year price return of such a randomly chosen equally weighed portfolio of 30 stocks  comes out to be 13.57% and it does not include any dividend and buy back re

 Everyone has a wish list for the annual budget event and so here are some of my ideas. 1. Welfare Effectiveness Index by Scheme and State: Each year we allocate thousands of crores for different welfare schemes including health, education, child and women welfare etc. The quality of welfare is not the same everywhere in the country with a huge population.  In order to gauge the effectiveness of the welfare schemes a welfare effectiveness index can be introduced. By surveying the beneficiaries on the key aspects of the welfare scheme and registering responses on a numeric scale, one can gauge the effectiveness. A healthy feedback loop can be put in place. Further potential beneficiaries can be encouraged to form Whatsapp/social media  groups (wherever possible) to sort out common issues and communication. 2. Ease of doing business index by sector: An ease of doing business by country and state is in place. It can be extended to sectors as well. So if mining sector scores low when compa