Complete the five problems and 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 - Saccadsheet Template Go back to 6,5. Kosher Aviation Project Scarlo 3 and Al ACA Problem 1 Based on the following information, calculate the expected return and standard deviation for two stocks State of the Economy Recession Rate of Return Stock B -19 Probability Rate of ReturnStock A 25 05 50 06 25 . 10 Normal Boom Fill in the value in the spreadsheet. . Problem 2 . Problem 3 Problem 4 N Stock A 0.05 State Probaby Recession Normal 0.50 Boom Stock B 10.19) 0.14 0.34 0.10 Oputan Return Deviation Squared Deviation Probability Return Product Product STORA Recession Noma Boom ER) - 0.0000 Variance Standard Deviation 0.00% Return Deviation Squared Deviation Return Product Product Stock Probability Recession Normal Boom 0.0000 Variance Standard Deviation 0.00% Sima md Sim Je