Reference no: EM1352169
Please advise how to set up these problems in Excel. I am unsure of the Excel functions required to solve the equations for equity cost of capital.
12-2. Suppose the market portfolio has an expected return of 10% and a volatility of 20%, while Microsoftâ??s stock has a volatility of 30%.
a. Given its higher volatility, should we expect Microsoft to have an equity cost of capital that is higher than 10%?
b. What would have to be true for Microsoft's equity cost of capital to be equal to 10%?
12-5. Suppose all possible investment opportunities in the world are limited to the five stocks listed in the table below. What does the market portfolio consist of (what are the portfolio weights)?
Using the above data, suppose you are holding a market portfolio, and have invested $12,000 in Stock C.
a. How much have you invested in Stock A?
b. How many shares of Stock B do you hold?
c. If the price of Stock C suddenly drops to $4 per share, what trades would you need to make to maintain a market portfolio?
13-2. Assume that the CAPM is a good description of stock price returns. The market expected return is 7% with 10% volatility and the risk-free rate is 3%. New news arrives that does not change any of these numbers but it does change the expected return of the following stocks:
a. At current market prices, which stocks represent buying opportunities?
b. On which stocks should you put a sell order in
Hint: calculate the returns using CAPM, campare them with the expected returns here, get the alphas.
13-8. Why does the CAPM imply that investors should trade very rarely?
|
Explain organizational change
: Recall extensive change you have witnessed recently inside your company or a company you are familiar with.
|
|
Explain some alternatives to which people have resorted
: In countries where the monetary system has broken down Explain some alternatives to which people have resorted to carry out exchange?
|
|
Elucidate what is the size of the gdp gap
: Assume that equilibrium real GDP is 800 billion, potential gdp is 900 billion, the mpc is .80, and the mpi is .40 . What is the size of the GDP gap.
|
|
How much energy would be available by fusion
: Water is in the big beaker in the figure on the left. Scale 1 reads 96 newtons, scale 2 reads 531 newtons, and scale 3 reads 0 newtons. The hanging block has a density of 10 × 10^3 kg/m3. To nearest tenth of a newton what does scale 1 read after t..
|
|
Calculate the returns using capm
: Assume the market portfolio has an expected return of 10% and a volatility of 20 percent, while Microsoft's stock has a volatility of 30 percent.
|
|
Opinions with regard to contingency fees
: What do you think would be on of the things that is argued for, and against, contingency fees in general and what are your own opinions with regard to contingency fees?
|
|
Introduction to multiple siblings
: I noticed that all of you that have responded so far have multiple siblings. There has been a tremendous amount of research that discusses the traits of individuals and how that is related to the birth order
|
|
How to deal with an employee wearing provocative clothing
: How would you deal with a situation like that where the employee wears the right colors/type of clothes, but they're still provocative and inappropriate?
|
|
How high does she rise during this interval
: An 8.m, 220 N uniform ladder rests against a smooth wall. The coefficient of static friction between the ladder and the ground is 0.75, and the ladder makes a 50° angle with the ground. How far up the ladder can an 770 N person climb before the la..
|