please solve this numerical problem
Al fx G H 17.96% 15.95% 10.48% 7.98% 18.45% 25.14% 74.86% A B D E F 26 27 28 29 Question 2 30 Given the following data on a potential branch acquisition please calculate the answers and decide if the branch should be acquired? 31 32 Input Area: 33 Expected retur: New branch office Fairmont 34 Expected retur: Existing facilities Morgantown 35 Standard Deviation: New branch office 36 Standard Deviation: Existing facilites 37 Correlation coefficient with New Branch in Fairmont 38 % of total assets: New branch office 39 % of total assets: Existing facilities 40 41 Answer Area Enter your answer rounded 42 43 Expected Combined Return after acquisition 0.00% 44 45 46 Expected Combined Standard deviation after acquisition 0.00% 47 48 is the expected return increasing as compared to the original 49 No enter ), Yes (enter 1) 50 is the expected standard deviation decreasing as compared to 51 the original No lenterYes (enter 1) 52 53 54 55 Question 3 0 0 Cover Sheet Quiz Sheet Ready Al fx G H 17.96% 15.95% 10.48% 7.98% 18.45% 25.14% 74.86% A B D E F 26 27 28 29 Question 2 30 Given the following data on a potential branch acquisition please calculate the answers and decide if the branch should be acquired? 31 32 Input Area: 33 Expected retur: New branch office Fairmont 34 Expected retur: Existing facilities Morgantown 35 Standard Deviation: New branch office 36 Standard Deviation: Existing facilites 37 Correlation coefficient with New Branch in Fairmont 38 % of total assets: New branch office 39 % of total assets: Existing facilities 40 41 Answer Area Enter your answer rounded 42 43 Expected Combined Return after acquisition 0.00% 44 45 46 Expected Combined Standard deviation after acquisition 0.00% 47 48 is the expected return increasing as compared to the original 49 No enter ), Yes (enter 1) 50 is the expected standard deviation decreasing as compared to 51 the original No lenterYes (enter 1) 52 53 54 55 Question 3 0 0 Cover Sheet Quiz Sheet Ready