Good afternoon! I am in MBA615 and working on UNIT5's homework and I'm stuck on question 6. Please provide the breakdown. I've attached as many files as I could. Please provide the ANSWER and step-by step instructions. THAAAANK YOU VERY MUCH IN ADVANCE FOR ALL YOUR HELP!

MBA615_Unit 5 HOMEWORK.xIsx Search Esther Colvin EC X File Home Insert Draw Page Layout Formulas Data Review View Help ProjectWise Acrobat Share Comments OC is i Get Add-ins h? e or Q PivotTable Recommended Table Illustrations My Add-ins Recommended Maps PivotChart 3D Line Column Win/ Slicer Timeline Link Comment Text Symbols PivotTables Charts Map v Loss Tables Add-ins Charts Tours Sparklines Filters Links Comments AutoSave . Off) J6 AC AD AE A AF AG AH Al AJ AK 35 30- 20- Probability 15- 5- -30%% return 8-5% return :30%% return Given that: The one-year return distribution for RCS Stock, Calulate: expected return, first we need to determine the weighted return of each component of RCS Stock. FORMULA = E[R]= EIRI's the expectation of return /7 and pR is the probability of the F R Var(R)= E[R - E[R] ]=EPAX (R - E[R])? Var(R)= (-0.30 x 0. 10)+(-0.05 x 0.20)+(0.00 x 0. 15)+(0.05 x 0.25)+(0.30 x 0.30) (P] Probability from chart in decimal form Return (P X) Expected Return P" (x - mean)2 0.1 -30% -0.03 -0.01 0.0%% 0.25 0.05 5% 0.0125 03 0.3 30%% E[R]= (-0.30 x 0. 10)+(-0.05 x 0.20)+(0.00 x 0. 15)+(0.05 x 0.25)+(0.30 .25% standard deviation is the square root of the variance: SO (R) = WVar (R) SO (R) = 0.015310 ## ### -EXAMPLE Jousted the weighted return for each stock component as Return ' Probability (GIVEN) Therefore, Expected Return = al. Expected Return = =1 [Probability(i] * Return(i]] = [0. 10* -30%%]+ [0.20' -5%] + [0.15 ' 0%]+ [0.25 ' 5%] + [0.30* 30%%] MBA615_Unit 5, Q3 MBA615_Unit5, Q4 MBA615_Unit5, Q5 MBA615_Unit5, Q6 MBA615_Unit5, Q7 + 1 4 Select destination and press ENTER or choose Paste " - -I + 40%Do Homework - Unit 5 Homework - Google Chrome 0 X mathxl.com/Student/PlayerHomework.aspx?homeworkld=616008237&questionld=6&flushed=false&cld=6794448¢erwin=yes MBA615DLS1P2022 Managerial Finance Esther Marie Colvin 01/19/22 2:34 PM ? Homework: Unit 5 Question 6, P10-1 HW Score: 50%, 10 E (similar to) of 20 points Homework Part 1 of 2 O Points: 0 of 2 Save The figure in the popup window, , shows the one-year return distribution for RCS stock. Calculate: a. The expected return. b. The standard deviation of the return. Note: Make sure to round all intermediate calculations to at least five decimal places. a. The expected return. The expected return is %. (Round to two decimal places.) Get more help - Clear all Check