PLEASE EXPLAIN VIA EXCEL SET UP

Best Invest seeks to allocate $$10,000$ between three funds A$,$ B$,$ and

C$.$ Best Invest's goal is to achieve an expected portfolio return of

$10\%$ at the lowest possible risk level. Best Invest has ten quarters of

annualized performance data on the three funds that are shown

below and provided in the Excel workbook for this quiz.

Which of the following statements is true at the optimal investment

allocation?

$($Note: Round answers to two significant digits except for covariance

values which are rounded to $5$ significant digits.$)$

The investment in Fund A would $57\mathrm{.}07\%$ or $$5707.$

The standard deviation of the portfolio return would be $2\mathrm{.}95\%$ or

$$295.$

The smallest amount of investment is in Fund $C.$

The overall portfolio risk is less than the risk of any individual fund.

Exactly two answers are correct.

Exactly three answers are correct.