Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel answer would be appreciated! 3 Here are the percentage returns on two stocks. 2.22 points Digital Cheese 15% -4 Month January February March April

Excel answer would be appreciated!

image text in transcribedimage text in transcribed

3 Here are the percentage returns on two stocks. 2.22 points Digital Cheese 15% -4 Month January February March April May June July August o w wivu do Executive Fruit 7% 2 5 13 1 5 un UIN -1 a-1. Calculate the monthly variance and standard deviation of each stock. (Do not round intermediate calculations. Round your answers to 1 decimal places.) Answer is complete but not entirely correct. Digital Cheese 20.8 X 4.6 x Variance Executive Fruit 15.3 X Standard deviation % 3.9 a-2. Which stock is the riskier if held on its own? Digital Cheese Executive Fruit b. Now calculate the variance and standard deviation of the returns on a portfolio that invests an equal amount each month in the two stocks. (Do not round intermediate calculations. Round your answers to 1 decimal places.) Variance Standard deviation % c. Is the variance more or less than half way between the variance of the two individual stocks? more than the 50%-50% less than the 50%-50%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance In Theory And Practice

Authors: Richard Abel Musgrave, Peggy B. Muscrave

5th Edition

0070441278, 978-0070441279

More Books

Students also viewed these Finance questions

Question

4. What kind of research study is this?

Answered: 1 week ago