ExcelBanter - How to calculate return on a open-ended mutual fund?

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

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

- - How to calculate return on a open-ended mutual fund? (https://www.excelbanter.com/excel-discussion-misc-queries/133684-how-calculate-return-open-ended-mutual-fund.html)

Kundan

How to calculate return on a open-ended mutual fund?

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.

Fred Smith

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.

All times are GMT +1. The time now is 04:55 AM.