QUOTE(avms01 @ Oct 21 2014, 03:23 PM)
On the F3 = purchased value, is this before or after service charges?
Thank you.
It depends on which is more important to you, the growth of the fund or the investment. It is without service charge for the former, and with service charge for the latter.
I do something a bit more complex (and since I'm using a excel spreadsheet)... I put the service charge into the formula as a reminder.
=1000 - 52.13
(1000 is the invested value. 52.13 is the service charge.)
As mentioned in a previous post, I have 2 tabs. The 1st tab is the main page of all the funds I'm having. The 2nd tab is a history of all the funds I realised, either redeemed or switched out.
Hence in the main tab, it is without the service charge, and I'm monitoring and comparing the growth of all the funds, and also the same fund which I purchased at different dates.
When I switched out (or redeemed) any funds, I moved it to the 2nd tab. And in this 2nd tab, the actual gain of the investment is more important, so I add back the service charge by tweaking the formula:
=1000 - 52.13 + 52.13
==============
The above method can also be used when there's no switching to another fund, or redemption of a fund.
For example, there is a long list of entries of the same fund due to regular monthly purchases or DDI. The entries can be trimmed and consolidate into one entry, by treating it as if it is switched and realised, but to the same fund.
Do this at the appropriate time like calendar year-end or financial year-end.
(Note: the consolidated entry back into the 1st main tab, will then be the invested value with service charge.)
Example: 7 purchases of the same fund at different times, and going to consolidate the top 5 entries (and realised their gains), at year end.
Main tab:
1/1/2014 ....... blah, blah, blah, blah...
1/2/2014 ....... blah, blah, blah, blah...
1/3/2014 ....... blah, blah, blah, blah...
1/4/2014 ....... blah, blah, blah, blah...
1/5/2014 ....... blah, blah, blah, blah...
1/8/2014 ....... blah, blah, blah, blah...
1/10/2014 ....... blah, blah, blah, blah...
1) Move the top 5 entries to the 2nd tab.
2) Sum up their current values as on 31/12/2014.
3) Add new 31/12/2014 entry into the main tab with the total Current Values (as on 31/12/2014) as the purchased/invested value.
Main tab will look like below:
1/8/2014 ....... blah, blah, blah, blah...
1/10/2014 ....... blah, blah, blah, blah...
31/12/2014 ....... blah, blah, blah, blah...
Eventually, after years of investing and switching or consolidation of the entries, the main tab will reflect the 'real' invested value (which is plus all the service charges and any switching fees incurred.)
This post has been edited by j.passing.by: Oct 21 2014, 07:46 PM