Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
explain, please the first picture is the question, the three other pictures are the data. thank you Refer to the 22-24 tab in the Excel
explain, please the first picture is the question, the three other pictures are the data. thank you
Refer to the 22-24 tab in the Excel Homework Template provided on D2L. Suppose the correlation between NCREIF and the S&P 500 is -20 percent. What is the standard deviation of the portfolio when 50 percent of the portfolio is allocated to each investment? oints 6 S&P 7 NCREIF 8 Correlation Std. Dev. 7.41% 1.76% -20.00% Return 4.06% 2.32% 11 14 15 17 18 19 20 % S&P 0.00% 5.00% 10.00% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% 45.00% 50.00% 55.00% 60.00% 65.00% 70.00% 75.00% 80.00% 85.00% 90.00% 95.00% 100.00% % NCREIF 100.00% 95.00% 90.00% 85.00% 80.00% 75.00% 70.00% 65.00% 60.00% 55.00% 50.00% 45.00% 40.00% 35.00% 30.00% 25.00% 20.00% 15.00% 10.00% 5.00% 0.00% Portfolio Variance 0.03% 0.03% 0.03% 0.03% 0.03% 0.04% 0.05% 0.07% 0.09% 0.11% 0.13% 0.16% 0.19% 0.22% 0.26% 0.30% 0.34% 0.39% 0.44% 0.49% 0.55% Portfolio Stand. Dev 1.76% 1.64% 1.61% 1.68% 1.83% 2.05% 2.32% 2.62% 2.94% 3.28% 3.63% 3.99% 4.36% 4.73% 5.11% 5.49% 5.87% 6.25% 6.64% 7.02% 7.41% Return Return x 100 2.32% 2.32 2.41% 2.41 2.50% 2.50 2.58% 2.58 2.67% 2.67 2.76% 2.76 2.84% 2.84 2.93% 2.93 3.02% 3.02 3.10% 3.10 3.19% 3.28% 3.28 3.36% 3.36 3.45% 3.45 3.54% 3.54 3.62% 3.62 3.71% 3.71 3.80% 3.80 3.88% 3.88 3.97% 3.97 4.06% 4.06 23 3.19 25 32 AutoSave OD File Home 2 insert 8 Draw UG FIN 460 Chapter 21-22 Homework Template - Excel Review View Help Search Page Layout Formulas Data 29 Wrap Text General AA TU-10A- Merge Center - $ % 9 9 Conditional Formatas Formatting Tables Chapter 22 Exhibit 22-8 Portfolio Returns of NCREIF and S&P 500 Portfolio Return (percent) Portfolio Standard deviation Type here to search
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e5b7d3a8c3_140669e5b7cabb8e.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e5b7e09632_141669e5b7d770c4.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e5b7f08625_142669e5b7e5045f.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669e5b800109b_143669e5b7f5561e.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started