Nick David / Getty Images There is no specific formula in Excel or other spreadsheet applications ... Use the formula =SUMPRODUCT(X1:X10, Y1:Y10)/SUM(Y1:Y10) to calculate the average weighted ...

A Microsoft Excel spreadsheet can be used to calculate ... or the lowest level of risk for a desired level of return. The formula for CAPM calculates the expected return of an asset (usually ...