Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

The annual returns of three stocks during the last eight years are presented.

STOCK A: 1%, 6%, 10%, 18%, 20%, 7%, -10%, -2%
STOCK B: 12%, 9%, 16%, 11%, -5%, -2%, -2%, 6%
STOCK C: 20%, -2%, 33%, 10%, -8%, -10%, 8%, 30%

1) Using Excel, Determine the average return, and the standard deviation of returns for each stock. Which stock has the highest expected return and which one has the highest risk?
2) Using Excel, Determine the correlation coefficient and the covariance between each pair of stocks.
3) Using Excel, Determine the expected return, and the standard deviation of returns of equally weighted portfolios consisting of two stocks (AB, BC, and AC) and three (ABC) stocks.
4) Create charts showing how the standard deviation of the two-stock (AB and AC) portfolios' returns changes as the weight of one stock (A) changes.
5) Use the Solver to determine the minimum variance portfolio composed of three stocks (ABC).

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M926851

Have any Question? 


Related Questions in Basic Finance

You are the senior assistant to the chairman of the board

You are the senior assistant to the Chairman of the Board of Hi-Teck Inc. In order to attract the chief operating officer of his choice from another firm, the Chairman offers the following incentive supplement to her bas ...

1 discuss the effects of risk and term of a bond on the

1. Discuss the effects of risk and term of a bond on the interest rate paid. 2. What are some of the constraints on the recovery and growth of the GSE and private mortgage-backed securities market? 3. How can pre-purchas ...

Mimi joined umuc basketball team since summer 2016 on

Mimi joined UMUC basketball team since summer 2016. On average, she is able to score 30% of the field goals. Assume she tries 15 field goals in a game. (a) Let X be the number of field goals that Mimi scores in the game. ...

1 name the three general methods of title assurance and

1. Name the three general methods of title assurance and briefly describe each. Which would you recommend to a friend purchasing a home? Why? 2. Would it be legal for you to give a quitclaim deed for the Statue of Libert ...

Assume that on 1 november the spot rate of the poundus was

Assume that, on 1 November, the spot rate of the £/US$ was $1.58 and the price on a December futures contract was $1.59. Assume that the pound depreciates over November, so that by 30 November it is worth $1.51. (a) What ...

1 what is the difference between a debt instrument and an

1. What is the difference between a debt instrument and an equity? 2. Define and briefly explain the following terms: a. Face value b. Coupon c. Coupon rate d. Current yield e. Maturity 3. Explain in which category of de ...

Use secondary sources to write a report about female

Use secondary sources to write a report about female leaders in business. 2020 Women on Boards is an organization dedicated to raising the percentage of women on corporate boards to at least 20% by the year 2020. As part ...

Normas cat food of shell knob ships cat food throughout the

Norma's Cat Food of Shell Knob ships cat food throughout the country. Norma has determined that through the establishment of local collection centers around the country, she can speed up the collection of payments by two ...

Contrast lookback options and barrier options and explain

Contrast lookback options and barrier options and explain the difference between in- and out-options? Explain how weather derivatives could be used by an electric utility to manage the risk associated with power consumpt ...

Briefly describe each of the following developments in

Briefly describe each of the following developments in accounts payable and disbursements. a. Integrated accounts payable b. Purchasing/procurement cards c. Imaging services d. Fraud prevention in disbursements.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen