please solve the following( please solve the excel problem using excel referance with the excel formula) example (=D3,F6...)
The spreadshect below has data on Microsoft and the SEP 500 from 1986 to 2006. Compleve the styps below using cell references to giwn dala or previous calculations. In some cases, a simple cell neference is all you need. To copplpaste a formula across a row or down a column, an absolute cell neference or a mixnd cell neference may be preferred. If a apreific Excel finction is to be used, the directions will spectfy the use of that finction. Do nor oppe in numerical data into a cell or function. In itead, mater a dincted, net the earliest apprarance of the data in your formulax, wasally the Given Data section. 2. Estimate Microsof's beta using linear regression over the periods 1987-1991, 1992-1996, 1997-2001, and 2002-2006. b. Compare the four estimated betas. What do you conclude about how Microsof's exposure to systematic risk changed over that 20 -year period" whit do you th ink explitits the change? a. Estimate Microsoft's beta using linear regression over the periods 1987-1991, 1992-1996, 1997-2001, and 2002-2006. Beta 1987.1991 Beta 1992-1996 Beta 19972001 Beta 20022006 b. Compare the four estimated betas, What do you conclude about how Microsof's exposure to systematic risk changed over that 20 -year period? What do you thiak explains the change? Systematic Risk Systematic Risk 5y)iematie Rist in the early 1990 's as Microsof established itself as a dominant company. during the internet bubble in the late 1990 's (when tech stocks roared). since the carly 2000K. 1 In eell E10, by using cell references, calculate the beta of Microsoft slock for the time period 1987-1991 (1 pt.) Notes. (1) Use the SLOPE function with the SRP 500 as the known x 's and Micronoft as the known yL (2) Do not absolute or mix oell references. 2 In cell E11, by using cell references, ealeulate the beta of Microson stock for the time period 1992-1996 (I pt.). Notes: (1) Use the SL.OPF function with the SAP 500 as the known x 's and Microsof as the known y 's. (2) Do not absolate or mix eell references. 3 In cell E12, by using cell references, calculate the beta of Microsoft stock for the time period 1997-2001 (1 pt.). Netes: (1) Une the SLOPE function with the SEP 500 as the knows x 's and Microsoft as the known y s. (2) Do not absolute or mix cell references. 4 In cell E13, by using cell references, calculate the beta of Microsoft stock for the time period 2002-2006 (1 pt). Notes: (1) Uic the St.OPE function with the SEP 500 as the known x s and Mictosoft as the known y. (2) De not absolute of mix cell references. You bought a stock one year ago for $48.54 per share and sold it today for $57.31 per share. It paid a $1.15 per share dividend today. How much of the return came from dividend yield and how much came from capital gain? The return that came from dividend yield is %. (Round to one decimal place.)
