Investment performance calculation does not account for "income"

shannahs's Avatar

shannahs

05 Sep, 2011 09:25 PM via web

In my opinion this is a problem but maybe it is as designed. I am not sure what the philosophy is here.

If I invest $1000 in mutual fund A. Over the next 5 years, the fund being an income fund pays out $100 each year. This is a pretty good deal, but the price on the fund has dropped to $999.

The investment performance report will show that this fund is a loser with an IRR that is negative. In actuality I had a 50% return over that period and an IRR of about %10 which is a winner. This is important in evaluating investment performance and the calculation must take into account both the change in price/value of the underlying security as well as any income realized during that time period.

  1. Support Staff 2 Posted by Ben Spencer on 06 Sep, 2011 05:17 AM

    Ben Spencer's Avatar

    If you record the income as a MiscInc transaction associated with the security MutualFundA it will be considered a gain in the investment performance report. See the attached screenshot.

    Ben Spencer
    Moneydance Support

  2. 3 Posted by shannahs on 24 Sep, 2011 09:54 PM

    shannahs's Avatar

    Ok, I see that. But I really want to record the income as Div or DivX where it is reinvested. I will try to see if I can come up with an example. I pulled a lot of this from Quicken where it is labeled as DivReinvest which seems like a natural itme.

  3. 4 Posted by zeke on 25 Sep, 2011 01:59 AM

    zeke's Avatar

    sth
    I'm not sure I understand. I routinely record income reinvestments as DivReinvest in Moneydance. One limitation of Moneydance w/ respect to mutual funds however is that there is no cap gain (short or long term) action for mutual funds as there is in Quicken. You can use a category identifying capital gains, but as far as I can tell Moneydance has no easy way to report for example, on the proportion of distributions due to cap gains, dividends and interest in a mutual fund. Everything is lumped together as dividends. The investment performance report does seem to include the DivReinvest actions in its calculations. Be aware however, that the calculations may or may not be accurate.

Reply to this discussion

Internal reply

Formatting help or Preview

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.