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.
|?||Show this help|
|ESC||Blurs the current field|
|r||Focus the comment reply box|
|^ + ↩||Submit the comment|
You can use
Command ⌘ instead of
Control ^ on Mac
1 Posted by dwg on 25 Mar, 2023 11:32 PM
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 Posted by tgilbert666 on 26 Mar, 2023 01:32 AM
I agree with dwg. I've long since decided MD Investment reports are best done in a different tool.
3 Posted by dwg on 26 Mar, 2023 01:39 AM
In general Moneydance reports need some work, there are a number with problems,
Additional Investments reports would not go astray either.
4 Posted by mhoggie on 26 Mar, 2023 02:08 AM
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.