A percent of return is a term used to describe a return relative to the original amount. Percent of return is most commonly used in investing to compare investments of different sizes. Because the percent return measures the return based on the original amount, you can use the same formula to fairly compare ... Calculate Stock Return. You can try to calculate the rate of return by manually, or you use an Excel formula to achieve the result. The best way to calculate your rate of return is to use the EXCEL XIRR function, and this function is a financial function in Excel.

Bankrate.com provides a FREE return on investment calculator and other ROI calculators to compare the impact of taxes on your investments. Dec 07, 2013 · Average monthly return for a stock using a spreadsheet. http://researchata.com Russell Investments has a calculator which makes it really easy to get the performance returns over any custom time period but Standard and Poors does a horrible job of calculating market returns. In fact, there is no way to calculate the total return with the data from the S&P500.

Oct 28, 2019 · Excel’s Internal Rate of Return (IRR) function is an annual growth rate formula for investments that pay out at regular intervals. It takes a list of dates and payments and calculates the average rate of return. The XIRR function is similar, but works for investments that pay at irregular intervals. For example, if you paid $1,500 for a stock and paid a $10 broker's fee, your total cost would be $1,510. Step Calculate the total return on your investment by adding the amount the asset was sold for and any payments, such as dividends, made to you while you owned it and subtracting the costs associated with the sale.

Calculating the expected return for both portfolio components yields the same figure: an expected return of 8%. However, when each component is examined for risk, based on year-to-year deviations from the average expected returns, you find that Portfolio Component A carries five times more risk than Portfolio Component B (A has a standard ...