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.

Find out more about return on equity, the formula to calculate ROE, and how to calculate this measure of corporate profitability in Microsoft Excel.