Annualized standard deviation of the portfolio

Assignment Help Finance Basics
Reference no: EM133070733

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 ratio-assume that the risk-free rate is zero. What is this portfolio's JNJ weight?

Reference no: EM133070733

Questions Cloud

Prefaced by langston hughes poem : The play is prefaced by a Langston Hughes poem. In what ways does the play illustrate the theme(s) of the poem?
What is the npv of the project : B. What is the NPV of the project? Answer in $ million, rounded up to two decimal places.
Prepare a Cash Budget for the quarter ending September : Cash Sales $75.000 Credit Sales $50.000 Receipts from Debtors $60.000 Wages paid $55.000. Prepare a Cash Budget for the quarter ending September
Estimate the modified durations of the bond : Please estimate the modified durations of the bond. Assume the coupon payment is made semiannually and the par value is $1,000.
Annualized standard deviation of the portfolio : Use the 60 monthly returns from September 2016 to August 2021 of Johnson & Johnson (JNJ) and Goldman Sachs (GS).
Define release plans : Define release plans. What purpose do they serve for those inmates who will be returning to society from prison and how are they implemented?"
Determine the sales revenue in the same market : 1. A European firm with operations in the United States offsets its U.S. operating costs with its sales revenue in the same market.
What would be the total overhead cost : Assume that 775 hours of machine hours are likely to be used in the month, what would be the total overhead cost based on the above calculations
What is booth additional funds needed : The Booth Company's sales are forecasted to double from $1,000 in 2019 to $2,000 in 2020. Here is the December 31, 2019, balance sheet:

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd