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. If you don't ...

A Microsoft Excel spreadsheet can be used to calculate CAPM. CAPM can be used to help you build a portfolio of stocks ... an investment like a U.S. Treasury bond, an asset’s beta, and the ...