2.1. Expected Rate of Return of ATT Stock = ? Probability of Return* Expected Return
=0.2* 12% + 0.2* 6% - 0.2* 10% + 0.2* 22% + 0.2*5%
=7%
Q2. Variance= ? ((Mean Expected Return-Expected Return)^2)/Population Size
Mean Expected Return = (12+6-10+22+5)/5 =7%
Popultion Size=5
Therefore, Variance of ATT Common Stock Return = ((7-12)^2 + (7-6)^2 + (7-(-10))^2 +(7-22)^2+ (7-5)^2)/5
=108.8
Please provide formula and process for solving 2.1 and 2.2 . NO EXCEL using please! Thank...
Please show work that is not on excel please. Thank you. Consider the following information 30. Systematic versus Unsystematic Risk. on Stocks I and II: Probability of State of Economy State of Rate of Return If State Occurs Economy Stock I Stock ll Recession 25 -.20 .02 Normal .12 60 .32 Irrational exuberance .40 .15 .18 00B 0 The market risk premium is 7 percent, and the risk-free rate is 4 percent. Which stock has the most systematic risk? Which...
Please show work that is not on excel please. Thank you. Рото 30. Systematic versus Unsystematic Risk. Consider the following information on Stocks I and II: State of Economy Probability of State of Economy Rate of Return If State Occurs Stock Stock II .25 .02 -.20 Recession Normal Irrational exuberance .60 .32 1.18 . 15 The market risk premium is 7 percent, and the risk-free rate is 4 perc Which stock has the most systematic risk? Which one has the...
Please show work that is not on excel please. Thank you. CHAPTER 11 Risk and Retur 6. Calculating Expecte bleulating Expected Return. Based on the following information, calculate the expected return. State of Economy Probability of State of Economy Rate of Return If State Occurs Recession Normal Boom .15 .60 .25 -.09 .11 .30 Calculating Returns and
Please do problem using excel 14 Based on the following data; 15 State of the Economy Rate of Return 16 Probablility Stock A Rate of Return Stock 6 % 17 Recession 0.2 20% 12%% Normal Growth 0.65 20% 18 50% 0.15 16% 19 Boom 20 calculate the expected return and the standard deviation of returns for each stock. 21 22 b) calculate the expected return and the standard deviation on the portfolio, where the portfolio is formed by investing 50%...
please provide assistance with the following as well as step by step instruction question 4 your portfolio is invested 30% each in A and C, and 40% in B what us the expected return if the portfolio? Also what is the variance of this portfolio? the standard deviation. pleas give steps and calculation 3. Returns and Variances [LOI] Consider the following information: Rate of Return If Probability of State of State of State Occurs Economy Economy Stock Stock Stock A...
no excel work. please provide formula. You have done your research for the following investments and your friend has provided their expectations for the markets for next year. Probability of State of State of Stock Stock Economy Economy A B TSX Boom .30 30% -9% 18% Normal .40 16% 12% 10% Recession .30 -10% 20% -10% Remember to show all of your work * e. Calculate the risk for stock B. (2 marks) f. Calculate the risk for the TSX....
Please, solve it with the formula in Excel. Thank you 3 The ACME Toy Company has the following information. Computer the cost of capital for each. a. It has $1,000 par value bond with a 9% annual coupon rate and a 20 year maturity. The investors require a 11% rate of return. Compute the market value of the bonds and the after-tax cost if the tax rate is 21% and you can buy the bond for $1,100 3 b. ACME's...
State of Economy Probability of State of Economy Rate of Return If State Occurs Stock K Stock M Boom 0.10 25% 18% Growth 0.20 10% 20% Normal 0.50 15% 4% Recession 0.20 -12% 0% An individual plans to invest $5,000: $3,000 in Stock K and $2,000 in Stock M. What are the stock weights for this portfolio? (wK = 60%, wM = 40%) Using the weights computed in Part a, what is the expected return for the portfolio? (E(Rp) =...
Please Kindly Show Step By Step Using EXCEL Formula Thank you Sheridan, Inc., paid a dividend of $4.27 last year. The company's management does not expect to increase its dividend in the foreseeable future. If the required rate of return is 12.5 percent, what is the current value of the stock? (Round answer to 2 decimal places, e.g. 15.25.) Current value
in an excel format, can you please solve the following! thanks! Calculate the weighted Average Cost of Capital Given Rate Below (60 points) Show Work Cost of Capital Weighted Average Bonds Preferred Stock Internal Equity Common Stock % of Equity 25.00% 10.00% 10.00% 55.00% Remember Flotation Costs and Taxes Par Value Market Price Flotation Costs Coupon Rate Maturity $1.001.00 $1.100.00 S100.00 X% 10 years Tax Rate 30.01% Preferred Stock Remember Flotation Costs Dividend Selling Price Flotation Costs $6.00 S85 0...