Can someone please help me with a calculation of ATR for a somewhat complex
mutual fund?
I have a fund, held for part of a year, with some of the dividends
reinvested and some not reinvested (withdrawn). Also some shares have been
sold and some additional shares bought during the period. I need to prepare
a formula which will calculate the Annualized Total Return of this fund.
Thanks for any help.
Jim.
jim simpson wrote:
> Can someone please help me with a calculation of ATR for a somewhat
complex
> mutual fund?
>
> I have a fund, held for part of a year, with some of the dividends
> reinvested and some not reinvested (withdrawn). Also some shares have
been
> sold and some additional shares bought during the period. I need to
prepare
> a formula which will calculate the Annualized Total Return of this
fund.
Excel has a function called XIRR that calculates the internal rate of
return. You will probably need to install one of the Analysis Toolpaks
add-in. Read the help file on XIRR. You basically enter in the date and
values. Ignore reinvested dividends. It's the greatest thing ever.
Thanks Bucky, I'll go to work on your idea.
Jim
"Bucky" <> wrote in message
news:
> jim simpson wrote:
> > Can someone please help me with a calculation of ATR for a somewhat
> complex
> > mutual fund?
> >
> > I have a fund, held for part of a year, with some of the dividends
> > reinvested and some not reinvested (withdrawn). Also some shares have
> been
> > sold and some additional shares bought during the period. I need to
> prepare
> > a formula which will calculate the Annualized Total Return of this
> fund.
>
> Excel has a function called XIRR that calculates the internal rate of
> return. You will probably need to install one of the Analysis Toolpaks
> add-in. Read the help file on XIRR. You basically enter in the date and
> values. Ignore reinvested dividends. It's the greatest thing ever.
>