Re: Investment Performance
Cal Learner-- MVP
>Seems like a new problem for Money 2006 (I have Deluxe). The Return for the
>Period calculation appears to double count reinvested interest. A clear
>example is on savings accounts or cds. The Return for the Period is exactly
>double the amount that appears in the Income column. I may be having othe
>discrepancies. Thoughts?
What you may be doing is entering both an Interest and a
ReinvestInterest transaction. Instead either do
Interest and Buy transactions,
or a single ReinvestInterest transaction.
Cal Learner-- MVP
>No, I'm only entering in a reinvest entry. And, if I was doing both as you
>suggest, my ending balance would have been off.
When you say "The Return for the Period calculation", are you
looking at the Portfolio? If so, what is the column heading?
Cal Learner-- MVP
>Sorry I didn't previously mention. This appears in the "Performance fy
>investment account (or type) reports. I think what's happening is that the $
>Return is adding the change in value from begin to end of the period (which
>grows because of the reinvested income) plus the income. Therefore, in
>effect doubling up on the income to calc the return. If the report included
>reinvested income as buys (which it doesn't), then it probably would have
>calc'ed properly.
I have not tried that report, but what I suggest you try is to
change the ReinvestInterest into two transactions: Interest and Buy.
Does that make things work differently?
Elliot
forward, but all prior data would still be incorrect. And to change input
back to 1996 would take a huge amount of time. If Microsoft could just fix
this for the next release.... It worked in prior releases.
Cal Learner-- MVP
>It does work fine if it's broken into 2 transactions. I could do it going
>forward, but all prior data would still be incorrect. And to change input
>back to 1996 would take a huge amount of time. If Microsoft could just fix
>this for the next release.... It worked in prior releases.
If I were to try to duplicate this, what are the conditions?
Investment account?
ReinvestInterest transactions for a security are entered into the
Investment Transactions register?
The security is set up as a Mutual Fund?
Elliot
2) Create a Mutual Fund, CD or Bond Investment
3) Enter a buy transaction
4) Reinvest Interest in the transaction register
5) Run the report
Elliot
reinvested interest). Not sure if it happens on reinvested dividends on
other types of mutual funds.
Marcia
have the CORRECT numbers in the return for the period - which now includes
any interest or dividends TWICE.
I am not sure this Cal guy has a degree in Accounting and understands what
is wrong with the report. Heck, I can even duplicate it (see another post of
mine on 2/26) in their SAMPLE.MNY file that came with the program.
It is the ONE report that I depend on GREATLY. GEEZ, the Portfolio Screen
has the correct number - why can't the programmers get that same number into
the report?
Probably because they really don't care. I have been so aggravated about
this since I updated to 2006. Wish I hadn't - but 2004 was having problems
downloading price quotes and customer service told me that they had fixed
that problem in 2006.
I just traded one problem for a BIGGER problem for me. Having to export the
report to Excel and fix it is time consuming!!!!!
Sadly, there is no easy way to convert to Quicken or I would.
"Elliot" wrote:
> By the way, the % Rate of Return is proper, only the $ Return for Period is
> double.
Cal Learner-- MVP
>1) Create an Investment Account
>2) Create a Mutual Fund, CD or Bond Investment
>3) Enter a buy transaction
>4) Reinvest Interest in the transaction register
>5) Run the report
>
I confirm that for both reinvest interest and reinvest dividends,
"Performance by investment account" report doubles up the "Return
for period" column, but does not double up the "Annual percent
return" column.
So the workaround is to use a separate Interest or Dividend
transaction and a Buy transaction if you are going to use that or
related reports.
I see that the Gain problem of the portfolio view does not have that
problem.
Marcia
I, however, DO NOT want to enter my reinvested transactions as two separate
transactions (one a buy instead of a re-invest) because that changes my
"Initial Investment."
For example, I buy mutual funds in lots of $5,000 or $10,000 and I want to
keep those numbers as my basis - WHAT I INITIALLY INVESTED!!!!!! So, no, I
do not want to do the double transaction entry way - especially when I have
over 12 years of information in my file.
The way that the investment report prints currently DOUBLES the amount of the
gain, or return for the period. I have money market accounts set up like
mutual funds and say it pays $10.00 in a dividend for the first quarter,
MONEY shows it as a total return of $20.00 for the period.
I wish it had been the $20, but no, it was only $10.
How hard is that to understand?
The number in that column should simply be the difference between the
"Beginning Balance" for the period and the "Ending Balance" you have chosen.
Somehow, Money is taking that number and then ADDS any dividend or interest
income (or reinvested LTG, STG's paid during the period.
I would suggest setting up an investment account with a money market with
say, $1,000 at $1.00 per share and for ease use a date of 10/01/05. Then,
add a transaction for a reinvested dividend of $10.00 for 12/31/05.
Now, look at the report and tell me what you see in the "Total Return for
Period" and see what I mean. It will show a Return of $20 - not $10!!!
I highly suggest "Customizing" and click on "Show Calculation Delails."
If you do this for me and you are able to show your Programming Department
the error, you will win many KUDOS!!!!!
BTW, I used to set up computerized accounting systems when I worked. I am
now disabled with MS, but my mind is still there. I've worked on many
different Accounting Software systems. So, anyhow, it was important for me
to get quirks out of the systems. This one I just feel like I'm lost in the
abyss on getting this fixed.