Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed
22 Pages « < 3 4 5 6 7 > » Bottom

Outline · [ Standard ] · Linear+

 Fundsupermart.com v8, The MS Excel Masterclass version!

views
     
SUSPink Spider
post Jan 10 2015, 08:08 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


QUOTE(prince_mk98 @ Jan 10 2015, 06:58 PM)
I also wan the sales charge of 0.5% smile.gif

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? hmm.gif

This post has been edited by Pink Spider: Jan 10 2015, 08:11 PM
SUSPink Spider
post Jan 10 2015, 09:28 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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
post Jan 11 2015, 04:30 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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.. tongue.gif
*
"IF"???

How could u...its there for so long time already ... sweat blood n tears do up post #1 u no appreciate cry.gif

tongue.gif
SUSPink Spider
post Jan 11 2015, 09:57 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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
post Jan 11 2015, 11:34 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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 tongue.gif

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
post Jan 12 2015, 12:57 AM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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?
*
doh.gif

This worksheet is just to track your UT transactions, your spendings whatsoever has got nothing to do with it.
SUSPink Spider
post Jan 12 2015, 09:04 AM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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. laugh.gif

This post has been edited by Pink Spider: Jan 12 2015, 09:08 AM
SUSPink Spider
post Jan 12 2015, 02:11 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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
post Jan 12 2015, 02:57 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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 laugh.gif

This post has been edited by Pink Spider: Jan 12 2015, 02:58 PM
SUSPink Spider
post Jan 12 2015, 05:00 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


QUOTE(prince_mk98 @ Jan 12 2015, 04:38 PM)
bro,

will you be going this Saturday? what time?
*
MidValley? No thanks laugh.gif
SUSPink Spider
post Jan 12 2015, 05:38 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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  smile.gif
*
Usually once a year only
SUSPink Spider
post Jan 13 2015, 03:03 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


A fund cannot be overpriced

Only the target market/sector of the fund can be overpriced
SUSPink Spider
post Jan 13 2015, 03:32 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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

tongue.gif
SUSPink Spider
post Jan 13 2015, 04:30 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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!"  brows.gif
*
ANALysts say during 2010

"Gloom gloom! Market will fall!"

Market fly fly fly fly fly fly ... ... ...

*2014-end*

"See? I told ya!" cool2.gif

tongue.gif biggrin.gif laugh.gif whistling.gif

This post has been edited by Pink Spider: Jan 13 2015, 04:30 PM
SUSPink Spider
post Jan 13 2015, 05:18 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


See oil price and MYR:USD forex rate...

doh.gif doh.gif doh.gif

really wanna move RM to other currencies liao sweat.gif

Affin Hwang SGD fund? hmm.gif
SUSPink Spider
post Jan 13 2015, 05:40 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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
post Jan 13 2015, 05:47 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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
post Jan 13 2015, 06:02 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


QUOTE(yklooi @ Jan 13 2015, 06:00 PM)
from fund factsheet as at 31 Oct 2014..see the arrowed..
*
Eh blink.gif

But as far as I remember... hmm.gif

Alcohol killed my brain cells, sorry! tongue.gif
SUSPink Spider
post Jan 13 2015, 08:43 PM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


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  notworthy.gif
*
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 biggrin.gif

Additional thought... hmm.gif

Buy Ruble? tongue.gif

This post has been edited by Pink Spider: Jan 13 2015, 08:45 PM
SUSPink Spider
post Jan 14 2015, 08:32 AM

Formerly known as Prince_Hamsap
********
Senior Member
16,872 posts

Joined: Jun 2011


Eyes on the ball indeed brows.gif

22 Pages « < 3 4 5 6 7 > » Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0460sec    0.41    7 queries    GZIP Disabled
Time is now: 2nd December 2025 - 10:38 AM