input numbers for T...
Clear all


4 Posts
3 Users
Trusted Member Customer
Joined: 1 year ago
Posts: 29
Topic starter  

I have some questions about my input numbers for PRC's TAXATION OF ASSETS IN REGULAR INVESTMENT ACCOUNTS table (screenshot attached).

Some of the historic data for calculating the taxation-input numbers came from Vanguard's "Statutory Prospectus".
The historic data in the prospectuses goes back only 5 years.
I suspect that averaging 5 years is nonsense due to the small sample size.

Do the numbers in the attached screenshot look reasonable?
For example, "Growth Taxed as LTCG When Withdrawn" (unrealized capital gains) for bonds is 0%.
The actual calculation was -1.31%, but Excel said, "Must be a percentage between 0 and 100%".

I'm concerned about garbage-in, garbage-out.
How many years of data do I need to get a reliable average?
Where do other PRC-Vanguard users find data for their taxation-input calculations?

I'm using PRC2023 GOLD v3.1 and asset-allocation mode 2.
PRC > FINANCIAL ASSETS > Management > "User Specifies Overall Asset Allocation and Target Asset Location"
The attached spreadsheet shows my taxation-input calculations in two sheets.

1. historic_Qdiv_&_LTCG sheet
For each fund, numbers were copied from 3 sources:
- Vanguard's "Statutory Prospectus" (5 most recent years)
- and previous years
- > Annually > Capital return by NAV
Then the years were averaged.

2. asset_class_taxation sheet
Averaged numbers from historic_Qdiv_&_LTCG sheet were used to calculate the TAXATION OF ASSETS IN REGULAR INVESTMENTS ACCOUNTS as described in PRC manual p50 > "Guidance for Determining the Numbers to Put in the Taxation Table".

Topic Tags
Reputable Member Customer
Joined: 2 years ago
Posts: 275

This is a tough one as far as bonds are concerned, at least if you're in bond *funds*. If you're just buying regular bonds yourself, ok, it's easier - all gains are just simple interest taxed as income. But with bond funds, the only gain taxed as regular income are the dividend payments, which are fundamentally interest. So that first box should be whatever your bond yield is per year, even if you're reinvesting those dividends. VGIT (Vanguard Intermediate Term Treasury) is currently 3.6% SEC yield.

When you sell bond fund shares in a brokerage, it's just like selling equity shares - LTCG rates if you've held the shares longer than a year. If held less than a year, regular income. Assuming held longer than a year, the other 96.4% should be "Growth taxed as LTCG when withdrawn" in that case.

Yes, there is usually some "Growth taxed annually as qualified dividends due to trading/churn within the funds, but it's almost nothing.

Anyone doing anything different here? It does depend on what types of bonds you have. Aggregate bonds funds have higher yield, for example. Muni yields not taxed at the federal (and perhaps state) level at all, other than MAGI calcs.

Trusted Member Customer
Joined: 1 year ago
Posts: 29
Topic starter  

Thank you Bill. All my taxable bonds are in Vanguard Total Bond Market Index Fund Admiral Shares (VBTLX).

My understanding is that PRC's Bond "Growth taxed as simple interest" column is a percentage of total bond growth (not a straight bond yield). All the "bond" columns are a percentage of total bond growth. And the "stock" columns are all a percentage of total stock growth.

From the formulas listed in 2023 PRC Gold Manual > “Asset Class Taxation” on page 51:

Armed with this information, we can start filling in the taxation table:
* Interest % for the taxable bonds class = TB(i) / TB (Total)
* Realized CG % for the taxable bonds class = TB(Qdiv) / TB (Total)
* Unrealized CG % for the taxable bonds class = TB(UCG)/ TB (Total)

There are two things on page 51 that I don't understand.

  1. No formula is listed for the "Growth Taxed Annually as Qualified Dividends" column.
    Would this formula be correct?:
    Qualified Dividends % for the taxable bonds class = TB(Qdiv) / TB (Total)
  2. Why does the formula for the "Growth Taxed Annually as LTCG" column use TB(Qdiv)?
    Realized CG % for the taxable bonds class = TB(Qdiv) / TB (Total)
    Would this alternative formula be correct?:
    Realized CG % for the taxable bonds class = TB(RCG) / TB (Total)

Eminent Member Customer
Joined: 2 years ago
Posts: 37


I think Pralana asks for Qualified Dividends in the Realized Capital Gains formula because it intends to calculate realized LTCGs during retirement as you sell assets and draw down your portfolio. So it wants QDivs to add to its calculation of realized LTCGs.

That is fine for ETFs or individual stocks that aren't sold, but if you churn stocks or hold mutual funds, you can also have realized capital gains even if you aren't spending from your portfolio. Such gains should be included in the Simple Interest or Qualified Dividends categories depending on whether they were short term or long term gains.