QUOTE(jutamind @ Nov 27 2012, 09:36 PM)
This will help: http://office.microsoft.com/en-us/excel-he...P005209341.aspx
Fund Investment Corner v3, Funds101
|
Nov 28 2012, 08:40 AM
|
Senior Member
16,872 posts Joined: Jun 2011 |
QUOTE(jutamind @ Nov 27 2012, 09:36 PM) This will help: http://office.microsoft.com/en-us/excel-he...P005209341.aspx |
|
|
|
Nov 28 2012, 03:12 PM
|
Junior Member
6 posts Joined: Oct 2008 |
Gurus, any comment on Hwang Select Income Fund ?
I saw their performance is quite consistent over the year. Any fund holder here ? This post has been edited by renomael: Nov 28 2012, 03:13 PM |
|
Nov 28 2012, 05:36 PM
|
Senior Member
16,872 posts Joined: Jun 2011 |
|
|
Nov 28 2012, 08:47 PM
|
Senior Member
2,203 posts Joined: Jul 2007 |
QUOTE(Pink Spider @ Nov 28 2012, 08:40 AM) Hi Pink Spider,I've seen this article before i post the query. Not too sure how to calc XIRR in terms of unit trust investment. Let's say i have RSP of RM1000 every month. At the end of the year, the value of my unit trust is 15,000. So how do i calculate XIRR? |
|
Nov 28 2012, 11:36 PM
|
Senior Member
16,872 posts Joined: Jun 2011 |
QUOTE(jutamind @ Nov 28 2012, 08:47 PM) Hi Pink Spider, Let's use an example...I've seen this article before i post the query. Not too sure how to calc XIRR in terms of unit trust investment. Let's say i have RSP of RM1000 every month. At the end of the year, the value of my unit trust is 15,000. So how do i calculate XIRR? 01-Jan-12 invest RM500 Assuming SC of 2%, u will be getting only RM490.20 worth of units. But for the purpose of calculating IRR, I'd prefer to use CASH FLOWS, in this case I'd use RM500 instead of RM490.20. Thus, our IRR calculation would be on cash flows basis, which will be very different to the Fund Fact Sheet returns. Understand? 07-Feb-12 invest RM300 08-May-12 invest RM400 14-Sep-12 invest RM250 27-Nov-12 value: RM1,567 A B 1 01-Jan-12 -RM500 2 07-Feb-12 -RM300 3 08-May-12 -RM400 4 14-Sep-12 -RM250 5 27-Nov-12 RM1,567 =XIRR(Value Range,Date Range) =XIRR(B1:B5,A1:A5) =12.25% When u invest, it's a cash OUTFLOW, thus negative value. Just put the dates of purchase in 1 column, with the amounts in next column. Value and date of valuation on the same columns but lowest row within the range. Got it? This post has been edited by Pink Spider: Nov 28 2012, 11:46 PM |
|
Nov 30 2012, 07:28 PM
|
Senior Member
8,251 posts Joined: Sep 2009 |
QUOTE(dewVP @ Nov 28 2012, 02:32 AM) Based on my overall portfolio, I would go for Asia Quantum as it has more out of MY exposure. Their MY exposure Is approx 40%. I got too many MY funds. Select opportunity is 60% MY focus for now. |
|
Nov 30 2012, 08:29 PM
|
Senior Member
16,872 posts Joined: Jun 2011 |
QUOTE(Kaka23 @ Nov 30 2012, 07:28 PM) Based on my overall portfolio, I would go for Asia Quantum as it has more out of MY exposure. Their MY exposure Is approx 40%. I got too many MY funds. Select opportunity is 60% MY focus for now. If u include the cash holdings, Select Opportunity Fund can never hold >30% in offshore investments, as it is EPF-approved. As most of us should know, EPF-approved funds can invest offshore up to 30% only.Asia Quantum is a small-mid cap equity fund, and HwangIM has proven itself as an able stock-picker. |
|
Nov 30 2012, 11:18 PM
|
Senior Member
8,251 posts Joined: Sep 2009 |
Today AmDynamc bond drop around 1%! This is the worst drop I ever seen...
|
|
|
|
Nov 30 2012, 11:52 PM
|
Senior Member
2,203 posts Joined: Jul 2007 |
|
|
Dec 1 2012, 12:11 AM
|
Senior Member
8,251 posts Joined: Sep 2009 |
QUOTE(jutamind @ Dec 1 2012, 12:52 AM) http://www.bloomberg.com/quote/AMDYMIC:MKOr if you have Bloomberg app for tablet, can also get it from there.. |
|
Dec 1 2012, 12:16 AM
|
Senior Member
16,872 posts Joined: Jun 2011 |
Steady lar...even if it really did dropped 1%, will u have to sell your home and pawn your car because of it?
|
|
Dec 1 2012, 12:25 AM
|
Senior Member
8,251 posts Joined: Sep 2009 |
|
|
Dec 1 2012, 12:28 AM
|
Senior Member
16,872 posts Joined: Jun 2011 |
Investing is for long-term...u are not trading...
What goes up must come down, and vice versa |
|
Dec 1 2012, 04:05 PM
|
All Stars
52,874 posts Joined: Jan 2003 |
Any reason why it dropped 1%? Distribution?
|
|
|
|
Dec 1 2012, 05:50 PM
|
Senior Member
16,872 posts Joined: Jun 2011 |
Looking at the historical distribution trend, unlikely to be the case.
AmDynamic Bond August 6, 2012 August 6, 2012 0.020005 Dividend Payout AmDynamic Bond March 12, 2012 March 12, 2012 0.020009 Dividend Payout AmDynamic Bond August 1, 2011 August 19, 2011 0.020052 Dividend Payout AmDynamic Bond February 16, 2011 March 7, 2011 0.020031 Dividend Payout AmDynamic Bond August 3, 2010 - 0.02 Dividend Payout AmDynamic Bond January 12, 2010 - 0.02 Dividend Payout AmDynamic Bond July 16, 2009 - 0.040021 Dividend Payout AmDynamic Bond August 20, 2008 - 0.02 Dividend Payout AmDynamic Bond February 20, 2008 - 0.02 Dividend Payout AmDynamic Bond August 17, 2007 - 0.02 Dividend Payout AmDynamic Bond February 22, 2007 - 0.02 Dividend Payout AmDynamic Bond July 11, 2006 - 0.02 Dividend Payout AmDynamic Bond February 8, 2006 - 0.02 Dividend Payout AmDynamic Bond July 28, 2005 - 0.04 Dividend Payout Added on December 1, 2012, 5:54 pmAmIncome Plus, a short-dated bond fund also kena, but just by 0.06%. AmIncome Plus rarely drops, there must be something happening in the bond market. This post has been edited by Pink Spider: Dec 1 2012, 05:54 PM |
|
Dec 1 2012, 05:56 PM
|
Senior Member
8,251 posts Joined: Sep 2009 |
Ya unlikely... My overall total portfolio XIRR drop 1.2% due to AmDynamic drop.
|
|
Dec 1 2012, 06:09 PM
|
Senior Member
16,872 posts Joined: Jun 2011 |
|
|
Dec 2 2012, 10:39 AM
|
Senior Member
8,251 posts Joined: Sep 2009 |
Mine overall portfolio IRR is now 4.52%
|
|
Dec 2 2012, 01:50 PM
|
Senior Member
1,449 posts Joined: Dec 2007 |
bubble burst in bond market?
|
|
Dec 2 2012, 02:41 PM
|
Senior Member
16,872 posts Joined: Jun 2011 |
Let's see how my other bond fund, OSK-UOB Income Fund fares when its 30-Nov-12 NAV is published tomorrow. Then we'll be able to see whether its the bond market or just AmInvestment's holdings.
|
Change to: | 0.0135sec
0.56
6 queries
GZIP Disabled
Time is now: 28th March 2024 - 08:03 PM |