Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Computing Mutual Fund Diversification | Excel Worksheet Functions | |||
How to calculate CAGR for mutual fund performance using XIRR | Excel Worksheet Functions | |||
open ended multi page sum | Excel Worksheet Functions | |||
open ended multi page sum | Excel Worksheet Functions | |||
open ended multi page sum | Excel Worksheet Functions |