To calculate beta from the inputs, divide the portfolio's (or stock's) co-variance by the benchmark's variance. For the benchmark, these values are equal, hence its beta equals one.

Enter this same formula in subsequent cells to calculate the portfolio weight of each investment, always dividing by the value in cell A2. In cell F2, enter the formula = ( [D2*E2] + [D3*E3 ...