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

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.

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.

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

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

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.