Hello, Can somebody help me with this?

Thanks!

1. Choose 18 companies traded on the NYSE.
2. For each stock, find the monthly closing prices for 61 months. The ending date will be the beginning of this month of this year and the beginning of the period will be 61 months ago.. These data are easily found at Yahoo! Finance . In Yahoo Finance enter a companys stock symbol in the search field. Once you arrive at the companys Summary page, click on the Historical Data link. Enter the required date range (Your 61 months) and ensure that you have selected monthly then click on Apply. Click on Download Data. Copy and paste information in the Date and Adj. Close columns into the appropriate columns on the worksheet in the workbook I have provided you (see Format below). When you paste, chose the 123 option. The other data columns are not needed]. Sort these data from oldest to newest. Ensure that you provide the name of the company and its stock symbol in the appropriate cells at the top of the worksheet.

1. Find the average realized rate of rate of return (r_s) over 60 months for each stock. (That is why you need 61 monthly stock prices) Do this by computing the realized return for each month then finding the average of all 60 monthly returns. The return for each month is found by using the equation: (Ending Price Beginning Price) / Beginning Price.
2. Translate the average monthly realized return to an annualized realized return by multiplying the number you arrived at in part a. by 12.

1. Find the standard deviation (s) for the 60 monthly realized returns. Use the standard deviation function to do this.
2. Translate this number into an annualized standard deviation by multiplying it by the square root of 12 (use the SQRT function).

5. Compute the coefficient of variation for each stock using average annualized realized returns from 3b. and the annualized ss from 4b. above.

File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial 8 | A == Wrap Text General LI Insert 9X Delete W 47 0 5 Paste BIU Ideas Av $ -% - Merge & Center Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity E10 for Q R S D F G H 1 J K L M N O 1 (Lay out Example. You can do a sheet per company or copy the columns and do it in one work sheet Remember to calcualte your monthly returns using (P2-P1)/P1 2 3 Diamond Jim's Enterprises Symbol: 4 Task 2 Task 3a Task 3b Task 4a Task 4b Task 5 5 Adjusted Monthly Ave. Ave. o (Monthly 6 Date Close Returns Monthly Annual Rtns) (Annualized) 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 DJims Task Task 7 Data (4 Stocks) Task 7 Chart (4 Stocks) Tasks 88-9 Task 10 + File Home Insert Page Layout Formulas Data Review View Help Share Comments Arial 8 | A == Wrap Text General LI Insert 9X Delete W 47 0 5 Paste BIU Ideas Av $ -% - Merge & Center Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing Ideas Sensitivity E10 for Q R S D F G H 1 J K L M N O 1 (Lay out Example. You can do a sheet per company or copy the columns and do it in one work sheet Remember to calcualte your monthly returns using (P2-P1)/P1 2 3 Diamond Jim's Enterprises Symbol: 4 Task 2 Task 3a Task 3b Task 4a Task 4b Task 5 5 Adjusted Monthly Ave. Ave. o (Monthly 6 Date Close Returns Monthly Annual Rtns) (Annualized) 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 DJims Task Task 7 Data (4 Stocks) Task 7 Chart (4 Stocks) Tasks 88-9 Task 10 +