Please show formulas

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 return: New branch office Fairmont 34 Expected return: 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 28.57% 28.33% 16.67% 14.17% 30.83% 40.00% 60.00% o o 48 1 Is the expected return increasing as compared to the original 49 No (enter O), Yes (enter 1) 50 Is the expected standard deviation decreasing as compared to 51 the original No (enter 0 ), Yes (enter 1) 52 1 1