View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default 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