I had asked a month or two ago about getting better information:
I'm using Quicken 21012 Home a& Business primarily to deal with investment which
>are mostly stock, bonds, preferreds and mutual funds. I also track a couple of
>IRAs and retirement funds and some debt. I wrote a spreadsheet in Excel to
>determine the yearly percentage return from original purchase to today.
>In order to do that, I need the totaled dividends and interest from purchase
>date till today.
>Quicken gives "Gain/Loss" which it says is total gain or loss since purchse date
>(pre-tax), "Gain/Loss (%)" which is is given as the Gain/Loss as a percentage of
>your cost basis and "Return" which is given as Market value plus cash income
>plus sale income minus dollars invested (since you invested)
>So my questions are:
> 1) Is Gain/Loss+Market Value giving me the same as Return? If I add the
>current value to Gain/Loss, I should end up with the same number as Return but
>it doesn't
> 2) When I divide Gail/Loss by Market Value, the resultant percentage doesn't
>match Gain/Loss (%).
>I'm trying to breakout the dividends that the investments are throwing off,
>divide by the invested amount (including commissions and fees) and then
>determine the annual rate of return for the time period I've owned the >investment
>FX; Purchase an investment for $10 in 1980; it started paying $0.50 per year
>dividend and is now paying $1.00 per year in dividends. I've owned the
>investment for 37 years, 2 months. What's the annual rate of return for the
>investment? Dividends started at 5% and is now at 10% but what's the average
>annual return? I've got about $300 in income from this investment and IF I divide
>by 37, I get about 8% return. BUT that's not right because later years build on
>earlier years earnings, so what is the real >rate of annual return? This ignores the
>current/market value, gain/loss and return the Quicken provides. How do I pull the
>earnings from the columns provided or how can I get them from the database
>Quicken uses?
>I'm shooting for 5%-6% yearly returns on my portfolio and want to buy/sell based
>on the return in dividends, not the gain in investment price. If I don't sell, I don't
>care (not too much anyway) about the investment gain/losses in market >price.
Someone suggested that I use the "performance report" build within Quicken. I've been trying but quicken reports on all investments - even the ones I have sold and am not interested in. I also have the investment marked (investments>Securities List make as hidden nut they are still being reported on. But on top of everything else, Q doesn't give a correct percentage return - they vary from the real return and I can't find out why. I'm just not getting what I want - a report that shows me the return on investment on a cumulative yearly percentage. Does anyone know how to get to my end point from what Q provides? R. Wink