Finance for Executives

Please answer the problems in Excel and submit the Excel spreadsheet. A template Excel file “Finance for Executives – Problem Set #3” that contains the relevant data is provided for your convenience.

1. Assume the risk-free rate is 2% (rf = 2%), the expected return on the market portfolio is 6% (rM = 6%) and the standard deviation of the return on the market portfolio is 15% (σM = 15%). (All numbers are annual.) Assume the CAPM holds.

 

1. What are the expected returns on securities with the following betas:

• β = 1.4
• β = 0.6
• β = -0.2

 

1. What are the betas of securities with the following expected returns:

• 10%
• 5%
• -1%

 

1. What are the portfolio weights (in the risk-free asset and the market portfolio) for efficient portfolios (portfolios on the efficient frontier/CML) with expected returns of

• 4%
• 5%
• 7%

 

1. What are the portfolio weights (in the risk-free asset and the market portfolio) for efficient portfolios (portfolios on the efficient frontier/CML) with standard deviations of

• 6%
• 15%
• 21%

 

1. For a moment (but just a moment) assume that the CAPM may not hold. A non-dividend paying stock has a current price of $50/share and an expected price in 1 year of $53/share (based on your personal analysis of the company’s prospects).

• If the stock has a beta of 1 (β = 1.0), what is its alpha (α)?
• What is the alpha (α) if the beta is 2 (β = 2.0)?

 

2. Assume that there are 3 firms in an industry for which you wish to compute an industry beta. The betas of these 3 firms are 1.1, 1.2, and 1.4.
   1. What is the beta of an equal-weighted portfolio of the 3 firms?
   2. If the market capitalizations of the 3 firms are $100 million (beta 1.1), $200 million (beta 1.2), $300 million (beta 1.4), what is the beta of a market capitalization, value-weighted industry portfolio?

 

 

 

 

3. Consider a firm with two equally sized divisions (in terms of their value) that engage in completely different lines of business with different risks.
4. If these 2 divisions have betas of 0.8 and 1.3, what is the beta of the firm?
5. If one division has a beta of 0.8, and the beta of the firm is 1.0, what is the beta of the second division?
6. For the firm in part (b), what beta should be used to compute the cost of capital for the low risk division, i.e., should it be the firm beta (1.0) or the divisional beta (0.8)?

 

4. The spreadsheet contains 60 months of monthly data on the excess returns on 3M (the maker of Post-it Notes among many other things) and the US stock market. Run a linear regression (SCL regression) of the returns on 3M on the returns on the market portfolio, using the regression tool in Excel. (There is a video and associated Excel file illustrating how to do this using data on Apple. Put the regression results elsewhere in the spreadsheet, and put references to the cells with the correct answers in the highlighted cells.)
5. What is 3M’s beta from this regression?
6. What is 3M’s monthly alpha?
7. What percentage of 3M’s total risk (variance) is systematic?

 

5. XYZ Inc. has expected earnings over the next year of $2/share (E1 = 2). The company is expected to maintain an earnings retention rate of 40% (b = 0.4), i.e., 60% of earnings are expected to be paid out as dividends every year. The company has a beta of 2, the risk-free rate is 2% (rf = 2%), and the market risk premium is 4% (rM-rf = 4%).
6. If the growth rate in earnings is expected to be 4% in perpetuity
   • What is the value of the stock?
   • What is the expected return over the next year?
7. If the current price of the stock is $16/share, what is the implied growth rate of earnings (and dividends)?

 

6. XYZ Inc. is expected to pay no dividends for the next 5 years. However, at the end of the sixth year (at time 6), the company is expected to pay a dividend of $1/share. Dividends are expected to grow at 10% per year for the following 9 years (through the end of the 15th year, i.e., time 15), then to grow at 3% every year thereafter (forever). Assume the appropriate discount rate (required return) is 6%.
7. What is the expected value of the stock at time 15 (not including the time 15 dividend)?
8. What is the expected value of the stock at time 5?
9. What is the value of the stock today?

 

7. Assume the risk-free rate is 2% (rf = 2%), the expected return on the market portfolio is 6% (rM = 6%) and the standard deviation of the return on the market portfolio is 15% (σM = 15%). Assume the CAPM holds. A stock with a beta of 1 has a return standard deviation (volatility) of 30%.
   1. What is the standard deviation (volatility) of the systematic component of the stock’s return?
   2. What is the standard deviation (volatility) of the idiosyncratic component of the stock’s return?
   3. What percentage of the stock’s return variance is systematic?

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."

"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"