i would like to see the work/formulas done on these too! thank you!

here is number 2 if you could not read

5 1 Problem 1 Calculate the expected Returns and Standard Deviations for Both Stocks. 12 points 2 ABC and XYZ have the following probabilities of return 3 ABC, Inc. XYZ, Inc. 4 Probability Probable Return Probability Probable Return 15.00% -60.00% 25.00% -10.00% 10.00% -30.00% 15.00% 0.00% 5.00% -10.00% 35.00% 10.00% 40.00% 20.00% 25.00% 25.00% 20.00% 40.00% 10 10.00% 80.00% 11 12 13 Expected Return ABC Expected Return XYZ 14 6 7 9 15 16 17 18 19 20 21 22 Standard Deviation ABC 23 Standard Deviation XYZ 25 Problem 2 12 points 26 You are a bond investor. You are considering purchasing an 4% coupon bond, which says interest payments quarterly. The par value on the bond is $50.000. Interest rates haver since you purchased the bond. 27 The current yield to maturity on similar risk bonds is 8% 20 > Before you solve the problem, what do you believe will happen to the bond value and why? Calculate the Current Bond we using the 4-Step Process 40 Problem 3 6 points You deposit 55,000 in an account today. You let the money sit for 10 years. It earns 4% compounded monthly. What is the future value of your money? Solve it using both the Excel formula and traditional formula 05 . Problem 4 6 points You will need $73,000 in 6 years. You can earn 5% on your money. How much will you have to deposit today to have $73,000 in 6 years? 5Solve it using both the Excel formula and traditional formula 2 53 54 25 Problem 2 12 points 26 You are a bond investor. You are considering purchasing an 4% coupon bond, which pays Interest payments quarterly. The par value on the bond is $50,000. Interest rates have risen since you purchased the bond 27 The current yield to maturity on similar risk bonds is 8%. 28 29 Before you solve the problem, what do you believe will happen to the band value and why? 30 Calculate the Current Bond Value using the 4-Step Process