Excel Based Financial Modeling for Making Portfolio Management Decisions

Sree Rama Murthy

Information Management and Business Review, 2019, vol. 11, issue 2, 35-41

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.

Date: 2019
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
https://ojs.amhinternational.com/index.php/imbr/article/view/2881/1867 (application/pdf)
https://ojs.amhinternational.com/index.php/imbr/article/view/2881 (text/html)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:rnd:arimbr:v:11:y:2019:i:2:p:35-41

DOI: 10.22610/imbr.v11i2(I).2881

Access Statistics for this article

More articles in Information Management and Business Review from AMH International
Bibliographic data for series maintained by Muhammad Tayyab ().