Question
Use the 60 monthly returns from September 2016 to August 2021 of Johnson & Johnson (JNJ) and Goldman Sachs (GS). (If the answer is 12.34%,
Use the 60 monthly returns from September 2016 to August 2021 of Johnson & Johnson (JNJ) and Goldman Sachs (GS).
(If the answer is 12.34%, then submit 12.34 instead of 0.1234 or 12.34%; you can download either raw data from Yahoo Finance or DJIA_RETURNS_211006_PIVOT.csv from Canvas.)
a. What is the annualized standard deviation of the portfolio that invests 67% to JNJ and 33% to GS?
b. Use Solver in Excel to find the JNJ-GS portfolio that has the minimum possible portfolio standard deviation. What is this portfolio's JNJ weight?
c. Use Solver in Excel to find the JNJ-GS portfolio that has the maximum possible Sharpe ratioassume that the risk-free rate is zero. What is this portfolio's JNJ weight?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Enhancing Financial Inclusion Through Islamic Finance Volume I
Authors: Abdelrahman Elzahi Saaid Ali , Khalifa Mohamed Ali , Muhammad Khaleequzzaman
1st Edition
3030399346,3030399354
