{"id":2085,"date":"2024-07-23T13:46:01","date_gmt":"2024-07-23T13:46:01","guid":{"rendered":"https:\/\/britainwriters.com\/answers\/?p=2085"},"modified":"2024-07-23T13:46:04","modified_gmt":"2024-07-23T13:46:04","slug":"janet-smith-investing-in-mutual-funds-assignment","status":"publish","type":"post","link":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/","title":{"rendered":"Janet Smith Investing In Mutual Funds Assignment"},"content":{"rendered":"\n

Assignment Task<\/strong><\/h3>\n\n\n\n

Janet Smith is interested in investing in the following set of mutual funds whose returns are normally distributed with the indicated means and standard deviations:<\/p>\n\n\n\n

 <\/td>Fund A<\/strong><\/td>Fund B<\/strong><\/td>Fund C<\/strong><\/td>Fund D<\/strong><\/td>Fund E<\/strong><\/td><\/tr>
Mean<\/strong><\/td>17.0%<\/td>14.0%<\/td>11.0%<\/td>8.0%<\/td>5.0%<\/td><\/tr>
Standard Deviation<\/strong><\/td>9.0%<\/td>6.5%<\/td>5.0%<\/td>3.5%<\/td>2.0%<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Based on historic data, the correlations between the mutual funds are as follows:<\/p>\n\n\n\n

 <\/td>Fund A<\/strong><\/td>Fund B<\/strong><\/td>Fund C<\/strong><\/td>Fund D<\/strong><\/td>Fund E<\/strong><\/td><\/tr>
Fund A<\/strong><\/td>1<\/td>0.1<\/td>0.05<\/td>0.3<\/td>0.6<\/td><\/tr>
Fund B<\/strong><\/td> <\/td>1<\/td>0.2<\/td>0.15<\/td>0.1<\/td><\/tr>
Fund C<\/strong><\/td> <\/td> <\/td>1<\/td>0.1<\/td>0.2<\/td><\/tr>
Fund D<\/strong><\/td> <\/td> <\/td> <\/td>1<\/td>0.4<\/td><\/tr>
Fund E<\/strong><\/td> <\/td> <\/td> <\/td> <\/td>1<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

1. Assume that Janet is willing to assume the risk associated with a 5% standard deviation on her portfolio. What is the optimal percentage allocation in each fund that will give Janet the maximum expected return for this level of risk? Make sure to copy the Forecast Chart along with the OptQuest Chart  within your spreadsheet.<\/p>\n\n\n\n

Hints:<\/strong><\/p>\n\n\n\n

    \n
  1. The decision variables pertain to the proportion Pi<\/sub>\u00a0that is to be invested in each fund rather than how much to invest in each fund.<\/li>\n\n\n\n
  2. Each decision variable is bounded by: \u00a0Pi<\/sub><=1 and Pi\u00a0<\/sub>>= 0 (continuous)<\/li>\n\n\n\n
  3. Make sure that you have a constraint restricting the sum of the Pi<\/sub>‘s = 1<\/li>\n\n\n\n
  4. Don’t forget to add a “requirement” restricting the standard deviation of the average max returns to be less than or equal to 5%\u00a0<\/li>\n\n\n\n
  5. Don’t forget to incorporate the provided correlations among the assumption cells.<\/li>\n\n\n\n
  6. Don’t forget to adjust your “run Preferences” for OptQuest (e.g., Latin Hyper Cube with 500 runs).<\/li>\n\n\n\n
  7. Don’t forget to copy the solution from the OptQuest results window to your spreadsheet.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Assignment Task Janet Smith is interested in investing in the following set of mutual funds whose returns are normally distributed with the indicated means and standard deviations:   Fund A Fund B Fund C Fund D Fund E Mean 17.0% 14.0% 11.0% 8.0% 5.0% Standard Deviation 9.0% 6.5% 5.0% 3.5% 2.0% Based on historic data, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2085","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nJanet Smith Investing In Mutual Funds Assignment - My Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Janet Smith Investing In Mutual Funds Assignment - My Blog\" \/>\n<meta property=\"og:description\" content=\"Assignment Task Janet Smith is interested in investing in the following set of mutual funds whose returns are normally distributed with the indicated means and standard deviations:   Fund A Fund B Fund C Fund D Fund E Mean 17.0% 14.0% 11.0% 8.0% 5.0% Standard Deviation 9.0% 6.5% 5.0% 3.5% 2.0% Based on historic data, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/\" \/>\n<meta property=\"og:site_name\" content=\"My Blog\" \/>\n<meta property=\"article:published_time\" content=\"2024-07-23T13:46:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-23T13:46:04+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/person\\\/c698e0f0b4a723b0d250ea199e68a6d3\"},\"headline\":\"Janet Smith Investing In Mutual Funds Assignment\",\"datePublished\":\"2024-07-23T13:46:01+00:00\",\"dateModified\":\"2024-07-23T13:46:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/\"},\"wordCount\":260,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/\",\"name\":\"Janet Smith Investing In Mutual Funds Assignment - My Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#website\"},\"datePublished\":\"2024-07-23T13:46:01+00:00\",\"dateModified\":\"2024-07-23T13:46:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/janet-smith-investing-in-mutual-funds-assignment\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Janet Smith Investing In Mutual Funds Assignment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#website\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/\",\"name\":\"My Blog\",\"description\":\"My WordPress Blog\",\"publisher\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#organization\",\"name\":\"My Blog\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/bw-logo.png\",\"contentUrl\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/wp-content\\\/uploads\\\/2023\\\/12\\\/bw-logo.png\",\"width\":379,\"height\":81,\"caption\":\"My Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/#\\\/schema\\\/person\\\/c698e0f0b4a723b0d250ea199e68a6d3\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/britainwriters.com\\\/website\"],\"url\":\"https:\\\/\\\/britainwriters.com\\\/answers\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Janet Smith Investing In Mutual Funds Assignment - My Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/","og_locale":"en_US","og_type":"article","og_title":"Janet Smith Investing In Mutual Funds Assignment - My Blog","og_description":"Assignment Task Janet Smith is interested in investing in the following set of mutual funds whose returns are normally distributed with the indicated means and standard deviations:   Fund A Fund B Fund C Fund D Fund E Mean 17.0% 14.0% 11.0% 8.0% 5.0% Standard Deviation 9.0% 6.5% 5.0% 3.5% 2.0% Based on historic data, […]","og_url":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/","og_site_name":"My Blog","article_published_time":"2024-07-23T13:46:01+00:00","article_modified_time":"2024-07-23T13:46:04+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/#article","isPartOf":{"@id":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/"},"author":{"name":"admin","@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/person\/c698e0f0b4a723b0d250ea199e68a6d3"},"headline":"Janet Smith Investing In Mutual Funds Assignment","datePublished":"2024-07-23T13:46:01+00:00","dateModified":"2024-07-23T13:46:04+00:00","mainEntityOfPage":{"@id":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/"},"wordCount":260,"commentCount":0,"publisher":{"@id":"https:\/\/britainwriters.com\/answers\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/","url":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/","name":"Janet Smith Investing In Mutual Funds Assignment - My Blog","isPartOf":{"@id":"https:\/\/britainwriters.com\/answers\/#website"},"datePublished":"2024-07-23T13:46:01+00:00","dateModified":"2024-07-23T13:46:04+00:00","breadcrumb":{"@id":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/britainwriters.com\/answers\/janet-smith-investing-in-mutual-funds-assignment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/britainwriters.com\/answers\/"},{"@type":"ListItem","position":2,"name":"Janet Smith Investing In Mutual Funds Assignment"}]},{"@type":"WebSite","@id":"https:\/\/britainwriters.com\/answers\/#website","url":"https:\/\/britainwriters.com\/answers\/","name":"My Blog","description":"My WordPress Blog","publisher":{"@id":"https:\/\/britainwriters.com\/answers\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/britainwriters.com\/answers\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/britainwriters.com\/answers\/#organization","name":"My Blog","url":"https:\/\/britainwriters.com\/answers\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/logo\/image\/","url":"https:\/\/britainwriters.com\/answers\/wp-content\/uploads\/2023\/12\/bw-logo.png","contentUrl":"https:\/\/britainwriters.com\/answers\/wp-content\/uploads\/2023\/12\/bw-logo.png","width":379,"height":81,"caption":"My Blog"},"image":{"@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/britainwriters.com\/answers\/#\/schema\/person\/c698e0f0b4a723b0d250ea199e68a6d3","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9c8389b9a2505b8a25de6eb6bd63d1b3bd34e49d8d91d40d9935e77bdb797c34?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/britainwriters.com\/website"],"url":"https:\/\/britainwriters.com\/answers\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts\/2085","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/comments?post=2085"}],"version-history":[{"count":1,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts\/2085\/revisions"}],"predecessor-version":[{"id":2086,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/posts\/2085\/revisions\/2086"}],"wp:attachment":[{"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/media?parent=2085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/categories?post=2085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/britainwriters.com\/answers\/wp-json\/wp\/v2\/tags?post=2085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}