Question: Calculate the expected return and return standard deviation for Stock B on p.5 in your handout4 in the module. It is Example 3. I would

Calculate the expected return and return standard deviation for Stock B

Calculate the expected return and return standard deviation for Stock B on p.5 in your handout4 in the module. It is Example 3. I would like you to work on your own before you check the answers in the notes.

Download historical month-end price from Jan. 2010 to Jan. 2022 for your favorite stock from finance.yahoo.com and save them in an Excel file. After you download the Excel, you only need to keep adjusted closing price. This is the price adjusted for dividend and stock splits. Calculate its risk and expected return. Remember to label your answers.

Following video 12, download historical month-end price from Jan. 2010 to Jan. 2023 SP500 index (Ticker: ^GSPC) finance.yahoo.com and save them in an Excel file. Keep adjusted closing price. calculate SP500, the market portfolio's risk and return. Label your answers.

The "download" button is not available on finance.yahoo. anymore. Here is how to download the data.

Highlight the data including the header for each column on finance.yahoo. page

Open Excel worksheet, click cell "A1" ==> right click your mouse, choose "paste special" ==> choose "Text"

Example 3: Find Mean and Variance for the Returns on stock B (U.S. Water)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

- Calculate the expected return and return standard deviation for Stock B on p.5 in your handout4 in the module. It is Example 3. I would like you to work on your own before you check the answers in...

Consider the following information on Stocks X and Y: State of Economy Probability of State of Economy Rate of Return if State Occurs Stock X Stock Y Recession 0.24 0.065 0.29 Normal 0.69 0.365 0.21...

You can use either Excel or manually calculate returns, standard deviations, covariance, and correlation coefficient using the formulas illustrated on Power Point slides. However, you need to show...

You can use either Excel or manually calculate returns, standard deviations, covariance, and correlation coefficient using the formulas illustrated on PowerPoint slides. However, you need to show the...

Please show work and formulas in Excel Based on the following data; State of the Economy Probability Stock A Rate of Return Recession 0.2 -5% Low Growth 0.3 10% Normal Growth 0.5 20% Calculate the...

Remaining Time: 42 minutes, 46 seconds. Question Completion Status: raup QUESTION 25 XYZ Inc. has an investment portfolio consisting of two stocks: Stock A (8% expected return and 4% standard...

Given the following information: State Probability Stock 1 Stock 2 Boom .25 5% 30% Normal .40 7% 18% Recession .35 11% -17% a. Calculate the expected return and the standard deviation for Stock 1 and...

G iven the following information : State Probability Stock 1 Stock 2 Boom . 2 5 5 % 3 0% Normal . 4 0 7 % 18 % Recession . 3 5 1 1 % -17 % a. Calculate the expected return and the standard deviation...

Company ABC has an investment in stock D and E. Stock E doesn't pay dividends while stock D pays dividends frequently. The prices of stock D and E for the last 5 years, also the dividend of stock D...

On December 1, Euphonia, a famous singer, contracted with Boito to sing at Boitos theater on December 31 for a fee of $25,000 to be paid immediately after the performance. (a) Euphonia, for value...

In the Edgeworth production box diagram, what conditions must hold for an allocation to be on the production contract curve? Why is a competitive equilibrium on the contract curve?

Question 3 3 ( 1 point ) When speed is important for FDI, investment is appropriate. new construction Greenfield portfolio mergers and acquisitions

Between institutional exchange and speculation, and asset the board at this scale, is alluded to as "discount finance". Organizations here broaden the items offered, with related exchanging, to...

Look at the cluster of high-performing stores. What do you think are some of the drivers for their good performance?

How many stores are missing benchmark data from 2016?

If management is interested in high-performing stores, where would they locate that cluster on this graph?