Homework_3_solutions

Homework_3_solutions - UNIVERSITY OF NORTH CAROLINA AT...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
U NIVERSITY OF N ORTH C AROLINA A T C HAPEL H ILL K ENAN -F LAGLER B USINESS S CHOOL B USI 408: C ORPORATE F INANCE S OLUTIONS TO A SSIGNMENT #3 P ROF . A RZU O ZOGUZ F ALL 2009 1. Go to http://finance.yahoo.com and download monthly stock prices for the following three stocks: Proctor and Gamble (PG) Apple Computer (AAPL) Caterpillar (CAT) a. Enter each ticker symbol at the top of the page. Then, click on “Historical Prices” on the left-hand side. Download monthly stock price data for each stock, starting in December 2001 and ending in December 2007. (Note that you can download data at many frequencies; make sure you download the monthly data). Then do the same for the S&P 500 index (ticker symbol ^GSPC) over the same period. b. Use the price data to calculate monthly returns from January 2002 through December 2007 for each stock. See attached spreadsheet. c. Compute the mean monthly return and standard deviation for the monthly returns of each stock. Convert the monthly statistics to annual statistics for easier interpretation (multiply the mean monthly return by 12, and multiply the monthly standard deviation by the square root of 12.) See attached spreadsheet. d. Consider four portfolios with the following weights: i. Equally-weighted ii. 30% in PG, 20% APPL, and 50% CAT iii. 50% in PG, 30% APPL, and 20% CAT iv. 20% in PG, 50% APPL and 30% CAT Compute the expected return and volatility for each portfolio. See attached spreadsheet. e. Plot the three stocks, the S&P index and the four portfolios in part (d) on the return-volatility space, with volatility on the x-axis and the average return on the y-axis. Compare the eight investment opportunities. Can you recommend buying (or not buying) any of these investments?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
f. Using Excel regression analysis, run a regression of each stock’s monthly returns on the ‘market’ (S&P 500) returns to estimate each stock’s beta. ߚ ஼஺் ൌ1 .30 ߚ ஺஺௉௅ ൌ1 .47 ߚ ௉ீ ൌ0
Background image of page 2
PG Beta Estimation g. Using your best estimates for the current risk-free rate and the historical market risk premium, calculate each stock’s required rate of return on equity based on its beta. Let ݎ ൌ3 .5% . This is the current yield on the 10-year Treasury note. Coming up with the market risk premium is trickier. Let ܧሺܴ ሻെݎ 5%. This is a conservative estimate. ܧሺܴ ஼஺் ሻൌݎ ൅ߚ ஼஺் ൣܧ൫ܴ െݎ ൯൧ ൌ 3.5% ൅ 1.30 ൈ 5% ൌ 10% ܧሺܴ ஺௉௉௅ ሻൌݎ ൅ߚ ஺஺௉௅ ൣܧ൫ܴ െݎ
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ܧሺܴ ௉ீ ሻൌݎ ൅ߚ ௉ீ ൣܧ൫ܴ െݎ ൯൧ ൌ 3.5% ൅ 0.19 ൈ 5% ൌ 4.45% 2. Roulette wheels are typically marked with the numbers 1 through 36 plus 0 and 00. Each of these outcomes is equally likely every time the wheel is spun. If you place a bet on any one number and are correct, the payoff is 35:1; that
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 11/04/2011 for the course BUSI 408 at UNC.

Page1 / 15

Homework_3_solutions - UNIVERSITY OF NORTH CAROLINA AT...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online