{"id":6708,"date":"2020-11-15T08:57:43","date_gmt":"2020-11-15T08:57:43","guid":{"rendered":"http:\/\/onlineclassesguru.com\/?p=6708"},"modified":"2020-11-15T08:57:43","modified_gmt":"2020-11-15T08:57:43","slug":"individual-stock-valuation-project","status":"publish","type":"post","link":"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/","title":{"rendered":"Individual Stock Valuation Project"},"content":{"rendered":"<style type=\"text\/css\"><\/style><p>Individual Stock Valuation Project<\/p>\n<p>This assignment will produce two documents both of which must be submitted via Moodle before the due date. Late submission will not be accepted. The documents are:<\/p>\n<p>\u2013 an Excel file where you perform all the calculations. Saved as YourName_ProjectCalculations.xlsx \u2013 a PDF report that will include summary results for your calculations as well as your discussion of these<\/p>\n<p>results (every table &amp; graph in your report must be followed by a brief discussion of the values and their comparison to one another). Saved as YourName_ProjectReport.pdf<\/p>\n<p>All material turned in are considered business documents. Errors and\/or sloppy work will result in loss of points.<\/p>\n<p>The first page of your report should include the followings: title of the case, course number, term, student\u0092s name, instructor\u0092s name, and a brief summary. The summary should be single-spaced. The next double spaced pages should include your analysis of the case. Pages should be numbered. All exhibits, such as figures, and tables, should be clearly labeled and referenced within the paper. Times New Roman font 12 should be used.<\/p>\n<p>Project description and steps<\/p>\n<p>1. Find names of the companies that were assigned to you in a separate spreadsheet. 2. Download daily stock price data that has been adjusted for splits and dividends for the two companies<\/p>\n<p>assigned to you and the Market Index. 3. Move this data to Excel. Calculate daily returns. 4. Use Daily Returns to calculate annual returns for the last 5 years for the two companies and the Market<\/p>\n<p>Index, and then calculate average returns over the five-year period. Include these results in your PDF report, e.g.<\/p>\n<p>Table 1. Annual rates of return<\/p>\n<p>Years Company A Company B Market Index 2018 2017 2016 2015 2014 Average<\/p>\n<p>5. Calculate the annual standard deviation of the returns for the two companies, and the Market Index. Include these results in your PDF report, e.g.<\/p>\n<p>Table 2. Annual Standard Deviation of Returns<\/p>\n<p>Company A Company B Market Index Std Dev of Returns<\/p>\n<p>6. Construct a scatter diagram graph that shows annual rates of return for the two companies on the Y-axis and the Market Index\u0092s returns on the X-axis (To make the graph, first select the range with the returns and the column heads, then click the chart wizard and choose the scatter diagram without connected lines. That will give you the data points. Use the drawing toolbar to make free-hand (\u0093by eye\u0094) regression lines. Make sure that information for the two companies is presented using different colors and include a legend that explains that.) Include the graph in your PDF report.<\/p>\n<p>Graph 1. Stock Returns vs. Market Index<\/p>\n<p>7. Calculate correlation for Company A and the Index, and Company B and the Index. Are they consistent<\/p>\n<p>with your graph? Include these results in your PDF report, e.g.<\/p>\n<p>Table 3. CorrelationFinance major ( Investment course )<\/p>\n<p>Read the requirements and make sure everything clear<\/p>\n<p>Company A: Intel Corporation<br \/>\nCompany b: American Express Group<\/p>\n<p>Must be done ASAP!!!<br \/>\nAfter you read and you feel comfortable, msg me<\/p>\n<p><center><a href=\"http:\/\/onlineclassesguru.com\/orders\/ordernow\"><img decoding=\"async\" src=\"https:\/\/encrypted-tbn0.gstatic.com\/images?q=tbn:ANd9GcTyj99p60XCLyLk1htB7-1neRt8-2QdnenNlQ&usqp=CAU\"target=\"_http:\/\/onlineclassesguru.com\/orders\/ordernow\"\/><\/center><p>","protected":false},"excerpt":{"rendered":"<p>Individual Stock Valuation Project This assignment will produce two documents both of which must be submitted via Moodle before the due date. Late submission will not be accepted. The documents are: \u2013 an Excel file where you perform all the calculations. Saved as YourName_ProjectCalculations.xlsx \u2013 a PDF report that will include summary results for your&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-6708","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Individual Stock Valuation Project - onlineclassesguru<\/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:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Individual Stock Valuation Project - onlineclassesguru\" \/>\n<meta property=\"og:description\" content=\"Individual Stock Valuation Project This assignment will produce two documents both of which must be submitted via Moodle before the due date. Late submission will not be accepted. The documents are: \u2013 an Excel file where you perform all the calculations. Saved as YourName_ProjectCalculations.xlsx \u2013 a PDF report that will include summary results for your...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/\" \/>\n<meta property=\"og:site_name\" content=\"onlineclassesguru\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-15T08:57:43+00:00\" \/>\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_admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineclassesguru.com\/#website\",\"url\":\"https:\/\/onlineclassesguru.com\/\",\"name\":\"onlineclassesguru\",\"description\":\"Cheap Professional coursework and reaction papers help\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineclassesguru.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/#webpage\",\"url\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/\",\"name\":\"Individual Stock Valuation Project - onlineclassesguru\",\"isPartOf\":{\"@id\":\"https:\/\/onlineclassesguru.com\/#website\"},\"datePublished\":\"2020-11-15T08:57:43+00:00\",\"dateModified\":\"2020-11-15T08:57:43+00:00\",\"author\":{\"@id\":\"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineclassesguru.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Individual Stock Valuation Project\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742\",\"name\":\"admin_admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/onlineclassesguru.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g\",\"caption\":\"admin_admin\"},\"url\":\"https:\/\/onlineclassesguru.com\/index.php\/author\/admin_admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Individual Stock Valuation Project - onlineclassesguru","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:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/","og_locale":"en_US","og_type":"article","og_title":"Individual Stock Valuation Project - onlineclassesguru","og_description":"Individual Stock Valuation Project This assignment will produce two documents both of which must be submitted via Moodle before the due date. Late submission will not be accepted. The documents are: \u2013 an Excel file where you perform all the calculations. Saved as YourName_ProjectCalculations.xlsx \u2013 a PDF report that will include summary results for your...","og_url":"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/","og_site_name":"onlineclassesguru","article_published_time":"2020-11-15T08:57:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin_admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/onlineclassesguru.com\/#website","url":"https:\/\/onlineclassesguru.com\/","name":"onlineclassesguru","description":"Cheap Professional coursework and reaction papers help","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineclassesguru.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/#webpage","url":"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/","name":"Individual Stock Valuation Project - onlineclassesguru","isPartOf":{"@id":"https:\/\/onlineclassesguru.com\/#website"},"datePublished":"2020-11-15T08:57:43+00:00","dateModified":"2020-11-15T08:57:43+00:00","author":{"@id":"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742"},"breadcrumb":{"@id":"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineclassesguru.com\/index.php\/2020\/11\/15\/individual-stock-valuation-project\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineclassesguru.com\/"},{"@type":"ListItem","position":2,"name":"Individual Stock Valuation Project"}]},{"@type":"Person","@id":"https:\/\/onlineclassesguru.com\/#\/schema\/person\/1831fa4d28e47b468621cf27932f5742","name":"admin_admin","image":{"@type":"ImageObject","@id":"https:\/\/onlineclassesguru.com\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429c8d043f7a770af242b0031e8b9f2b?s=96&d=mm&r=g","caption":"admin_admin"},"url":"https:\/\/onlineclassesguru.com\/index.php\/author\/admin_admin\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts\/6708"}],"collection":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/comments?post=6708"}],"version-history":[{"count":1,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts\/6708\/revisions"}],"predecessor-version":[{"id":6709,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/posts\/6708\/revisions\/6709"}],"wp:attachment":[{"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/media?parent=6708"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/categories?post=6708"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineclassesguru.com\/index.php\/wp-json\/wp\/v2\/tags?post=6708"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}