Yahoo Finance Website 10 Years of Monthly Price Data Paper

Yahoo Finance Website 10 Years of Monthly Price Data Paper

Order ID: 89JHGSJE83839

Style: APA/MLA/Harvard/Chicago

Pages: 5-10

Instructions:

Yahoo Finance Website 10 Years of Monthly Price Data Paper

Question Description
calculate the data correctly.

Part 1: Individual stocks
Instructions
Using Yahoo’s finance website, download 10 years of monthly price data for two stocks and the S&P 500 (^GSPC).The stocks chosen must have at least 10 years of price data on Yahoo.
Perform the following for each stock and the S&P 500:
1) Compute monthly returns for all downloaded months
2) Compute the arithmetic mean of the monthly returns
3) Compute the geometric mean of the monthly returns
4) Annualize the geometric mean and arithmetic mean computed in 2) and 3) above
5) Compute the CWI over the 10-year time period
Perform the following for each stock:
1) Compute the return correlation with the S&P 500 using all 10 years of data
2) Compute the stock’s beta using all 10 years of data
3) Compute the beta using the first five (of the 10) years of data
4) Compute the beta using the last five (of the 10) years of data
5) Determine whether there was a shift in systematic risk over the 10 year period (write conclusion in one sentence)
Part 2: ETFs
Instructions
Using Yahoo’s finance website, download two years of monthly data for the following ETFs: 1) the S&P 500 (SPY), 2) a bond ETF of your choice, and 3) a foreign stock ETF of your choice.The chosen ETFs must have at least two years of price data on Yahoo.
Perform the following for each ETF:
1) Compute the correlation with the other ETFs.
2) Place the results in a correlation matrix (example below).
SPYBondForeign
SPY1.0
Bond0.501.0
Foreign0.750.651.0
How and What to Turn In
Put your name on your spreadsheets and email them to the instructor directly (stephen.ciccone@unh.edu) or through the Canvas messaging system.

Yahoo Finance Website 10 Years of Monthly Price Data Paper

RUBRIC
Excellent Quality 95-100%	Introduction 45-41 points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.		Literature Support 91-84  points The background and significance of the problem and a clear statement of the research purpose is provided. The search history is mentioned.			Methodology 58-53 points Content is well-organized with headings for each slide and bulleted lists to group related material as needed. Use of font, color, graphics, effects, etc. to enhance readability and presentation content is excellent. Length requirements of 10 slides/pages or less is met.
Average Score 50-85%	40-38 points More depth/detail for the background and significance is needed, or the research detail is not clear. No search history information is provided.		83-76  points Review of relevant theoretical literature is evident, but there is little integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are included. Summary of information presented is included. Conclusion may not contain a biblical integration.			52-49  points Content is somewhat organized, but no structure is apparent. The use of font, color, graphics, effects, etc. is occasionally detracting to the presentation content. Length requirements may not be met.
Poor Quality 0-45%	37-1 points The background and/or significance are missing. No search history information is provided.		75-1 points Review of relevant theoretical literature is evident, but there is no integration of studies into concepts related to problem. Review is partially focused and organized. Supporting and opposing research are not included in the summary of information presented. Conclusion does not contain a biblical integration.			48-1 points There is no clear or logical organizational structure. No logical sequence is apparent. The use of font, color, graphics, effects etc. is often detracting to the presentation content. Length requirements may not be met
You Can Also Place the Order at www.collegepaper.us/orders/ordernow or www.crucialessay.com/orders/ordernow Yahoo Finance Website 10 Years of Monthly Price Data Paper

Yahoo Finance Website 10 Years of Monthly Price Data Paper

PLACE THE ORDER WITH US TODAY AND GET A PERFECT SCORE!!!