Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed
125 Pages « < 18 19 20 21 22 > » Bottom

Outline · [ Standard ] · Linear+

 Fundsupermart.com v8, The MS Excel Masterclass version!

views
     
prince_mk98
post Jan 11 2015, 03:43 PM

Getting Started
**
Junior Member
249 posts

Joined: Jan 2015
QUOTE(David83 @ Jan 11 2015, 03:32 PM)
You still got Eastspring Inv Equity Income and AMB Income Trust Fund.
*
Advisable to buy RHB OSK GS US Equity fund via cash? coz this is foreign equity focus in us.
Kaka23
post Jan 11 2015, 04:08 PM

Look at all my stars!!
*******
Senior Member
8,259 posts

Joined: Sep 2009


QUOTE(prince_mk98 @ Jan 11 2015, 04:16 PM)
ok. noted bro david.

how abt the KGF I purchased via epf $$. if i sold, what funds should I consider?
*
Kgf is good fund.. Maybe just keep the money invested. Since it is using EPF and is long term..
prince_mk98
post Jan 11 2015, 04:13 PM

Getting Started
**
Junior Member
249 posts

Joined: Jan 2015
QUOTE(Kaka23 @ Jan 11 2015, 04:08 PM)
Kgf is good fund..  Maybe just keep the money invested. Since it is using EPF and is long term..
*
thanks kaka. you got use the IRR template? good ? i m interested to use but dont know how to start.
SUSyklooi
post Jan 11 2015, 04:24 PM

Look at all my stars!!
*******
Senior Member
8,188 posts

Joined: Apr 2013


QUOTE(prince_mk98 @ Jan 11 2015, 04:13 PM)
thanks kaka. you got use the IRR template? good ? i m interested to use but dont know how to start.
*
hmm.gif I think other SIFUs that had used IRR will tell you that if less than 1 year...IRR is not good to use. BUt if you do regular top up... then it will be good to start using...
there is 1 at post #1 and also page 6 post #114

This post has been edited by yklooi: Jan 11 2015, 04:26 PM
Kaka23
post Jan 11 2015, 04:24 PM

Look at all my stars!!
*******
Senior Member
8,259 posts

Joined: Sep 2009


QUOTE(prince_mk98 @ Jan 11 2015, 05:13 PM)
thanks kaka. you got use the IRR template? good ? i m interested to use but dont know how to start.
*
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
SUSDavid83
post Jan 11 2015, 04:27 PM

20k VIP Club
*********
All Stars
52,874 posts

Joined: Jan 2003
» Click to show Spoiler - click again to hide... «


URL: http://www.investopedia.com/ask/answers/07...-cagr-excel.asp

I use simple CAGR formula.
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
prince_mk98
post Jan 11 2015, 04:52 PM

Getting Started
**
Junior Member
249 posts

Joined: Jan 2015
QUOTE(Pink Spider @ Dec 24 2014, 04:32 PM)
user posted image

Fundsupermart.com (FSM) Malaysia is the online unit trust distribution arm of iFAST Capital Sdn. Bhd. ("iFAST Capital").

iFAST Capital is a holder of a Capital Markets Services Licence (CMSL) and is licensed by the Securities Commission to conduct the following regulated activities:

- To deal in unit trusts
- To offer investment advisory services
- To deal in Private Retirement Scheme

iFAST Capital is also registered with the Federation of Investment Managers Malaysia (FiMM) as an Institutional Unit Trust Adviser (IUTA).

iFAST Capital is part of iFAST Corporation Pte. Ltd. ("iFAST Corp"), which is headquartered in Singapore and the iFAST group of companies are also present in Hong Kong and Malaysia. The company was incorporated in Singapore on 10 January 2000.

iFAST Corp, via its wholly-owned subsidiary iFAST Financial Pte. Ltd., is Singapore's leading online distributor of unit trusts as well as the leading operator of an investment platform for financial advisers and financial institutions. It carries the Capital Markets Services (CMS) and Financial Adviser (FA) licences issued by the Monetary Authority of Singapore (MAS), and is also one of three appointed Central Provident Board (CPF) Investment Administrators.

iFAST Corp has two corporate shareholders. They are SPH AsiaOne Ltd, the Internet arm of Singapore Press Holdings, Singapore's largest media group, and DMG & Partners Securities Pte Ltd (a joint-venture between RHB Investment Bank Berhad and Deutsche Asia Pacific Holdings Pte Ltd). In recent years, iFAST Corp has been expanding beyond local shores. In 2007, iFAST Corp launched its first overseas business, Fundsupermart in Hong Kong and in 2008, it launched Fundsupermart in Malaysia.

user posted image

1. Wide range of information
2. Extensive product range and value-added services
3. One of the cheapest Sales Charges in town! thumbup.gif
To keep discussions at this thread fruitful and constructive, it would be greatly appreciated that fellow investors try to look for answer to their queries at Frequently Asked Questions before posting here. icon_rolleyes.gif

What is unit trust?
Federation of Investment Managers Malaysia - ABC of Unit Trusts

Other FAQs on Fundsupermart.com and unit trust investing in general

1. NAV pricing and processing time
» Click to show Spoiler - click again to hide... «


2. The NAV price of the fund that I'm interested in is quite high now, should I stay away? Investment gurus always say "buy low, sell high"...
» Click to show Spoiler - click again to hide... «

FSM Idea Of The Week: Unit Split and High Fund Price Misconceptions [24 October 2014]
3. Common misconceptions about unit trust dividends/distributions:

(i) After dividend distribution, NAV price will go down, the fund will become cheaper.
(ii) A fund that declares dividends is better than a fund that does not, dividends are my profit, they make me richer.

» Click to show Spoiler - click again to hide... «


