Question about mutual funds

[Kaitlyn]

Numbers aren't real, but when I log into EasyWeb and go into my mutual fund account I see something like for my Canadian Index-e, for example:


fund - units - price - market value - book value
TD CDN Index-e** 1000 $19.48 $15,000.00 $14,400.00

That looks like I've only made $600. But in fact, I would have made more right? Through re-invested dividends? It has a cost, of course... but was "profit to buy more" ?

[OhGreatGuru]

According to the Prospectus: The Fund distributes net income and net realized capital gains annually in December.
How long have you owned it?
For the rest of it, it's pretty hard to intepret because your made-up numbers don't make sense. if you have 1000 units, and their market value is $15,000, then current unit value would be $15.00, not $19.48. If "Price" is your average unit purchase price (ie. ACB/share), then the book value woudl be $19,480.

[Kaitlyn]

According to the Prospectus: The Fund distributes net income and net realized capital gains annually in December.
How long have you owned it?
For the rest of it, it's pretty hard to intepret because your made-up numbers don't make sense. if you have 1000 units, and their market value is $15,000, then current unit value would be $15.00, not $19.48. If "Price" is your average unit purchase price (ie. ACB/share), then the book value woudl be $19,480.

Sorry that's what happens when I quickly make up numbers and don't verify they actually make sense... hah

I've owned it since 2005 and have bought a bunch of new units over the years - so yes I've received multiple of those "Reinvested Dividend" in Decembers

[Barwelle]

Kaitlyn:

If you really wanted to figure out what your actual contributions are and compare them to market value, you could look back at the last statement from each year and add up all the YTD contribution amounts. (Hopefully you've kept them!) I've only had e-Series for about a year, but as far as I can tell, they don't include the reinvested distributions in the contribution amount.

How handy are you with Excel? I noticed this the other day as well with my e-Series funds, and a blog post by Canadian Capitalist inspired me to graph the return on this part of my portfolio, so I created an Excel sheet to track its progress quarterly. See here (http://i1155.photobucket.com/albums/p544/barwelle/trackerimage.jpg).

[MrMatt]

Book value is what you paid.
When you reinvest, you're buying more.
So you bought $10k initially, then bought $4400 with reinvested dividends, this is how your book value is $14400, but the actual market value is more.

[Kaitlyn]

I could do some stuff in excel. Originally I wanted to track it all in excel but I also wanted everything in one spot, and I think it gets more confusing when I try to handle stocks too!

I've entered the entire mutual fund history into Quicken. The book value does indeed include reinvested dividends, which I do understand. But is there any way for me to break it out? To me, I'd like to see
- The amount I've actually contributed
- The dividends/reinvested portion, separated out
- Total market value

In many ways, to me.. gain = [market value] - [what I've bought] - [dividends issued]

[HaroldCrump]

In many ways, to me.. gain = [market value] - [what I've bought] - [dividends issued]
You mean:
Gain = Market Value - Original Investment + Dividends
And if dividends are automatically re-invested, then:
Gain = Market Value - Original Investment

[Kaitlyn]

You mean:
Gain = Market Value - Original Investment + Dividends
And if dividends are automatically re-invested, then:
Gain = Market Value - Original Investment

Oops... again... :)

Yep. Does quicken have any way to easily report/show Marketing Value - Original Investment + Dividends?

[HaroldCrump]

You don't need Quicken.
Just go to TD's WebBroker site, select your account, then click on the mutual fund without your portfolio.
It will show you the entire distribution and re-investment history - how many units purchased, at what price, what date, etc.
Plug all that into a spreadsheet and now you are in control of your destiny.

[Kaitlyn]

You don't need Quicken.
Just go to TD's WebBroker site, select your account, then click on the mutual fund without your portfolio.
It will show you the entire distribution and re-investment history - how many units purchased, at what price, what date, etc.
Plug all that into a spreadsheet and now you are in control of your destiny.

Ya - as I said I used quicken mainly to manage/oversee everything at once. Mutual funds would be easy to track/report on within Excel but I didn't want to try the same with stocks :(. So I used quicken... but I guess I'm not quite getting what I was hoping out of it...

[caricole]

I suggest :encouragement:

Register at The Globe....Fundlist

Create Fundlist....its FREE

1) Original date

2) Original purchase of Number of shares or amount...

3) Later, any date of purchase or partial disposition

4) Your Funlist is up to date with ALL details of Value,Yield, réinvestments, distributions, numder of parts held ETC.

[Barwelle]

You don't need Quicken.
Just go to TD's WebBroker site, select your account, then click on the mutual fund without your portfolio.
It will show you the entire distribution and re-investment history - how many units purchased, at what price, what date, etc.
Plug all that into a spreadsheet and now you are in control of your destiny.

The furthest back I can see is 18 months. Which is OK for me but not for Kaitlyn. Unless I'm in the wrong area?