Instructions: You need to show your work in order to receive any credit. Round numerical values up to 5 decimals (e.g. 0.12345 or 12.345%, where appropriate) and dollar values up to cents (e.g. $12.34). Solve the following questions in an organized manner into the sheet with the same name in the Excel file "IM Homework Set 2.xlsx," and submit the file via email at mehmet.f.yalin@pitt.edu by the announced due date no later than the beginning of our session. Security A is currently priced at $75 per share and security B is currently priced at $30 per share. The economy can experience a recession, normal growth, or boom over the next year. The normal growth is eight times as likely as the recession and the boom is as likely as the recession. The table below presents the market-consensus per-share dividend and share price of each security in each state of the economy. Security A Security B Dividend Ex-dividend price Dividend Ex-dividend price State in year 1 in year 1 in year 1 in year 1 Recession $- $67.50 $1.65 $31.35 Normal $- $82.50 $1.65 $34.35 Boom $1.05 $96.45 $1.95 $19.05 Using the information above, answer parts a through f. [Hint: First, calculate the probability of each state (recession, normal, and boom). Second, calculate the holding period return of each asset (security A and security B) in each state (recession, normal, and boom). And then, you can solve parts a through f.] a. Calculate the expected percentage return of security A and security B. b. Calculate the standard deviation of the expected percentage return of security A and security B. Calculate the covariance and the correlation coefficient between the returns of security A and security B. d. Calculate the expected percentage return and its standard deviation of a portfolio that invests equal amounts in security A and security B. Calculate the expected percentage return and its standard deviation of a portfolio that takes a short position in security A in the amount of $20,000 and a long position in security B in the amount of $120,000. f. Calculate the expected percentage return and its standard deviation of a portfolio that borrows $10,000 at the annual risk-free rate of 4%, and takes a short position in security B in the amount of $15,000 and a long position in security A in the amount of $75,000. C. e. Instructions: You need to show your work in order to receive any credit. Round numerical values up to 5 decimals (e.g. 0.12345 or 12.345%, where appropriate) and dollar values up to cents (e.g. $12.34). Solve the following questions in an organized manner into the sheet with the same name in the Excel file "IM Homework Set 2.xlsx," and submit the file via email at mehmet.f.yalin@pitt.edu by the announced due date no later than the beginning of our session. Security A is currently priced at $75 per share and security B is currently priced at $30 per share. The economy can experience a recession, normal growth, or boom over the next year. The normal growth is eight times as likely as the recession and the boom is as likely as the recession. The table below presents the market-consensus per-share dividend and share price of each security in each state of the economy. Security A Security B Dividend Ex-dividend price Dividend Ex-dividend price State in year 1 in year 1 in year 1 in year 1 Recession $- $67.50 $1.65 $31.35 Normal $- $82.50 $1.65 $34.35 Boom $1.05 $96.45 $1.95 $19.05 Using the information above, answer parts a through f. [Hint: First, calculate the probability of each state (recession, normal, and boom). Second, calculate the holding period return of each asset (security A and security B) in each state (recession, normal, and boom). And then, you can solve parts a through f.] a. Calculate the expected percentage return of security A and security B. b. Calculate the standard deviation of the expected percentage return of security A and security B. Calculate the covariance and the correlation coefficient between the returns of security A and security B. d. Calculate the expected percentage return and its standard deviation of a portfolio that invests equal amounts in security A and security B. Calculate the expected percentage return and its standard deviation of a portfolio that takes a short position in security A in the amount of $20,000 and a long position in security B in the amount of $120,000. f. Calculate the expected percentage return and its standard deviation of a portfolio that borrows $10,000 at the annual risk-free rate of 4%, and takes a short position in security B in the amount of $15,000 and a long position in security A in the amount of $75,000. C. e