Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Calculate Standard Deviation and show in Excel Fill in the missing information in the following table. Assume that Portfolio AB is 60 percent invested

image text in transcribed Please Calculate Standard Deviation and show in Excel

Fill in the missing information in the following table. Assume that Portfolio AB is 60 percent invested in Stock A. (A negative value should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) Answer is complete but not entirely correct. % Annual Returns on Stocks A and B Stock A Stock B 14.0 22.0 % 34.2 (33.8) % (15.4) 43.8 24.6 17.4 15.8 28.2 % 14.64 15.52 0.00 0.00 % Year 2012 2013 2014 2015 2016 Average return Standard deviation % Portfolio AB 17.20 7.00 8.28 21.72 20.76 14.99 0.00

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

Gulf Capital And Islamic Finance The Rise Of The New Global Players

Authors: Aamir A. Rehman

1st Edition

0071621989

More Books

Students also viewed these Finance questions