Excel Based Financial Modeling for Making Portfolio Management Decisions

  • Sree Rama Murthy Department of Economics & Finance, College of Economics and Political Science, Sultan Qaboos University,
DOI: https://doi.org/10.22610/imbr.v11i2(I).2881
Keywords: Portfolio optimization, Sharpe ratio, portfolio standard deviation, financial model.

Abstract

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.

Downloads

Download data is not yet available.

References

Beninga, S. (2006). Principles of Finance with Excel, 2nd ed. New York: Oxford. Elton, E. J., Martin, J. G., Stephen, J. B. (2003). Modern Portfolio Theory and Investment Analysis, 6th ed. New York: Wiley Reilly, F., K., Keith, C. B. (2006). Investment Analysis and Portfolio Management, 8th ed. Mason: Thomson South Western. Sharpe, F. (1994). The Sharpe Ratio, the Journal of Portfolio Management, 21(1), 49-58.
Published
2019-07-27
How to Cite
Murthy, S. R. (2019). Excel Based Financial Modeling for Making Portfolio Management Decisions . Information Management and Business Review, 11(2(I), 35-41. https://doi.org/10.22610/imbr.v11i2(I).2881
Issue
Vol 11 No 2(I) (2019)
Section
Research Paper

Copyright (c) 2019 Sree Rama Murthy Y Murthy Y

Creative Commons License

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.