Compute the standard deviation of the market

Assignment Help Business Economics
Reference no: EM133067812

You are trying to form portfolios based on the following information about Stocks A,B,C and D Expected Return of Stock A = 5%; Stock B = 8%; Stock C = 15%; Stock D = 21%

The Standard Deviation of Stock A = 12%; Stock B = 18%; Stock C = 32%; Stock D = 40%

The Correlation between A,B = - 0.05; A,C = 0.10, A,D = 0.07; B,C = 0.20; B,D = 0.50; C,D = 0.35

The Risk Free Rate is 4.0%

Question: Compute the standard deviation of the market (optimal portfolio) using the excel solver function.

Reference no: EM133067812

Questions Cloud

Calculate the expected return for omega fund : Q3. What is the standard deviation of a portfolio of two stocks given the following data? Stock A has a standard deviation of 0.19. Stock B has a standard devia
How much is the factory overhead variance for the period : The Factory Overhead Control account had a balance of P375,000. Actual machine hours were 70,000. How much is the factory overhead variance for the period
Mortgaged backed securities : Why did so many investment banks have to start buying CDO's and other mortgaged backed securities themselves (rather than selling them to other investors).
Methods for establishing key risk indicators : Summarize the COSO Risk Management Framework and COSO's ERM process. Analyze the methods for establishing key risk indicators (KRIs).
Compute the standard deviation of the market : Compute the standard deviation of the market (optimal portfolio) using the excel solver function.
Compute the per unit cost and selling price of both : The company has identified the appropriate cost driver for each activity. Compute the per unit cost and selling price of both
Determining the total recruiting cost : The Baldwin's workforce complement will grow by 10% (rounded to the nearest person) next year. Ignoring downsizing from automating, what would their total recru
Calculate the average return : In a recent 5-year period, mutual fund manager Diana Sauros produced the following percentage rates of return for the Mesozoic Fund. Rates of return on the mark
Responsibilities of various company stakeholders : Identify the key roles and responsibilities of the various company stakeholders.

Reviews

Write a Review

Business Economics Questions & Answers

  Dozen eggs gasoline or chevron gas specifically

Consider the 'pairs' of goods below. Which good in each pair is likely to have relatively more elastic demand? Why?:  Sirloin steak or a dozen eggs Gasoline or Chevron gas specifically.  iPhones or Androids

  Many arguments in favor of tariffs

Of the many arguments in favor of tariffs, the one that has enjoyed the most significant economic justification has been the: If the U.S. demand for Korean steel is price elastic, an export subsidy granted to Korean steel firms will increase Korea's ..

  Illustrate what is the internal rate of return

The annual cash flows have the following projections. Illustrate what is the internal rate of return.

  Opportunity cost of going to a movie premiere at theatre

Calculate your opportunity cost of going to a movie premiere at the theatre with your friend Spencer on Saturday night in the following scenarios. You have no other plans for the night, and Spencer is paying for your ticket. You have already bought y..

  Economy is recovering from the recession

Senator Snodgrass says, “You economists say the economy is recovering from the recession but corporations are sitting on piles of cash and the unemployment rate is not declining. If the economy is really getting better, why aren’t more people getting..

  Which is the most economical installation

A boiler is being considered for a new process plant. The boiler can be fired either by natural gas, fuel oil, or coal. A decision must be made on which fuel to use. An analysis of the costs shows that the installed cost, with all controls, would be ..

  Rate r of the transmission link

Incorporate some form of weighted fair queueing in the head-of-line priority system so that the low-priority traffic is guaranteed to receive r bps out of the total bit rate R of the transmission link.

  Discuss the types of field trips students

Discuss the types of field trips students in the program attend and why.

  What should she charge per bus to maximize her profit

What should she charge per bus to maximize her profit? What would her profit be?

  Perform the appropriate test

Perform the appropriate test to determine if the proportion distribution of likely most popular majors in the next two years

  Estimate student loan obligation upon graduation

Estimate your student loan obligation upon graduation. You will need both the loan amount (principal) and interest rate for each loan.

  What is break-even quantity

Your dartboard venture proves to be a success and so you are considering expanding your business by starting a division that specializes in making darts.

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