please complete the following task:
MAIN DETAILS:
1. Go to www.finance.yahoo.com and select your company
using ticker symbol. GE or SBUX in this example
2.
Then go to historical prices section and choose monthly stock price in the
range. Here I choose from 2005 to 2011
3.
Download monthly historical price into excel
4.
Here I calculate the return measure = (end - begin) / begin, Please careful for the date for your stock
price.
5.
Calculate average and standard deviation, also correlation coeffiecient using
financial fuction. CORR
6.
Then look at the Analyze section below to calculate portfolio return and
portfolio risk
7.
Draw Scatter (x-y) graph to see the relation between risk and return.
8.
Now you need to write a summery of your analysis. Thanks.
