Excel Based Financial Modeling for Making Portfolio Management Decisions
The Excel based financial model proposed in this paper provides a very simple but powerful method for portfolio selection. Apart from a simple and powerful tool for making portfolio management decisions, the paper also proposes an easy to use technique for calculating portfolio standard deviation without using correlation coefficients. The model uses â€œExcel Solver Add-Inâ€ to create an optimum portfolio by maximizing the Sharpe ratio. Benefits of Sharpe style optimization are demonstrated using data on monthly returns from 1999 to 2010 covering 30 stocks.
Copyright (c) 2019 Sree Rama Murthy Y Murthy Y
This work is licensed under a Creative Commons Attribution 4.0 International License.
Author (s) should affirm that the material has not been published previously. It has not been submitted and it is not under consideration by any other journal. At the same time author (s) need to execute a publication permission agreement to assume the responsibility of the submitted content and any omissions and errors therein. After submission of revised paper in the light of suggestions of the reviewers, the editorial team edits and formats manuscripts to bring uniformity and standardization in published material.
This work will be licensed under Creative Commons Attribution 4.0 International (CC BY 4.0) and under condition of the license, users are free to read, copy, remix, transform, redistribute, download, print, search or link to the full texts of articles and even build upon their work as long as they credit the author for the original work. Moreover, as per journal policy author (s) hold and retain copyrights without any restrictions.