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.

  5. System closed this discussion on 25 Jun, 2023 02:10 AM.

Comments are currently closed for this discussion. You can start a new one.

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