Project 1 Autosave Design Draw Home Insert ANCE AaBbc References Mailings Layout View Review Tell me A A Aav AEEE ADA Times New... 16 Emphasis Path Project #1 FIN 45 Puild a pret tower the following to the aparate worksheet for each of the 2 question 1. Calculate the arithmetic return, the geometrie retum, and the standard deviation for the following securities 8 A 02 -0.1 Year 1 2 3 4 5 D O 0.1 04 E 0.1 0.2 0.3 0.2 0.2 0.4 0.1 02 -02 05 -0.1 0 03 0 05 02 03 -02 0.5 0.1 0.1 04 7 0.1 03 03 -0.1 0 02 02 0.3 -0.2 0.1 0.3 0.3 -0.1 0.1 0.3 0.1 0.2 0.1 9 10 2. Create the probablyweighted returns and standard deviation for each of the stocks below State of the Reture for SA 20% 19% Refers for Stock -3016 10 Return for Stock -0% -10% 15% 10% Average 40 10% 19 MacBook Air esc F2 000 000 Project 1 Saved to Home Insert Draw Design Layout References Mailings Tell me Times New... 16 ' ' A B I U ab X, X ADA Paste Paragraph Styles Dictate Project #1 FIN 345 Build a spreadsheet to answer the following questions. Use a separate worksh for each of the 2 questions 1. Calculate the arithmetic return, the geometric return, and the standard deviation for the following securities. A Year 1 2 3 4 -0.1 0.4 0.1 -0.3 0 0.5 -0.2 0.3 -0.2 05 0.1 -0.1 0.4 D 0 0.1 0.4 -0.1 -0.2 0.1 E 0.1 0.2 0.3 0.2 0.2 0.4 0.3 0.1 0.2 0.1 -0.1 0 0.1 0.3 0.3 -0.1 0 02 0.2 0.3 6 -02 0.5 01 D 03 0.3 -0.1 0.1 10 2. Calculate the probability-weighted return and standard deviation for each of the stocks below. Return for Stock C 40% State of the Economy Recession Below Average Average Above Average Boom Probability 10 20 40 20 .10 Return for Stock A 20% 15% 12% 2% -10% Return for Stock B -3096 096 10% 1594 25% -10% 15% 30% 45% FO MacBod