Hi, I'm new to this product, but can't for the life of me figure out how to get the sheet to report dividends and capital gain distributions as annual income (not reinvested) from a regular account. All I see is that I can ask for this income to be reported from the "growth" of the account, but not on the actual account balance. I thought I saw some old discussion this was being fixed, but I don't see it. Thank you for any thoughts on this matter.
@billycee1958 I may not be fully understanding your issue, but I'll provide some information here to shed some light on dividends and capital gain distributions. Dividends and capital gains distributions are part (or all) of the growth of the account and can be included in the Tabular Projections > Taxes view (or any other view depending upon the way the View Mgmt page is set up); however, the values in those columns are the same regardless of whether those amounts are reinvested or deposited into the Cash account and there's no mechanism to display the components of the annual deposits to the Cash account. The setting of the "reinvest ?" checkbox on the Financial Assets > Taxation page governs whether or not they get reinvested, but there's no output that shows that result explicitly. The column entitled "Total Income" on the Tabular Projections > Summary page is showing income from external sources (such as employment, pensions, SS, annuities, etc) but does not include some things that are treated as income such as RMDs, and interest and dividends from your accounts. If this doesn't sufficiently clarify this area for you, please elaborate and I'll try again.
Stuart
@smatthews51 If "Check if interest and dividends are to be re-invested" is left unchecked, and these dividends are not treated as income, but instead lumped into growth of the account, then should the dividends not at least show up as a "withdrawal" from regular investment ? As far as I can see the checkbox has no effect on any outcome that I noticed. (I think you are saying the same in that "no output shows that result explicitly")
I am trying to reconcile: Total expenses (including Taxes) = Income + Withdrawals
And the 2 things missing right now are draw-down on Cash and these non-re-invested dividends.
The manual states that the non-reinvested interest and dividends are contributions to the cash account, but I fail to see this in any of the reports. (Below a section from the manual)
Contributions to the cash account are never specified directly by the user and are only done via
PRC’s algorithms. Here is a list of events that result in contributions to the cash account:....
o growth of the regular investment account that is attributed to simple interest, short-
term capital gains or qualified dividends and that is not reinvested
ANSWER TO THE QUESTION:
In further researching I did find a reporting field "Net withdrawals from cash account" that is not on any of the default reports, and that is where the magic happens. The values of this field changes when you check or uncheck the re-invest dividends checkbox (with the amount of Taxable interest on regular investments plus qualified dividend columns from the AGI report), and this was for me the missing link to reconcile "Expenses = Income + withdrawals"
Hope @billycee1958 and others will benefit
Andre.
@adenhaan I'd like to add one other thing that may be helpful: If you'll go to the Reports page, you'll see a large button labeled "Show Me a Summary Report". Click that and then scroll down to the Account Summary > Cash Account section and you'll see a row labeled "Regular investment account Interest and dividends not reinvested" which will show you that value; however, it's only for the first five years of the modeling period.
Stuart
@smatthews51 Whow, had not gotten to explore that report yet, it is Gold and answers most all of the questions I had. Thank you again.
