QUOTE(David83 @ Jan 11 2015, 03:32 PM)
Advisable to buy RHB OSK GS US Equity fund via cash? coz this is foreign equity focus in us.Fundsupermart.com v8, The MS Excel Masterclass version!
Fundsupermart.com v8, The MS Excel Masterclass version!
|
|
Jan 11 2015, 03:43 PM
|
![]() ![]()
Junior Member
249 posts Joined: Jan 2015 |
|
|
|
|
|
|
Jan 11 2015, 04:08 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
8,259 posts Joined: Sep 2009 |
|
|
|
Jan 11 2015, 04:13 PM
|
![]() ![]()
Junior Member
249 posts Joined: Jan 2015 |
|
|
|
Jan 11 2015, 04:24 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
8,188 posts Joined: Apr 2013 |
QUOTE(prince_mk98 @ Jan 11 2015, 04:13 PM) 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 |
|
|
Jan 11 2015, 04:24 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
8,259 posts Joined: Sep 2009 |
|
|
|
Jan 11 2015, 04:27 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
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. |
|
|
|
|
|
Jan 11 2015, 04:30 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
16,872 posts Joined: Jun 2011 |
|
|
|
Jan 11 2015, 04:52 PM
|
![]() ![]()
Junior Member
249 posts Joined: Jan 2015 |
QUOTE(Pink Spider @ Dec 24 2014, 04:32 PM) ![]() 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. ![]() 1. Wide range of information 2. Extensive product range and value-added services 3. One of the cheapest Sales Charges in town! 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. 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! 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. 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 |
|
|
Jan 11 2015, 05:52 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
8,259 posts Joined: Sep 2009 |
|
|
|
Jan 11 2015, 05:54 PM
|
![]() ![]()
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. Mind to share a template Excel with this formula embedded. |
|
|
Jan 11 2015, 06:00 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
All Stars
52,874 posts Joined: Jan 2003 |
|
|
|
Jan 11 2015, 06:02 PM
|
![]() ![]()
Junior Member
249 posts Joined: Jan 2015 |
|
|
|
Jan 11 2015, 07:35 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
2,516 posts Joined: Feb 2007 From: Uarla Umpur |
|
|
|
|
|
|
Jan 11 2015, 07:58 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
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 |
|
|
Jan 11 2015, 09:49 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
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 |
|
|
Jan 11 2015, 09:51 PM
|
![]() ![]()
Junior Member
249 posts Joined: Jan 2015 |
QUOTE(Pink Spider @ Jan 11 2015, 04:30 PM) "IF"??? Bro spiderHow could u...its there for so long time already ... sweat blood n tears do up post #1 u no appreciate 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? |
|
|
Jan 11 2015, 09:57 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
16,872 posts Joined: Jun 2011 |
|
|
|
Jan 11 2015, 11:18 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
5,854 posts Joined: Sep 2009 |
QUOTE(Pink Spider @ Jan 11 2015, 09:57 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. |
|
|
Jan 11 2015, 11:34 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
16,872 posts Joined: Jun 2011 |
QUOTE(guy3288 @ Jan 11 2015, 11:18 PM) pink bro can ask a bit ah. This is not accounts balance sheet, no need balance 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. 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 |
|
|
Jan 11 2015, 11:52 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
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 Sorry ah me abit blur.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 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? |
|
Topic ClosedOptions
|
| Change to: | 0.0281sec
0.96
6 queries
GZIP Disabled
Time is now: 3rd December 2025 - 01:03 AM |