ExcelBanter - calculate investment returns

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - calculate investment returns (https://www.excelbanter.com/excel-discussion-misc-queries/66471-calculate-investment-returns.html)

calculate investment returns

What is the best way to calculate the return on an investment account
factoring in periodic (but inconsistent) deposits and withdrawals to the
account?

Ron Rosenfeld

calculate investment returns

On Fri, 20 Jan 2006 14:16:03 -0800, "PG" wrote:

What is the best way to calculate the return on an investment account
factoring in periodic (but inconsistent) deposits and withdrawals to the
account?

You can use the XIRR function to give you an annualized return.

--ron

All times are GMT +1. The time now is 05:23 AM.