Answered You can hire a professional tutor to get the answer.
Demonstrate to your colleagues how you would calculate the expected rate of return,, also called r-hat, and Beta on a self-designed portfolio of four...
Demonstrate to your colleagues how you would calculate the expected rate of return,, also called r-hat, and Beta on a self-designed portfolio of four common stocks selected from the NASDAQ or NYSE stock exchanges. Assume the weighting of the portfolio to be 15%, 30%, 35%, 20%. a.)Explain how to calculate the standard deviation for each stock in your portfolio using the monthly close stock price (show your calculations using Excel if possible). b.)What is the Beta Coefficient (this is given in Yahoo) of each stock and the Beta of your portfolio c.)What does beta mean to you and your selection of stocks compared to your colleagues?
NameTime WarnerPepsi CoWalmartNike Exp Price date(p1) Symbol $40.00$75.00$80.00$90.00$285.00 TWXPEPWMTNKE Price today's date close (p0) $30.28$64.73$50.88$69.84$215.73 Expected...