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

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

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