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.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

Reviewed by Thomas Brock Fact checked by Suzanne Kvilhaug CAPM: An Overview Many investors use the capital asset pricing model (CAPM) as a way to estimate the potential return of a stock or other ...

If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of return over a span of time for financial reporting obligations.

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier.

One simple but powerful method investors can use to assess the risk and reward of a stock portfolio is using the Capital Asset Pricing Model, or CAPM, model for expected returns.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money.

Calculating returns from your stock portfolio can be a tricky matter, especially if some of your holdings pay dividends, or you make frequent deposits and withdrawals from your account. With Excel ...

How to calculate average stock returns in Excel In the following example, I'll calculate the returns for Microsoft stock using historical prices and dividends. The first step is to get organized.