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 ...

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

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.

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.

Reviewed by Thomas J. Catalano Fact checked by Ryan Eichler What Is the Capital Asset Pricing Model (CAPM)? Corporate accountants and financial analysts often use the capital asset pricing model (CAPM ...

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.