View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default How to calculate return on a open-ended mutual fund?

You want XIRR.

Build a table of your cash flows and their dates, then feed this to XIRR.

--
Regards,
Fred


"Kundan" wrote in message
...
I want to know how to calculate return on an open-ended mutual fund where
investor can invest at different points of time at different NAV and offload
the investment at a certain NAV.