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:
– an Excel file where you perform all the calculations. Saved as YourName_ProjectCalculations.xlsx – a PDF report that will include summary results for your calculations as well as your discussion of these
results (every table & 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
All material turned in are considered business documents. Errors and/or sloppy work will result in loss of points.
The first page of your report should include the followings: title of the case, course number, term, students name, instructors 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.
Project description and steps
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
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
Index, and then calculate average returns over the five-year period. Include these results in your PDF report, e.g.
Table 1. Annual rates of return
Years Company A Company B Market Index 2018 2017 2016 2015 2014 Average
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.
Table 2. Annual Standard Deviation of Returns
Company A Company B Market Index Std Dev of Returns
6. Construct a scatter diagram graph that shows annual rates of return for the two companies on the Y-axis and the Market Indexs 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 (by eye) 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.
Graph 1. Stock Returns vs. Market Index
7. Calculate correlation for Company A and the Index, and Company B and the Index. Are they consistent
with your graph? Include these results in your PDF report, e.g.
Table 3. CorrelationFinance major ( Investment course )
Read the requirements and make sure everything clear
Company A: Intel Corporation
Company b: American Express Group
Must be done ASAP!!!
After you read and you feel comfortable, msg me
Leave a Reply