els au prepare the spreadsheet template with your solutions. Consider each problem Independently without reference to the previous problem. The problems cover material from Modules 6 and 7. Each problem is worth 20 points for a total of 100 points. Show your work. for the opportunity to receive partial credit in the case of an incorrect answer Scenario 3 Spreadsheet Template a Go back to 6.5.- King Elsher Aviation Project - Scenario 3 Expand All Collapse All Problem 1 Based on the following information, calculate the expected return and standard deviation for two stocks: Rate of Return Stock B State of the Economy Recession Probability Rate of Return Stock A .25 .05 -19 Normal .50 L06 .14 Boom 25 .10 .34 Fill in the value in the spreadsheet. Problem 2 Problem 3 Problem 4 Problem 5 Ne 217/pages/king-fisher-aviation-module-7-scenario-3-problems BA e o 99+