Risk and Return Homework FIN 331

What is the expected return on an investment with the following probable payoffs?

Probability Payoff

15% 30.0%

55% 5.0%

30% - 2.0%

You are an average risk-averse investor considering the purchase of three stocks. Which should you purchase and why?

Stock Expected Return Standard Deviation

A 6.0% 4.0%

B 18.0% 12.0%

C 12.0% 7.0%

The risk-free rate of return is currently 2%. The expected return on the market is 8%. You are analyzing a stock with a beta of 1.05. What is the required rate of return on this stock using the CAPM approach?

The current risk-free rate is 3.5%. The market risk premium is 7%. Techno Electronics, with a beta coefficient of 0.9, is currently selling for $28 per share. The company is expected to grow at 4% constantly forever. The last dividend paid to stockholders was $1.75 per share. Is Techno Electronics stock correctly priced? Explain.

Risk and Return Excel Assignment

Go to finance.yahoo.com. You should see a quote lookup box on right side. In this box, enter the ticker symbol for Microsoft which is MSFT. Then after the information for the company comes up you will be able to select historical data. This tab will allow you to download historical pricing information. Enter the start date and ending dates January 2, 2017 through January 2, 2018 in the appropriate box. Select daily to get daily data then press apply. Then select to download to spreadsheet which will download the information to an Excel spreadsheet.

Do the same process for NFLX, Netflix. Then again do the same for ^DJI to pull up the data for the Dow Jones Industrial Average which represents the market index.

You want to work with the adjusted closing price column for each of the stocks and stock index. You can copy that one column from NFLX and from the DJI into the Microsoft worksheet, so you can easily copy the equations.

You need the daily returns for all three stock columns. To get these values, you will take the:

(adjusted close for one day adjusted close for the previous day)/adjusted close for the previous day.