# Question: Although not absolutely necessary you are advised to use a

Although not absolutely necessary, you are advised to use a computer spreadsheet to work the following problem.

a. Use the price data from the table that follows for the Standard & Poor’s 500 Index, Wal-mart, and Target to calculate the holding- period returns for the 24 months from July 2010 through June 2012.

b. Calculate the average monthly holding- period returns and the standard deviation of these returns for the S& P 500 Index, Wal-mart, and Target.

c. Plot (1) the holding- period returns for Wal-mart against the Standard & Poor’s 500 Index, and (2) the Target holding- period returns against the Standard & Poor’s 500 Index. (Use Figure 6- 5 as the format for your graph.)

d. From your graphs in part (c), describe the nature of the relationship between the stock returns for Walmart and the returns for the S& P 500 Index. Make the same comparison for Target.

e. Assume that you have decided to invest one- half of your money in Wal-mart and the remainder in Target. Calculate the monthly holding- period returns for your two- stock port-folio.

f. Plot the returns of your two- stock portfolio against the Standard & Poor’s 500 Index as you did for the individual stocks in part (c). How does this graph compare to the graphs for the individual stocks? Explain the difference.

g. The following table shows the returns on an annualized basis that were realized from holding long- term government bonds for the same period. Calculate the average monthly holding- period returns and the standard deviations of these returns.

h. Now assuming that you have decided to invest equal amounts of money in Wal-mart, Target, and long- term government securities, calculate the monthly returns for your three-asset portfolio. What is the average return and the standard deviation?

i. Make a comparison of the average returns and the standard deviations for all the individual assets and the two portfolios that we designed. What conclusions can be reached by your comparison?

j. According to Standard & Poor’s, the betas for Wal-mart and Target are 0.45 and 0.60, respectively. Compare the meaning of these betas relative to the standard deviations calculated above.

k. Assume that the current Treasury bill rate is 3 percent and that the expected market return is 10 percent. Given the betas for Wal-mart and Target in part (j), estimate an appropriate rate of return for the two firms.

a. Use the price data from the table that follows for the Standard & Poor’s 500 Index, Wal-mart, and Target to calculate the holding- period returns for the 24 months from July 2010 through June 2012.

b. Calculate the average monthly holding- period returns and the standard deviation of these returns for the S& P 500 Index, Wal-mart, and Target.

c. Plot (1) the holding- period returns for Wal-mart against the Standard & Poor’s 500 Index, and (2) the Target holding- period returns against the Standard & Poor’s 500 Index. (Use Figure 6- 5 as the format for your graph.)

d. From your graphs in part (c), describe the nature of the relationship between the stock returns for Walmart and the returns for the S& P 500 Index. Make the same comparison for Target.

e. Assume that you have decided to invest one- half of your money in Wal-mart and the remainder in Target. Calculate the monthly holding- period returns for your two- stock port-folio.

f. Plot the returns of your two- stock portfolio against the Standard & Poor’s 500 Index as you did for the individual stocks in part (c). How does this graph compare to the graphs for the individual stocks? Explain the difference.

g. The following table shows the returns on an annualized basis that were realized from holding long- term government bonds for the same period. Calculate the average monthly holding- period returns and the standard deviations of these returns.

h. Now assuming that you have decided to invest equal amounts of money in Wal-mart, Target, and long- term government securities, calculate the monthly returns for your three-asset portfolio. What is the average return and the standard deviation?

i. Make a comparison of the average returns and the standard deviations for all the individual assets and the two portfolios that we designed. What conclusions can be reached by your comparison?

j. According to Standard & Poor’s, the betas for Wal-mart and Target are 0.45 and 0.60, respectively. Compare the meaning of these betas relative to the standard deviations calculated above.

k. Assume that the current Treasury bill rate is 3 percent and that the expected market return is 10 percent. Given the betas for Wal-mart and Target in part (j), estimate an appropriate rate of return for the two firms.

**View Solution:**## Answer to relevant Questions

Distinguish between debentures and mortgage bonds. Trico bonds have an annual coupon rate of 8 percent and a par value of $ 1,000 and will mature in 20 years. If you require a return of 7 percent, what price would you be willing to pay for the bond? What happens if you pay ...You own a bond that has a par value of $ 1,000 and matures in 5 years. It pays a 5 percent annual coupon rate. The bond currently sells for $ 1,100. What is the bond’s expected rate of return? Assume you own a bond with a market value of $ 820 that matures in 7 years. The par value of the bond is $ 1,000. Interest payments of $ 30 are paid semiannually. What is your expected rate of return on the bond? National Steel 15- year, $ 1,000 par value bonds pay 5.5 percent interest annually. The market price of the bonds is $ 1,085, and your required rate of return is 7 percent. a. Compute the bond’s expected rate of return. b. ...Post your question