https://bugs.kde.org/show_bug.cgi?id=396301
Bug ID: 396301
Summary: Investment Performance by Account YTD Return on
Investment result different between version 4.8 and
5.01
Product: kmymoney
Version: 5.0.1
Platform: Mint (Ubuntu based)
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: NOR
Component: reports
Assignee: kmymoney-devel@kde.org
Reporter: clouddrive...@gmail.com
Target Milestone: ---
I have been using KMyMoney version 4.8 for several years in Linux Mint 18.3. I
upgraded a few days ago to Linux Mint 19 and installed KMyMoney 5.0.1 using the
Software Manager. When I ran the Investment by Account YTD report I see that
version 5.0.1 provides different values for Return on Investment than those
provided by version 4.8. I believe (but am not certain) that version 4.8
provides the correct results.
For example, I have a mutual fund bond account that pays a monthly dividend
that is reinvested to buy additional shares. There have been no Buy or Sell
activities this year. Version 4.8 calculates the difference between the
Beginning Balance and Ending Balance and divides the result by the beginning
balance then multiplies the result by 100 to convert it into the Return on
Investment percentage. Version 5.0.1 gives a different answer that I have been
able to duplicate by subtracting the Beginning Balance AND the Dividends
Reinvested from the Ending Balance and dividing a result that again is
multiplied by 100 to convert to a percentage. Because the Dividends Reinvested
were used to purchase new shares that are included in the Ending Balance I see
no reason to subtract the Dividends Reinvested value from the Ending Balance
when calculating Return on Investment.
I have another mutual fund account from which we take monthly dividends in cash
(no reinvestment). There has been no Buy or Sell activity this year. Both
version 4.8 and 5.0.1 calculate the same (that I believe correct) Return on
Investment percentage by adding the Dividends Paid Out to the Ending Balance,
subtracting the Beginning Balance and then dividing the result by the Beginning
Balance and converting to a percentage.
I have a third mutual fund that has quarterly Reinvested Dividends and Buy
activity but no Sell activity this year. Version 4.8 calculates Return on
Investment for this fund by subtracting both the Beginning Balance and Buy
Value from the Ending Balance, then dividing the result by the sum of the
Beginning Balance and Buy Value. The Dividends Reinvested amount is not a part
of the calculation. Version 5.0.1 comes up with a lower Return on Investment
that I have been unable to duplicate in any way.
I have a fourth mutual fund that has quarterly Reinvested Dividends and Sell
activity but no Buy activity this year. Version 4.8 calculates Return on
Investment for this fund by subtracting the Sell Value from the Beginning
Balance and then subtracting the result from the Ending Balance. Dividing this
result by the Beginning Balance minus the Sell Value gives the Return on
Investment. The Dividends Reinvested amount is not a part of the calculation.
Version 5.0.1 comes up with a lower Return on Investment that I have been
unable to duplicate in any way.
The Annualized Return percentages for all of my individual investments are the
same for both version 4.8 and 5.0.1 and also match what I calculate using the
Excel XIRR function. I'm not sure about the new Annualized Return Account
totals in version 5.0.1 as I haven't tried to match them in Excel as yet.
Thank you in advance for any assistance in resolving the differences between
version 4.8 and 5.0.1.
Jon
--
You are receiving this mail because:
You are the assignee for the bug.
