Question
Please provide formula and process for solving 2.1 and 2.2 . NO EXCEL using please! Thank u!
Qustion2 Suppose the following information represents possible future returns for ATT stock next year: State of Economy Probability of state of Rate of return if state occurs 20 20 10% 20 1.00 (2.1) What is the expected rate of return for ATT common stock? (10 points) 22) What s the variance of the retum for ATT common stock? C0 pointy) ニ0. 2.10.1) + 04°-w、+1.25+ oos*) 0.2x(0.12-0
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

Add a comment
Know the answer?
Add Answer to:
Please provide formula and process for solving 2.1 and 2.2 . NO EXCEL using please! Thank...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please show work that is not on excel please. Thank you. Consider the following information 30....

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT