If your expected return on the individual investments in your portfolio is known or can be anticipated, you can calculate the portfolio's overall rate of return using Microsoft Excel.

How to calculate return on investment (ROI), the money an investment made relative to its cost, in Microsoft Excel.

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.

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.

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 value the stock and bond markets and project future returns. My future return assumptions for stocks, bonds, and gold for 2020 and beyond.

Calculate the expected annual return of your portfolio in Microsoft Excel by using the value and expected rate of return of each investment.