{ "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": "\"image

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>

\"image<\/div><\/div><\/div> 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", "transcribed_text": "", "related_book": { "title": "Thomas Calculus Early Transcendentals", "isbn": "978-0321884077, 0321884078", "edition": "13th Edition", "authors": "Joel R Hass, Christopher E Heil, Maurice D Weir", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/63ae9246a77a5_20930.jpg", "uri": "\/textbooks\/thomas-calculus-early-transcendentals-13th-edition-9780321884077", "see_more_uri": "" }, "free_related_book": { "isbn": "1473220289", "uri": "\/textbooks\/valley-of-terror-1st-edition-9781473220287-95292", "name": "Valley Of Terror", "edition": "" }, "question_posted": "2024-06-09 07:11:21", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/presented-here-are-selected-data-from-the-10k-reports-of", "description": "Presented here are selected data from the 10-K reports of four companies. The four companies, in alphabetical order, are BellSouth Corporation, a telephone company that operates in the southeastern...", "stars": 3 }, { "url": "\/a-large-omaha-feed-mill-b-swart-processing-prepares-its", "description": "A large Omaha feed mill, B. Swart Processing, prepares its 6-month aggregate plan by forecasting demand for 50-pound bags of cattle feed as follows: January, 1,000 bags; February, 1,200; March,...", "stars": 3 }, { "url": "\/study-help\/psychology\/explain-ways-to-deal-with-anger-constructively-1982700", "description": "Explain ways to deal with anger constructively.", "stars": 3 }, { "url": "\/on-july-1-2008-falk-company-signed-a-contract-to", "description": "On July 1, 2008, Falk Company signed a contract to lease space in a building for 15 years. The lease con-tract calls for annual (prepaid) rental payments of $80,000 on each July 1 throughout the life...", "stars": 3 }, { "url": "\/study-help\/questions\/bogscraft-company-has-outstanding-68000-shares-of-10-par-value-9857188", "description": "Bogscraft Company has outstanding 68,000 shares of $10 par value common stock and 26,600 shares of $20 par value preferred stock (8 percent). On February 1, the board of directors voted in favor of...", "stars": 3 }, { "url": "\/study-help\/questions\/your-answers-are-saved-automatically-maining-time-1hour-21-minutes-5682228", "description": "Your answers are saved automatically maining Time 1hour, 21 minutes, 57 seconds stion Completion Status 1 45 10 11 12 13 35 16 17 18 19 20 21 22 More to water on will save this response Question 12...", "stars": 3 }, { "url": "\/study-help\/questions\/x-consigned-100-packets-of-cosmetics-each-costing-rs-300-813286", "description": "X consigned 100 packets of cosmetics each costing Rs. 300 to his agent at Mumbai. He paid Rs. 500 towards freight and insurance. 15 packets were destroyed on the way. Consignee took delivery of the...", "stars": 3 }, { "url": "\/study-help\/questions\/for-the-system-transfer-function-determine-the-percent-peak-overshoot-1029117", "description": "For the system transfer function determine the percent peak overshoot, the rise time, and the settling time. It could be done with MATLAB graphics. G(s) : = 48 10s2+14s+16", "stars": 3 }, { "url": "\/study-help\/questions\/the-severity-of-a-larceny-charge-is-increased-when-property-3211810", "description": "The severity of a larceny charge is increased when property was taken during the looting of a disaster area. Group of answer choices True False", "stars": 3 }, { "url": "\/study-help\/questions\/11-exercise-138-algo-analyzing-effect-of-transactions-on-current-2042609", "description": "11 Exercise 13-8 (Algo) Analyzing effect of transactions on current ratio LO P3 its eBook On January 1, 5G Co. reported current assets of $187,200 and current liabilities of $156,000. Compute total...", "stars": 3 }, { "url": "\/study-help\/questions\/the-four-most-common-computerbased-information-systems-are-a-transaction-1005333", "description": "The four most common computer-based information systems are a: Transaction Processing System (TPS), Management Information System (MIS), and a Decision Support System (DSS). Describe each of these...", "stars": 3 }, { "url": "\/study-help\/questions\/it-is-not-uncommon-for-community-service-workers-to-travel-5096869", "description": "It is not uncommon for community service workers to travel or transport clients in company vehicles. List two (2) strategies that you could include in the 'safe driving' procedures of a community...", "stars": 3 }, { "url": "\/study-help\/fundamentals-of-management\/how-do-incidents-like-this-affect-how-managers-work-with-1550778", "description": "How do incidents like this affect how managers work with a value chain?", "stars": 3 }, { "url": "\/study-help\/fundamentals-of-management\/discuss-this-from-a-value-chain-management-perspective-what-happened-1550779", "description": "Discuss this from a value chain management perspective. What happened? How did it happen? Why did it happen?", "stars": 3 }, { "url": "\/study-help\/fundamentals-of-management\/describe-the-operations-management-issues-that-the-dreamliner-team-faced-1550771", "description": "Describe the operations management issues that the Dreamliner team faced. Could these issues have been avoided? Why or why not?", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/il-answered-question-10-01-pt-a-chemical-manufacturing-plant-2506151", "next": "\/study-help\/questions\/question-below-go-into-components-such-as-reivenvestment-risk-and-2506153" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Finance", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-finance" }, { "name": "4) To achieve international diversification, John invests in the USA and India", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/4-to-achieve-international-diversification-john-invests-in-the-usa-2506152" } ], "skill_details": { "skill_id": "13", "skill_name": "Finance", "parent_id": "1" } } "1" } }