Economics Homework Help

FIN 673 Ashford University Facebook and Apple Modern Portfolio Theory Analysis

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page
Order Now

To develop an understanding of modern portfolio theory, you will begin by analyzing a portfolio of two securities. In your Modern Portfolio Theory Report, describe the two stocks you chose to invest in (FACEBOOK and APPLE)

Include the following in your report:

  • Create a table and list the two stocks you chose to purchase for the Stock-Trak investment.
  • Identify the name, ticker symbol, price per share, and total amount of trade.
  • Explain your choice of these two securities as either highly correlated or negatively correlated.
  • Calculate the weight of each security based on the market values of this two-security
  • Calculate the geometric mean return for each stock based on the last five years.
    • Note: Not all stocks will have data over this time period. Use a reasonable time period that is equivalent for both stocks.
  • Calculate the standard deviation of each stock, using data from Stock-Trak. To do this
    • On Stock-Trak, for each stock go to Share Price Performance.
    • Look up the standard deviation as reported by Stock-Trak. This is the monthly standard deviation.
    • To determine the annualized standard deviation, multiply the monthly standard by the square root of 12.
    • Annual Std. Dev. = (SQRT 12) * Std Dev.
  • Calculate the covariance of these two securities using equation 7-9 in the textbook.
    • Calculate annual returns for each security for the past five years.
    • Use your calculated geometric mean return as the expected return.
    • Assume an equal probability for each return.
  • Calculate the correlation coefficient between these two stocks using equation 7-10 in the textbook.
    • Use your calculated covariance.
    • Use the annualized standard deviations you derived from Stock-Trak for each security.
  • Calculate the risk of the portfolio.
    • Use equation 7-12 in the textbook.
    • Use your calculated correlation coefficient.
    • Use the annualized standard deviation you calculated for each.
  • Calculate the expected return of this two-security portfolio.
    • Use your calculated geometric mean return as the expected return for each security.
  • Summarize your calculations in a table.
  • Explain the meaning of the correlation coefficient you calculated and determine if the value meets your expectation for these two stocks as either highly correlated or negatively correlated.
  • Compare the portfolio expected return and risk to the expected return and risk for each security alone.
  • Calculate the portfolio risk and the portfolio expected return for five portfolios using these two securities and the following weights on each security:
    • Security A: 10%, Security B: 90%
    • Security A: 25%, Security B: 75%
    • Security A: 50%, Security B: 50%
    • Security A: 75%, Security B: 25%
    • Security A: 90%, Security B: 10%
    • Use your calculated correlation coefficient.
  • Create a table illustrating the impact of changing weights of these two securities on the portfolio risk and expected returns.
  • Explain the benefit of diversifying this portfolio from a portfolio of one of these stocks into the portfolio of two stocks.

The Modern Portfolio Theory Report paper

  • Must be no less than three to five single-spaced pages in length including data tables (not including references pages).
  • Must include an introduction and conclusion paragraph.
  • Must be written for a professional setting.
  • Must have all in-text citations formatted according to APA standards
  • Must use at least three credible sources.