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.