Compute the standard deviation of the market

Assignment Help Finance Basics
Reference no: EM133071988

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: EM133071988

Questions Cloud

What is the project net present value : Kim Hotels is interested in developing a new hotel in Seoul. The company estimates that the hotel would require an initial investment of $17 million. Kim expec
Calculate the three measures of central tendency-mean : Pick two of the three continuous variables (ADDC, IQ, or GPA) to calculate the three measures of central tendency-mean, median, and mode.
Describe the signs and symptoms of disease or disorder : Define the disease or disorder and explain its typical cause. Describe the signs and symptoms of the disease or disorder.
Explain the role of institutions : Explain the role of any 2 institutions under the category of development finance institutions (DFIs) in the movement of funds in the Malaysian financial systems
Compute the standard deviation of the market : You are trying to form portfolios based on the following information about Stocks A,B,C and D
What was the company networking capital : Total current assets of $1,975 million, total assets of $6,341 million, total current liabilities of $1,341 million, What was the company networking capital
Community health assessments-continuous quality improvement : What role or roles should community members have in a community needs assessment? What are some strategies for engaging community members?
Determine the realize profit in terms of euros : Suppose that the current spot exchange rate is EUR/USD 0.80 and the three-month forward exchange rate is EUR/USD 0.7813. The three-month interest rate is 8% per
Determine the total monthly housing payment : They will obtain a $225,000, 30-year mortgage at 7.5 percent. Determine the total monthly housing payment for the Covingtons

Reviews

Write a Review

Finance Basics Questions & Answers

  Why does the price go up when interest rates fall

What is the interest rate should fall to 4.5%? Rise to 8.5%? Why does the price go up when interest rates fall? Why does the price go down when interest rates rise?

  Company weighted average cost of capital

What factors may influence a company's weighted average cost of capital? Why?

  What is happening to the pv of the annuity as r increases

You need to insure your home over the next 20 years. You can either pay beginning-of-year premiums with today's premium of $5,000 and future premiums growing at 4 percent per year, or prepay a lump sum of $67,500 for the entire 20 years of coverag..

  Evaluate the payoffs of a short sale of boa

Evaluate the payoffs of a short sale of BOA and the synthetic short sale at prices of $18, $25 and $28. Don't forget the premiums on the options

  Bond pricing factors and direction of response

Write down the three factors that cause a bond's price to change and what is the predicted direction of change for the bond's price from changes in these factors?

  Calculate operating cash flow

A proposed new project has projected sales of $175,000, costs of $93,000, and depreciation of $24,800. The tax rate is 23 percent. Calculate operating cash flow

  Improving transfer of training

Focusing on this particular training program, and considering the pre-training, training and post-training periods, what suggestions do you have for improving.

  What is the exact cost of trade credit as an annual rate

If your firm buys $100 worth of supplies on credit with terms 3/10 n30 and pays the bill on the 30thday after the purchase.

  Calculate the effective or approximate duration of bond

Consider a 20-year, semiannual-pay bond with an 8% coupon that is currently priced at $799.608 to yield 10.5%. If the yield changes by 50 basis points, the pric

  Price of the corresponding european call

A stock selling at $150 is expected to pay a dividend of $10 in three months and has a volatility of 20%. Consider call and put options with a 6-month maturity

  How much of a dividend will you receive

The board of directors has authorized $292,000 to be distributed to its stockholders as an annual dividend. You own 100 of the 8,000 shares of common stock.

  What is structured systems design

What are the factors an organization must consider in structuring the RFP and deciding to whom the RFP will be sent?

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