ROI questions

mhoggie's Avatar


25 Mar, 2023 11:04 PM

Does anyone know the formula that MD uses to calculate the Annual % (ROI) in the Investment Performance report?
ROI number is correct, but Annual % (ROI) number seems to be off a bit the way I figure it.

  1. 1 Posted by dwg on 25 Mar, 2023 11:32 PM

    dwg's Avatar

    I've seen some references but they do not go deep enough.

    I do not know but I have a suspicion they take the time period you have set for the report and tried to annualize the data from that time period.

    Which if they do creates utter garbage, as it is merely some sort of projection.

  2. 2 Posted by tgilbert666 on 26 Mar, 2023 01:32 AM

    tgilbert666's Avatar

    I agree with dwg. I've long since decided MD Investment reports are best done in a different tool.

  3. 3 Posted by dwg on 26 Mar, 2023 01:39 AM

    dwg's Avatar

    In general Moneydance reports need some work, there are a number with problems,

    Additional Investments reports would not go astray either.

  4. 4 Posted by mhoggie on 26 Mar, 2023 02:08 AM

    mhoggie's Avatar

    The normal ROI number comes up correct, but that is a simple calculation. The annualized ROI is a bit more involved because it involves the number of years invested. MD seems to be in the ball park but seems to be 10 to 20 % off. I think I might create a test investment and see if I can sort out what they are doing.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


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.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac