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

Quizquestion 1 when viewing the terms special returns or

QUIZ Question 1. When viewing the terms "special returns" or "abnormal returns," we know this can refer to _____. the Efficient Market Hypothesis gains in excess of the market risk-adjusted average convertibles and warra ...

1 discuss some of the major issues to consider when

1. Discuss some of the major issues to consider when choosing between an active or passive exporting strategy. 2. You work for a small company that has an innovative low-cost production method for high-capacity jump driv ...

Go to the financeyahoocom web site and click on the dow

Go to the finance.yahoo.com Web site and click on the Dow index. Select "Historical Prices" and download the monthly data for the Dow back to 1929. Graph these data using an Excel spreadsheet and comment on any strong pa ...

Class while us treasury stock and bonds are backed with the

Class, while US Treasury Stock and Bonds are backed with the credit of the US Government, there are still risks attached to these investments. What are these risks?

A recent survey at a major corporation found that employees

A recent survey at a major corporation found that employees who regularly participated in the company fitness program tended to have fewer sick days than employees who did not participate. However, because the study was ...

1 describe in your words the meaning of spatialtemporal

1. Describe in your words the meaning of spatial/temporal integration in logistical system integration. 2. What justification of logic can be presented to support the placement of a warehouse in a logistical system? 3. W ...

Question 1 outline the differences between common stock and

Question 1: Outline the differences between common stock and preferred stock? Question 2: What are the differences between capital projects that are independent, mutually exclusive, and contingent? Question 3: Cortez Art ...

What is the price of a t-bond with exactly 245 years to

What is the price of a T-Bond with exactly 24.5 years to maturity and coupons with rate 5.875% paid semi-annually? Its yield is 6.5% BEY (Bond Equivalent Yield is semi-annually compounded).

Canadian treasury bills with 1-year to maturity have a

Canadian Treasury bills with 1-year to maturity have a yield to maturity of 0.98% peryear. If you expect inflation to be 1.4% per year over the upcoming year, what is your expected real rate of return?

1 how many conditions are there in the simplest possible

1. How many conditions are there in the simplest possible experiment? 2. Describe how participants are assigned to conditions in randomized groups, matched-subjects, and repeated measures experimental designs. 3. What ar ...

  • 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