It is fairly straightforward to calculate the equity risk premium for a security using Microsoft Excel; you can even find out how to estimate the expected return.

The adjusted premium added to the risk-free rate is the difference in the expected market return times the beta of the asset. This formula can be calculated in Microsoft Excel as shown below.