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

1 suppose financial intermediaries did not exist and only

1. Suppose financial intermediaries did not exist and only direct finance was possible. How would this affect the process of an individual buying a car or a house? 2. During the 2007-2009 recession, many people who had t ...

Dealer quotes a rate of 5 on this fra and the end user

Dealer quotes a rate of 5% on this FRA and the end user agrees. The expiration date is in 90 days. The notional amount is $3,000,000. The underlying interest is the 180 LIBOR time deposit. In 90 days the 180-day LIBOR is ...

1 why is variance reduction important to logistical

1. Why is variance reduction important to logistical integration? Illustrate in terms of logistical operations. 2. What is the meaning of the phrase cradle-to-cradle logistics? Discuss the operational differences of orig ...

Suppose there are two risky assets c and d the tangency

Suppose there are two risky assets, c and d, the tangency portfolio is 60% c and 40% d, and the expected return and standard deviation of the return on the tangency portfolio are 5% and 7%, respectively. Suppose also tha ...

Us federal law regulates some futures market participants

U.S. federal law regulates some futures market participants, even though they do not directly participate in trading. Explain the difference between an introducing broker, a commodity trading advisor, a commodity pool op ...

The text discusses the trade-off between internal and

The text discusses the trade-off between internal and external validity, known as the experimenters dilemma. Speculate on things a researcher can do to increase internal and external validity simultaneously, thereby desi ...

Assume that you have an opportunity to visit a civilization

Assume that you have an opportunity to visit a civilization in outer space. Its society is at roughly the same stage of development as U.S. society is now. Its economic system is virtually identical to that of the United ...

1 what is the base salary of the international assignee2

1. What is the base salary of the international assignee? 2. How much is the G&S differential and how was it calculated? 3. How much is the housing differential and how was it calculated? 4. What type of allowance did th ...

Define each of the followinga call optionb put optionc

Define each of the following: a. Call option b. Put option c. Strike price d. Expiration date 2. How do the rights and obligations of options buyers and sellers differ from the rights and obligations of futures buyers an ...

1 discuss the differences between foreign trade and foreign

1. Discuss the differences between foreign trade and foreign direct investment. 2. Identify some of the competitive threats of RDEs. 3. Discuss the ethics of outsourcing to other countries where the wages are less than o ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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