It has been proven that generally whenever the risk is high, the return is also higher and lower the risks lower the return. In this research paper an effort has been made to minimize the risk to get the same rate of return. For this purpose three companies have been considered-Asian Paints Ltd., Britannia Industries Ltd. and Reliance Industries Ltd. The financial information of these companies has been analyzed to calculate optimum portfolio weights that would maximize Sharpe's ratio with the help of excel functions. And later, this has been used to calculate Markowitz's portfolio risk minimization using ‘Solver’ add-in in excel.
Risk, Return, Sharpe's ratio, Markowitz's risk minimization, Excel Solver
