Outline ·
[ Standard ] ·
Linear+
Fundsupermart.com v8, The MS Excel Masterclass version!
|
SUSPink Spider
|
Jan 10 2015, 08:08 PM
|
|
QUOTE(prince_mk98 @ Jan 10 2015, 06:58 PM) I also wan the sales charge of 0.5%  omg...now only I realized that Fundsupermart's Discounted Initial Sales Charge is 0.5%That's only for fund houses participating in today's fair up to 12AM today QUOTE(David83 @ Jan 10 2015, 06:32 PM) I'm still headache on what to buy or top up? Top up Eastspring Investments Asia Pacific Ex-Japan Target Return Fund or buy Affin Hwang Japan Growth Fund? Got poisoned by Nikko/Affin Hwang to go into Japan? This post has been edited by Pink Spider: Jan 10 2015, 08:11 PM
|
|
|
|
|
|
SUSPink Spider
|
Jan 10 2015, 09:28 PM
|
|
QUOTE(David83 @ Jan 10 2015, 09:24 PM) Maybe that fund you wanted to top up is not from participating fund houses. I just topped up Eastspring Investments Asia Pacific Ex-Japan Target Return Fund and the SC is 0.5% Why are u having a fund with similar strategy/target markets as CIMB Asia Pac Dynamite Income?
|
|
|
|
|
|
SUSPink Spider
|
Jan 11 2015, 04:30 PM
|
|
QUOTE(Kaka23 @ Jan 11 2015, 04:24 PM) Ya.. I am using IRR as a judgement how the fund is performing for me. Pink did share the template. you can look at the 1st page if he put it there..  "IF"??? How could u...its there for so long time already ... sweat blood n tears do up post #1 u no appreciate 
|
|
|
|
|
|
SUSPink Spider
|
Jan 11 2015, 09:57 PM
|
|
QUOTE(prince_mk98 @ Jan 11 2015, 09:51 PM) Bro spider should I have different sheet for different funds? Or lump all in one sheet? I noticed if purchase is -ve and sales is +ve. Ermm wonder why? CASH FLOW purchase is u pay Sell is u receive
|
|
|
|
|
|
SUSPink Spider
|
Jan 11 2015, 11:34 PM
|
|
QUOTE(guy3288 @ Jan 11 2015, 11:18 PM) pink bro can ask a bit ah. I saw your portfolio IRR got 2 switch sell like this: Hwang Select Income Fund 18-Aug-2009 RM534.10 0.00% RM0.5341 (1,000.00) Switch Sell Maybank Hwang Select Income Fund 28-Aug-2009 RM539.20 0.00% RM0.5392 (1,000.00) Switch Sell Maybank i cant find where is the switch buy for the money you got back from the sales above, will it balance out?. Can help explain, me also learning to use this IRR also. If got many Uts and many switch buy , park in CMF and and switch sell, i see quite difficult to use your template with all UTs mixed together. This is not accounts balance sheet, no need balance If u wanna include CMF in your IRR calculation, then u include. If u wanna exclude CMF and/or u sell for cash, u exclude
|
|
|
|
|
|
SUSPink Spider
|
Jan 12 2015, 12:57 AM
|
|
QUOTE(guy3288 @ Jan 11 2015, 11:52 PM) Sorry ah me abit blur. So in your case, the proceeds of the 2 sales were actually pumped in back for switch buy of other Ut which were not obvious at a glance. ie the proceeds are still in the portfolio, but not easily identifiable in the portfolio. What about say if we sell, and we take out the money to spend elsewhere, do we need any correction so that this will not falsely bring down the IRR? With many Uts in there, the IRR is the average of all UTs put together? So if some UT make profit, others make loss, IRR may end up 0?  This worksheet is just to track your UT transactions, your spendings whatsoever has got nothing to do with it.
|
|
|
|
|
|
SUSPink Spider
|
Jan 12 2015, 09:04 AM
|
|
QUOTE(guy3288 @ Jan 12 2015, 09:03 AM) thanks for the comment. for now just use fsm summary....... Just remember... The worksheet is to track your UT TRANSACTIONS and the growth rate of your UT portfolio. Anything else is not relevant. FSM summary does not compute IRR or CAGR of your investments, though the "Analyse My Portfolio" function comes quite close. IRR/CAGR is used to assess, whether our UT investments are working hard enough, whether it can beat FD and/or EPF. If not, might as well dump all in FD. This post has been edited by Pink Spider: Jan 12 2015, 09:08 AM
|
|
|
|
|
|
SUSPink Spider
|
Jan 12 2015, 02:11 PM
|
|
QUOTE(prince_mk98 @ Jan 12 2015, 02:06 PM) Bro spider, do u mind to include the CAGR in the existing IRR template ? can it be done? CAGR is not useful (actually, cannot be used!) when u got top up CAGR is only usable for 1 lump sum, one-off investment IRR and CAGR actually are 99% the same thing
|
|
|
|
|
|
SUSPink Spider
|
Jan 12 2015, 02:57 PM
|
|
QUOTE(prince_mk98 @ Jan 12 2015, 02:49 PM) Ok..noted bro spider. I will use the IRR template you shared. if the IRR shown is 10% (let say), it means with the money I invested, I had generated 10% per annum so far?? can i have this kind of thinking? was is nett profit or gross profit? IRR is all about cash flows - money paid, money received, current value, and nothing else So, it's net profit (except for funds that have exit/redemption fee e.g. AmDynamic Bond which has 1% exit fee) To put it simply, let's say if u have invested for 6 months, and u get IRR of 10%, ASSUMING your investment continue to grow at the same rate, u will get 10% p.a. IRR also means annualised growth rate. ACCOUNTANT? I'm just a drunkard This post has been edited by Pink Spider: Jan 12 2015, 02:58 PM
|
|
|
|
|
|
SUSPink Spider
|
Jan 12 2015, 05:00 PM
|
|
QUOTE(prince_mk98 @ Jan 12 2015, 04:38 PM) bro, will you be going this Saturday? what time? MidValley? No thanks
|
|
|
|
|
|
SUSPink Spider
|
Jan 12 2015, 05:38 PM
|
|
QUOTE(Jenny87 @ Jan 12 2015, 05:29 PM) Hi all, May I know how many times Fundsupermart organized seminar/fair in a year for the previous years? Thanks  Usually once a year only
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 03:03 PM
|
|
A fund cannot be overpriced
Only the target market/sector of the fund can be overpriced
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 03:32 PM
|
|
QUOTE(kimyee73 @ Jan 13 2015, 03:28 PM) Oil price will definitely go up, just a matter of when and by how much. Your prediction is after CNY, analysts estimate is in 6-9 months time. March is after CNY June is after CNY December is also after CNY
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 04:30 PM
|
|
QUOTE(river.sand @ Jan 13 2015, 04:26 PM) It doesn't matter when the oil price will go up. What matter is: when it does go up, you can tell people, "You see, I was right!"  ANALysts say during 2010 "Gloom gloom! Market will fall!" Market fly fly fly fly fly fly ... ... ... *2014-end*"See? I told ya!" This post has been edited by Pink Spider: Jan 13 2015, 04:30 PM
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 05:18 PM
|
|
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 05:40 PM
|
|
QUOTE(yklooi @ Jan 13 2015, 04:50 PM) Rise and Fall of the KLCI Index (1984 - 2014). RM100k invested in 1984 till now 2014 is now worth RM500k....what is the IRR/XIRR? IRR 5.51% This post has been edited by Pink Spider: Jan 13 2015, 05:40 PM
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 05:47 PM
|
|
QUOTE(aurora97 @ Jan 13 2015, 05:45 PM) Just clarified with agent.. Aside from those previously managed by affin and aiiman, and those which have been suspended. The original hwang funds are: Select bal Select div Select opp Not so sure about aiiman, whether they have adulterated their original funds with affins... Anyway wouldnt buy islamic coz it limits my investment shpehere. Hwang Select Dividend was never approved for EPF, cos its mandate >30% foreign exposure
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 06:02 PM
|
|
QUOTE(yklooi @ Jan 13 2015, 06:00 PM) from fund factsheet as at 31 Oct 2014..see the arrowed.. Eh But as far as I remember... Alcohol killed my brain cells, sorry!
|
|
|
|
|
|
SUSPink Spider
|
Jan 13 2015, 08:43 PM
|
|
QUOTE(wongmunkeong @ Jan 13 2015, 07:22 PM) Pink - methinks by succumbing to such URGES, one "buys high" leh. Shd move when MYR strong against USD or AUD or SGD last few years. I'm currently contemplating selling or switching some CIMB Principal Global Titan Funds heheh (matter of how much only -urgh) Just a thought  Wong Seafood, After drinking a hot soup of ABC for dinner, I've had that same though as yours... Now is already too late to run Run now = Sell low (Ringgit), buy high (USD/SGD) Thanks for giving me the confidence to hold station  Additional thought...  Buy Ruble? This post has been edited by Pink Spider: Jan 13 2015, 08:45 PM
|
|
|
|
|
|
SUSPink Spider
|
Jan 14 2015, 08:32 AM
|
|
Eyes on the ball indeed
|
|
|
|
|