The question is in the below
2. Risk analysis. Download the dataset \"Bonds A and B \" from BU Brain. Two risky rms, A and B, nance their operations in part by continuously issuing short-term (30-day) zero-coupon commercial paper. The face value of each debt obligation is $1. The two time series represent 60 months (ve years) of data for defaults on these debt obligations: a value of 1 indicates that a default occurred that month (the bondholder received nothing), and a value of 0 indicates that a default did not occur that month (the bondholder received the face value. You will use these data to estimate the probability that the bonds default this period. a. First, use the fundamental pricing equation to nd the price of the bond issued by each rm (A and B), assuming that the representative investor is risk-neutral and has a monthly time discount preference of 6 = 0.95. Use this price to nd the expected return on each bond, E [TA] and E [r3]. (Calculate the return with and without default, then take a probability-weighted average. The probability that each bond defaults (or doesn't default) can be estimated from the data.) Find the volatility of each bond's return, 0,; and 0'3. For simplicity, we can assume normally-distributed outcomes and use the variance formula, as in Homework 1. (2 points) b. You are the representative investor, it is the rst of the month, and you have a portfolio consisting of one unit of each bond, both maturing at the end of the month. The value of the portfolio, P", is equal to the sum of the bond prices, PA and PB. Ignore the role of correlation between the defaults on the bonds (assume the defaults occur totally independently of one another) and nd the expected return on the portfolio, E [rm], and the volatility of the portfolio return, Up. To do this, you need to nd four probabilities: (1) the probability that both bonds default; (2) the probability that only bond A defaults; (3) the probability that only bond B defaults; and (4) the probability that neither bond defaults. (4 points) c. Now, incorporate correlation into your forecast of the portfolio's risk. Calculate and report the correlation coefcient between the two bonds' defaults (use =CORREL). Find the same four probabilities as in part (b), but this time, start by sketching the 2 x 2 probability space, as in Bayes' Theorem. Then, nd the expected return on the portfolio, E [TPH'], and the volatility of the portfolio return, Up\". How do they compare to the expected return and volatility that you found in part (b)? Produce a bar plot in Excel showing the probabilities of these three outcomes from each of part (b) and part (c): (1) zero bonds default; (2) only one bond defaults (either A or B); (3) both bonds default. What do you take away from this? (4 points) d. On the rst day of the month, rm B announces that it is experiencing nancial difculties and will place a moratorium on its debt payments (i.e., it is certain to default on bond B at the end of the month). Based on this observation, what should be the new price of bond A? (4 points)