Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you show me the formulas for the yellow.. This is what is asked to do to solve for the yellow using the data? Clipboard
Can you show me the formulas for the yellow.. This is what is asked to do to solve for the yellow using the data?
Clipboard Security Warning Macros have been disabled.Enable Content B22 FORD AND MSFT FORD MSFT return return Date 31-Dec-05 31-Dec-06 31-Dec-07 31-Dec-08 31-Dec-09 31-Dec-10 31-Dec-11 31-Dec-12 31-Dec-13 31-Dec-14 0.93%) -15.82% 20.85% -44.37% 60.40% -6.52% -4.52% 5.83% 44.29% 27.54% _11 2.92% 52.92% -43.44% ._--5.91 % -5.83% 53.33% -48.14% -11.38% 4.73% -32.90% - 14 Average, E(rRRD) and E(rism) 15. Varance, Var(roc) and Var(r. 16 Standard deviation, sRRD and s, 17| Covariance of returns, Cov(rFOR s Correlation of returns, IRoxD MSFT -2.95% 0.2646 0.0858, 51.44% 29.289: -00276,#NAME? 11.84% #NAME? #NAME? #NAME? 0.1831 #NAME? 19 20 Section a. 21 Minimum variance portfolio 22 Proportion in FORD 23 Proportion in MSFT 24 Average return 25 Standard deviation of return 28 27 Section b. 28 Target portfolio 29 Average return 30Proportion in FORD 31 Proportion in MSFT 32 Average return (check) 33 Standard deviation of return 34 35 4% 0.00% #NAMEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started