28) You wish to diversify your single-security portfolio in a way thai wil ma imize your reduction in risk. lpha Company stock that has a correlation coefficient of-0ent secarity D) elta Company bonds that have a correlation coefticient A) SIDEVP is the correct Excel function to find the variance of a oar two. currer security with you Beta Company stock that has a correlation coefficient ot dh our current Treasury bills that have a correlation coefficientd.36 with yo 0.50 with yount security cient of 0.50 with yo ficient of 0.0 with yourc usrent security,- 2)?ucq of the following statements is TRUE? variance of a sample. ear zero as the cash er to find the correct IRR. B) Excel's NPV function treats the cash flow of year zeoorder to find the correct Ik. order to find the c In Excel, the IRR function requires an additional adjustm on the NPV additional adjustment in oitai that has a negative NPV Profile graph, the IRR lies to the left of any cost of ca ssociated with it. indicatedcellsinnn' Excel for years zero through 2, firm's s cost of capital of 9% is in cell A4. NPV of this project? respectively: Al -$1,000; A2-$600; A3 $500. In addition, the Which of the following would be the correct formula to compute the (B) NPV(A4, A1:A3) Sum(Al: A3/(1 + A4)A3 C) NPV(A4, A2: A3) + A1 PV(A4, A2:A3)- A1