Question: I need help with question 6 that is shown in the excel. Excel File Edit View Insert Format Tools Data Window Help 39% O Thu

I need help with question 6 that is shown in the excel.
Excel File Edit View Insert Format Tools Data Window Help 39% O Thu 8:24 AM a FIN3312-summer2020-Ch567-stu Q Search Sheet Home Insert Page Layout Formulas Data Review View + Share Cut Arial 11 AutoSum A- A General Wrap Text X 49 Copy Fill Paste BI U - A - Merge & Center $ %) +.0 .00 .00 0 Insert Delete Format Format Conditional Format Formatting as Table Cell Styles Clear Sort & Filter E91 fc A B D E F G H J K L M N 0 P - Q R What makes this CAL combination better than the frontier portfolio? Be specific! 43 44 45 46 47 48 49 50 51 6) 52 Use the data below and CAPM to fill in the E[r] column, and then draw the SML. Show a formula to show where your E[r]'s came from! (10 points) 53 E[rmkt] 0.085 rf 0.015 B E[r] 54 55 56 57 58 59 60 0.00 0.20 0.40 0.60 0.80 1.00 1.20 1.40 1.50 61 62 63 64 65 66 67 68 69 70 7) 71 72 73 74 Here are 3 betas (B): (10 points) EXPLAIN each of your selections!! B 75 76 Identify which one is the beta for Proctor & Gamble, which is the beta for SPY, and which is the beta for Citigroup beta is Explanation: for: 0.402 bookch6 Sheet1 + Ready + 134%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
