QUOTE(jutamind @ Dec 21 2012, 09:14 PM)
Hi j,passingby,
Your method doesnt seems right.
1. For bond funds, Total MGQP is always 0. How can i find out the cost of investment for bond funds?
2. Sometime ago, i switched PFES to PFSF. The amount invested after switching is about 7xxx, but in the MGQP for my PFSF, it's shown as 9xxx. If you are saying MGQP is 1 RM 1 point, then the MGQP for my PFSF should be 7xxx, instead of 9xxx.
1. Bond funds. You're right. Buying directly into a bond fund is low-loaded ie. meaning there is no high service charge of 3.0 - 5.5 %. You only incur a low service charge of 0.25%. And no gold points. The cost of the investment is the what you have paid in total.
For example recently I bought 20k at price of 1.2018 per unit and getting 16600.2 units after deduction of rm49.88 as service charge.
After some time, with changes to the unit price, plus dividend (if any) paid out which will change the number of units, it will not be easy to remember what you have paid, but it will be easy to figure out its cost if you always buy in neat round numbers of hundreds or thousands including the service charge; and let PM do the deduction for the service charge and calculate the number of units you are entitled to.
2. Yes, the gold points is 1 ringgit per point. Check your total points again, it should be correct. The total is what you have paid. If not mistaken, the total MGQP is what you paid in total inclusive of the service charge; rm1000 will get 1000 points.
For example, switched out from PNREF into PFEPRF (copied from PMO transaction history)
Fund NAV Amt Invested S/Charge Amount Paid (RM) Total Units
PNREF 0.2075 -10,859.91 00.00 -10,859.91 -52,336.92
PFEPRF 0.2862 10,834.91 25.00 10,859.91 37,857.83
The gold points transferred to PFEPRF was 10,860.
Added on December 22, 2012, 12:02 amUsing Excel to track the funds.I'm using excel to record the transactions. And I find it easier to have 2 tabs - one tab showing a summary of all the funds, and in another tab, all the switching out transactions.
From the above switching example, I will record switching out of PNREF in the latter; together with the appropriate details like date bought, date switched, total units, NAV, etc.
To have lesser columns, I deducted the switching charge from the net amount ie. using rm10,834.91. In each line of the switching out record is the net gain (or net lost).
At the bottom-most line in that tab, is the total of the net gain (or net lost).
In the 1st tab, it is almost similar to the "summary of accounts" in PMO but with added columns like date purchased or switched in, number of days having the fund, the amount invested. etc. The total amount is on the last line, which should tally against the total amount in PMO.
For example,
Far-East Property & Resorts Fund 04-12-2012 16days 0.2862 RM10,834.91 37,857.83 0.2894 RM10,956.06
In the same 1st tab, the total gain (or net lost) from the 2nd tab is also on the cell just below the total amount. And a 3rd cell with a simple formula, will show the final gain (or lost) to-date.
My summary page is further enhance by grouping the funds accordingly to conservative, moderate, and aggressive; each grouping showing the group percentage of the total amount...
This post has been edited by j.passing.by: Dec 22 2012, 12:11 AM