Please refer to your textbook, page 210 (NOTE: if you are using another textbook edition, data may appear on a later page, keep looking!) Specifically, you will be using the actual annual HPR data for Consolidated Edison (symbol: ED) and Central Valley Community Bancorp (symbol: CVCY). I.e., 2008-2017 HPR data for ED & CYCY. Answer only the following questions, do not look at any of the questions in the textbook. Using Excel spreadsheet: Determine the expected return (average) for both ED & CVCY. Determine the standard deviation of returns for both ED & CVCY. Determine the correlation coefficient between ED & CVCY. Suppose you want to construct a 2-asset portfolio using: 90% ED & 10% CVCY. Calculate this portfolio's expected return and standard deviation*. Any improvement of this

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Question
CE( ED) CV ( CVY)
2008 -15.70%|
Year
-43.40%
2009
23.80%
-9.90%
2010
14.90%
1.40%
2011
30.80%
-3.60%
2012
-6.70%
43.70%
2013
3.80%
47.40%
2014
24.80%
0.30%
2015
1.40%
10.80%
2016
18.90%
69.00%
2017
19.30%
2.20%
Transcribed Image Text:CE( ED) CV ( CVY) 2008 -15.70%| Year -43.40% 2009 23.80% -9.90% 2010 14.90% 1.40% 2011 30.80% -3.60% 2012 -6.70% 43.70% 2013 3.80% 47.40% 2014 24.80% 0.30% 2015 1.40% 10.80% 2016 18.90% 69.00% 2017 19.30% 2.20%
Question 1- 2-asset portfolio (please include your Excel spreadsheet file)
Please refer to your textbook, page 210 (NOTE: if you are using another textbook edition, data
may appear on a later page, keep looking!) Specifically, you will be using the actual annual HPR
data for Consolidated Edison (symbol: ED) and Central Valley Community Bancorp (symbol:
CVCY). I.e., 2008-2017 HPR data for ED & CYCY. Answer only the following questions, do not
look at any of the questions in the textbook.
Using Excel spreadsheet:
Determine the expected return (average) for both ED & CVCY.
Determine the standard deviation of returns for both ED & CVCY.
Determine the correlation coefficient between ED & CVCY.
Suppose you want to construct a 2-asset portfolio using: 90% ED & 10% CVCY. Calculate
this portfolio's expected return and standard deviation*. Any improvement of this
portfolio over using just 100% ED?
*For portfolio standard deviation, you may write the equation separately, show the inputs, and
use a calculator to solve. I.e., Excel is optional for standard deviation calculations.
Question 2
Based upon your answers above, are ED & CYCY effective stocks to include in a 2-asset
portfolio? Briefly discuss.
Question 3
Briefly discuss possible limitations to the determination of "beta value" for common stocks.
(HINT: consult Chapter 5 of the textbook & class discussions!)
Transcribed Image Text:Question 1- 2-asset portfolio (please include your Excel spreadsheet file) Please refer to your textbook, page 210 (NOTE: if you are using another textbook edition, data may appear on a later page, keep looking!) Specifically, you will be using the actual annual HPR data for Consolidated Edison (symbol: ED) and Central Valley Community Bancorp (symbol: CVCY). I.e., 2008-2017 HPR data for ED & CYCY. Answer only the following questions, do not look at any of the questions in the textbook. Using Excel spreadsheet: Determine the expected return (average) for both ED & CVCY. Determine the standard deviation of returns for both ED & CVCY. Determine the correlation coefficient between ED & CVCY. Suppose you want to construct a 2-asset portfolio using: 90% ED & 10% CVCY. Calculate this portfolio's expected return and standard deviation*. Any improvement of this portfolio over using just 100% ED? *For portfolio standard deviation, you may write the equation separately, show the inputs, and use a calculator to solve. I.e., Excel is optional for standard deviation calculations. Question 2 Based upon your answers above, are ED & CYCY effective stocks to include in a 2-asset portfolio? Briefly discuss. Question 3 Briefly discuss possible limitations to the determination of "beta value" for common stocks. (HINT: consult Chapter 5 of the textbook & class discussions!)
Expert Solution
Honor Code:

"Hi, Thanks for the Question. Since you asked multiple sub parts questions, we will answer first three sub parts for you as per authoring guidelines. Kindly repost the other sub parts separately by specifying the sub parts you want us to answer. Thankyou."

In this case we are solving all sub parts of question-1

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education