Good Example Of About The Research: Research Paper

Type of paper: Research Paper

Topic: Portfolio, Investment, Finance, Standard, Deviation, Risk, Basis, Optimal

Pages: 3

Words: 825

Published: 2020/12/01

Investments

We initiated this paper with the objective of earning $1 million in 20 years down the line with the present value of investment of $250000. At the same time, in part A of this report, we also discussed the importance of diversification for our portfolio which eliminates most of the unsystematic risk leaving our portfolio exposed only to market risk.
Thus, in order to achieve our objective and to create a diversified portfolio, we selected four equity stocks from US stock exchange, namely, Ebay Inc., Apple Inc., Starbucks Inc. and Bank of America. In addition, since we want a guaranteed on our investment, risk free asset was also included in our portfolio that offers 2% return on annual basis. However, in order to find optimal portfolio weights that will multiply our portfolio to $1 million in 25 years and least standard deviation, we used excel solver function.

Data:

In order to calculate the optimal weights, we used past 5 year historical closing prices for each stock. The closing prices were then used to calculate monthly returns and standard deviation on annualized basis.
This was followed by a correlation and weighted covariance matrix, which we used to calculate portfolio standard deviation, later to be used while finding optimal weights of each asset in our portfolio.

Problem Solving:

Conclusion and Recommendation
Using excel solver we found that in order to earn 7.18% return on per annum basis under minimal standard deviation, our portfolio weights should be:

Cite this page
Choose cite format:
  • APA
  • MLA
  • Harvard
  • Vancouver
  • Chicago
  • ASA
  • IEEE
  • AMA
WePapers. (2020, December, 01) Good Example Of About The Research: Research Paper. Retrieved April 12, 2021, from https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/
"Good Example Of About The Research: Research Paper." WePapers, 01 Dec. 2020, https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/. Accessed 12 April 2021.
WePapers. 2020. Good Example Of About The Research: Research Paper., viewed April 12 2021, <https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/>
WePapers. Good Example Of About The Research: Research Paper. [Internet]. December 2020. [Accessed April 12, 2021]. Available from: https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/
"Good Example Of About The Research: Research Paper." WePapers, Dec 01, 2020. Accessed April 12, 2021. https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/
WePapers. 2020. "Good Example Of About The Research: Research Paper." Free Essay Examples - WePapers.com. Retrieved April 12, 2021. (https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/).
"Good Example Of About The Research: Research Paper," Free Essay Examples - WePapers.com, 01-Dec-2020. [Online]. Available: https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/. [Accessed: 12-Apr-2021].
Good Example Of About The Research: Research Paper. Free Essay Examples - WePapers.com. https://www.wepapers.com/samples/good-example-of-about-the-research-research-paper/. Published Dec 01, 2020. Accessed April 12, 2021.
Copy

Share with friends using:

Please remember that this paper is open-access and other students can use it too.

If you need an original paper created exclusively for you, hire one of our brilliant writers!

GET UNIQUE PAPER
Contact us
Chat now