You want to create a portfolio equally as risky as the market, and you have $1,000,000 to invest. Given this information, fill in the rest of the following table:

Please answer using excel

Asset Investment Beta StockA .80 $185,000 $320,000 1.13 Stock B Stock C Risk-free asset 1.29 Portfolio beta Total investment Investment Beta Asset Stock A Stock B Stock C Risk-free asset Output area: Investment Beta Asset Stock A Stock B Stock C Risk-free asset