Consider the following information and then calculate the required rate of return for the Global Investment Fund, which holds 4 stocks. The market's required rate of return is 17.50%, the risk-free rate is 3.00%, and the Fund's assets are as follows (Do not round your intermediate calculations.): please show work in excel Stock   Investment   Beta A   $200,000   1.50 B   $300,000   -0.50 C   $500,000   1.25 D   $1,000,000   0.75

Are these correct? Need help with C, Thank you!

Consider the following information and then calculate the required rate of return for the Scientific Investment Fund, which holds 4 stocks. The market's required rate of return is 16 %, the risk-free rate is 7 %, and the Fund's assets are as follows: Stock  Investment  Beta   A $   200,000  1.50 B      300,000 -0.50 C      500,000   1.25 D   1,000,000   1.1         Round it to two decimal places without the percent sign (%), e.g., 13.54.

Consider the following information and then calculate the required rate of return for the Global Equity Fund, which includes 4 stocks in the portfolio.  The market's required rate of return is 16.00%, the risk-free rate is 5.25%, and the Fund's assets are as follows:Round your answer to two decimal places. For example, if your answer is $345.6671 round as 345.67 and if your answer is .05718 or 5.7182% round as 5.72.   Stock Investment Beta A    $205,000 1.45 B $375,000 0.85 C     $555,000 –0.45 D $1,130,000 2.08