Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Get the monthly returns for Apple ( AAPL ) , Tesla ( TSLA ) , Eli Lilly ( LLY ) and the S&P 5 0

Get the monthly returns for Apple (AAPL), Tesla (TSLA), Eli Lilly (LLY) and the S&P 500(SPX) for the last 5 years.
Use these returns to answer the following questions. Assume the returns follow the normal distribution. Create a column
with the returns for a portfolio with the four stocks. Create separate cells that determine the weighting of the portfolio, you
can start with an equally weighted portfolio. There should be five columns with different returns.
a) Find the portfolio weighting that maximizes the expected value.
b) Find the portfolio weighting that maximizes \mu /\sigma . Explain the role risk plays in the change in portfolio weighting from
that of the previous question.
c) What portfolio weighting minimizes the standard deviation?
d) What portfolio minimizes the standard deviation but with the constraint the expected returns is at least 3%?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Institutions And Markets

Authors: Jeff Madura

10th International Edition

0538482176, 9780538482172

More Books

Students also viewed these Finance questions