{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-09T07:11:21-04:00", "answer_date": "2024-06-09 07:11:21", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "2506152", "url": "\/study-help\/questions\/4-to-achieve-international-diversification-john-invests-in-the-usa-2506152", "question_creation_date_js": "2024-06-09T07:11:21-04:00", "question_creation_date": "Jun 09, 2024 07:11 AM", "meta_title": "[Solved] 4) To achieve international diversificati | SolutionInn", "meta_description": "Answer of - 4) To achieve international diversification, John invests in the USA and India indexes. What are the weights on the tw | SolutionInn", "meta_keywords": "4,achieve,international,diversification,john,invests,usa,india,indexes,weights,two,optimal", "question_title_h1": "4) To achieve international diversification, John invests in the USA and India indexes. What are the weights on the two indexes to achieve the optimal", "question_title": "4) To achieve international diversification, John invests in the USA and India", "question_title_for_js_snippet": "4) To achieve international diversification, John invests in the USA and India indexes What are the weights on the two indexes to achieve the optimal international portfolio What are the mean and standard deviation of returns on his optimal international portfolio 5) Mary instead invests in the USA and Korean indexes What are the weights on the two indexes to achieve the optimal international portfolio What are the mean and standard deviation of returns on her optimal international portfolio Please explain excel steps T bill average is 39 Font Paragraph Styles Editing Part One International Portfolio Management 1 Go to http finance yahoo com, download monthly Adj close prices (adjusted for Example of data presentation dividend and stock split) from 12 01 2010 through 12 01 2017 for the following three GSPC BSESN KS11 GSPC BSESN KS11 country indexes Adj Adj Adj Closing Closing Closing Country Ticker Dat Price Price Price HPR HPR HPR USA S P 500 GSPC 12 2 2013 6 6 India BSESN KS11 11 1 2013 2 45 79 2 7 75 Korea 10 1 2013 2 48 75 4 4 72 Note Historical T bill rates are provided in a separate EXCEL file 9 2 2013 2 14 78 5 4 18 8 1 2013 2 87 74 6 10 19 Compute monthly holding period return using Adj close prices 7 1 2013 5 95 74 8 11 18 Use the EXCEL statistical functions to compute mean (using AVERAGE) and standard 6 3 2013 11 44 78 4 16 80 deviation (using STDEV) of the monthly return for each index 5 2 2013 79 1 20 95 Assume that historical mean returns are good estimates of expected returns Mean STD To achieve international diversification, John invests in the USA and India indexes What are the weights on the two indexes to achieve the optimal international portfolio What are the mean and standard deviation of returns on his optimal international portfolio All calculations should be done in EXCEL with clear labels Mary instead invests in the USA and Korean indexes What are the weights on the two indexes to achieve the optimal international portfolio What are the mean and standard deviation of returns on her optimal international portfolio All calculations should be done in EXCEL with clear labels Discuss whose optimal portfolio performs better (John or Mary), and explain why Also discuss potential reason(s) that causes the difference (At least a half or one page discussion, double space) Use the following statistical functions in excel 1 Function AVERAGE for mean Function STDEV for standard deviation Function COVAR for covariance Function CORREL for correlation coefficient LO", "question_description": "
4) To achieve international diversification, John invests in the USA and India indexes. What are the weights on the two indexes to achieve the optimal international portfolio? What are the mean and standard deviation of returns on his optimal international portfolio?<\/p>
5) Mary instead invests in the USA and Korean indexes. What are the weights on the two indexes to achieve the optimal international portfolio? What are the mean and standard deviation of returns on her optimal international portfolio<\/p>
Please explain excel steps <\/p>
T-bill average is .39%<\/p>
<\/p>