Open a new Microsoft Excel 2010 spreadsheet. Click on cell "A1" and enter the earlier of the two dates that you are working with. To ensure that Excel converts your date to a number enter it like ...

The midpoint on the SML would be the average performance of the market and the highest point on the SML would be the CAPM of a stock that you want to evaluate. Launch Excel and create a new, blank ...