If you are able to provide steps on how to complete these two, that would be greatly appreciated

^ 6 5 E AutoSave O OFF Excel Exam 01_BUS 5590 Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 A A ab General Paste B IUV 1-4- A $ ~ % " C A20 X V fx A B C D E F G H K M Price: 167 Date Dividends 12/15/16 0.47 3/13/17 D.47 6/13/17 D.47 9/14/17 0.47 12/14/17 0.52 3/14/18 0.52 6/14/18 0.52 9/13/18 0.52 12/13/18 0.57 3/14/19 0.57 6/13/19 0.57 9/12/19 0.57Home Insert Draw Page Layout Formulas Data Review View X Calibri (Body) 11 General Conditional Formatting Format as Table v Paste BI U A $ 9 Cell Styles v B10 X V fx '2. Using data in the sheet "CAPM Regression" and "Market Environment," what is the expected 1-year stock return? A B D E F G H M BUS 5590: Investment Management Additional Questions: 1. Using data in the sheet "Dividends" what is the expected 1-year stock return? Expected 1-Yr Return: Show all work in Excel 10 2. Using data in the sheet ICAPM Regression"and "Market Environment, "what is the expected 1-year stock return? 11 Expected 1-Yr Return: 12 Show all work in Excel 13 14 15 Additional Questions Dividends CAPM Regression Market Environment +O n 4 5 0 AutoSave OFF *3 Excel Exam 01_BUS 5590 Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 11 A A = ib General Conditional Formatting v Insert Format as Table v Ex Delete Paste BIUY Y A += $ ~ % " Cell Styles v Format A1 X fx A B C D E F G H K L M CAPM Regression Results Regression Statistics Multiple R 0.561508468 R Square 0.31529176 Adjusted R Square 0.313680682 Standard Error 0.012108825 Observations 427 ANOVA of MS F Significance F Regression 1 0.028694591 0.028695 195.7023 7.60121E-37 15 Residual 425 0.062315053 0.000147 Total 426 0.091009643 Coefficients Standard Error t Stat P-value Lower 95%% Upper 95% Lower 95.0% Upper 95.0% 19 Alpha 0.001280677 0.000586106 2.185061 0.02943 0.00012865 0.002432704 0.00012865 0.002432704 20 Beta 0.824724923 0.058953707 13.98936 7.6E-37 0.708847789 0.940602058 0.708847789 0.940602058 22 23 24 25 26O Ah n UE AutoSave OFF Excel Exam 01_BUS 5590 Home Insert Draw Page Layout Formulas Data Review View Li Calibri (Body) 11 A General Condition Format a Paste BI UY A v $ ~ % " Cell Style B1 X v fx A B C D E F G H K L SP500 Market Environment Environment Probability Return Volatility Recession D.25 0.08 D.25 Normal 0.50 0.10 0.20 Growth 0.25 0.30 0.30 10