Which formula/function in B5 will correctly calculate the expected return of the portfolio?





a) {=SUMPRODUCT(TRANSPOSE(B2:B4),D3:F3)}

b) {=SUM(B2:B4*TRANSPOSE(D3:F3))}

c) =B2*D3+B3*E3+B4*F3

d) =MMULT(H3:J3,F2:F4)

e) All of the above


e) All of the above

Business

You might also like to view...

The FASB recommends that assets and liabilities with differing liquidities be arranged as separate items in the balance sheet

Indicate whether the statement is true or false

Business

Investing and financing activities for the statement of cash flows may differ when using the direct method instead of the indirect method.

A. True B. False

Business

________ are situations that excuse a WTO member state from complying with its GATT obligations in order for the state to protect certain essential public policy objectives

A. Harmonized Systems B. General exceptions C. Safeguards D. Security exceptions

Business

E-mation, Inc hires Marvin to steal trade secrets from one of its competitors for $10,000 . Marvin demands half of the money up front. E-mation pays Marvin $5000 but Marvin decides not to pursue theft of the trade secrets. E-mation sues Marvin for the return of the $5000 . What will the court do with this contract?

a. The court will order Marvin to return the $5000. b. The court will order Marvin to return the $5000 with interest. c. The court will order Marvin to obtain the trade secrets. d. The court will not do anything to help E-mation get its money back.

Business