(iii) Topping up my holdings after dividend distribution pulls down my cost per unit, lower cost = higher profit.
» Click to show Spoiler - click again to hide... «


(iv) Distribution = Income

» Click to show Spoiler - click again to hide... «


» Click to show Spoiler - click again to hide... «


4. Annual Management Charge, Trustee Fee and NAV pricing
» Click to show Spoiler - click again to hide... «


5. Return On Investment (ROI) vs Annualised Return, similar to Internal Rate of Return (IRR)
» Click to show Spoiler - click again to hide... «

Link to v1
Link to v2
Link to v3
Link to v4
Link to v5
Link to v6
Link to v7

Download here >>> Pinky's Portfolio Worksheet with IRR Calculation

Happy investing! rclxms.gif

Disclaimer -
I am not a UT agent, nor am I employed by FSM. All my comments here are posted in good faith and with the intention to share knowledge. I am not to be held liable for any losses that may be incurred as a result of following any advice/opinion shared here. I believe the same should be applicable for any other LYN members posting here.
smile.gif
*
TQ Pink spider. I will study it first.

The info you shared here are very useful. thumbub to you.

TQ

This post has been edited by prince_mk98: Jan 11 2015, 05:16 PM
Kaka23
post Jan 11 2015, 05:52 PM

Look at all my stars!!
*******
Senior Member
8,259 posts

Joined: Sep 2009


QUOTE(Pink Spider @ Jan 11 2015, 05:30 PM)
"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
*
haha... sorry bro. I long time didnt see #1 tongue.gif
prince_mk98
post Jan 11 2015, 05:54 PM

Getting Started
**
Junior Member
249 posts

Joined: Jan 2015
QUOTE(David83 @ Jan 11 2015, 04:27 PM)
» Click to show Spoiler - click again to hide... «


URL: http://www.investopedia.com/ask/answers/07...-cagr-excel.asp

I use simple CAGR formula.
*
bro David,

Mind to share a template Excel with this formula embedded. tongue.gif
SUSDavid83
post Jan 11 2015, 06:00 PM

20k VIP Club
*********
All Stars
52,874 posts

Joined: Jan 2003
QUOTE(prince_mk98 @ Jan 11 2015, 05:54 PM)
bro David,

Mind to share a template Excel with this formula embedded. tongue.gif
*
I'm running several nested formula:

QUOTE
=(POWER(G5/C5,1/(YEARFRAC(A5,TODAY())))-1)*100


G5: Current valuation of the fund
C5: Capital invested
A5: First date where the fund is bought


prince_mk98
post Jan 11 2015, 06:02 PM

Getting Started
**
Junior Member
249 posts

Joined: Jan 2015
QUOTE(David83 @ Jan 11 2015, 06:00 PM)
I'm running several nested formula:
G5: Current valuation of the fund
C5: Capital invested
A5: First date where the fund is bought
*
so complicated. i think I got forget abt it. sigh...let me just use the IRR template by Pink spider.

let me start key in first.
JinXXX
post Jan 11 2015, 07:35 PM

Look at all my stars!!
*******
Senior Member
2,516 posts

Joined: Feb 2007
From: Uarla Umpur



QUOTE(David83 @ Jan 11 2015, 06:00 PM)

=(POWER(G5/C5,1/(YEARFRAC(A5,TODAY())))-1)*100

I'm running several nested formula:
G5: Current valuation of the fund
C5: Capital invested
A5: First date where the fund is bought
*
hey thanks for the formula man.. now i can see CAGR tongue.gif

hmm cagr of 7.. not bad i guess smile.gif
SUSyklooi
post Jan 11 2015, 07:58 PM

Look at all my stars!!
*******
Senior Member
8,188 posts

Joined: Apr 2013


Things get ugly when the CAGR is used to promote investment results without incorporating the risk factor. Mutual fund companies emphasize their CAGRs from different time periods in order to get you to invest in their funds, but they rarely incorporate a risk adjustment. It is also important to read the fine print in order to know what time period is being used. Ads can tout a fund's 20% CAGR in bold type, but the time period used may be from the peak of the last bubble, which has no bearing on the most recent performance.

The CAGR is a good and valuable tool to evaluate investment options, but it does not tell the whole story. Investors can analyze investment alternatives by comparing their CAGRs from identical time periods. Investors, however, also need to evaluate the relative investment risk. This requires the use of another measure such as standard deviation.

http://www.investopedia.com/articles/analyst/041502.asp

just saw the above in the web....

This post has been edited by yklooi: Jan 11 2015, 08:00 PM
xuzen
post Jan 11 2015, 09:49 PM

Look at all my stars!!
*******
Senior Member
4,436 posts

Joined: Oct 2008


using CAGR alone is like looking at a 2D picture. The third dimension i.e. risk aka stad-dev, although please note that some modern academics use downside semi-deviation should be incorporated into the portfolio construction.

Xuzen


prince_mk98
post Jan 11 2015, 09:51 PM

Getting Started
**
Junior Member
249 posts

Joined: Jan 2015
QUOTE(Pink Spider @ Jan 11 2015, 04:30 PM)
"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
*
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?


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

Look at all my stars!!
*******
Senior Member
5,854 posts

Joined: Sep 2009


QUOTE(Pink Spider @ Jan 11 2015, 09:57 PM)
CASH FLOW

purchase is u pay
Sell is u receive
*
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.
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
guy3288
post Jan 11 2015, 11:52 PM

Look at all my stars!!
*******
Senior Member
5,854 posts

Joined: Sep 2009


QUOTE(Pink Spider @ Jan 11 2015, 11:34 PM)
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
*
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?


125 Pages « < 18 19 20 21 22 > » Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0281sec    0.96    6 queries    GZIP Disabled
Time is now: 3rd December 2025 - 01:03 AM